please answer all questions, thank you.
Anden Amma bubon Month fet les conto the new to the schedule of ye hiyo hairshotels wie A Tweeter the www AL Lavape Rapide in a Canadian company that owns and operates a large automatico car with facilly now Mantront. The following table provide data concerning the company's costa Fikod CA De Month 5 1.100 Casper Car Washed $0.50 $ 0.07 Cleaning upp Electricity Maintenance Wages and sales Depreciation Rant Administrative aspersen $ 0.30 $0 AD $ 4.800 $4,200 $ 2.100 $ 0.04 For example, electricity costs are $1,100 per month plus 10.07 per car washed. The company expect to wash 100crs in August and to collect an average of $6.50 per car washed Required: Prepare the company's planning budget for August Lavere Rapide Planning Budget For the Month Ended August 31 Revenue Expenses Cleaning supplies Electricity Maintenance Wages and salaries Depreciation Rant Administrative expenses Total expense Net operating income 0 0 $ Food Coul per Mont Lavape Rapide la a Canadian company that owns and operates a large automate car with faca ty new Montrow. The following tatlo prossen clata concoming the company costs Coupe Ca West Cleaning supple $ 0.70 Electricity $ 1.100 $10.08 Mantece $ 0.15 Wapes and salarios 341 SO. Depreciation $ 3500 Rent $ 1.100 Administre $ 1.500 $ 0.00 For example, electricity costs are $1,100 per month plus so.06 per car washed. The company actualy washed 3.200 cers in August and collected an average of $6.30 per car washed. Required: Prepare the company's foile budget for August Lavage Rapide Pleable Budget For the Month Ended At Revenue Expenses Cleaning supplies Electricity Maintenance Wages and see Depreciation Reni Administrative expenses Total expense Net operating income 0 $0 Alyeski Tours operates day tours of coastal glaciers in Alaska on its tour boat the Blue Glacier. Management has identified two cost drivers-the number of cruises and the number of passengers-that it uses in its budgeting and performance reports. The company publishes a schedule of day cruises that it may supplement with special sailings if there is sufficient demand. Up to 80 passengers can be accommodated on the tour boat. Data concerning the company's cost formulas appear below: Cost per Passenger $ 3.40 Vessel operating costs Advertising Administrative costs Insurance Fixed cost per Month Cost per Cruise $ 6,400 $ 477.00 $ 3,000 $ 5,600 $31.00 $ 3,200 $ 1.50 For example, vessel operating costs should be $6.400 per month plus $477.00 per cruise plus $3.40 per passenger. The company's sales should average $29.00 per passenger. In July, the company provided 53 cruises for a total of 3,150 passengers. Required: Prepare the company's flexible budget for July Alyeski Tours Flexible Budget For the Month Ended July 31 Revenue Expenses: Vessel operating costs Advertising Administrative costs Insurance Total expense Net operating income 0 0 Fixed Cost per Month Cost per Car Washed $0.50 $0.07 $ 0.20 $ 0.40 Cleaning supplies Electricity Maintenance Wages and salaries Depreciation Rent Administrative expenses $ 1.100 $ 4,800 $ 8,200 $2,100 $1,800 $ 0.04 For example, electricity costs are $1.100 per month plus $0.07 per car washed. The company expects to wash 8.100 cars in August and to collect an average of $6.50 per car washed. Required: Prepare the company's planning budget for August Lavage Rapide Planning Budget For the Month Ended August 31 Revenue Expenses: Cleaning supplies Electricity Maintenance Wages and salaries Depreciation Rent Administrative expenses Total expense Net operating income 0 $ Cost per Month $1,100 cleaning supplies Electricity Maintenance Wages and salaries Depreciation Rent Administrative expenses Car Washed $ 0.70 $ 0.06 $ 0.15 $ 0.30 $4,800 $8,500 $1,800 $1,500 $ 0.00 For example, electricity costs are $1.100 per month plus $0.06 per car washed. The company actually washed 8,200 cars in August and collected an average of $6.30 per car washed. Required: Prepare the company's flexible budget for August Lavage Rapide Flexible Budget For the Month Ended August 31 Revenue Expenses: Cleaning supplies Electricity Maintenance Wages and salaries Depreciation Rent Administrative expenses Total expense Net operating income 0 0