S Puget Sound Divers is a company that provides diving services such as underwater ship repairs to clients in the Puget Sound area. The company's planning budget for May appears below: Puget Sound Divers Planning Budget For the Month Ended May 31 Budgeted diving-hours (9) Revenue ($460.009) Expenses: Wages and salaries ($11,800 +$126.00q) Supplies ($5.009) Equipment rental ($2,000 + $21.009) Insurance ($3,900) Miscellaneous ($530 + $1.48q) Total expense Net operating income 350 $ 161,000 55,900 1,750 9,350 3,900 1,048 71,948 $ 89,052 During May, the company's actual activity was 340 diving-hours. During May, the company's actual activity was 340 diving-hours. Required: Prepare a flexible budget for May. (Round your answers to the nearest whole dollar.) Puget Sound Divers Flexible Budget For the Month Ended May 31 Actual diving-hours Revenue Expenses: Wages and salaries Supplies Equipment rental Insurance Miscellaneous Total expense Net operating income 69 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 87 passengers can be accommodated on the tour boat. Data concerning the company's cost formulas appear below: Vessel operating costs Advertising Administrative costs Insurance Fixed Cost per Cost per Cost per Passenger Month $ 6,400 Cruise $ 474.00 $ 3.30 $ 2,200 $ 5,300 $ 3,800 $ 33.00 $ 1.50 For example, vessel operating costs should be $6,400 per month plus $474.00 per cruise plus $3.30 per passenger. The company's sales should average $34.00 per passenger. In July, the company provided 53 cruises for a total of 3,100 passengers. Quilcene Oysteria farms and sells oysters in the Pacific Northwest. The company harvested and sold 7,200 pounds of oysters in August. The company's flexible budget for August appears below: Quilcene Oysteria Flexible Budget For the Month Ended August 31 Actual pounds (q) Revenue ($4.25q) Expenses: Packing supplies ($0.35q) Oyster bed maintenance ($3,200) Wages and salaries ($2,100 + $0.50q) Shipping ($0.70g) Utilities ($1,230) Other ($400 + $0.019) Total expense Net operating income 7,200 $ 30,600 2,520 3,200 5,700 5,040 1,230 472 18,162 $ 12,438 The actual results for August appear below: Quilcene Oysteria Income Statement For the Month Ended August 31 Actual pounds Revenue Expenses: 7,200 $ 26,700 Packing supplies Oyster bed maintenance Wages and salaries Shipping Utilities Other Total expense 2,690 3,060 6,110 4,770 1,040 1,092 18,762 Net operating income $ 7,938 Required: Calculate the company's revenue and spending 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.) Quilcene Oysteria Revenue and Spending Variances For the Month Ended August 31 Revenue Expenses: Packing supplies Oyster bed maintenance Wages and salaries Shipping Utilities Other Total expense 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: Cleaning supplies Electricity Maintenance Wages and salaries Depreciation Rent Administrative expenses Fixed Cost Cost per Car per Month Washed $ 0.50 $ 1,500 $ 0.06 $ 0.30 $ 4,300 $ 0.20 $ 8,200 $ 1,800 $ 1,500 $ 0.02 For example, electricity costs are $1,500 per month plus $0.06 per car washed. The company expects to wash 8,300 cars in August and to collect an average of $6.70 per car washed. 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 X Prey 3 of 5 Next > 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 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: Cleaning supplies Electricity Maintenance Wages and salaries Depreciation Rent Administrative expenses Fixed Cost Cost per Car per Month Washed $0.40 $ 1,200 $ 0.10 $ 0.25 $ 4,500 $ 0.30 $ 8,400 $ 1,800 $ 1,400 $ 0.02 For example, electricity costs are $1,200 per month plus $0.10 per car washed. The company actually washed 8,400 cars in August and collected an average of $6.90 per car washed. es 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