You are the project manager of a commercial construction project that is scheduled to be completed in 12 months. You have just completed month 6 and your boss wants a project update. Use the attached excel spreadsheet to construct a time phased budget to show the Planned Value (PV), Earned Value (EV), and Actual Costs (AC) in a funding profile that you will show to your boss. Tell your boss your analysis of the status of the project in terms of cost and schedule variance and cost and schedule performance. The attached spreadsheet presents you with 3 different tabs containing costs and elements of a WBS, the phased budget and the actual costs incurred so far in the project.

\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline A & B & C & D & E & F & G & H & I & J & K & L & M & N & 0 & P \\ \hline & Month 1 & Month 2 & Month 3 & Month 4 & Month 5 & Month 6 & Month 7 & Month 8 & Month 9 & Month 10 & Month 11 & Month 12 & & & \\ \hline General Conditions & 25.000 & & & & & & & & & & & & & & \\ \hline Long Lead Procurement & & 175.000 & 155.000 & & & & & & & & & & & & \\ \hline Mobilize on Site & & 20.000 & 6.000 & & & & & & & & & & & & \\ \hline Site Grading and Utilities & & 100.000 & 150.000 & & & & & & & & & & & & \\ \hline Foundations & & 125.000 & 375.000 & & & & & & & & & & & & \\ \hline Steel Erection & & & & 150.000 & 150.000 & & & & & & & & & & \\ \hline Form and Pour Concrete - Floors and Roof & & & & & 75.000 & 100.000 & & & & & & & & & \\ \hline Carpentry Work & & & & & & 50.000 & 75.000 & 125.000 & & & & & & & \\ \hline Masonry Work & & & & & & 25.000 & 30.000 & 39.000 & 31.000 & & & & & & \\ \hline Roofing & & & & & & & 50.000 & & & & & & & & \\ \hline Window wall and store front closures & & & & & & & & 75.000 & 40.000 & 10.000 & & & & & \\ \hline Building Finishes & & & & & & & 18.000 & 130.000 & 230.000 & 372.000 & & & & & \\ \hline Elevators & & & & & & & & & 122.000 & 3.000 & & & & & \\ \hline Plumbing & & & & & & & & & 25.000 & 75.000 & 35.000 & & & & \\ \hline Electrical & & & & & & & 7.000 & 23.000 & 35.000 & 100.000 & 35.000 & & & & \\ \hline Heating and Ventilating - AC & & & & & & & & & 100.000 & 200.000 & 50.000 & & & & \\ \hline Final Clean-up and Occupancy & & & & & & & & & & & 25.000 & 5000 & & & \\ \hline Complete Final Inspections & & & & & & & & & & & 4.000 & 4000 & & & \\ \hline \end{tabular}