Answer:
The Gourmand Cooking School
1. Planning Budget for September:
Fixed Cost Cost per Cost per Planning
per Month Course Student Budget
Instructor wages $ 2,960 $11,840
Classroom supplies $ 270 16,740
Utilities $ 1,220 $ 75 1,520
Campus rent $ 4,800 4,800
Insurance $ 2,300 2,300
Administrative expenses $ 3,900 $ 44 $ 7 4,510
Total $41,710
2) Flexible Budget for September:
Fixed Cost Cost per Cost per Flexible
per Month Course Student Budget
Instructor wages $ 2,960 $11,840
Classroom supplies $ 270 15,120
Utilities $ 1,220 $ 75 1,520
Campus rent $ 4,800 4,800
Insurance $ 2,300 2,300
Administrative expenses $ 3,900 $ 44 $ 7 4,468
Total $40,048
3. The Revenue and Spending Variances for September (based on flexible budget):
Planning Flexible Actual Spending
Budget Budget Variance
Revenue $55,180 $46,280 $52,280 $6,000 F
Instructor wages $11,840 $11,840 $11,120 $720 F
Classroom supplies 16,740 15,120 16,590 1,470 U
Utilities 1,520 1,520 1,930 410 U
Campus rent 4,800 4,800 4,800 0 None
Insurance 2,300 2,300 2,440 140 U
Administrative expenses 4,510 4,468 3,936 532 F
Total $41,710 $40,048 $40,816 $768 U
Explanation:
a) Data and Calculations:
Sales price per student = $890
Planned number of courses = 4
Planned total number of students = 62
Actual number of courses ran = 4
Actual total number of students = 56
Data concerning the company’s cost formulas appear below:
Fixed Cost Cost per Cost per
per Month Course Student
Instructor wages $ 2,960
Classroom supplies $ 270
Utilities $ 1,220 $ 75
Campus rent $ 4,800
Insurance $ 2,300
Administrative expenses $ 3,900 $ 44 $ 7
Actual Results:
Actual Revenue $ 52,280
Instructor wages $ 11,120
Classroom supplies $ 16,590
Utilities $ 1,930
Campus rent $ 4,800
Insurance $ 2,440
Administrative expenses $ 3,936