Exercise 9-4 (Algo) Prepare a Flexible Budget Performance Report [LO9-4] Vulcan Flyovers offers scenic overflights of Mount Saint Helens, the volcano in Washington State that explosively erupted in 1982. Data concerning the company's operations in July appear below: Flights (q) Revenue ($345.00q) Vulcan Flyovers Operating Data For the Month Ended July 31 Expenses: Wages and salaries ($3,500 + $90.00g) Fuel ($33.00g) Airport fees ($830 + $30.00q) Aircraft depreciation ($8.00q) Office expenses ($240 + $1.00q) Total expense Net operating income Actual Results 57 $ 16,100 8,590 2,045 2,395 456 465 13,951 $ 2,149 Flexible Budget 57 $ 19,665 8,630 1,881 2,540 456 297 13,804 $ 5,861 Planning Budget 55 $ 18,975 8,450 1,815 2,480 440 295 13,480 $ 5,495 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.)
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
![Exercise 9-4 (Algo) Prepare a Flexible Budget Performance Report [LO9-4]
Vulcan Flyovers offers scenic overflights of Mount Saint Helens, the volcano in
Washington State that explosively erupted in 1982. Data concerning the company's
operations in July appear below:
Flights (q)
Revenue ($345.00q)
Expenses:
Wages and salaries ($3,500 + $90.00q)
Fuel ($33.00q)
Airport fees ($830 + $30.00q)
Aircraft depreciation ($8.00q)
Office expenses ($240 + $1.00g)
Total expense
Net operating income
Flights
Revenue
Expenses:
Vulcan Flyovers
Operating Data
For the Month Ended July 31
Wages and salaries
Fuel
Airport fees
Aircraft depreciation
Office expenses
Total expense
Net operating income
Actual Results
$
$
Actual Results
57
$ 16,100
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.
57
16,100
8,590
2,045
2,395
456
465
13,951
$ 2,149
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.)
8.590
2,045
2,395
456
465
13,951
2,149
Flexible
Budget
57
$ 19,665
$
8,630
1,881
2,540
456
297
13,804
$ 5,861
$
Vulcan Flyovers
Flexible Budget Performance Report
For the Month Ended July 31
Flexible
Budget
Planning
Budget
57
19,665
55
$ 18,975
8,630
1,881
2,540
456
297
13,804
5,861
8,450
1,815
2,480
440
295
13,480
$ 5,495
Planning
Budget
$
$
55
18,975
8,450
1,815
2,480
440
295
13,480
5,495](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F15a526c6-de52-4025-8530-5e7aa950042d%2F5087ed0d-9bff-4bba-983f-91c588b724c1%2Fegx1few_processed.jpeg&w=3840&q=75)

Trending now
This is a popular solution!
Step by step
Solved in 2 steps









