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.
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
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
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education