Lavage Rapide is a Canadian company that owns and operates a large automatic car wash facility near Montreal The following table provides data concerning the company's costs Fixed Cost per Month Cost per Car Washed $ 0.50 $ 0.07 $0.15 $ 0.30 Cleaning supplies Electricity Maintenance Wages and salaries Depreciation Hent Administrative expenses $ 1.100 $ 4,100 $ 8.400 5.2,200 $1,800 $ 0.00 For example, electricity costs are $1,100 per month plus $0.07 per car washed. The company expects to wash 8,000 cars in August and to collect an average of $6.30 per car washed. Required: Prepare the company's planning budget for August Answer is complete and correct. Lavage Rapide Planning Budget For the Month Ended August 31 Budgeted cars washed 8,000 5 50.400 Revenue Expenses Cleaning Supplies Electricity Maintenance Wages and salaries Depreciation Rent Administrative expenses Total expense Net operating income 4.000 1,660 1.200 6.500 8.400 2.200 2.120 2600 24 120 000 S Lavage Rapide is a Canadian company that owns and operates a large automatic car wash facility near Montreal. The following table provides date concerning the company's costs Fixed Cost per Month $1,300 Cleaning Supplies Electricity Maintenance Wages and salaries Depreciation Rent Administrative expenses Cost per Car Washed $ 0.60 $ 0.06 $ 0.15 $ 0.40 $ 4,300 $3,400 $2,000 $1,490 $ 0.03 For example, electricity costs are $1,300 per month plus $0.06 per car washed. The company actually washed 8.400 cars in August and collected an average of 56 40 per car washed Required: Prepare the company's flexible budget for August Answer is complete and correct. Lavage Rapido Flexible Budget For the Month Ended August 31 Actual cars washed 8.400 S 53.760 Revenue Expenses Cleaning Supplies Electricity Maintenance Wages and salanes Depreciation Rent Administrative expenses Total expense Net operating income 5040 1.804 1.250 7,680 8.400 2.000 1,652 27 810 25,944 S Lavage Rapide is a Canadian company that owns and operates a large automatic car wash facility near Montreal. The following table provides data concerning the company's costs: Fixed Cost per Month $1,109 Cleaning Supplies Electricity Maintenance Wages and salaries Depreciation Rent Administrative expenses Cost per Car Washed $8.50 $0.07 50.30 $0.40 $4,400 $3,300 $1,900 $1,600 $0.04 For example, electricity costs are $1,500 per month plus $0.07 per car washed. The company expects to wash 8,000 cars in August and to collect an average of $6.00 per car washed. The company actually washed 8,100 cars in August Required: Calculate the company's activity variances for August (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.) Lavago Rapide Activity Variances For the Month Ended August 31 Revenue Expenses Cleaning supplies Electricity Maintenance Wages and salaries Depreciation None Rent Administrative expenses Total expense LU Net operating income Lavage Rapide is a Canadian company that owns and operates a large automatic car wash facility near Montreal. The following table provides data concerning the company's costs: Fixed cost per Month Cleaning supplies Electricity Maintenance Wapes and salaries Depreciation Rent Adrinistrative expenses $1,300 $4,200 58,5ee $1,900 51,400 Cost per Car Washed 30.50 50.88 50.15 50.20 se.es For example, electricity costs are $1.300 per month plus $0.08 per car washed. The company expects to wash 8.200 cars in August and to collect an average of $6.80 per car washed. The actual operating results for August are as follows: es Lavage Rapide Income Statement for the Month Ended August 31 Actual cars washed 3,300 592 868 Revenue Expenses: Cleaning supplies Electricity Maintenance Wages and salaries Depreciation Rent Administrative expenses Total expense Net operating income 4,60 1,926 1,479 6,200 8.50 2,100 3.210 26. Sed $ 31,154 Required: Calculate the company's revenue and spending variances for August (Indicate the effect of each variance by selecting "P" for favorable. "U" for unfavorable, and "None" for no effect (l.e., zero varience). Input all amounts as positive values.) Lavage Rapide Revenue and Spending Variances For the Month Ended August 31 Revenue Expenses Cleaning Supplies Electricity Maintenance Wages and sales Depreciation Rent Administrative penses Totapete Set operating income 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: Instructor wages Classroom Supplies utilities Campus rent Insurance Administrative expenses Fixed Cost Cost per cont per per Month Course Student $ 2,910 $300 $1,250 $ RO $5,100 $2,000 $1,600 5 46 $4 For example, administrative expenses should be $3,600 per month plus $46 per course plus $4 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: Actual Revenue 5 54,860 Instructor wages $ 10,920 Classroon supplies $ 19,050 Utilities $ 1,980 Campus rent 55,100 Insurance 5 2,140 Administrative expenses $3,456 Required: Prepare a flexible budget performance report that shows both revenue and spending variances and activity variances for September (Indicate the effect of each verlance by selecting for favorable, "U" for unfavorable, and "None" for no effect (.e., zero verlance). Input all amounts of poultive values.) Gourmand Cooling School Flexible Budget Performance Report For the Month Ended September 30 Flexible Actual Results Budget Planning Budget Courses Students 00 $ 54,000 Revenue Expenses Instructor wages Com supplies Campus rent Insurance Administrative expenses 10.920 10.050 1.980 5.100 2.140 3.450 Nat operating income S 11,404