Have most of this finished but need help with the blank boxes. Please show the formulas used!

CVP Modeling project The purpose of this project is to give you experience creating a multiproduct profitability analysis that can be used to determine the effects of changing business conditions on the client's financial position. Your goal will be to use Excel in such a way that any changes to the assumptions will correctly ripple through the entire profitability analysis. If executed properly, the client should be able to use this spreadsheet over and over, using different "what if" assumptions. Business Description After taking business classes, Jake, an avid dog-lover, decided to start selling unique pet supplies at trade shows. He has two products: Product 1: "Launch-it" - a tennis ball thrower that will sell for $10. Product 2: "Treat-time"- an automatic treat dispenser that releases a treat when the dog places his paw on the pedal. The treat dispenser will sell for $30. Costs: Jake has hired an employee to work the trade show booths. The work contract is $1,000 per month plus a commission equal to 10% of revenue. Jake will also spend $500 per month on trade-show entry fees. Jake is purchasing the products from a supplier in Mexico. Launch-its cost $1 each; Treat-times cost $7 each. Shipping and handling on the Launch-its will cost $2 each; Shipping and handling on the Treat-times, which are heavier, will cost $8 each. The shipping and handling costs will be paid by Jake, not the customer. Assume Jake expects to sell 200 Launch-its and 100 Treat-times during his first month of operations (June). Jake's financial goal is to earn an operating income of $8,000 per month. He believes volume may grow at rate of 5% a month. \begin{tabular}{|l|lr|} \hline Product \#1 & \multicolumn{1}{|l|}{ Launch-it } \\ \hline Unit CM & $ & 6.00 \\ \hline CM \% & & 60% \\ \hline Breakeven point: & & 250 \\ \hline -in units & & 2,500.00 \\ \hline -in sales revenue & $ & \\ \hline & & \\ \hline Target profit volume: & & 2,375.00 \\ \hline -in units & $ & 23,750.00 \\ \hline -in sales revenue & $ & \\ \hline \end{tabular} \begin{tabular}{|l|lr|} \hline Product 12. & \multicolumn{1}{|l|}{ Treat-time } \\ \hline Unit CM & $ & 12.00 \\ \hline CM \% & & 40% \\ \hline Breakeven point: & & 125 \\ \hline -in units & & 3,750.00 \\ \hline -in sales revenue & $ & \\ \hline & & \\ \hline Target profit volume: & & \\ \hline -in units & $ & 15,833.33 \\ \hline -in sales revenue & $ & \\ \hline \end{tabular} Jake's Pet Supplies Pro Forma Contribution Margin Income Statement For the month ending June 30 \begin{tabular}{|l|rr|rr|rr|} \hline & \multicolumn{2}{|c|}{ Product \#1 } & \multicolumn{2}{c|}{ Product \#2 } & \multicolumn{2}{c|}{ Total } \\ \hline Sales Price & $ & 2,000.00 & $ & 3,000.00 & $ & 5,000.00 \\ \hline Less: Total variable cost & $ & 800.00 & $ & 1,800.00 & $ & 2,600.00 \\ \hline Contribution Margin & $ & 1,200.00 & $ & 1,200.00 & $ & 2,400.00 \\ \hline Less: Total Fixed costs per month & & & & & $ & 1,500.00 \\ \hline Operating Income & & & & $ & 900.00 \\ \hline & & & & & \\ \hline Overall CM \% & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|} \hline Multiproduct Breakeven point: & Product \#1 & Product \#2 & Total \\ \hline -in units & & & 187.5 \\ \hline Sales revenue at breakeven & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|} \hline Multiproduct Target profit point: & Product A1 & Product \#2 & Total \\ \hline - in units & & & \\ \hline Sales revenue at target profit & & & \\ \hline \end{tabular} Margin of Safety (in \$) Margin of Safety \% Operating Leverage Factor Expected % change in operating income (%) Once you have buit the model, use it to artwer jake's questions about his business. Ireat each situation as a separate scenario. All comparisons should be made to the original assumption. 1. Sime a copy of your onigiral model to a new spreadsheet called sypplier cost increase". Say the sapplier is expected to increase the cost of the products by 203 . What is the new aperating income? What is the new overall cMot? What is the new Mosks? Reriefly explain your findings to the dient. 2. Stre a copr of vour criginal model to a new spreadshent called "new salet max". 5a) the monthly sples volume an now expected to be 175 "Treat cines" and 125 "Launch-ts" (same total onits, but a different sales mix). What is the new operating income? What b the new overall CM per unt ? Gven thes sales mis, how many units (an total) wit iake nesed to sell to earn his taret profit? Enetly explain your findings to the clent. 3. Save a copr of your ocignal model to a new spieadsheet called "altemative contract". Say laker semployee wanted to negotiate a different work contract 51,500 contret heve changed ake's operating income? What is the new operative leverate factar? What is the newe eapected percentage chanee in opersting incone if wolume increases at eopected in the future? eniefy explan your findings to the clent