Question

please answer the required 1-3, thank you.

Check my work 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 65 students enrolled in those two courses. Data concerning the company's cost formulas appear below: Fixed Cost per Cost per Cost per Course $2,950 Month Student Instructor wages Classroom supplies Utilities $270 $1,250 $4,700 $2,400 60 Campus rent Insurance Administrative expenses $4,000 S 45 $ 5 For example, administrative expenses should be $4,000 per month plus $45 per course plus $5 per student. The company's sales should average $880 per student. The company planned to run four courses with a total of 65 students; however, it actually ran four courses students. The actual operating results for September appear below with a total of only 55 Actual $54,300 $11,080 $17,400 $ 1,900 $ 4,700 Revenue Instructor wages Classroom supplies Utilities Campus rent Insurance S 2,540 Administrative expenses $ 3,931 Required: 1. Prepare the company's planning budget for September Check my work 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 Complete this question by entering your answers in the tabs below. Reqüired 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 Prev 1 of 6 Next> Check my work 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 Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Prepare the company's flexible budget for September. Gourmand Cooking School Flexible Budget For the Month Ended September 30 Actual courses Actual students Revenue Expenses: Instructor wages Classroom supplies Utilities Campus rent Insurance Administrative expenses Prev 1 of 6 Next> Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Calculate the revenue and spending 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.) Gourmand Cooking School Revenue and Spending Variances For the Month Ended September 30 Actual Results Revenue and Spending Variances Flexible Budget Courses 4 Students 55 Revenue 54,300 Expenses: Instructor wages 11,080 Classroom supplies 17,400 Utilities 1,900 Campus rent 4,700 Insurance 2,540 Administrative expenses 3,931 Total expense 41,551 12,749 Net operating income Prev 1 of 6 Next >

Answer 1

Answer 1 and 2.

GOURMAND COOKING SSCHOOL Planning and Flexible Budget For the Month Ended September 30 Planning Flexible Budget Budget Course (p) 4 4 Student (q) Revenue ($880*q) Expenses: Instructor wages ($2,950 p) Classroom supplies ($270 q) Utilities ($1,250 + $60*p) Campus rent Insurance ($2,400) Administrative expenses ($4,000 $45*p+ $5*q) Total expenses Net operating income 65 55 57200 48400 11800 11800 17550 14850 1490 1490 ($4,700) 4700 4700 2400 2400 4505 4455 42445 39695 14755 8705

Answer 3.

GOURMAND COOKING SCHOOL Flexible Budget Performance Report For the Month Ended September 30 Actual Revenue and Flexible Planning Activity Variance Results Budget Spending Variance Budget Course (p) 4 4 Student (q) Revenue ($880* q) Expenses: Instructor wages ($2,950*p) Classroom supplies ($270 q) Utilities ($1,250 + $60*p) Campus rent ($4,700) Insurance ($2A00) Administrative expenses ($4,000 $45*p+ $5*q) Total expenses Net operating income 55 55 65 57200 54300 5900 48400 8800 U 11800 11080 720 F 11800 0 None 17400 2550 14850 2700 17550 1900 410 U 1490 None 1490 4700 0 None 4700 C None 4700 2540 140 U 2400 None 2400 3931 524 4455 50 4505 41551 2750 1856 U 39695 42445 12749 14755 4044 F 8705 6050 U