Project Management

please fill this excel sheet for me

For this assignment, we are going to change our point of view. You are now working for Woolly, and you are preparing Woolly's response to Mammoth's RFP to support the transition of the 12 staff from Saber to Mammoth. Your job is to develop the price that will be part of the fixed price contract Since Woolly has done transitions many times, you have good historical records, and you can use parametric estimating to help prepare the estimate. Working with the team, you have to develop the following information.

please fill this excel sheet for me

Cost/Benefit Analysis Project Project manager Project artifacts Project # Sponsor Updated Project Development and Maintenance Costs FY01 FYO2 FYO3 FY04 FY05 Total Description Cost of Project Development Salaries Other internal expenses Consulting costs Capital expenditures Total project costs Cost of Support Operational costs Nonrecurring costs Recurring costs Total ongoing support costs $0.00 S0.00 $0.00 S0.00 $0.00 S0.00 $0.00 $0.00 $0.00 $0.00 50.00 $0.00 Benefits/Savings FY02 FY01 FYO3 FY04 FY05 Total Current Process Total annual price New Process Total annual price Annual savings Cumulative savings Cumulative costs Cumulative total net savings 0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 50.00 $0.00 $0.00 $0.00 $0.00 50.00 $0.00 $0.00 50.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Future Value Interest Rate Present Value # Periods Future Value $0.00 Present Value Interest Rate # Periods Future Value $0.00 Present Value S0.00 Net Present Value Cash Flow Present Value Period 1 2 3 4 $0.00 5 Totals Project development cost Net present value $0.00 $0.00 S0.00 ASSIGNMENT PROJECT MANAGEMENT Course Code: BUS 1037 January 11 - April 24, 2021 Due Date: ,2021 Assignment Value: 20% Project: Estimating Overview For this assignment, we are going to change our point of view. You are now working for Woolly, and you are preparing Woolly's response to Mammoth's RFP to support the transition of the 12 staff from Saber to Mammoth. Your job is to develop the price that will be part of the fixed price contract. Since Woolly has done transitions many times, you have good historical records, and you can use parametric estimating to help prepare the estimate. Working with the team, you have to develop the following information. Activities Rate Comments Consultant $ 100 A team of 25 to work 400 hours Legal Support $ 200 You have experience with Saber's country location Communications $ 100 Communications with Mammoth and responding to staff questions Travel $ 2,000 3 trips to Saber's location to meet with staff, consultant based in Europe Package Preparation $ 500 To prepare customized packages for each staff Staff Coaching $ 5,000 Outsource support for staff for 90 days, delux package Also, your Accounting team wants you to add a 40% overhead on labour costs and a 30% for profit and contingency on all the costs, but not the 40% overhead cost. The overhead on labour costs applies only to hourly costs (consultant, legal support, and communications). You expect that you will need to submit a bid of $140,000 to win the contract. Unit Hours Hours Hours Trips Staff Staff Quantity 400 50 100 3 12 5 Fall 2014