Please help me answer the following three questions with the original worksheet shown above

Once you have built the model, use it to answer Jake's questions about his business. Treat each situation as a separate scenario. All comparisons should be made to the original assumptions.

1. Save a copy of your original model to a new spreadsheet called "supplier cost increase". Say the supplier is expected to increase the cost of the products by 20%. What is the new operating income? What is the new WACM%? What is the new MOS%? Briefly explain your findings to the client.

2. Save a copy of your original model to a new spreadsheet called "new sales mix". Say the monthly sales volume is now expected to be 175 "Treat-times" and 125

"Launch-its" (same total units, but a different sales mix). What is the new operating income? What is the new WACM/unit ? Given this sales mix, how many units (in total) will Jake need to sell to earn his target profit? Briefly explain your findings to the client.

3. Save a copy of your original model to a new spreadsheet called "alternative contract". Say Jake's employee wanted to negotiate a different work contract: $1,500 per month plus 5% of revenue. Given his original sales volume and mix, how would this contract have changed Jake's operating income? What is the new operating leverage factor? What is the new expected percentage change in operating income if volume increases as expected in the future? Briefly explain your findings to the client.

Once you have built the model, use it to answer Jake's questions about his business. Treat each situation as a separate scenario. All comparisons should be made to the original assumptions. 1. Save a copy of your original model to a new spreadsheet called "supplier cost increase". Say the supplier is expected to increase the cost of the products by 20%. What is the new operating income? What is the new WACM\%? What is the new MOS\%? Briefly explain your findings to the client. 2. Save a copy of your original model to a new spreadsheet called "new sales mix". Say the monthly sales volume is now expected to be 175 "Treat-times" and 125 "Launch-its" (same total units, but a different sales mix). What is the new operating income? What is the new WACM/unit? Given this sales mix, how many units (in total) will Jake need to sell to earn his target profit? Briefly explain your findings to the client. 3. Save a copy of your original model to a new spreadsheet called "alternative contract". Say Jake's employee wanted to negotiate a different work contract: $1,500 per month plus 5% of revenue. Given his original sales volume and mix, how would this contract have changed Jake's operating income? What is the new operating leverage factor? What is the new expected percentage change in operating income if volume increases as expected in the future? Briefly explain your findings to the client. \begin{tabular}{|l|l|lr|} \hline \multicolumn{1}{|c|}{} & \multicolumn{2}{c|}{ E } & \multicolumn{2}{c|}{ F } \\ \hline Product \#A & Launch-it & \\ \hline Unit CM & $ & 60% \\ \hline CM \% & & 650 \\ \hline Breakeven point: & & 2,500 \\ \hline -in units & & \\ \hline -in sales revenue & $ & 1583 \\ \hline & & 15,833 \\ \hline & Target profit volume: & & \\ \hline -in units & & 250 \\ \hline & -in sales revenue & $ & 20 \\ \hline \end{tabular} Jake's Pet Supplies Pro Forma Contribution Margin Income Statement For the month ending June 30 \begin{tabular}{|l|rr|rr|r|} \hline Multiproduct Breakeven point: & \multicolumn{2}{|c|}{ Product \#\# } & \multicolumn{2}{|c|}{ Product \#\# 2} & \multicolumn{2}{|c|}{ Iotal } \\ \hline -in units & 125 & & 63 & 188 \\ \hline Sales revenue at breakeven & $ & 1,250 & $ & 1,875 & $125 \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline Margin of Safety (in \$) & $ \\ \hline & 1,875 \\ \hline Margin of Safety \% & 38% \\ \hline & \\ \hline Operating Leverage Factor & 2.67 \\ \hline & 13% \\ \hline Expected \% change in operating income (\%) & \\ \hline \end{tabular}