Hello,

I need an urgent help in 2 hours to compute financial projections for 6 months based on the data provided. I need one simple table and few bullet points explaining the projections. I need it asap. Please help.

Thanks in advance...

At this point, Project X is 39% complete. Labor hours so far have been spent in R & D and Project Management. R&D is 68% complete with their task while Project Management is only 33% complete with their task. In November, the Engineering Design team will begin their work and kick off the execution phase of Project X. Month BCWS BCWP ACWP EAC CPI SPI Jan 111,608 68,108 130,928 4,487,839 0.52 0.61 Feb 223,216 136,216 261,856 4,487,839 0.52 0.61 March 334,824 247,824 392,784 3,846,664 0.65 0.74 April 446,432 402,932 531,684 3,342,367 0.76 0.90 May 558,040 558,040 672,384 3,124,540 0.83 1.00 June 669,648 713,146 824,990 3,033,190 0.86 1.06 Both the CPI and SPI indicate this project got off to a rough start. At this point, we are still over budget by approximately $3 mill dollars. This number has been reduced quite a bit since January, when it was estimated to cost $4.5 million over budget. With time, we may be able to reduce this number even more to more evenly match the original budget projections. Originally, this project was faced with poor management and high employee turnover. This set labor hours back quite a bit but currently, we are running slightly ahead of schedule