The purpose of this projects to give you experience Creating a profitability analys that can be used to determine the effects of changing business conditions on the dients financial poution. Your goal will be to excel in such a way that any chang to the sumption will controle through the entire profitabilly anai. Business Description After taking buien desses, joke, on avid dag komt decided to start wingutique pet supplies at trade show has two products Product 1 "Throw it at all throw that will sell for $15. You have been hired by take to build a CVP model that will be understand the impacto en condition hisperating in con. See Starting File world in your model of the original wmption will be listed in one area of the readed green bas Mother calculations in the model will reference the wins green boa ach that any assumption, the feet will ople touch the entire model focomio this, you will ne FORMULAShether other in the wheet. In other words, the only place you will type number is the box. FIRST TASK Rename your Encel preadsheet to your full name FORMATTING Convention to we throughout project Hand UNITS to the nearest while the decrease edilebutton on your toolbar rather than the Hounding function Show all MONETARY mots en dollers and cente Hound to the newest contaj Use the decease decimal button rather than the function Show dl percentodecimos, no Right justily alles numbers should be to the right side of the orill, not in the middle or left 1) Complete the core bus based on the date about our business entity and variable costs separately and will find comparately before finding the total for each type of cont 2) Com the Product Vincle ONLY the Protect throw out 2 Product 2 Tretti automatic tre dispenser that releases are when the dont places his power the pedal. The treat dispenser wille for $40 Contato has hired an employee to work the trade show booth. The work contract $1,600 per month lary has a commission equal to 10% estevenue lewe a spend 100 per month on trade show entry fees to purchasing the products from a supplier in China. Throw it cost $2.50 cach: Treath $11 each Shipping and handling on the Throw it will cost 56 at Shipping and handling on the Treat Is which are heavier, will cost $9 each the shipping and handling costs will be paid in Jabe, not the customer 3) Complete the CM Statement for the month of June yelowo), HINT: on products Income statements such as this, the food costs are only listed in the total com Malere you who show the tal for all other items Assume loke expects to sell Throw its and 200 Treats during his first month of operations une Jake's financial goal is to camanet operating income of $6.0 per month believe volume may at a rate of month 4) to the Margin of ty MOST les as the expected sales pe box und in only Thew Tapet opples ASSUMPTIONS Podu: Spe Vancouts per unit: UCM CMS For the month ending P1 in care Monthly volume woducto Pro UA CMS Marine Marge of Latery sed cost per month Totalt cont Tort properth 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: "Throw-It"- a tennis ball thrower that will sell for $15. Product 2: "Treat-It Is"- an automatic treat dispenser that releases a treat when the dog places his paw on the pedal. The treat dispenser will sell for $40. Costs: Jake has hired an employee to work the trade show booths. The work contract is $1,680 per month salary plus a commission equal to 10% of sales revenue. Jake will also spend $800 per month on trade-show entry fees. Jake is purchasing the products from a supplier in China. Throw-It cost $2.50 each; Treat-It Is cost $11 each. Shipping and handling on the Throw-its will cost $6 each; Shipping and handling on the Treat-It- Is, which are heavier, will cost $9 each. The shipping and handling costs will be paid by Jake, not the customer. Assume Jake expects to sell 600 Throw-Its and 200 Treat-It-ls during his first month of operations (June). Jake's financial goal is to earn a net operating income of $6,820 per month. He believes volume may grow at a rate of 6% a month. Business & Directions Starting file Grad Type here to search RI N P K M 0 R S calculations in the model will reference the assumptions (green box) such that if any assumption changes, the effect will ripple through the entire model. To accomplish this goal, you will use FORMULAs, rather than numbers, in every other cell in the worksheet. In other words, the only place you will type numbers is the green assumptions box. FIRST TASK: Rename your Excel spreadsheet to your full name I FORMATTING conventions to use throughout project: Round all UNITS to the nearest whole unit. Use the "decrease decimals" button on your tool bar rather than the Rounding function - Show all MONETARY amounts as dollars and cents. Round to the nearest cent. ($x.xx). Use the "decrease decimals" button rather than the Rounding function. Show all percentages as %, not as decimals. (x%, not .xx) Right justify all cells (numbers should be to the right side of the cell, not in the middle or left) 1) Complete the assumptions (green box) based on the data about Jake's business. Identify and list all variable costs separately and all fixed costs separately before finding the total for each type of cost. 2) Complete the Product Analysis (pink boxe) assuming lake ONLY sells either Product #1 (Throw-It) OR Product #2 (Treat-it-is). 3) Complete the CM Income Statement for the month of June (yellow box). HINT: On product line income statements such as this, the fixed costs are only listed in the total column. Make sure you also show the totals for all other line items. 4) Calculate the Margin of Safety (MOS) using June sales as the expected sales (purple box) and assuming only Prodcut 1 is being sold. Calculate the MOS in terms of salos revenue and as a percentage