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 $ 280 Utilities $ 1,210 $ 85 Campus rent $ 5,100 Insurance $ 2,100 Administrative expenses $ 3,600 $ 45 $ 4 For example, administrative expenses should be $3,600 per month plus $45 per course plus $4 per student. The company’s sales should average $860 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 60 students. The actual operating results for September appear below: Actual Revenue $ 50,420 Instructor wages $ 11,120 Classroom supplies $ 17,210 Utilities $ 1,960 Campus rent $ 5,100 Insurance $ 2,240 Administrative expenses $ 3,454 Required: Prepare a flexible budget performance report that shows both revenue and spending variances and activity variances for September. (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.)

Answer 1

Gourmand Cooking School Flexible Budget Performance Report For the Month Ended September 30 Actual Revenue and Results Spending Variance Flexible Budget Activity Variance Planning Budget Courses (p) Students (9) 60 60 50420 1180 51600 1720 53320 11120 17210 1960 Revenue ($860*9) Expenses: Instructor wages ($2,960*p) Classroom supplies ($280*C) Utilities ($1,210 + $85*p) Campus rent ($5,100) Insurance ($2,100) Administrative expenses ($3,600 + $45*p + $4*q) Total Expenses Net Operating Income 5100 720 F 410U 410U None 140U 566 F 326 854 U None 560F None None None 0 11840 16800 1550 5100 2100 4020 41410 10190 11840 17360 1550 5100 2100 4028 41978 11342 2240 3454 41084 9336 1 152