Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I had to repost the question because I was unable to figure out how to repost multiple photos within this same question. Ignore the top
I had to repost the question because I was unable to figure out how to repost multiple photos within this same question.
Ignore the top pictures, there is no way for me to delete them. The only photos that matter are the bottom 6. Sorry!
the image is clear to read on my end, but i dont knkwnhow to remove the old photos to mske it easier. pleaee give me more info on how i can help.
Part 1 Part 2 Part 3 Synporal of Copa , , , Pastor - Natar cipate parting the ri Number of een employee wheth e r Customer had the respekt Sympoulet per alle Bartel Mar Part 1 Part 2 Part 3 S e per la Saw Se m ere her i New 8:544 X Snowies Shaved Ice... n Part 1 Part 2 Part 3 Hequired: Man fill the d esign from the per la Colt per pal p icades como Kicke r (12 LA Nurd beledi: i ng the per Number of how you will comployes we think or day Support Couper Serv ice Cura de 1. (arry ) Spewnopol En fordypom Sady Break mem VS Tad Ulce mariage Viewer Spruce Street Shelter Case Required: Please fill in the highlighted cells asing numbers from the case and formulas when appropriate and specify if each variance is favorable or unfavorable Name: Spruce Street Shelter. Laundry Department 1) Flexible budget and total variance decomposition Activity variance Favorable or Unfavorable Spending variance Favorable or Unfavorable per pound Master budget 9.500 Flexible Budget 11.900 156,600 Actual 11.900 156,600 125.000 Actisity Client nights Pounds of laundry processed Costs Laundry labor Supplies Water & water heating & softening Maintenance Supervisor's salary Allocated administrative costs Equipment depreciation Total 2) Laundry labor - Spending variance analysis Actual labor minutes at budgeted sborrate Actual Client nights Pounds of laundry processed 11.900 156.600 Fudgeted labor cost labor cost Budgeted labor rate per hour Actual labor rate per hour Labor Labor efficiency variance Favorable or Unfavorable Favorable or Unfavorable variance Budgeted labor rate per minute Actual labor rate per minute Budgeted labor minutes per pound Actual labor minutes per pound Spruce Street Shelter Case Rewiny Please fill in the highlighted cells using numbers from the case and formulas when appropriate and specify if each variance is favorable or unfavorable Name: Spruce Street Shelter - Laundry Department 1) Flexible budget and total variance decomposition Rate per pound Activity variance Favorable or Unfavorable Spending variance Favorable or Unfavorable Activity Client nights Pounds of laundry processed Flexible Budget 11.900 156.000 Master budget 9.500 125.000 Actual 11.00 156000 Costs Laundry labor Supplies Water & water heating & softening Maintenance Supervisor's salary Allocated administrative costs Equipment depreciation Total 2) Laundry labor - Spending variance analysis Actual labe minutes at budgeted labor rate Client nights Pounds of laundry processed 11.900 150.000 Budgetest labor cost Actul labor cost Budereted labor rate per hour Actual labor rate per hour Labor efficiency variance Favorable or Unfavorable Laber rate variance Favorable or Unfavorable Buduced labor male per minute Actual labor rate per minute Badgeted labor minutes per pound Actual labor minutes per pound Snowies Shaved Ice Business Case Required: Please fill in the highlighted cells using numbers from the case and formulas when appropriate. 4 Name: 6 Part 1 Amount 4.00 8 Data 9 Selling price per large Snowie 10 11 Ice per Snowie 12 Spoon straw (need one per Snowie) 13 Styrofoam cup (need one per Snowie) 14 Napkin (need two per Snowie) 15 Servings per gallon of syrup 16 Cost per gallon of syrup (includes concentrate, preservative, and sugar) 17 Hourly rate for workers 18 Event registration fee per day 19 Electricity, insurance, maintenance, and permit costs per month 20 Kiosk rental cost per month (12-month lease) 21 Purchase cost of two ice shavers (5-year life) 22 Purchase cost of a flavor station (5-year life) 23 24 Requirements 25 26 1. Assumptions (to be filled in): 27 a. Number of days you anticipate opening the kiosk per month 28 b. Number of hours you will work (no wages required) per day 29 c. Number of hours you will pay an employee to work in the kiosk per day 32 Syrup cost per Snowie (Cost per gallon / Servings per gallon of syrup) C D E 34 3. Cost of worker wages per day and month: 35 a. Cost per day (Hourly rate for workers x Number of hours you will pay an employee) 36 b. Cost per month (Cost per day above x Number of days kiosk is open per month) 37 38 4. Total variable cost per Snowie 39 Cost of syrup per Snowie (from Question 2) 40 Ice per Snowie 41 Spoon straw (need one per Snowie) 42 Styrofoam cup (need one per Snowie) 43 Napkin (need two per Snowie) 44 Total variable cost per Snowie 45 46 5. Total fixed cost per month 47 Wages for workers for month 48 Event registration fee per day x number of days kiosk open 49 Kiosk rental cost per month 50 Straight-line depreciation - ice shavers ($3,180/5 years / 12 months) 51 Straight-line depreciation - flavor station ($1,080/5 years / 12 months) 52 Total fixed cost per month 53 54 6. Break even volume per month 55 Total fixed costs 56 Unit contribution margin (Selling price - Variable cost per Snowie) 57 Number of Snowies to be sold per month to break even 58 59 7. Number of Snowies to be sold to earn target profit of $2,000 per month 60 Total fixed costs plus target profit 61 Unit contribution margin (Selling price - Variable cost per Snowie) 62 Number of Snowies to be sold per month to earn target profit 3 V PRI A Part 2 Data (all from Part 1 except for new selling price and cup cost) Selling price per large Snowie 3.00 Ice per Snowie Spoon straw (need one per Snowie) Styrofoam cup (need one per Snowie) Napkin (need two per Snowie) Syrup cost per Snowie (from Part 1, Question 2) Total variable cost per Snowie Sales revenue from Octoberfest (200 Snowies sold) Variable costs for Octoberfest Total contribution margin - Octoberfest Should Snowie accept the special price offer? (Yes or No to the next cell) Part 1 Part 2 Part 3 Part 3 Data (all from Part 1 except for new selling price and syrup cost) Selling price per large Snowie 5.00 Ice per Snowie Spoon straw (need one per Snowie) Styrofoam cup (need one per Snowie) Napkin (need two per Snowie) Servings per gallon of syrup Cost per gallon of syrup (includes concentrate, preservative, and sugar) Hourly rate for workers Event registration fee per day Electricity, insurance, maintenance, and permit costs per month 5 Kiosk rental cost per month 5 Purchase cost of two ice shavers (5-year life) Purchase cost of a flavor station (5-year life) Requirements 1. Assumptions e a. Number of days you anticipate opening the kiosk per month b. Number of hours you will work (no wages required) per day c. Number of hours you will pay an employee to work in the kiosk per day 5 d. Number of Snowies you estimate you will sell on an average day Cost of syrup per Snowie (based on the new cost per gallon): Cost of syrup per Snowie (based on the new cost per gallon) Syrup cost per Snowie (Cost per gallon / Servings per gallon of syrup) 2. Budgeted contribution margin income statement for one month. Business Name Budgeted Contribution Margin Income Statement For Month Ended July 31 6,900.00 Sales revenue Less variable expenses: Ice expense Spoon straws Styrofoam cups Napkins Syrup Total variable expenses Total contribution margin Less fixed expenses: Wages for workers Event registration fees Kiosk rental cost Depreciation - ice shavers Depreciation - flavor station Total fixed expenses Operating income 6,900.00 6,900.00 Part 1 Part 2 Part 3 Synporal of Copa , , , Pastor - Natar cipate parting the ri Number of een employee wheth e r Customer had the respekt Sympoulet per alle Bartel Mar Part 1 Part 2 Part 3 S e per la Saw Se m ere her i New 8:544 X Snowies Shaved Ice... n Part 1 Part 2 Part 3 Hequired: Man fill the d esign from the per la Colt per pal p icades como Kicke r (12 LA Nurd beledi: i ng the per Number of how you will comployes we think or day Support Couper Serv ice Cura de 1. (arry ) Spewnopol En fordypom Sady Break mem VS Tad Ulce mariage Viewer Spruce Street Shelter Case Required: Please fill in the highlighted cells asing numbers from the case and formulas when appropriate and specify if each variance is favorable or unfavorable Name: Spruce Street Shelter. Laundry Department 1) Flexible budget and total variance decomposition Activity variance Favorable or Unfavorable Spending variance Favorable or Unfavorable per pound Master budget 9.500 Flexible Budget 11.900 156,600 Actual 11.900 156,600 125.000 Actisity Client nights Pounds of laundry processed Costs Laundry labor Supplies Water & water heating & softening Maintenance Supervisor's salary Allocated administrative costs Equipment depreciation Total 2) Laundry labor - Spending variance analysis Actual labor minutes at budgeted sborrate Actual Client nights Pounds of laundry processed 11.900 156.600 Fudgeted labor cost labor cost Budgeted labor rate per hour Actual labor rate per hour Labor Labor efficiency variance Favorable or Unfavorable Favorable or Unfavorable variance Budgeted labor rate per minute Actual labor rate per minute Budgeted labor minutes per pound Actual labor minutes per pound Spruce Street Shelter Case Rewiny Please fill in the highlighted cells using numbers from the case and formulas when appropriate and specify if each variance is favorable or unfavorable Name: Spruce Street Shelter - Laundry Department 1) Flexible budget and total variance decomposition Rate per pound Activity variance Favorable or Unfavorable Spending variance Favorable or Unfavorable Activity Client nights Pounds of laundry processed Flexible Budget 11.900 156.000 Master budget 9.500 125.000 Actual 11.00 156000 Costs Laundry labor Supplies Water & water heating & softening Maintenance Supervisor's salary Allocated administrative costs Equipment depreciation Total 2) Laundry labor - Spending variance analysis Actual labe minutes at budgeted labor rate Client nights Pounds of laundry processed 11.900 150.000 Budgetest labor cost Actul labor cost Budereted labor rate per hour Actual labor rate per hour Labor efficiency variance Favorable or Unfavorable Laber rate variance Favorable or Unfavorable Buduced labor male per minute Actual labor rate per minute Badgeted labor minutes per pound Actual labor minutes per pound Snowies Shaved Ice Business Case Required: Please fill in the highlighted cells using numbers from the case and formulas when appropriate. 4 Name: 6 Part 1 Amount 4.00 8 Data 9 Selling price per large Snowie 10 11 Ice per Snowie 12 Spoon straw (need one per Snowie) 13 Styrofoam cup (need one per Snowie) 14 Napkin (need two per Snowie) 15 Servings per gallon of syrup 16 Cost per gallon of syrup (includes concentrate, preservative, and sugar) 17 Hourly rate for workers 18 Event registration fee per day 19 Electricity, insurance, maintenance, and permit costs per month 20 Kiosk rental cost per month (12-month lease) 21 Purchase cost of two ice shavers (5-year life) 22 Purchase cost of a flavor station (5-year life) 23 24 Requirements 25 26 1. Assumptions (to be filled in): 27 a. Number of days you anticipate opening the kiosk per month 28 b. Number of hours you will work (no wages required) per day 29 c. Number of hours you will pay an employee to work in the kiosk per day 32 Syrup cost per Snowie (Cost per gallon / Servings per gallon of syrup) C D E 34 3. Cost of worker wages per day and month: 35 a. Cost per day (Hourly rate for workers x Number of hours you will pay an employee) 36 b. Cost per month (Cost per day above x Number of days kiosk is open per month) 37 38 4. Total variable cost per Snowie 39 Cost of syrup per Snowie (from Question 2) 40 Ice per Snowie 41 Spoon straw (need one per Snowie) 42 Styrofoam cup (need one per Snowie) 43 Napkin (need two per Snowie) 44 Total variable cost per Snowie 45 46 5. Total fixed cost per month 47 Wages for workers for month 48 Event registration fee per day x number of days kiosk open 49 Kiosk rental cost per month 50 Straight-line depreciation - ice shavers ($3,180/5 years / 12 months) 51 Straight-line depreciation - flavor station ($1,080/5 years / 12 months) 52 Total fixed cost per month 53 54 6. Break even volume per month 55 Total fixed costs 56 Unit contribution margin (Selling price - Variable cost per Snowie) 57 Number of Snowies to be sold per month to break even 58 59 7. Number of Snowies to be sold to earn target profit of $2,000 per month 60 Total fixed costs plus target profit 61 Unit contribution margin (Selling price - Variable cost per Snowie) 62 Number of Snowies to be sold per month to earn target profit 3 V PRI A Part 2 Data (all from Part 1 except for new selling price and cup cost) Selling price per large Snowie 3.00 Ice per Snowie Spoon straw (need one per Snowie) Styrofoam cup (need one per Snowie) Napkin (need two per Snowie) Syrup cost per Snowie (from Part 1, Question 2) Total variable cost per Snowie Sales revenue from Octoberfest (200 Snowies sold) Variable costs for Octoberfest Total contribution margin - Octoberfest Should Snowie accept the special price offer? (Yes or No to the next cell) Part 1 Part 2 Part 3 Part 3 Data (all from Part 1 except for new selling price and syrup cost) Selling price per large Snowie 5.00 Ice per Snowie Spoon straw (need one per Snowie) Styrofoam cup (need one per Snowie) Napkin (need two per Snowie) Servings per gallon of syrup Cost per gallon of syrup (includes concentrate, preservative, and sugar) Hourly rate for workers Event registration fee per day Electricity, insurance, maintenance, and permit costs per month 5 Kiosk rental cost per month 5 Purchase cost of two ice shavers (5-year life) Purchase cost of a flavor station (5-year life) Requirements 1. Assumptions e a. Number of days you anticipate opening the kiosk per month b. Number of hours you will work (no wages required) per day c. Number of hours you will pay an employee to work in the kiosk per day 5 d. Number of Snowies you estimate you will sell on an average day Cost of syrup per Snowie (based on the new cost per gallon): Cost of syrup per Snowie (based on the new cost per gallon) Syrup cost per Snowie (Cost per gallon / Servings per gallon of syrup) 2. Budgeted contribution margin income statement for one month. Business Name Budgeted Contribution Margin Income Statement For Month Ended July 31 6,900.00 Sales revenue Less variable expenses: Ice expense Spoon straws Styrofoam cups Napkins Syrup Total variable expenses Total contribution margin Less fixed expenses: Wages for workers Event registration fees Kiosk rental cost Depreciation - ice shavers Depreciation - flavor station Total fixed expenses Operating income 6,900.00 6,900.00 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started