Project Management Project

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.

please fill this excel sheet for me

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 2.5 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 ASSIGNMENT Assignment Requirements 1. The cost elements (calculations) for the cost of the project 2. The price you would provide to Mammoth 3. Break out and identify opportunities to reduce or increase the cost of the proposal that will allow you to come in at or below $140,000 target price 4. A well-structured, professional document with title page, page numbers, and no spelling or grammatical errors. Submission Instructions Submit your assignment in Blackboard before midnight of the day before the next class Submit your assignment as one file in PDF, Microsoft Word, or Microsoft Excel format Filename must include student's Last Name and the Assignment Number Fall 2014 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 50.00 50.00 $0.00 S0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Benefits/Savings FY02 FY01 FY03 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 S0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 S0.00 S0.00 S0.00 $0.00 $0.00 S0.00 $0.00 $0.00 Future Value Interest Rate Present Value # Periods Future Value $0.00 Present Value Interest Rate # Periods Future Value S0.00 Present Value $0.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 Cost/Benefit Analysis Project Project manager Project artifacts Project # Sponsor Updated Project Development and Maintenance Costs FY01 FYO2 FY03 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 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Benefits/Savings FY02 FY01 FY03 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 $0.00 $0.00 $0.00 $0.00 50.00 S0.00 $0.00 $0.00 $0.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 S0.00 Present Value S0.00 Net Present Value Cash Flow Present Value Period 1 2 3 4 S Totals Project development cost Net present value $0.00 $0.00 $0.00 $0.00