Screenshot (400)
png
keyboard_arrow_up
School
North Carolina State University *
*We aren’t endorsed by this school
Course
630
Subject
Accounting
Date
Apr 3, 2024
Type
png
Pages
1
Uploaded by PresidentFlamingo4131
Exercise 9-4 (20 minutes) 1. Vulcan Flyovers Flexible Budget Performance Report For the Month Ended July 31 Revenue and Spending Flexible Variances Budget Actual Results Flights (g) 48 Revenue ($320.009) $13,650 $1,710 Expenses: Wages and salaries ($4,000 + $82.009) 8,430 494 Fuel ($23.009) 1,260 156 Airport fees ($650 + $38.00q) ___ 2,350 124 Aircraft depreciation ($7.00q) ___ 336 0 Office expenses ($190 + $2.00g) 460 174 Total expenses 12,836 700 Net operating income $§ 814 $2,410 48 U $15,360 u 7,936 U 1,104 F 2474 336 U 286 U 12,136 U $3,.224 Activity Variances $640 164 46 76 14 5 _304 $336 U F F F F F F U Planning Budget 50 $16,000 2. The overall $336 unfavorable activity variance is due to activity falling below what had been planned for the month. The $1,710 unfavorable revenue variance is very large relative to the company’s net operating income and should be investigated. Was this due to discounts given or perhaps a lower average number of passengers per flight than usual? The $494 unfavorable spending variance for wages and salaries is also large and should be investigated. The other spending variances are relatively small, but are worth some management attention—particularly if they recur next month.
Discover more documents: Sign up today!
Unlock a world of knowledge! Explore tailored content for a richer learning experience. Here's what you'll get:
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Documents
Related Questions
Haresh
arrow_forward
None
arrow_forward
None
arrow_forward
int
erences
Vulcan Flyovers
Operating Data
For the Month Ended July 31
Flights (q)
Revenue ($360.00q)
Expenses:
Wages and salaries ($3,700+ $87.00q)
Fuel ($33.00q)
Airport fees ($890 +$34.009)
Aircraft depreciation ($9.00q)
Office expenses ($230 +$1.00q)
Total expenses
Net operating income
Actual
Results
Flexible
Budget
57
57
Planning
Budget
55
$ 16,200
$ 20,520
$ 19,800
8,625
8,659
8,485
2,045
1,881
1,815
2,688
2,828
2,760
513
513
495
455
14,326
287
14,168
285
13,840
$ 1,874
$ 6,352
$ 5,960
The company measures its activity in terms of flights. Customers can buy individual tickets for overflights or hire an entire plane at a
discount.
Required:
1. Prepare a flexible budget performance report for July.
Note: 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
Flights
Revenue
Expenses:
Wages and salaries
Actual Results
57
$
16,200
8,625
Flexible…
arrow_forward
None
arrow_forward
Hansaben
arrow_forward
am. 103.
arrow_forward
Do not give solution in image
arrow_forward
Graded HW i
Fixed Budget
For Year Ended December 31
$
Sales
3,171,000
Costs
Direct materials
996,600
Direct labor
226,500
Sales staff commissions
60,400
Depreciation-Machinery
295,000
Supervisory salaries
203,000
Shipping
226,500
Sales staff salaries (fixed annual
250,000
amount)
Administrative salaries
556,450
Depreciation-Office equipment
198,000
Income
$ 158,550
Saved
Required:
1&2. Prepare flexible budgets at sales volumes of 14,100 and 16,100 units.
3. The company's business conditions are improving. One possible result is a sales volume of 18,100 units. Prepare a
simple budgeted income statement if 18,100 units are sold.
Complete this question by entering your answers in the tabs below.
Req 1
Req 3
and 2
Prepare flexible budgets at sales volumes of 14,100 and 16,100 units.
Sales
Variable costs
Direct materials
Direct labor
Sales staff commissions
Shipping
Total variable costs
Contribution margin
Fixed costs
PHOENIX COMPANY
Flexible Budgets
For Year Ended December 31
Flexible…
arrow_forward
None
arrow_forward
Exercise 9-4 (Algo) Prepare a Flexible Budget Performance Report [LO9-4]
Vulcan Flyovers offers scenic overflights of Mount Saint Helens. Data concerning the company's operations in July appear below:
Vulcan Flyovers
Operating Data
For the Month Ended July 31
Flights (q)
Revenue ($355.00g)
Expenses:
Wages and salaries ($3,100 +$88.00g)
Fuel ($33.00q)
Airport fees ($880 +$34.00g)
Aircraft depreciation ($10.00q)
Office expenses ($240 + $1.00q)
Total expenses
Net operating income.
Actual
Results
Flexible
Budget
Planning
Budget
62
62
60
$ 16,000
$ 22,010
$ 21,300
8,520
8,556
8,380
2,210
2,046
1,980
2,878
2,988
2,920
620
620
600
470
302
300
14,698
14,512
14,180
$ 1,302
$ 7,498
$ 7,120
The company measures its activity in terms of flights. Customers can buy individual tickets for overflights or hire an entire plane at a
discount.
Required:
1. Prepare a flexible budget performance report for July.
Note: Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable,…
arrow_forward
Raw materials
Wages and salaries
Utilities
Facility rent
Insurance
Miscellaneous
Total expense
Net operating income
arrow_forward
Do not give image format
arrow_forward
Exercise 9-4 (Algo) Prepare a Flexible Budget Performance Report [LO9-4]
Vulcan Flyovers offers scenic overflights of Mount Saint Helens. Data concerning the company's operations in July appear below:
Vulcan Flyovers
Operating Data
For the Month Ended July 31
Flights (q)
Revenue ($345.00q)
Expenses:
Wages and salaries ($3,600 + $91.00g)
Fuel ($30.00q)
Airport fees ($860 + $32.009)
Aircraft depreciation ($11.00q)
Office expenses ($230 + $1.00g)
Total expenses
Net operating income
Flights
Revenue
Expenses:
Wages and salaries
Fuel
Airport fees
Aircraft depreciation
Office expenses
Total expenses
Net operating income
Actual Results
$
$
Actual
Results
54
16,200
54
$ 16, 200
8,472
1,790
2,478
594
452
13,786
2,414
The company measures its activity in terms of flights. Customers can buy individual tickets for overflights or hire an entire plane at a
discount.
Flexible
Budget
8,472
1,790
2,478
594
452
13,786
13,600
$ 2,414 $ 5,030
Required:
1. Prepare a flexible budget performance report for…
arrow_forward
None
arrow_forward
None
arrow_forward
Rahul
arrow_forward
15
Flight Café prepares in-flight meals for airlines and its planning budget for July appears below:
Flight Café
Planning Budget
For the Month Ended July 31
Budgeted meals (g)
Revenue ($4.00g)
Expenses:
Raw materials ($2.10g)
Wages and salaries ($6,300 + $0.20g)
Utilities ($2,000+ $0.05g)
Facility rent ($3,900)
Insurance ($2,500)
Miscellaneous ($600+ $0.10g)
Total expenses
Net operating income.
For the Month Ended July 31
In July, 26,000 meals were actually served. The company's flexible budget for this level of activity appears below:
Flight Café
Flexible Budget
Budgeted meals (g)
Revenue ($4.00g)
Expenses:
Rav materials ($2.10g)
Wages and salaries ($6,300+ $0.20g)
Utilities ($2,000+ $0.05g)
25,000
$ 100,000
Facility rent ($3,900)
Insurance ($2,500)
Miscellaneous ($600+ $0.10g)
Total expenses
Net operating income
52,500
11,300
3,250
3,900
2,500
3,100
76,550
$ 23,450
26,000
$ 104,000
54,600
11,500
3,300
3,900
2,500
3,200
79,000
$ 25,000
arrow_forward
Actual pounds (9)
Flexible Budget
For the Month Ended August 31
Revenue ($4.189)
Expenses:
Packing supplies ($0.309)
Oyster bed maintenance ($3,500)
Wages and salaries ($2,000 + $0.459)
Shipping ($0.659)
Utilities ($1,250)
Other ($510 + $0.019)
Total expenses
Net operating income
The actual results for August were as follows:
Quilcene Oysteria
Income Statement
For the Month Ended August 31
7,400
$ 30,340
2,228
3,500
5,330
4,810
1,250
584
17,694
$ 12,646
Actual pounds
Revenue
Expenses:
Packing supplies
Oyster bed maintenance
Wages and salaries
Shipping
Utilities
Other
Total expenses
Net operating income
Required:
7,400
$ 26,700
2,390
3,360
5,740
4,540
1,060
1,204
18,294
$ 8,406
Calculate the company's revenue and spending variances for August.
Note: Indicate the effect of each varlance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (l.e., zero
varlance). Input all amounts as positive values.
Revenue
Quilcene Oysteria
Revenue and Spending Variances
For the…
arrow_forward
Exercise 9-4 (Algo) Prepare a Flexible Budget Performance Report [LO9-4]
Vulcan Flyovers offers scenic overflights of Mount Saint Helens. Data concerning the company's operations in July appear below:
Vulcan Flyovers
Operating Data
For the Month Ended July 31
Flights (q)
Revenue ($355.00g)
Expenses:
Wages and salaries ($3,200+ $89.00q)
Fuel ($32.000)
Airport fees ($820 +$32.009)
Office expenses ($250 + $1.00q)
Aircraft depreciation ($10.009)
Total expenses
Net operating income
Actual
Results
Flexible
Budget
Planning
Budget.
56
56
54
$ 16,000
$ 19,880
$ 19,170
8,146
8,184
8,006
1,958
1,792
1,728
2,502
2,612
2,548
560
560
540
474
306
304
13,640
13,454
13,126
$ 2,360
$ 6,426
$ 6,044
The company measures its activity in terms of flights. Customers can buy individual tickets for overflights or hire an entire plane at a
discount.
Required:
1. Prepare a flexible budget performance report for July.
Note: Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable,…
arrow_forward
Planning Budget
For the Month Ended May 31
Budgeted diving-hours (q)
Revenue ($470.009)
Expenses:
Wages and salaries ($11,800 + $124.009)
Supplies ($4.009)
Equipment rental ($2,200 + $26.009)
Insurance ($4,000)
Miscellaneous ($540 + $1.469)
Total expense
Net operating income
300
$ 141,000
49,000
1,200
10,000
4,000
978
65,178
$ 75,822
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.)
Puget Sound Divers
Flexible Budget
For the Month Ended May 31
Revenue
Expenses:
Wages and salaries
Supplies
Equipment rental
Insurance
Miscellaneous
Total expense
0
Net operating income
$
0
arrow_forward
Prowse Corporation is an oil well service company that measures its output by the number of wells serviced. The company has provided the following fixed and variable cost
estimates that it uses for budgeting purposes.
Fixed Element
Variable Element per Well
per Month
Serviced
Revenue
$4,000
$1,000
Employee salaries and wages
Servicing materials
other expenses
$43,800
$ 600
$38,200
A total of 42 wells were actually serviced during October.
The revenue in the company's flexible budget for October would have been closest to:
arrow_forward
appears below:
Lessons
Revenue
Expenses:
Instructor wages
TipTop Flight School
Variance Report
For the Month Ended July 31
Actual
Results
185
Planning
Budget
180
Aircraft depreciation
Fuel
Maintenance
Ground facility expenses
Administration
Total expenses
Net operating income
Variances
$ 42,360
$ 41,400
$ 960 F
10,960
10,800
160 U
7,400
7,200
200 U
3,620
3,060
560 U
2,690
2,530
160 U
2,130
2,170
40 F
3,720
3,840
120 F
30,520
29,600
920 U
$ 11,840
$ 11,800
$ 48 F
After several months of using these reports, the owner has become frustrated. For example, she is confident instructor wages were
very tightly controlled in July, but the report shows an unfavorable variance.
She developed the planning budget using the following formulas, where q is the number of lessons sold:
Cost Formulas
Revenue
Instructor wages
$238q
$60q
Aircraft depreciation
$40q
$17q
$550 +$11g
Ground facility expenses
$1,450 + $4q
$3,300+ $3q
Fuel
Maintenance
Administration
Required:
2. Complete the flexible budget…
arrow_forward
appears below:
Lessons
Revenue
Expenses:
Instructor wages
TipTop Flight School
Variance Report
For the Month Ended July 31
Actual
Results
Planning
Budget
180
Aircraft depreciation
Fuel
Maintenance
Ground facility expenses
Administration
Total expenses
Net operating income
Variances
185
$ 42,360
$ 41,400
$ 960 F
10,960
10,800
160 U
7,400
7,200
200 U
3,620
3,060
560 U
2,690
2,530
160 U
2,130
2,170
40 F
3,720
3,840
120 F
30,520
$ 11,840
29,600
$ 11,800
920 U
$ 40 F
After several months of using these reports, the owner has become frustrated. For example, she is confident instructor wages were
very tightly controlled in July, but the report shows an unfavorable variance.
She developed the planning budget using the following formulas, where q is the number of lessons sold:
Cost Formulas
Revenue
Instructor wages
$238q
$60q
Aircraft depreciation
$40g
$17q
Fuel
$550 +$11g
Ground facility expenses
$1,450 + $4q
$3,300+ $3q
Maintenance
Administration
Required:
2. Complete the flexible budget…
arrow_forward
ABC Bus Lines runs a series of bus routes. A new route is being planned for next year.
The Sales Manager says the range of passengers would be:
20,000 Conservative Estimate
40.000 Optimistic Estimate
$26.00 Ticket Price
The controller provides the following information:
$6.00 Fuell
$6.00 Driver
$2.00 Selling
$1.00 Admin
$15.00
$100,000 Facility Overhead (Regardless of Number of Trips).
$50,000 Selling & Administration (Regardless of Number of Trips)
Instructions
Assume the first-year results were:
22,450 Passengers.
$538,800-Revenue
$123,475-Fuel
arrow_forward
A clinic uses client-visits as Its measure of activity Duning January, the clinic budgeted for 3,300 client-visits, but Its actual level of activity was 3,280 client-visits.
results for January:
Data used In budgeting:
Fixed element
Variable element
per client-visit
$35.30
per month
Revenue
Personnel expenses
$427,300
$11.30
5.30
1,300
10,300
6,300
Medical supplies
1.00
Occupancy expenses
Administrative expenses
0.40
$ 45,200
$ 18.00
Total expenses
Actual results for January:
$ 124,680
$ 72,030
$ 22,706
$ 14,630
$ 8,135
Revenue
Personnel expenses
Medical supplies
Occupancy expenses
Administrative expenses
The activity varlance for net operating Income In January would be closest to:
Multiple Choice
O $346 F
$4.711 F
arrow_forward
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 80
passengers can be accommodated on the tour boat. Data concerning the company's cost formulas appear below:
Cost per Cruise
$ 477.00
Cost per Passenger
Fixed Cost per Month
$ 6,000
$ 2,500
$ 5,300
$ 3,300
$ 3.00
Vessel operating costs
Advertising
Administrative costs
$
31.00
$ 1.50
Insurance
For example, vessel operating costs should be $6,000 per month plus $477.00 per cruise plus $3.00 per passenger. The
company's sales should average $31.00 per passenger. In July, the company provided 52 cruises for a total of 3,200 passengers.
Required:
Prepare the company's flexible budget for July.
Alyeski Tours
Flexible…
arrow_forward
TB Problem Qu. 10-287 Cicchetti Corporation uses customers...
Cicchetti Corporation uses customers served as its measure of activity. The following report compares the planning budget to the actual operating results for the month of December:
Cicchetti CorporationComparison of Actual Results to Planning BudgetFor the Month Ended December 31
Actual Results
Planning Budget
Variances
Customers served
37,000
31,000
Revenue ($4.8q)
$
178,550
$
148,800
$
29,750
F
Expenses:
Wages and salaries ($37,400 + $1.6q)
100,000
87,000
13,000
U
Supplies ($0.9q)
32,750
27,900
4,850
U
Insurance ($14,400)
14,800
14,400
400
U
Miscellaneous expense ($7,400 + $0.4q)
24,100
19,800
4,300
U
Total expense
171,650
149,100
22,550
U
Net operating income
$
6,900
$
-300
$
7,200
F
Required:Prepare the company's flexible budget performance report for…
arrow_forward
Saved
antcring overhead s budgeted to be $33,000 plus $6 per unit produced. What Is budgeted manufacturing overhead for AuguUst?
32
Sylerh tas brecast production for the next three months as follows: July 6,500 units, August 8,200 units, September 9,100 units. Monthly
Mutole Choice
S82.200
$I2.000
$9.200
SE7500
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning

Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Related Questions
- int erences Vulcan Flyovers Operating Data For the Month Ended July 31 Flights (q) Revenue ($360.00q) Expenses: Wages and salaries ($3,700+ $87.00q) Fuel ($33.00q) Airport fees ($890 +$34.009) Aircraft depreciation ($9.00q) Office expenses ($230 +$1.00q) Total expenses Net operating income Actual Results Flexible Budget 57 57 Planning Budget 55 $ 16,200 $ 20,520 $ 19,800 8,625 8,659 8,485 2,045 1,881 1,815 2,688 2,828 2,760 513 513 495 455 14,326 287 14,168 285 13,840 $ 1,874 $ 6,352 $ 5,960 The company measures its activity in terms of flights. Customers can buy individual tickets for overflights or hire an entire plane at a discount. Required: 1. Prepare a flexible budget performance report for July. Note: 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 Flights Revenue Expenses: Wages and salaries Actual Results 57 $ 16,200 8,625 Flexible…arrow_forwardNonearrow_forwardHansabenarrow_forward
- am. 103.arrow_forwardDo not give solution in imagearrow_forwardGraded HW i Fixed Budget For Year Ended December 31 $ Sales 3,171,000 Costs Direct materials 996,600 Direct labor 226,500 Sales staff commissions 60,400 Depreciation-Machinery 295,000 Supervisory salaries 203,000 Shipping 226,500 Sales staff salaries (fixed annual 250,000 amount) Administrative salaries 556,450 Depreciation-Office equipment 198,000 Income $ 158,550 Saved Required: 1&2. Prepare flexible budgets at sales volumes of 14,100 and 16,100 units. 3. The company's business conditions are improving. One possible result is a sales volume of 18,100 units. Prepare a simple budgeted income statement if 18,100 units are sold. Complete this question by entering your answers in the tabs below. Req 1 Req 3 and 2 Prepare flexible budgets at sales volumes of 14,100 and 16,100 units. Sales Variable costs Direct materials Direct labor Sales staff commissions Shipping Total variable costs Contribution margin Fixed costs PHOENIX COMPANY Flexible Budgets For Year Ended December 31 Flexible…arrow_forward
- Nonearrow_forwardExercise 9-4 (Algo) Prepare a Flexible Budget Performance Report [LO9-4] Vulcan Flyovers offers scenic overflights of Mount Saint Helens. Data concerning the company's operations in July appear below: Vulcan Flyovers Operating Data For the Month Ended July 31 Flights (q) Revenue ($355.00g) Expenses: Wages and salaries ($3,100 +$88.00g) Fuel ($33.00q) Airport fees ($880 +$34.00g) Aircraft depreciation ($10.00q) Office expenses ($240 + $1.00q) Total expenses Net operating income. Actual Results Flexible Budget Planning Budget 62 62 60 $ 16,000 $ 22,010 $ 21,300 8,520 8,556 8,380 2,210 2,046 1,980 2,878 2,988 2,920 620 620 600 470 302 300 14,698 14,512 14,180 $ 1,302 $ 7,498 $ 7,120 The company measures its activity in terms of flights. Customers can buy individual tickets for overflights or hire an entire plane at a discount. Required: 1. Prepare a flexible budget performance report for July. Note: Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable,…arrow_forwardRaw materials Wages and salaries Utilities Facility rent Insurance Miscellaneous Total expense Net operating incomearrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning

Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning

Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning