Vulcan Flyovers offers scenic overflights 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 Results |
Flexible Budget |
Planning Budget |
||||
Flights (q) | 53 | 53 | 51 | |||
Revenue ($355.00q) | $ | 16,500 | $ | 18,815 | $ | 18,105 |
Expenses: | ||||||
Wages and salaries ($3,200 + $87.00q) | 7,777 | 7,811 | 7,637 | |||
Fuel ($31.00q) | 1,811 | 1,643 | 1,581 | |||
Airport fees ($820 + $34.00q) | 2,507 | 2,622 | 2,554 | |||
Aircraft depreciation ($11.00q) | 583 | 583 | 561 | |||
Office expenses ($250 + $1.00q) | 471 | 303 | 301 | |||
Total expense | 13,149 | 12,962 | 12,634 | |||
Net operating income | $ | 3,351 | $ | 5,853 | $ | 5,471 |
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 flexible 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.)
Vulcan Flyovers
Flexible Budget Performance
Report For the Month Ended July 31
Actual Results Flexible Budget Planning Budget
Flights 53 _________________ __________ 53 ______ _______ 51
Revenue $16,500 ________________ __________ $18,815 --------- _______ $18,105
Expenses:
Wages and salaries 7,777 __________________ ______________ 7,811 ______ ____ 7,637
Fuel 1,811 __________________ ______________ 1,643 ______ _____ 1,581
Airport fees 2,507 __________________ ___________ 2,622 _______ _________ 2,554
Aircraft depreciation 583 ____________________ _____________ 583 _______ _____________ 561
Office expenses 471 ______________________ ____________ 303 ________ ____________ 301
Total expense 13,1491 _____________________ _______________ 2,9621 ________ _____________ 2,634
Net operating income $3,351 _________________ _____________ $5,853 ________ _________-- $5,471
FLEXIBLE BUDGET PERFORMANCE REPORT | |||||||
Planning Budget | Activity Variances | Flexible Budget | Revenue and Spending Variances | Actual Results | |||
Flights [q] | 51 | 53 | 53 | ||||
Revenue [$355q] | $ 18,105 | $ 710 | F | $ 18,815 | $ 2,315 | U | $ 16,500 |
Expenses: | |||||||
Wages and salaries [$3200+$87q] | $ 7,637 | $ 174 | U | $ 7,811 | $ 34 | F | $ 7,777 |
Fuel [$31q] | $ 1,581 | $ 62 | U | $ 1,643 | $ 168 | U | $ 1,811 |
Airport fees [$820+$34q] | $ 2,554 | $ 68 | U | $ 2,622 | $ 115 | F | $ 2,507 |
Aircraft depreciation [$11q] | $ 561 | $ 22 | U | $ 583 | $ - | N | $ 583 |
Office expenses | $ 301 | $ 2 | U | $ 303 | $ 168 | U | $ 471 |
Total expenses | $ 12,634 | $ 328 | U | $ 12,962 | $ 187 | U | $ 13,149 |
Net operating income | $ 5,471 | $ 382 | F | $ 5,853 | $ 2,502 | U | $ 3,351 |
Vulcan Flyovers offers scenic overflights of Mount St. Helens, the volcano in Washington State that explosively...
Vulcan Flyovers offers scenic overflights 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 Results Flexible Budget Planning Budget Flights (q) 55 55 53 Revenue ($340.00q) $ 16,300 $ 18,700 $ 18,020 Expenses: Wages and salaries ($3,500 + $89.00q) 8,357 8,395 8,217 Fuel ($31.00q) 1,873 1,705 1,643 Airport fees ($800 + $32.00q) 2,410 2,560 2,496...
Vulcan Flyovers offers scenic overflights of Mount St. Helens, the volcano in Washington State that explosively erupted in 1982. Data concerning the company's operations in July appear below: Flexible Budget 53 $18,550 Planning Budget 51 $17,850 Vulcan Flyovers Operating Data For the Month Ended July 31 Actual Results Flights (9) 53 Revenue ($350.009) $ 16,200 Expenses: Wages and salaries ($3,100 + $89.009) 7,779 Fuel ($34.009) 1,964 Airport fees ($860 + $30.009) 2,325 Aircraft depreciation ($9.009) 477 Office expenses ($230 +...
Vulcan Flyovers offers scenic overflights 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 3.1 Actual Flexible Planning Results Budget Budget 53 Flights (g) $ 16,300 $ 19,250 18,550 Revenue ($350.00g) Expenses: Wages and salaries ($3,600 + $90.00q) Fuel ($34.00q) Airport fees ($850 $33.00g) Aircraft depreciation ($10.00g) Office expenses ($230+ $1.00g) 8,370 1,802 2,599 530 283 14,070...
Vulcan Flyovers offers scenic overflights 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 59 Flights (9) $ 16,300 $ 20,355 $ 19,665 Revenue ($345.009) Expenses : Wages and salaries ($3,600 + $90.00) Fuel ($34.00) Airport fees ($890 + $34.000) Aircraft depreciation ($9.00) Office expenses ($240 + $1.009) Total expense...
Vulcan Flyovers offers scenic overflights 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 (9) 60 60 58 Revenue ($355.000) $ 16,300 $ 21,300 20,590 8,702 8,7408,562 Expenses: Wages and salaries ($3,400+ $89.000) Fuel ($34.000 Airport fees ($870 + $34.00) Aircraft depreciation ($8.00m) Office expenses ($210 + $1.000) 2,040...
Vulcan Flyovers offers scenic overflights of Mount St. Helens, the volcano in Washington State that explosively erupted in 1982. Data conceming the company's operations in July appear below: Vulcan Flyovers Operating Data For the Month Ended July 31 Planning Budget 50 $16,000 Actual Flexible Budget 48 $15,360 Results Flights (g) Revenue ($320.00g) Expenses: Wages and salaries ($4,000 + $82.00g) Fuel ($23.00g) Airport fees ($650 + $38.00g) Aircraft depreciation (S7.00g) Office expenses ($190 + $2.00g) Total expense Net operating income 48...
Vulcan Flyovers offers scenic overflights 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 57 57 55 Flights (9) $16,100 $19,950 $19,250 Revenue ($350.000) Expenses: Wages and salaries ($3,500 + $91.009) Fuel ($30.009) Airport fees ($820 + $33.000) Aircraft depreciation ($8.009) Office expenses ($210 + $1.009) Total expense Net operating...
Vulcan Flyovers offers scenic overflights 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 Results Flexible Planning Budget Budget 62 68 Flights (9) $ 16,100 $ 21,399 $ 20,709 Revenue ($345.999) Expenses: Wages and salaries ($3,588 + $89.08) Fuel ($32.899) Airport fees ($860 + $32.899) Aircraft depreciation ($8.089) Office expenses ($220 + $1.889) Total expense...
Vulcan Flyovers offers scenic overflights of Mount St. Helens, the volcano in Washington State that explosively erupted in 1982. Data concerning the company's operations in July appear below: The company measures its activity in terms of flights. Customers can but individual tickets for overflights or hire an entire plane for an overflight at a discount. Prepare a flexible budget performance report for July that includes revenue and spending variances and activity variances. Indicate the effect of each variance by selecting...
Vulcan Flyovers offers scenic overflights 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 nok Flights (9) $ 16,300 $ 20.700 $20,010 ences 8.640 1,920 2.880 Revenue ($345.004) Expenses: Wages and salaries ($3,300 + $89.00) Fuel ($32.009) Airport fees ($840 + $34.009) Aircraft depreciation (59.009) office expenses ($240 + $1.009)...