Exercise 9-15 (Algo) Flexible Budgets and Revenue and Spending Variances [LO9-1, LO9-3] Via Gelato, a popular neighborhood gelato shop, provided the following cost formulas and actual results for the month of June: Fixed Variable Element per Element per Actual Total Month Liter for June Revenue $ 23.00 $ 140,540 Raw materials $ 5.75 $ 37,030 Wages Utilities $ 6,700 $ 2.50 $ 21,800 $ 2,730 $ 1.30 $ 11,600 CES Rent $ 3,700 Insurance $ 2,450 Miscellaneous $ 760 1.45 $ 3,700 $ 2,450 $9,390 While gelato is sold by the cone or cup, the shop measures its activity in terms of the total number of liters of gelato sold. For example, wages should be $6,700 plus $2.50 per liter of gelato sold and the actual wages for June were $21,800. Via Gelato expected to sell 6,100 liters in June but actually sold 6,300 liters. Required: Calculate Via Gelato's revenue and spending variances for June. Note: Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.
Exercise 9-15 (Algo) Flexible Budgets and Revenue and Spending Variances [LO9-1, LO9-3] Via Gelato, a popular neighborhood gelato shop, provided the following cost formulas and actual results for the month of June: Fixed Variable Element per Element per Actual Total Month Liter for June Revenue $ 23.00 $ 140,540 Raw materials $ 5.75 $ 37,030 Wages Utilities $ 6,700 $ 2.50 $ 21,800 $ 2,730 $ 1.30 $ 11,600 CES Rent $ 3,700 Insurance $ 2,450 Miscellaneous $ 760 1.45 $ 3,700 $ 2,450 $9,390 While gelato is sold by the cone or cup, the shop measures its activity in terms of the total number of liters of gelato sold. For example, wages should be $6,700 plus $2.50 per liter of gelato sold and the actual wages for June were $21,800. Via Gelato expected to sell 6,100 liters in June but actually sold 6,300 liters. Required: Calculate Via Gelato's revenue and spending variances for June. Note: Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.
Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter23: Flexible Budgeting (flexbud)
Section: Chapter Questions
Problem 4R
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Recommended textbooks for you
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning