Part 3 Part A Top management has accepted the schedule created at the end of Part 2 (Part B). Material cost is as follow: UPS cost $49,375.00, surge suppressors cost $21,638.06 and electrical materials $25,000.00. Prepare a brief memo that addresses the following questions: 1. How much will the project cost? What is the most expensive activity? 2. What resource commands the greatest total cost? 3. During which month of the project are the highest and lowest costs expected to occur? What are those costs? 4. What likely costs are not contained in this budget? 5. Include a monthly cash flow for the project. Once you are confident that you have the final schedule, save the file as a baseline. Hint: Save a backup file just in case without baseline! Part B Today's date is May 22, 2015. Table 5 below summarizes the information regarding activities accomplished to date Top management has requested a written status report for the UPS project 1. Your status report should include a table containing the PV, EV, AC, BAC, EAC, SV, CV, and CPI for each activity and the whole project. The report should also address the following questions: a) How is the project progressing in terms of cost and schedule? b ) What activities have gone well? What activities have not gone well? C) State the PCIB and PCIC and interpret what they mean in terms of this project? d) What is the forecasted cost at completion (EAC,)? What is the predicted VAC,? Interpret what they mean in terms of this project? e) Report and interpret the TOPI for the project at this point in time. f) What is the estimated date of completion? g) How well is the project doing in terms of its priorities? What advice can you give Top management? Try to present the above information in a form worthy of consideration by top management. Note: Enter May 21 as the status report date since you are preparing your report on the 22nd. 2. While preparing your report you receive a phone call from Jim Keltner, a fellow project manager. He is calling to see if one of the PC & Network Team members assigned to your project would be available to work on his project from May 27 to 29, 2015. What would you tell him?Why? You should submit THREE files: 1. ONE MS Project files named Group_Your GroupNumber Part A and B with the following: Cost Table for Task and Resources Include a tracking table for the project. Include an earned value table with the necessary information. Include a variance table for schedule 2. A MS Word document named Group_YourGroupNumber with your memo answering the questions above