2.1. Data Center Data Work began on 01/01/22. The Completion date is 12/31/22. No. Description Completion Period Month/Yr. Status as of Planned Planned 9/30/22 Quantity Amount Equipment 1.1 Servers ($9,000/Unit) 8/22 100% 10 $90,000 1.2 Desktop ($2,000/Unit) 8/22 100% 4 $8,000 1.3 Printer ($1,500/Unit) 8/22 100% 2 $3,000 1.4 Routers & Switches ($3,000/Unit) 8/22 100% 5 $15,000 1.5 Firewall ($2,500/Unit) 11/22 1 $2,500 1.6 Intrusion Detection system ($1,000/Unit) 11/22 100% 1 $1,000 1.7 VPN 11/22 0 $1,000 1.8 Optical System & accessories 11/22 100% $5,000 1.9 UPS ($1,250/Unit) 8/22 100% 3 $3,750 1.10 Racks 8/22 100% $2,000 1.11 PPE (3) 3 $1,200 1.12 Accessories & Misc. 11/22 0 1 $5,000 1 Equipment Subtotal $137,450 Labor 2.1 Procure Equipment ($100/Hr) 12/22 70% 240 Hrs. $24,000 2.2 Procure Software ($100/Hr.) 12/22 70% 160 Hrs. $16,000 2.3 Create Network ($100/Hr.) 12/22 70% 200 Hrs. $20,000 2.4 Install & Connect All Equipment 12/22 70% 400 Hrs. $40,000 ($100/Hr.) 2.5 Project Management ($150/Hr.) 12/22 70% 100 Hrs. $15,000 2 Labor Subtotal $115,000 Other Costs 31 IT Related Costs 12/22 0 $5,000 3.2 Non-IT Related 12/22 50% $3,000 3.3 Warranty and Maintenance 12/22 0 $5,000 3.4 Internet and VPN Costs for One Year 12/22 0 $2,000/ Mo $24,000 3.5 On-Site Meetings ($1,800/Trip) 12/22 50% 2 $4,000 3 Other Costs Subtotal $41,000 Total Costs (1+2+3) $293,450 4 Contingency Costs 0% $0 Grand Total (1+2+3) $293,450 2.2. Status Reporting Notes The Data Center project is well underway. The above table reflects the work status as of the reporting date of 9/30/2022. Prepare an EVMS table as of this reporting date. 1. The period column shows the month when the equipment or other items need to be deployed. 2. The status column indicates the % of work completed as of the reporting date. 3. The Planned Amount column shows the planned (committed) amount for that line item. 4. The accounting department has reported the total actual cost incurred as of the reporting date to be $190K. 5. Line Items Interpretation: Line item 1.1 indicates that all the servers (100%) were installed by 8/22, for which the total planned amount is $90K. Line item 1.6 shows that it is 100% installed though it is not due until the end of 11/22. 6. The labor and project management costs are planned to be at 75% (for 9 out of 12 months), but they have incurred only 70% of the allocated hours as of 9/22. 7. The two trips are planned for each July and December 2022. 8. The tasks (line items) completed ahead of schedule are color-coded orange. 9. State your assumptions wherever needed for clarification. 10. Show your formula and calculations clearly. EVMS Table as of 9/30/22 Fill in the table below by showing the formula and calculations. No. Parameter 1 BAC 2 PV 3 EV 4 CV | 5 AC 6 SV 7 CPI 8 EAC 9 VAC 10 10 ETC 11 TCPI Formula and clarification Value