400 hours/ea @ $50/hour 250 hours/ea @ $55/hour 200 hours/ea @ $40/hour 50 hours/ea @ $50/hour $50,000 Development CostsPersonnel Remote Analysts 4 programmers 1 Remote Transition Consultant 1 Remote Specialist Development Costs-Training Remote Training Development Costs- Hardware/Software 1 Additional Server Space Cloud/VPN license 5 Laptops Zoom license Annual Operating Costs-Personnel Annual Operating Costs $18,700 $50,000 $2000/laptop $10,000 $20,000 Your organization has an annual 200,000 worth of sales. Using a remote model, sales will be 50% less. Using a format similar to the spreadsheets in this course, develop a spreadsheet that summarizes this project's cash flow, assuming a 4- year useful life after the project is developed. Compute the present value of the cash flows, using an interest rate of 9%. What is the NPV for this project? What is the ROI? What is the breakeven point? Would you do the project? Why or why not? What is the NPV and ROI if the pandemic were over in 2022? What are the risks your organization faces if you don't do the project? 400 hours/ea @ $50/hour 250 hours/ea @ $55/hour 200 hours/ea @ $40/hour 50 hours/ea @ $50/hour $50,000 Development CostsPersonnel Remote Analysts 4 programmers 1 Remote Transition Consultant 1 Remote Specialist Development Costs-Training Remote Training Development Costs- Hardware/Software 1 Additional Server Space Cloud/VPN license 5 Laptops Zoom license Annual Operating Costs-Personnel Annual Operating Costs $18,700 $50,000 $2000/laptop $10,000 $20,000 Your organization has an annual 200,000 worth of sales. Using a remote model, sales will be 50% less. Using a format similar to the spreadsheets in this course, develop a spreadsheet that summarizes this project's cash flow, assuming a 4- year useful life after the project is developed. Compute the present value of the cash flows, using an interest rate of 9%. What is the NPV for this project? What is the ROI? What is the breakeven point? Would you do the project? Why or why not? What is the NPV and ROI if the pandemic were over in 2022? What are the risks your organization faces if you don't do the project