For this assignment, you will continue working on the WAG expansion project. The PM, project sponsor, and the Finance department have met and determined that 3 million US dollars is still the appropriate funding requirements to build the new plant in the UK over a 2-year time period. After meeting, the team determined the following breakdown for the allocation of costs:
- The budget will be $1.5 million per year
- 20% is allocated to salaries each year
- 50% is allocated to construction, upfitting, and purchase of land per year
- 20% is allocated for equipment purchases per year
- 10% is allocated for contingency reserve per year
Your task is to use the budget template linked below to input your projected budget breakdown for year 1 and year 2. Using the tasks that you created in the project management schedule from Module 03 and the work breakdown from Module 04, fill in the sheet so that you can begin building the budget by high-level task group. After completing your budget, explain in a Word document why you chose the expense lines that you included and justify the totals for each of your major categories.
Below is an example of what your budget will look like once it is completed.
Please note that you are submitting two documents to the drop box. Please check the Course Calendar for specific due dates.
Save your budget as a Microsoft Excel spreadsheet. (Mac users, please remember to append the “.xlsx” extension to the filename.) Save your explanation as a Microsoft Word document. (Mac users, please remember to append the “.docx” extension to the filename.)