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
please show ALL work! thank you sm!
arrow_forward
Do not give image format
arrow_forward
Hansaben
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
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
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
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
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
Bugos Corporation is a sérvice company that measures its output by the number of
customers served. The company has provided the following fixed and variable cost
estimates that it uses for budgeting purposes.
Variable
Fixed Element Element per
per Month
Customer
Served
Revenue
4,200
Employee salaries and wages
$ 58,800
006
Travel expenses
Other expenses
$ 33,300
When the company prepared its pianning budget at the beginning of March, it assumed
that 40 customers would have been served.
The amount shown for "Employee salaries and wages" in the planning budget for March would have
been closest to:
O $91,200
MacBook Air
DD
F10
08
F5
%24
%24
%24
%24
arrow_forward
6. Question Content Area
Administrative Expense Budget
Green Earth Landscaping Company provides monthly and weekly landscaping and maintenance services to residential customers in the tri-city area. Green Earth has no variable administrative expense. Fixed administrative expenses for June, July, and August include:
Salaries
$10,000
Insurance
2,100
Depreciation
3,900
Accounting services
800
Required:
Question Content Area
1. Construct an administrative expense budget for Green Earth Landscaping Company for the three summer months. Show total amounts by month and in total for the three-month period.
Green Earth Landscaping CompanyAdministrative Expense BudgetFor the Summer Months
June
July
August
Total
Salaries
$fill in the blank 532c4bfc1f8bfa8_1
$fill in the blank 532c4bfc1f8bfa8_2
$fill in the blank 532c4bfc1f8bfa8_3
$fill in the blank 532c4bfc1f8bfa8_4
Insurance
fill in the blank 532c4bfc1f8bfa8_5
fill in the blank 532c4bfc1f8bfa8_6
fill in…
arrow_forward
es
w
Exercise 9-1 (Algo) Prepare a Flexible Budget [LO9-1]
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)
Revenue ($390.00q)
Expenses:
Wages and salaries ($11,200 + $126.00q)
Supplies ($4.00q)
Equipment rental ($2,300 + $22.00q)
Insurance ($4,200)
Miscellaneous ($500+ $1.46q)
Total expense
Net operating income
During May, the company's actual activity was 340 diving-hours.
350
$ 136,500
Puget Sound Divers
Flexible Budget
For the Month Ended May 31
arrow_forward
Lavage Rapide is a Canadian company that owns and operates a large automatic car wash facility near Montreal. The following table
provides estimates concerning the company's costs:
Fixed
Cost per
Cost per
Car Washed
Month
Cleaning supplies
Electricity
Maintenance
$ 0.60
$ 0.06
$ 0.10
$ 0.20
$ 1,000
Wages and salaries
Depreciation
$ 4,700
$ 8,100
$ 1,800
$ 1,500
Book
Rent
Hint
Administrative expenses
$ 0.04
For example, electricity costs should be $1,000 per month plus $0.06 per car washed. The company actually washed 8,300 cars in
August and collected an average of $6.90 per car washed.
Required:
Prepare the company's flexible budget for August.
Lavage Rapide
Flexible Budget
For the Month Ended August 31
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_forwardplease show ALL work! thank you sm!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_forwardNonearrow_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_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