Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

it should be in excel according to below picture

image text in transcribed

image text in transcribedimage text in transcribed 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Communication Audit In Globally Integrated R And D Project Teams

Authors: Justyna Alnajjar

1st Edition

3631666608, 978-3631666609

More Books

Students also viewed these Accounting questions

Question

1. Let a, b R, a Answered: 1 week ago

Answered: 1 week ago