Question

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 62 students enrolled in those two courses. Data concerning the company’s cost formulas appear below: Fixed Cost per Month Cost per Course Cost per 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 For example, administrative expenses should be $3,900 per month plus $44 per course plus $7 per student. The company’s sales should average $890 per student. The company planned to run four courses with a total of 62 students; however, it actually ran four courses with a total of only 56 students. The actual operating results for September appear below: 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 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

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