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 ($345.00q) $ 16,200 $ 18,285 $ 17,595 Expenses: Wages and salaries ($3,300 + $91.00q) 8,081 8,123 7,941 Fuel ($30.00q) 1,760 1,590 1,530 Airport fees ($820 + $32.00q) 2,386 2,516 2,452 Aircraft depreciation ($10.00q) 530 530 510 Office expenses ($240 + $1.00q) 461 293 291 Total expense 13,218 13,052 12,724 Net operating income $ 2,982 $ 5,233 $ 4,871 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.)
Ans. | VULCAN FLYOVERS | |||||||
Flexible Budget Performance Report | ||||||||
For the Month Of July | ||||||||
Actual Results | Spending variance | Flexible Budget | Activity variance | Planning Budget | ||||
Flights | 53 | 53 | 51 | |||||
Revenue | $16,200 | $2,085 | U | $18,285 | $690 | F | $17,595 | |
Expenses: | ||||||||
Wages and salaries | $8,081 | $42 | F | $8,123 | $182 | U | $7,941 | |
Fuel | $1,760 | $796 | U | $1,590 | $60 | U | $1,530 | |
Airport fees | $2,386 | $130 | F | $2,516 | $64 | U | $2,452 | |
Aircraft depreciation | $530 | $0 | none | $530 | $20 | U | $510 | |
Office expenses | $461 | $168 | U | $293 | $2 | U | $291 | |
Total expenses | $13,218 | $166 | U | $13,052 | $328 | U | $12,724 | |
Net operating income | $2,982 | $2,251 | U | $5,233 | $362 | F | $4,871 | |
*Calculation of Flexible budget & Planning budget: | ||||||||
Flexible Budget | Planning budget | |||||||
Flights | 53 | 51 | ||||||
Revenue | $345 * 53 | $345 * 51 | ||||||
Expenses: | ||||||||
Wages and salaries | $3300 + ($91*53) | $3300 + ($91*51) | ||||||
Fuel | $30 * 53 | $30 * 51 | ||||||
Airport fees | $820 + ($32 * 53) | $820 + ($32 * 51) | ||||||
Aircraft depreciation | $10 * 53 | $10 * 51 | ||||||
Office expenses | $240 + ($1 * 53) | $240 + ($1 * 51) | ||||||
*Flexible budget is prepared on the basis of actual units. | ||||||||
*Fixed expenses remain same as planning budget. | ||||||||
Revenue & Spending variance = Actual results - Flexible budget | ||||||||
Activity variance = Flexible budget - Planning budget | ||||||||
*Increase in expenses from flexible budget to actual results & Planning budget to flexible budget = Unfavorable. | ||||||||
*Decrease in expenses from flexible budget to actual results & Planning budget to flexible budget = Favorable. | ||||||||
*Increase in revenue or net income from flexible budget to actual results & Planning budget to flexible budget = Favorable. | ||||||||
*Decrease in revenue or net income from flexible budget to actual results & Planning budget to flexible budget = Unfavorable. |
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: Vulcan Flyovers Operating Data For the Month Ended July 31 Actual Results Flexible Budget Planning Budget Flights (q) 56 56 54 Revenue ($355.00q) $ 16,300 $ 19,880 $ 19,170 Expenses: Wages and salaries ($3,300 + $91.00q) 8,354 8,396 8,214 Fuel ($32.00q) 1,958 1,792 1,728 Airport fees ($820 + $30.00q) 2,380 2,500 2,440...
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) 56 56 54 Revenue ($355.00q) $ 16,300 $ 19,880 $ 19,170 Expenses: Wages and salaries ($3,300 + $91.00q) 8,354 8,396 8,214 Fuel ($32.00q) 1,958 1,792 1,728 Airport fees ($820 + $30.00q) 2,380 2,500 2,440...
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) 57 57 55 Revenue ($350.00q) $ 16,200 $ 19,950 $ 19,250 Expenses: Wages and salaries ($3,200 + $88.00q) 8,180 8,216 8,040 Fuel ($34.00q) 2,100 1,938 1,870 Airport fees ($840 + $32.00q) 2,539 2,664 2,600...
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) 57 57 55 Revenue ($345.00q) $ 16,000 $ 19,665 $ 18,975 Expenses: Wages and salaries ($3,800 + $85.00q) 8,615 8,645 8,475 Fuel ($31.00q) 1,935 1,767 1,705 Airport fees ($880 + $34.00q) 2,678 2,818 2,750...
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,200 $ 19,950 $ 19,250 O AO Revenue ($350.00q) Expenses: Wages and salaries ($3,300 + $91.00g) Fuel ($33.009) Airport fees ($830 + $31.009) Aircraft depreciation ($10.00q). Office expenses ($220 +...
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) 60 60 58 Revenue ($355.00q) $ 16,100 $ 21,300 $ 20,590 Expenses: Wages and salaries ($3,600 + $90.00q) 8,960 9,000 8,820 Fuel ($31.00q) 2,028 1,860 1,798 Airport fees ($870 + $34.00q) 2,810 2,910 2,842...
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) 61 61 59 Revenue ($355.00q) $ 16,100 $ 21,655 $ 20,945 Expenses: Wages and salaries ($3,400 + $85.00q) 8,555 8,585 8,415 Fuel ($30.00q) 2,000 1,830 1,770 Airport fees ($800 + $34.00q) 2,744 2,874 2,806...
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 Flexible Planning Budget Actual Results Budget Flights (q) 56 56 54 Revenue ($340.00g) 16,100 19,040 18,360 Expenses: Wages and salaries ($3,300$91.00q) Fuel ($30.00q) Airport fees (S800 $34.00g) Aircraft depreciation ($8.00q) Office expenses ($210$1.00q) Total expense 8,354 1,850 2,589 8,396 1,680 2,704 8,214...
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) 52 52 50 Revenue ($355.00q) $ 16,400 $ 18,460 $ 17,750 Expenses: Wages and salaries ($3,800 + $92.00q) 8,540 8,584 8,400 Fuel ($31.00q) 1,780 1,612 1,550 Airport fees ($870 + $32.00q) 2,409 2,534 2,470...