The Gourmand Cooking School runs short cooking courses at its small campus. Management has identified two cost drivers it uses in its budgeting and performance reports-the number of courses and the total number of students. For example, the school might run two courses in a month and have a total of 63 students enrolled in those two courses. Data concerning the company's cost formulas appear below: Instructor wages Classroom supplies Utilities Campus rent Insurance Administrative expenses Fixed Cost per Cost per Cost per Month Student $ 290 Revenue Instructor wages Classroom supplies Utilities $ 1,210 $ 5,000 $ 2,300 $ 3,500 Campus rent Insurance Administrative expenses Course $ 2,950 $ 90 For example, administrative expenses should be $3,500 per month plus $43 per course plus $4 per student. The company's sales should average $900 per student. $ 43 The company planned to run four courses with a total of 63 students; however, it actually ran four courses with a total of only 55 students. The actual operating results for September were as follows: $4 Actual $ 53,800 $ 11,080 $ 18,120 $ 1,980 $ 5,000 $ 2,440 $ 3,350 Required: Prepare a flexible budget performance report that shows both revenue and spending variances and activity variances for September. 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.
The Gourmand Cooking School runs short cooking courses at its small campus. Management has identified two cost drivers it uses in its budgeting and performance reports-the number of courses and the total number of students. For example, the school might run two courses in a month and have a total of 63 students enrolled in those two courses. Data concerning the company's cost formulas appear below: Instructor wages Classroom supplies Utilities Campus rent Insurance Administrative expenses Fixed Cost per Cost per Cost per Month Student $ 290 Revenue Instructor wages Classroom supplies Utilities $ 1,210 $ 5,000 $ 2,300 $ 3,500 Campus rent Insurance Administrative expenses Course $ 2,950 $ 90 For example, administrative expenses should be $3,500 per month plus $43 per course plus $4 per student. The company's sales should average $900 per student. $ 43 The company planned to run four courses with a total of 63 students; however, it actually ran four courses with a total of only 55 students. The actual operating results for September were as follows: $4 Actual $ 53,800 $ 11,080 $ 18,120 $ 1,980 $ 5,000 $ 2,440 $ 3,350 Required: Prepare a flexible budget performance report that shows both revenue and spending variances and activity variances for September. 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.
Managerial Accounting: The Cornerstone of Business Decision-Making
7th Edition
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Chapter3: Cost Behavior And Cost Forecasting
Section: Chapter Questions
Problem 57P: Identifying Fixed, Variable, Mixed, and Step Costs Consider each of the following independent...
Related questions
Concept explainers
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
Question
ss.2
Transcribed Image Text:Required:
Prepare a flexible budget performance report that shows both revenue and spending variances and activity variances for September.
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.
Courses
Students
Revenue
Expenses:
Instructor wages
Classroom supplies
Utilities
Campus rent
Insurance
Administrative expenses
Total expense
Net operating income
Actual Results
$
Gourmand Cooking School
Flexible Budget Performance Report
For the Month Ended September 30
$
4
55
53,800
11,080
18,120
1,980
5,000
2,440
3,350
41,970
11,830
Flexible
Budget
Planning
Budget
Transcribed Image Text:The Gourmand Cooking School runs short cooking courses at its small campus. Management has identified two cost drivers it uses in
its budgeting and performance reports-the number of courses and the total number of students. For example, the school might run
two courses in a month and have a total of 63 students enrolled in those two courses. Data concerning the company's cost formulas
appear below:
Instructor wages
Classroom supplies
Utilities
Campus rent
Insurance
Administrative expenses
Fixed
Cost per
Month
Revenue
Instructor wages
Classroom supplies
Utilities
$ 1,210
$ 5,000
$ 2,300
$ 3,500
Campus rent
Insurance
Administrative expenses
Cost per
Course
$ 2,950
$ 90
$ 43
For example, administrative expenses should be $3,500 per month plus $43 per course plus $4 per student. The company's sales
should average $900 per student.
Actual
$ 53,800
$ 11,080
$ 18,120
$ 1,980
$ 5,000
$ 2,440
$ 3,350
Cost per
Student
$ 290
The company planned to run four courses with a total of 63 students; however, it actually ran four courses with a total of only 55
students. The actual operating results for September were as follows:
$ 4
Required:
Prepare a flexible budget performance report that shows both revenue and spending variances and activity variances for September.
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.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 3 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College