Question

AutoSave 00 File Home o 2 Insert Search 8 Draw IMA Case Study - Snowies Shaved Ice Excel Template ... Page Layout Formulas Data Review View Help A40 . f S. Total fixed cost per month 1 Part 1 3 Data 4 Selling price per large Snowie 4.00 u 0.20 0.02 0.08 0.01 6 Ice per Snowie 7 Spoon straw (need one per Snowie) 8 Styrofoam cup (need one per Snowie) 9 Napkin (need two per Snowie) 10 Servings per gallon of syrup 11 Cost per gallon of syrup (includes concentrate, preservative, and sugar) 12 Hourly rate for workers 13 Event registration fee per day 14 Electricity, insurance, maintenance, and permit costs per month 15 Kiosk rental cost per month 16 Purchase cost of two ice shavers (5 year life) 17 Purchase cost of a flavor station (5-year life) 52 6. Break even volume per month su 4.25 10.00 25.00 250.00 650.00 3,180.00 1,080.00 57 7. Number of Snowies to be sold to earn target profit of $2,000 per month Part 1 Ready Circus Part 2 Part 3 Type here to search

Answer 1

Break Even Point Total Fixed Cost Contribution Per Snowie | BEP | $3,596.67 $3.53 1019.00| Variable Cost Per Unit Cost in $ Ice Cost/Snowie 0.20 Spoon Straw 0.02 Styrofoam Cup 0.08 Napkin (2*$0.01) 0.02 Cost Of Serving Per Snowie $4.25/128 Ounces* 4.5 ounces per Snowie 0.15 Total Variable Cost $0.47 Selleing Cost Per Snowie $4.00 Contribution Per Snowie $3.53 Unit to be sold To Earn Profit Of $2000 Total Fixed Cost $3,596.67 Profit To be Earn $2,000.00 Total Contribution Required $5,596.67 Contribution Per Snowie $3.53 Fixed Cost Cost of Worker $10/Hr*8Hr/Day* 25Days/Mon $2,000.00 Unit To Be Sold 1585.00 Registration Fees =$25/Day* 25 Days $625.00 Electricity, Insurance, Maintenance & Permits/Month Rental Cost Per Month Cost Of Ice Shavers Cost Flavour Station Total Fixed Cost/Month $250.00 $650.00 $53.33 $18.33 $3,596.67