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 64 students enrolled in those two courses. Data concerning the company's cost formulas appear below: Fixed Cost per Month Cost per Course $ 2,930 Cost per Student $ 260 Instructor wages Classroom supplies Utilities Campus rent Insurance Administrative expenses $50 $1,220 54,700 $ 2,200 $ 3,900 $ 43 53 For example, administrative expenses should be $3,900 per month plus $43 per course plus $3 per student. The company's sales should average $890 per student The company planned to run four courses with a total of 64 students; however, it actually ran four courses with a total of only 60 students. The actual operating results for September appear below: Revenue Instructor wages Classroom supplies Utilities Campus rent Insurance Administrative expenses Actual $ 54,060 $ 11,000 $ 16,490 $ 1,830 $4,700 $ 2,340 $ 3,690 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 Required 1 Required 2 Required 3 Prepare the company's planning budget for September Gourmand Cooking School Planning Budget For the Month Ended September 30 Budgeted courses Budgeted students Revenue Expenses: Instructor wages Classroom supplies Utilities Campus rent Insurance Administrative expenses Total expense Net operating income $ 0 GA 0 Required 1 Required 1 Regitired 2 Required 3 Prepare the company's flexible budget for September. Gourmand Cooking School Flexible Budget For the Month Ended September 30 Revenue Expenses: Instructor wages Classroom supplies Utilities Campus rent Insurance Administrative expenses Total expense Net operating income 0 $ 0