Manage Your Health, Inc. (MYH) is listed as a Fortune 500 Company that provides various healthcare services across the globe. They have 5,000 full-time and 2000 part-time employees. A study found that MYH, Inc. pays 45% more than the industry average for its employee healthcare premiums due to the poor health of its employees. Therefore, the company plans to provide a web application that offers online functionalities to help employees enrol and manage their health-management and recreational programs. This application will have the following capabilities.

Allow employees to register for company-sponsored recreational programs such as soccer, netball, bowling, jogging, walking, etc.

Allow employees to register for company-sponsored classes and programs to help them manage their weight, reduce stress, stop smoking etc.

Track employees' involvement in these recreational and health-management programs

Offer incentives for people to join the programs and do well in them

Project's financial information

The project is expected to cost the company $800,000 for web application development and $140,000 for web and database servers. The project is expected to take eight months to complete. They believe this application will help improve their employees' health a year after its rollout. The rollout of this app will help the company to negotiate lower health insurance premiums, providing a net saving of $250 per employee per year for full-time employees and $150 per employee per year for part-time employees over the next five years. The company expects no savings in employee healthcare premiums for the first two years when the application is up and running. A yearly budget of $100,000 has been set aside for the next five years for system maintenance. A new role, "Application Operations Manager," has been created to work with the software engineering team to develop the application and provide ongoing application support after the rollout of the application. This role will cost the company $140,000 with a 3% yearly increase in the annual salary. Assume that the discount rate is 6%.

Task 1: Business case financial analysis (20 marks) Note: You must also include all the work for any particular calculation ques- 1.1 You must prepare a financial analysis up to year 5 using the Table provided below tion to support your answers for MYH's project to find the project's return on investment (ROI) and payback pe- 2.1 What is the total budget at completion (BAC) for the project? (1 mark) riod based on the financial information provided. (13 marks) 2.2 Assume that the work for the first month is completed in the project. Due to the work done so far, the following information has been provided for its first month. PlanValue(PV)=$100,000EarnedValue(EV)=$90,000ActualCost(AC)=$110,000 Answer the following questions 2.2.12.2.5 (must show all the work). 2.2.1 Explain a likely reason for the difference between PV and AC for the first month of this project. (3 marks) 2.2.2 Calculate the cost variance (CV) and the cost performance ind ex (CPI) for the first month of this project. Is the project under or over budget? (4 marks) Note: Use an Excel spreadsheet to do the financial analysis calculations and 2.2.3 Calculate the schedule variance (SV) and the schedule performance index then cut\& paste the Table into this Word document. You must keep the (SPI) for the first month of this project. Is the project ahead of or behind schedule? (4 marks) Excel spreadsheet for me to see your formulas if required. 2.2.4 Calculate the new estimate at completion (EAC) for this project after the first month's work. (4 marks) 1.2 Calculate the ROI of the project. (2 marks) 2.2.5 Calculate how long it will now take to finish this project. (4 marks) 1.3 Calculate the payback period of the project. (2 marks) 1.4 Justify if the proposed project is worthwhile to undertake. (3 marks) Task 2: Project cost control (20 marks) You are required to control the budget for the above MYH project