Problem:

Company ABC is to produce 200 widgets and is scheduled to take five weeks. Each unit is planned to cost $90. The project is severely cost constrained. Performance data for the project at the end of week three is presented below:

120 total units were planned to be produced

130 units have actually been produced

The financial manager reported that the business had actually spent $13,000 on the project by the end of week three.

Answer the following questions:

Quantify cost variance. Is the project ahead or behind budget?

Quantify schedule variance. Is the project ahead or behind schedule?

Quantify cost performance efficiency. Is the project performing better or worse than planned?

Quantify schedule performance efficiency. Is the project performing better or worse than planned?

What is the forecast of project cost at completion assuming current cost performance efficiency remains the same? How much budget variance is expected at completion?

What is the forecast of funding needed to complete the project (from this point forward)?

What cost performance efficiency would be required for the remainder of the project to complete the project within the original budget?

As the project financial manager, what recommendations would you make?

Note: Can someone please give me a step by step solution?