Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please answer all empty please help! Part 4: July Performance Report In part 3 of Case 2a, your team put together a planning budget for

image text in transcribed

image text in transcribed

Please answer all empty

please help!
Part 4: July Performance Report In part 3 of Case 2a, your team put together a planning budget for the next month. It is now the end of the month and it is time to use that planning budget to put together a performance report. The report has been filled in for you. Actual Quantity 4500 1 1.5 1.25 Estimated Costs for July 2020 Selling price and sales estimate per laree Snowie 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 Kiosk rental cost per month Purchase cost of twoiceshavers (5-year life) Purchase cost of a flavor station (5-year life) 1 Estimated Prices $5.00 $0.20 $0.02 $0.08 $0.01 28 $ $8.00 $10.00 $25.00 $250.00 $650 OD $3,180.00 $1,080.00 Estimated Quantity 5000 1 1 1 2 28 28 Actual Prices $5.25 $0.15 $0.03 $0.10 $0.01 26 $10.00 $10.00 $25.00 $275.00 $650.00 $3,180.00 $1,080.00 26 26 - Assumptions from 2a (please use these not what you used in 2a) 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 employer to work in the kiosk per da d. Number of Snowies you estimate you will sell on an average day 25 8 200 Part 4 Question 1: Complete the Performance Report Snowies Performance Report July 2021 U/F Quantity Variance U/F Activity Variance Price Variance U/F U/F / Quantity Sold Sales revenue Actual Budget Spending Variance 4500 $23,625.00 TC10 Budget 4500 $ 23,625.00 Flex Budget 4500 $22,500.00 Planning Budget 5000 $25,000.00 Variable expenses: Ice expense Spoon straws Styrofoam cups $675.00 $202.50 $562.50 $45.00 $1,730.77 $3,215.77 $900.00 $135.00 $450.00 $45.00 $1,384.62 $2,914.62 $900.00 $90.00 $360.00 $90.00 $1,285,71 $2,725.71 $1,000.00 $100.00 $ $400.00 $100.00 $1,428.57 Napkins Syrup Total variable expenses $3,028571 Fixed expenses Wages for workers Event registration fees Klask rental cost Depreciation - ice shavers Depreciation - Flavor station Insurance, dectrical, etc. Total fixed expenses Operating income $2,000.00 $625.00 $650.00 $53.00 $ $18.00 $275.00 $3,621.00 $16.788231 $2,000.00 $625.00 $650.00 $53.00 $18.00 $250.00 $3,596.00 $17,114.38 $2,000.00 $625.00 $650.00 $53.00 $18.00 $250.00 $3,596.00 $16,178.29 $2,000.00 $625.00 $650.00 $53.00 $18.00 $250.00 $3,596.00 $18375431 Part 4 Question 2: Given this performance report, what are the actions you would take as a manager next period. Complete answers must include 5 different action items and clearly explain the data behind taking those actions. Action 1: Action 2: Action 3: Action 4: Action 5: Part 4: July Performance Report In part 3 of Case 2a, your team put together a planning budget for the next month. It is now the end of the month and it is time to use that planning budget to put together a performance report. The report has been filled in for you. Actual Quantity 4500 1 1.5 1.25 Estimated Costs for July 2020 Selling price and sales estimate per laree Snowie 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 Kiosk rental cost per month Purchase cost of twoiceshavers (5-year life) Purchase cost of a flavor station (5-year life) 1 Estimated Prices $5.00 $0.20 $0.02 $0.08 $0.01 28 $ $8.00 $10.00 $25.00 $250.00 $650 OD $3,180.00 $1,080.00 Estimated Quantity 5000 1 1 1 2 28 28 Actual Prices $5.25 $0.15 $0.03 $0.10 $0.01 26 $10.00 $10.00 $25.00 $275.00 $650.00 $3,180.00 $1,080.00 26 26 - Assumptions from 2a (please use these not what you used in 2a) 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 employer to work in the kiosk per da d. Number of Snowies you estimate you will sell on an average day 25 8 200 Part 4 Question 1: Complete the Performance Report Snowies Performance Report July 2021 U/F Quantity Variance U/F Activity Variance Price Variance U/F U/F / Quantity Sold Sales revenue Actual Budget Spending Variance 4500 $23,625.00 TC10 Budget 4500 $ 23,625.00 Flex Budget 4500 $22,500.00 Planning Budget 5000 $25,000.00 Variable expenses: Ice expense Spoon straws Styrofoam cups $675.00 $202.50 $562.50 $45.00 $1,730.77 $3,215.77 $900.00 $135.00 $450.00 $45.00 $1,384.62 $2,914.62 $900.00 $90.00 $360.00 $90.00 $1,285,71 $2,725.71 $1,000.00 $100.00 $ $400.00 $100.00 $1,428.57 Napkins Syrup Total variable expenses $3,028571 Fixed expenses Wages for workers Event registration fees Klask rental cost Depreciation - ice shavers Depreciation - Flavor station Insurance, dectrical, etc. Total fixed expenses Operating income $2,000.00 $625.00 $650.00 $53.00 $ $18.00 $275.00 $3,621.00 $16.788231 $2,000.00 $625.00 $650.00 $53.00 $18.00 $250.00 $3,596.00 $17,114.38 $2,000.00 $625.00 $650.00 $53.00 $18.00 $250.00 $3,596.00 $16,178.29 $2,000.00 $625.00 $650.00 $53.00 $18.00 $250.00 $3,596.00 $18375431 Part 4 Question 2: Given this performance report, what are the actions you would take as a manager next period. Complete answers must include 5 different action items and clearly explain the data behind taking those actions. Action 1: Action 2: Action 3: Action 4: Action 5

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Consolidated Financial Reporting

Authors: Paul Taylor

1st Edition

1853962503, 9781853962509

More Books

Students also viewed these Accounting questions

Question

Write each whole number in expanded form. 1. 3158 2. 403,225,000

Answered: 1 week ago