Answered step by step
Verified Expert Solution
Question
1 Approved Answer
it should be in excel according to below picture Also, your Accounting team wants you to add a 40% overhead on labour costs and a
it should be in excel according to below picture
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. Total Budget \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multicolumn{7}{|c|}{ Cost/Benefit Analysis } \\ \hline Project & & & & Project \# & & \\ \hline Project manager & & & & Sponsor & & 0 \\ \hline Project artifacts & & & & Updated & & \\ \hline \multicolumn{7}{|c|}{ Project Development and Maintenance Costs } \\ \hline Description & FY01 & FY02 & FY03 & FY04 & FY05 & Total \\ \hline \multicolumn{7}{|c|}{ Cost of Project Development } \\ \hline \multicolumn{7}{|l|}{ Salaries } \\ \hline \multicolumn{7}{|l|}{ Other internal expenses } \\ \hline \multicolumn{7}{|l|}{ Consulting costs } \\ \hline \multicolumn{7}{|l|}{ Capital expenditures } \\ \hline Total project costs & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 \\ \hline \multicolumn{7}{|c|}{ Cost of Support } \\ \hline \multicolumn{7}{|l|}{ Operational costs } \\ \hline \multicolumn{7}{|l|}{ Nonrecurring costs } \\ \hline \multicolumn{7}{|l|}{ Recurring costs } \\ \hline Total ongoing support costs & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 \\ \hline \end{tabular} 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. \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multicolumn{7}{|c|}{ Benefits/Savings } \\ \hline Current Process & FY01 & FY02 & FY03 & FY04 & FY05 & Total \\ \hline \multicolumn{7}{|l|}{ Total annual price } \\ \hline \multicolumn{7}{|l|}{ New Process } \\ \hline \multicolumn{7}{|l|}{ Total annual price } \\ \hline Annual savings & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 \\ \hline Cumulative savings & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 \\ \hline Cumulative costs & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 \\ \hline Cumulative total net savings & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 \\ \hline \multirow[t]{2}{*}{ Present Value } & \multirow{2}{*}{\multicolumn{2}{|c|}{ Interest Rate }} & \multicolumn{2}{|c|}{ \# Periods } & \multicolumn{2}{|c|}{ Future Value } \\ \hline & & & & & \multicolumn{2}{|c|}{$0.00} \\ \hline \multicolumn{7}{|c|}{ Present Value } \\ \hline Future Value & \multicolumn{2}{|c|}{ Interest Rate } & \multicolumn{2}{|c|}{ \# Periods } & \multicolumn{2}{|c|}{ Present Value } \\ \hline$0.00 & & & & & \multicolumn{2}{|c|}{$0.00} \\ \hline \multicolumn{7}{|c|}{ Net Present Value } \\ \hline Period & \multicolumn{4}{|c|}{ Cash Flow } & \multicolumn{2}{|c|}{ Present Value } \\ \hline \multicolumn{7}{|l|}{1} \\ \hline \multicolumn{7}{|l|}{2} \\ \hline \multicolumn{7}{|l|}{3} \\ \hline \multicolumn{7}{|l|}{4} \\ \hline \multicolumn{7}{|l|}{5} \\ \hline Totals & \multicolumn{4}{|c|}{$0.00} & \multicolumn{2}{|c|}{$0.00} \\ \hline \multicolumn{5}{|l|}{ Project development cost } & \multicolumn{2}{|c|}{$0.00} \\ \hline Net present value & & & & & & \\ \hline \end{tabular} 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. Total Budget \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multicolumn{7}{|c|}{ Cost/Benefit Analysis } \\ \hline Project & & & & Project \# & & \\ \hline Project manager & & & & Sponsor & & 0 \\ \hline Project artifacts & & & & Updated & & \\ \hline \multicolumn{7}{|c|}{ Project Development and Maintenance Costs } \\ \hline Description & FY01 & FY02 & FY03 & FY04 & FY05 & Total \\ \hline \multicolumn{7}{|c|}{ Cost of Project Development } \\ \hline \multicolumn{7}{|l|}{ Salaries } \\ \hline \multicolumn{7}{|l|}{ Other internal expenses } \\ \hline \multicolumn{7}{|l|}{ Consulting costs } \\ \hline \multicolumn{7}{|l|}{ Capital expenditures } \\ \hline Total project costs & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 \\ \hline \multicolumn{7}{|c|}{ Cost of Support } \\ \hline \multicolumn{7}{|l|}{ Operational costs } \\ \hline \multicolumn{7}{|l|}{ Nonrecurring costs } \\ \hline \multicolumn{7}{|l|}{ Recurring costs } \\ \hline Total ongoing support costs & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 \\ \hline \end{tabular} 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. \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multicolumn{7}{|c|}{ Benefits/Savings } \\ \hline Current Process & FY01 & FY02 & FY03 & FY04 & FY05 & Total \\ \hline \multicolumn{7}{|l|}{ Total annual price } \\ \hline \multicolumn{7}{|l|}{ New Process } \\ \hline \multicolumn{7}{|l|}{ Total annual price } \\ \hline Annual savings & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 \\ \hline Cumulative savings & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 \\ \hline Cumulative costs & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 \\ \hline Cumulative total net savings & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 \\ \hline \multirow[t]{2}{*}{ Present Value } & \multirow{2}{*}{\multicolumn{2}{|c|}{ Interest Rate }} & \multicolumn{2}{|c|}{ \# Periods } & \multicolumn{2}{|c|}{ Future Value } \\ \hline & & & & & \multicolumn{2}{|c|}{$0.00} \\ \hline \multicolumn{7}{|c|}{ Present Value } \\ \hline Future Value & \multicolumn{2}{|c|}{ Interest Rate } & \multicolumn{2}{|c|}{ \# Periods } & \multicolumn{2}{|c|}{ Present Value } \\ \hline$0.00 & & & & & \multicolumn{2}{|c|}{$0.00} \\ \hline \multicolumn{7}{|c|}{ Net Present Value } \\ \hline Period & \multicolumn{4}{|c|}{ Cash Flow } & \multicolumn{2}{|c|}{ Present Value } \\ \hline \multicolumn{7}{|l|}{1} \\ \hline \multicolumn{7}{|l|}{2} \\ \hline \multicolumn{7}{|l|}{3} \\ \hline \multicolumn{7}{|l|}{4} \\ \hline \multicolumn{7}{|l|}{5} \\ \hline Totals & \multicolumn{4}{|c|}{$0.00} & \multicolumn{2}{|c|}{$0.00} \\ \hline \multicolumn{5}{|l|}{ Project development cost } & \multicolumn{2}{|c|}{$0.00} \\ \hline Net present value & & & & & & \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started