Question

In: Accounting

Data: Selling price per large Snowie 5$ Ice per snowie (need one per servin)$0.2 Spoon straw...

Data: Selling price per large Snowie 5$

Ice per snowie (need one per servin)$0.2

Spoon straw (need one per serving)$0.02

Napking(need two per snowine) $0.01

Serving per gallon of syrup $28

Cost per gallon of syrup (includes concentrate, preservative, and sugar) $4.25

Hourly rate for workers $10

Even registration fee per day $25

Electricity, insurance, maintenance, and permit cost per month $250

Kiosk rental cost per month (12 month) $650

Purchase cost of two ice shavers (5 year life) $3180

Purchase cost of flavor station (5 year life) $1080

Number of days you anticipate opening the kiosk per month 20

Number of hours you will work (no wages required) per day 6

Number of hours you will pay an employee to work in the kiosk per day 8

  1. Number of days you anticipate opening the kiosk per month 20
  2. Number of hours you will work( no wages required) per day 6
  3. Number of hours you will pay an employee to work in the kiosk per day 8
  4. Number of Snowies you estimate you will sell on average day 69

Question:

Syrup cost per snowie (cost per gallon/Servings per gallon of syrup)

Budget contribution margin income statement For the month ended July 31

Sales revenue from October 6900

Less variable expenses: Ice expense, Spoon straws, Styrofoam cups, napkins, syrup

Total variable expenses $ - No need

Total contribution margin $6900

Less fixed expenses: Wages for workers, event registration fees, kiosk rental cost, Depreciation – ice shavers, Depreciation flavor station

Total fixed expense $- No need

Oparating income $6900

Solutions

Expert Solution

(1) Syrup cost per snowie

= (cost per gallon/Servings per gallon of syrup)

=$4.25/28

=$0.15

(2)

variable costs

ice per snowie $0.2
Napkin $0.02[$0.01*2] Need two per snowie
Spoon straw $0.02
Syrup cost $0.15
Total variable cost per snowie $0.39

wages for worker = $10 per hour*8 hours per day*20 days a month

=$1,600

depreciation ice shavers= cost/useful life/12 months

=$3,180/5 /12

=636/12

=$53

depreciation flavor station = $1,080/5/12

=$18 per month

Budget contribution margin income statement For the month ended July 31

working
Sales revenue $6,900 [69 per day*20 days a month*$5]
Less variable expenses
Ice expense $276 [$0.2*69*20]
Spoon straw $27.6 [$0.02*69*20]
napkins $27.6
syrup $207 [$0.15*69*20]
Total variable costs $538.2
Total contribution margin $6,361.8 [$6,900-538.2]
Less: fixed costs
wages for worker $1,600
Event registration fees $500 [$25*20]
kiosk rental cost $650
Electricity, insurance, maintenance, and permit cost per month $250
depreciation-ice shavers $53
Depreiction Flavor station $18
Total fixed expenses $3,071
Operating income $3,290.8 [$6,361.8-$3,071]

round off if required.

Please upvote if you find this helpful.In case of query please comment.


Related Solutions

