Instructions: The assignment should be a series of calculations addressing the requested items. This will be done in cleanly designed and clearly labeled spreadsheets that are formatted for printing. Name the tab of the sheet with your answers with your first and last name. Submit your Excel spreadsheet to me via D2L.

Snowies, owned by Carl and Gordon Rupp, is a company that provided training, equipment, and supplies for operating a shaved ice business. Shaved ice is an ice-based refreshment made by shaving a block of ice into a fluffy, snow-like ice. The product is served in cups with flavored syrups added to the ice. Due to its fine texture, shaved ice absorbs the syrup, making each bite flavorful. Snowie does not sell franchises. It sells a wide array of equipment and supplies, including ice shavers, kiosks, carts, buses, syrups, cups, and other supplies to independent operators.

Assume that you are evaluating whether to start a Snowie business. You could operate a shaved ice kiosk at fairs, downtown areas, and other outdoor events. The kiosk is portable with wheels and a hitch. It has plenty of storage place, work area, electrical outlets, lighting, and a water system. The flavored shaved ice, a Snowie, is normally offered in three sizes. For this case, we are going to assume that only one size is offered the large size, 20 oz. The large Snowie sells for US$4.00. See the following page for a list of all costs related to a large size Snowie.

In this case, use straight-line depreciation with a five-year life and salvage values of zero for both the ice shavers and the flavor station. All monetary amounts in this case are expressed in U.S. dollars.[i]

In your calculations, specify your assumptions about the following items:

1. Number of days you anticipate opening the Snowie kiosk per month ___________
2. Number of hours you will work (no wages required) per day ___________
3. Number of hours you will pay an employee to work in the Snowie kiosk per day __________

Make the above figures dynamic, such that if you can change them the answers will also change.

Answers needed:

1. What is the contribution margin per snow cone?
2. How many snow cones must be sold each month to break even? How many snow cones is that on a per day and per hour basis? If this does not seem reasonable based on your assumptions, adjust your assumptions.
3. How many snow cones must be sold to achieve an operating profit of $2000 per month (before tax)? How many snow cones is that on a per day and per hour basis? If this does not seem reasonable based on your assumptions, adjust your assumptions.

Ice per snowie	$0.20
Spoon straw (need one per snowie)	$0.02
Styrofoam cup (need one per snowie)	$0.08
Napkin per sheet	$0.01
Servings per gallon of syrup	28
Cost per gallon of syrup (includes concentrate, preservative, and sugar)	$4.25
Hourly rate of workers	$10.00
Event registration fee per day	$25.00
Electricity, insurance, maintenance, and permit costs per month	$250.00
Kiosk rental per month	$650.00
Purchase cost of two ice shavers (five-year life)	$3,180.00
Purchase cost of a flavor station (five year life)	$1,080.00