Question

the gourmand cooking school runs shirt cooking courses at its small campus. managment had identified

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 t two courses in a month and have a total of 50 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 Course Student $ 3,080 $ 260 $ 870 $ 130 $ 4,200 S1,890 $ 3.270 15 4 wit For example, administrative expenses should be $3,270 per month plus $15 per course plus $4 per student. The company's sales should average $800 per student erences The company planned to run three courses with a total of 45 students; however, it actually ran three courses with a total of only 42 students. The actual operating results for September appear below: Revenue Instructor wages Classroom supplies Utilities Campus rent Insurance Administrative expenses Actual $ 32,400 $ 9,080 $ 3.540 $ 1.530 $ 4,200 $ 3.790 Required: 1. Prepare the company's planning budget for September 2. Prepare the company's flexible budget for September 3. Calculate the revenue and spending variances for September

Answer 1

	Planning Budget
	For the month ended September 30
Budgeted courses	3
Budgeted students	45
Revenue	36000	=45*800
Expenses:
Instructor wages	9240	=3*3080
Classroom supplies	11700	=45*260
Utilities	1260	=870+(3*130)
Campus rent	4200
Insurance	1890
Administrative expenses	3495	=3270+(3*15)+(45*4)
Total expense	31785
Net operating income	4215
2
	Flexible Budget
	For the month ended September 30
Actual courses	3
Actual students	42
Revenue	33600	=42*800
Expenses:
Instructor wages	9240	=3*3080
Classroom supplies	10920	=42*260
Utilities	1260	=870+(3*130)
Campus rent	4200
Insurance	1890
Administrative expenses	3483	=3270+(3*15)+(42*4)
Total expense	30993
Net operating income	2607
3
	Actual results	Revenue and spending variance		Flexible budget
Courses	3			3
Students	42			42
Revenue	32400	1200	U	33600
Expenses:
Instructor wages	9080	160	F	9240
Classroom supplies	8540	2380	F	10920
Utilities	1530	270	U	1260
Campus rent	4200	0	None	4200
Insurance	1890	0	None	1890
Administrative expenses	3790	307	U	3483
Total expense	29030	1963	F	30993
Net operating income	3370	763	F	2607