(0)

Edit question

calculate ROI, Payback period and NPV on the Microsoft EXCEL

Bruce and other C-Level Managers have approved a Budget at Completion of AU$ 1.2 million and have made a provision of an additional management reserve of $100,000. This is subject to a change authorization and approval process and Vijay Singh as the project sponsor/champion will oversee the process. All the vice presidents are on board with the project and have provided assurance to support the project human resourcing as required from their relevant areas of responsibility. It is assumed that the project would commence in July 2023 and the new EPR to be commissioned by October 2023 (Quarter 1). The budget and projections provided include expected income for the full year.

Integration of the individual databases and systems can occur once the new systems have been installed. Your team needs to plan for the suitable integration of the above systems by understanding the relevant sequencing requirements for the integration. For preliminary costing purpose, the following figures have been provided: As an estimate, $450,000 is allocated for the project costs (staffing, outsourcing etc @ 150,000 per month for the 3 months). Other costs include licencing, training and operations ($250,000 per quarter) for the full year. Quarterly project revenue is $0 for Q1, $400,000 for Q2, $500,000 for Q3, and $650,000 for Q4. The project has been given the go ahead and your team now needs to initiate and plan the project.