Please answer the following questions below:
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 (q) 300 Revenue ($410.00g) $123,000 Expenses: Wages and salaries ($11,400 + $122.00q) 48,000 Supplies ($5.00q) 1,500 Equipment rental ($2,100 + $23.00q) 9,000 Insurance ($3,800) 3,800 Miscellaneous ($500 + $1.48q) 944 Total expense 63,244 Net operating income __ELEELZE_ 7 During May, the company's actual activity was 290 diving-hours. Required: Prepare a flexible budget for May. (Round your answers to the nearest whole number.) Revenue Wages and salaries Equipment rental Miscellaneous Total expense Net operating income Flight Cafe prepares in-flight meals for airlines in its kitchen located next to a local airport. The company's planning budget for July appears below: Flight Cafe Planning Budget For the Month Ended July 31 Budgeted meals (q) 21 , 000 Revenue ($4.30q) $90 , 300 Expenses : Raw materials ($2.30q) Wages and salaries ($6, 300 + $0.20q) 48, 300 10 , 500 Utilities ($1, 800 + $0. 05q) 2, 850 Facility rent ($3, 400) 3, 400 Insurance ($2, 300) 2,300 Miscellaneous ($800 + $0. 10q) 2,900 Total expense 70 , 250 Net operating income $20 , 050 In July, 22,000 meals were actually served. The company's flexible budget for this level of activity appears below: Flight Cafe Flexible Budget For the Month Ended July 31 Budgeted meals (9) 22, 000 Revenue ($4.30g) $94, 600 Expenses : Raw materials ($2.30q) 50, 600 Wages and salaries ($6, 300+ $0.20q) 10, 700 Utilities ($1, 800 + $0. 05q) Facility rent ($3, 400) 2, 90 Insurance ($2, 300) 3,40 2,300 Miscellaneous ($800 + $0. 10g) 3, 000 Total expense 72 , 900 Net operating income $21 , 700 Required: 1. Calculate the company's activity variances for July. (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.) Flight Cafe Activity Variances For the Month Ended July 31 Revenue Expenses Raw materials Wages and salaries Utilities Facility rent Insurance Miscellaneous Total expense Net operating incomeOuilcene Oysteria farms and sells oysters in the Pacic Northwest. The company harvested and sold 7,800 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 (g) 7,300 Revenue ($4.20q] $32,760 Expenses: Packing supplies ($0.40q) 3,120 Oyster bed maintenance ($3,400) 3,400 Wages and salaries ($2,200 + $0.25q) 4,150 Shipping ($0.55q) 4,290 Utilities ($1,280) 1,280 Other ($500 + $0.01q) 578 Total expense 16,818 $15,942 Net operating income I The actual results for August were as follows: Quiloene Oysteria Income Statement For the Month Ended August 31 Actual pounds 7,300 Revenue $27,100 Expenses: Packing supplies 3,290 Oyster bed maintenance 3,260 Wages and salaries 4,560 Shipping 4,020 Utilities 1,090 Other 1,198 Total expense 17:419 $ 9,682 Net operating income F_________________________________ 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.) Other Total expense Net operating income Vulcan Flyovers offers scenic overights of Mount St. Helens, the volcano in Washington State that explosively erupted in 1982. Data concerning the company's operations in July appear below: Vulcan Flyovers Operating Data For the Month Ended July 31 Actual Flexible Planning Results Budget Budget Flights (q) 55 55 53 Revenue ($350.00q) $ 16,000 $ 19,250 $ 18,550 Expenses: Wages and salaries ($3,400 + $88.00q) 8,204 8,240 8,064 Fuel ($30.00q) 1,820 1,650 1,590 Airport fees ($880 + $31.00q) 2,475 2,535 2,523 Aircraft depreciation ($10.00q) 550 550 530 Office expenses ($230 + $1.00q) 453 285 283 Total expense 13,502 13,310 12,990 Net operating income $ 21495 $ 5,940 $ 5,550 , The company measures its activity in terms of flights. Customers can buy individual tickets for overflights or hire an entire plane for an overflight at a discount. Required: 1. Prepare a exible budget performance report for July that includes revenue and spending variances and activity variances. (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.) $ as $ --_ Airport fees 2,475 2,523 Aircraft depreciation 530 Ofce expenses Total expense Net operating income Alyeski Tours operates day tours of coastal glaciers in Alaska on its tour boat the Blue Glacier. Management has identied two cost driversthe number of cruises and the number of passengersthat 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 86 passengers can be accommodated on the tour boat. Data concerning the company's cost formulas appear below: Fixed Cost per Month Cost per Cruise Cost per Passenger Vessel operating costs $ 6,200 $478.00 $ 3.50 Advertising $ 2,100 Administrative costs $ 5,500 $ 34.00 $ 1.50 Insurance 5 3,800 For example, vessel operating costs should be $6,200 per month plus $478.00 per cruise plus $3.50 per passenger. The company's sales should average $29.00 per passenger. In July, the company provided 56 cruises for a total of 3,100 passengers. Required: Prepare the company's flexible budget for July. Revenue _ Vessel operating costs _ Administrative costs _ Total expense Net operating income