Data: selling price per large Snowie 4$ Ice per snowie (need one per servin)0.2 Spoon straw...
Data: selling price per large Snowie 4$ Ice per snowie (need one per servin)0.2 Spoon straw (need one per serving)0.02 Napking(need two per snowine) 0.01 Serving per gallon of syrup 28 Cost per gallon of syrup (includes concentrate, preservative, and sugar) 4.25 Hourly rate for workers 10 Even registration fee per day 25 Electricity, insurance, maintenance, and permit cost per month 250 Kiosk rental cost per month (12 month) 650 Purchase cost of two ice shavers (5 year life) 3180...
Data 4 Unit sales 30,000 units 5 Selling price per unit $60 per unit 6 Variable...
Data 4 Unit sales 30,000 units 5 Selling price per unit $60 per unit 6 Variable expenses per unit $30 per unit 7 Fixed expenses $810,000 What is the break-even in dollar sales?        (b) What is the margin of safety percentage?        (c) What is the degree of operating leverage? (Round your answer to 2 decimal places.)        3. Using the degree of operating leverage and without changing anything in your worksheet, calculate the percentage change in net operating...
Data 4 Selling price per unit $374 5 Manufacturing costs: 6   Variable per unit produced: 7...
Data 4 Selling price per unit $374 5 Manufacturing costs: 6   Variable per unit produced: 7     Direct materials $152 8     Direct labor $58 9     Variable manufacturing overhead $38 10   Fixed manufacturing overhead per year $166,400 11 Selling and administrative expenses: 12   Variable per unit sold $4 13   Fixed per year $98,000 14 15 Year 1 Year 2 16 Units in beginning inventory 0 17 Units produced during the year 3,200 2,600 18 Units sold during the year 2,800 2,800 19...
A B C D 1 Chapter 5: Applying Excel 2 3 Data 4 Selling price per...
A B C D 1 Chapter 5: Applying Excel 2 3 Data 4 Selling price per unit $321 5 Manufacturing costs: 6   Variable per unit produced: 7     Direct materials $141 8     Direct labor $69 9     Variable manufacturing overhead $40 10   Fixed manufacturing overhead per year $127,600 11 Selling and administrative expenses: 12   Variable per unit sold $5 13   Fixed per year $65,000 14 15 Year 1 Year 2 16 Units in beginning inventory 0 17 Units produced during the year...
Selling price of ZylexB per gallon $         17.00 Selling price of ZylexA per gallon $         11.00...
Selling price of ZylexB per gallon $         17.00 Selling price of ZylexA per gallon $         11.00 Minutes to manufacture a gallon of ZylexA                  25 Additional minutes to manufacture a gallon of ZylexB                  10 Cost per gallon of resources for manufacturing: ZylexA Additional Cost - ZylexB Material $2.00 $1.75 Labor 2.50 0.50 Variable overhead 2.25 1.10 Both products have been successful and demand for both products is strong and beyond the company's capacity. Since it takes additional time to...
ABC Inc. manufactures and sells toys. Price and cost data are as follows: Selling price per...
ABC Inc. manufactures and sells toys. Price and cost data are as follows: Selling price per unit (package of 2 CDs)...................................... $20.00 Variable costs per unit: Direct material............................................................................................................... $4.00 Direct labor...................................................................................................................... $5.00 Artist's royalties.............................................................................................................. $3.50 Manufacturing overhead.......................................................................................... $3.00 Selling expenses............................................................................................................ $1.00 Total variable costs per unit............................................................ $16.50 Annual fixed costs: Manufacturing overhead.......................................................................................... $180,000 Selling and administrative....................................................................................... $220,000 Total fixed costs................................................................................ $400,000 Forecasted annual sales volume (120,000 units)......................... $2,400,000 If the company's direct-labor costs do increase by 8%, what selling price...
Builders need to predict the final selling price of a home. For one model using size...
Builders need to predict the final selling price of a home. For one model using size (x), in square feet, to predict price (y), in U.S. dollars, a slope of 77 was found. Interpret this slope in context. a. If a house costs one more dollar, it is predicted to increase in size by 77 square feet, on average. b. If a house increases in size by one square foot, it is predicted to cost $77 more, on average. c....
Monthly Budget Data Selling price per Unit $79 per unit Raw Materials Cost $27 per unit...
Monthly Budget Data Selling price per Unit $79 per unit Raw Materials Cost $27 per unit Packaging Costs $15 per unit Electricity $4 per unit Waste and Other Costs $6 per unit Salary and Wages Costs $560,000 per month Fringe Benefits 50% of salaries Rent Costs $750,000 per month Insurance Costs $50,000 per month Depreciation Costs $370,000 per month Actual Data January February Production (Units) 245000 187000 Revenue $ 19,345,000.00 $ 14,888,000.00 Raw Materials $    6,545,000.00 $    4,996,000.00 Package Materials...
Consider the following data: x 4 5 6 7 8 P(X=x) 0.2 0.2 0.1 0.2 0.3...
Consider the following data: x 4 5 6 7 8 P(X=x) 0.2 0.2 0.1 0.2 0.3 Step 2 of 5: Find the variance. Round your answer to one decimal place. Step 3 of 5: Find the standard deviation. Round your answer to one decimal place. Step 4 of 5: Find the value of P(X<7). Round your answer to one decimal place Step 5 of 5:Find the value of P(X≥7). Round your answer to one decimal place.
Sales (in units) 60,000 Selling price per unit $25 Manufacturing costs per unit:   Materials 5   Direct...
Sales (in units) 60,000 Selling price per unit $25 Manufacturing costs per unit:   Materials 5   Direct labor 4   Overhead         Variable 4          Fixed 6     Total $19 Gross margin 6 Selling and admin. Expenses per unit 2 Operating income $4 A company in a foreign market offer to buy and the offer specifies the following data units to be sold 10,000 price per unit $12 The incremental profit should be
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT