Pls, help me out for this excel as soon as possible... ( Subject:- Project management)

Assignment: 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 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 S 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. Rate Comments Unit Hours Hours Hours Trips Staff Staff Quantity 400 50 100 3 12 5 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 Grading See attached rubric Grading Rubric Available Not completed Many Items Some Items Fully Complete Marks Missing Missing Cost 3 0 1 2 3 O out of 6 costs 1 or 2 out of 6 3 or 4 out of 6 5 or 6 out of 6 correct costs correct costs correct costs correct Price 3 0 1 2 3 O out of 3 correct 1 out of 3 correct 2 out of 3 correct 3 out of 3 correct (overhead, (overhead, (overhead, (overhead, profit, total) profit, total) profit, total) profit, total) Price 3 0 1 2 3 Reduction Not provided Provided with no Provided with a Provided with rational basic rational full rational Format 1 0 0.5 1 O or 1 of 3 2 of 3 submission 3 of 3 submission submissions instructions instructions instructions followed followed. followed Project Project manager Project artifacts Budget Project Sponsor Updated Approved Budget $0.00 Budget Status Planned Expenditures to Date Actual Expenditures to Date $0.00 $0.00 Planned Remaining Budget Actual Remaining Budget 50.00 50.00 Variance $0.00 Variance $0.00 Additional $ needed Budget Details Hourly Rate 50.00 50.00 $0.00 50.00 $0.00 $0.00 Hours 0.00 0.00 0.00 0.00 0.00 0.00 Total Cost $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Total Cost $0.00 $0.00 $0.00 Intemal Expenses Salaries Type of resource Type of resource Type of resource Type of resource Type of resource Type of resource Other Internal Expenses Type of expense Type of expense Dype of expense Total Internal Expenses Edemal Expenses Consulting Costs Type of consulting Dype of consulting Dype of consulting Capital Expenditures Dype of expense Dype of expense Type of expense Total External Expenses Total Budget $0.00 Total Cost $0.00 $0.00 $0.00 Total Cost $0.00 $0.00 $0.00 $0.00 $0.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 $0.00 $0.00 $0.00 $0.00 $0.00 50.00 $0.00 $0.00 $0.00 $0.00 $0.00 Benefits/Savings FYO2 FY01 FY03 FY04 FYOS 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 50.00 $0.00 $0.00 $0.00 50.00 $0.00 $0.00 $0.00 50.00 $0.00 $0.00 $0.00 50.00 $0.00 $0.00 $0.00 50.00 Future Value Interest Rate Present Value Periods Future Value $0.00 Present Value Interest Rate Periods Future Value $0.00 Present Value $0.00 Net Present Value Cash Flow Present Value Period 1 2 3 4 5 Totals Project development cost Net present value 50.00 $0.00 $0.00 $0.00