two courses in a month and have a total of 60 students enrolled in those two...

Transcribed Image Text:

two courses in a month and have a total of 60 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 Revenue Instructor wages Classroom supplies Utilities Campus rent Insurance Administrative expenses For example, administrative expenses should be $3,900 per month plus $46 per course plus $7 per student. The company's sales should average $900 per student. The company planned to run four courses with a total of 60 students; however, it actually ran four courses with a total of only 54 students. The actual operating results for September appear below: Fixed Cost Cost per: per Month Course $ 2,910 $ 85 Revenue Expenses: $1,210 $4,800 $2,200 $ 3,900 $ 46 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 flexible budget for September. Instructor wages Classroom supplies Complete this question by entering your answers in the tabs below. Gourmand Cooking School Flexible Budget For the Month Ended September 30 Utilities Campus rent Insurance Administrative expenses Actual $ 51,100 $ 10,920 $ 17,850 $ 1,960 $ 4,800 $ 2,340 $ 3,930 Total expense Net operating income $ Cost per Student $ 300 $7 0 0 two courses in a month and have a total of 60 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 Revenue Instructor wages Classroom supplies Utilities Campus rent Insurance Administrative expenses For example, administrative expenses should be $3,900 per month plus $46 per course plus $7 per student. The company's sales should average $900 per student. The company planned to run four courses with a total of 60 students; however, it actually ran four courses with a total of only 54 students. The actual operating results for September appear below: Fixed Cost Cost per: per Month Course $ 2,910 $ 85 Revenue Expenses: $1,210 $4,800 $2,200 $ 3,900 $ 46 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 flexible budget for September. Instructor wages Classroom supplies Complete this question by entering your answers in the tabs below. Gourmand Cooking School Flexible Budget For the Month Ended September 30 Utilities Campus rent Insurance Administrative expenses Actual $ 51,100 $ 10,920 $ 17,850 $ 1,960 $ 4,800 $ 2,340 $ 3,930 Total expense Net operating income $ Cost per Student $ 300 $7 0 0