Flaming Foliage Sky Tours is a small sightseeing tour company in New Hampshire. The firm specializes in aerial tours of the New England countryside during September and October, when the fall color is at its peak. Until recently, the company had not had an accounting department. Routine bookkeeping tasks, such as billing, had been handled by an individual who had little formal training in accounting. As the business began to grow, however, the owner recognized the need for more formal accounting procedures. Jacqueline Frost has recently been hired as the new controller, and she will have the authority to hire an assistant. During her first week on the job, Frost was given the following performance report. The report was prepared by Red Leif, the company's manager of aircraft operations, who was planning to present it to the owner the next morning. "Look at these favorable variances for fuel and so forth," Leif pointed out, as he showed the report to Frost. "My operations people are really doing a great job." Later that day, Frost looked at the performance report more carefully. She immediately realized that it was improperly prepared and would be misleading to the company's owner. Passenger revenue Less: Variable expenses: Fuel Aircraft maintenance Flight crew salaries. Selling and administrative Total variable expenses Contribution margin Less: Fixed expenses: Depreciation on aircraft Landing fees Supervisory salaries. Selling and administrative Total fixed expenses Operating income FLAMING FOLIAGE SKY TOURS Performance Report For the Month of September Formula Flexible Budget (per air mile) $ 16.00 $ 1.50 2.20 1.20 2.30 $ 7.20 $ 8.80 Per Month $ 9,800 3,800 35,000 44,000 $ 92,600 Actual (21,000 air miles) $336,000 $ 35,000 44,200 27,000 45,900 $152,100 $ 183,900 $ 9,800 5,000 33,000 49,300 $ 97,100 $ 86,800 Static Budget (25,000 air miles) $ 400,000 $ 37,500 55,000 30,000 57,500 $ 180,000 $ 220,000 $ 9,800 3,800 35,000 44,000 $ 92,600 $ 127,400 Variance $ 64,000 $ 2,500 10,800 3,000 11,600 $ 27,900 $36,100 $0 1,200 2,000 5,300 $4,500 $ 40,600 U F F F F F U UFUUU

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

part one: Prepare a columnar flexible budget for Flaming Foliage Sky Tours’ expenses, using air miles as the cost driver at the following activity levels: 21,000 air miles, 25,000 air miles, and 28,000 air miles.

part two: Prepare a revised expense variance report for September, which is based on the flexible budget prepared in part 1. (format for table in part two is attached below)

Flaming Foliage Sky Tours is a small sightseeing tour company in New Hampshire. The firm specializes in aerial tours of
the New England countryside during September and October, when the fall color is at its peak. Until recently, the company
had not had an accounting department. Routine bookkeeping tasks, such as billing, had been handled by an individual
who had little formal training in accounting. As the business began to grow, however, the owner recognized the need for
more formal accounting procedures. Jacqueline Frost has recently been hired as the new controller, and she will have the
authority to hire an assistant.
During her first week on the job, Frost was given the following performance report. The report was prepared by Red Leif,
the company's manager of aircraft operations, who was planning to present it to the owner the next morning. "Look at
these favorable variances for fuel and so forth," Leif pointed out, as he showed the report to Frost. "My operations people
are really doing a great job." Later that day, Frost looked at the performance report more carefully. She immediately
realized that it was improperly prepared and would be misleading to the company's owner.
Passenger revenue
Less: Variable expenses:
Fuel
Aircraft maintenance
Flight crew salaries
Selling and administrative
Total variable expenses
Contribution margin
Less: Fixed expenses:
Depreciation on aircraft
Landing fees
Supervisory salaries
Selling and administrative
Total fixed expenses
Operating income
FLAMING FOLIAGE SKY TOURS
Performance Report
For the Month of September
Formula Flexible
Budget (per air
mile)
$ 16.00
$ 1.50
2.20
1.20
2.30
$7.20
$ 8.80
Per Month
$ 9,800
3,800
35,000
44,000
$ 92,600
Actual (21,000
air miles)
$336,000
$ 35,000
44,200
27,000
45,900
$ 152,100
$ 183,900
$ 9,800
5,000
33,000
49,300
$ 97,100
$ 86,800
Static Budget
(25,000 air
miles)
$ 400,000
$ 37,500
55,000
30,000
57,500
$ 180,000
$ 220,000
$ 9,800
3,800
35,000
44,000
$ 92,600
$ 127,400
Variance
$ 64,000 U
$ 2,500
10,800
3,000
11,600
$ 27,900 F
$ 36,100
U
FFFFF
$0
1,200
2,000
5,300
$ 4,500
$ 40,600
UFUN
U
U
Transcribed Image Text:Flaming Foliage Sky Tours is a small sightseeing tour company in New Hampshire. The firm specializes in aerial tours of the New England countryside during September and October, when the fall color is at its peak. Until recently, the company had not had an accounting department. Routine bookkeeping tasks, such as billing, had been handled by an individual who had little formal training in accounting. As the business began to grow, however, the owner recognized the need for more formal accounting procedures. Jacqueline Frost has recently been hired as the new controller, and she will have the authority to hire an assistant. During her first week on the job, Frost was given the following performance report. The report was prepared by Red Leif, the company's manager of aircraft operations, who was planning to present it to the owner the next morning. "Look at these favorable variances for fuel and so forth," Leif pointed out, as he showed the report to Frost. "My operations people are really doing a great job." Later that day, Frost looked at the performance report more carefully. She immediately realized that it was improperly prepared and would be misleading to the company's owner. Passenger revenue Less: Variable expenses: Fuel Aircraft maintenance Flight crew salaries Selling and administrative Total variable expenses Contribution margin Less: Fixed expenses: Depreciation on aircraft Landing fees Supervisory salaries Selling and administrative Total fixed expenses Operating income FLAMING FOLIAGE SKY TOURS Performance Report For the Month of September Formula Flexible Budget (per air mile) $ 16.00 $ 1.50 2.20 1.20 2.30 $7.20 $ 8.80 Per Month $ 9,800 3,800 35,000 44,000 $ 92,600 Actual (21,000 air miles) $336,000 $ 35,000 44,200 27,000 45,900 $ 152,100 $ 183,900 $ 9,800 5,000 33,000 49,300 $ 97,100 $ 86,800 Static Budget (25,000 air miles) $ 400,000 $ 37,500 55,000 30,000 57,500 $ 180,000 $ 220,000 $ 9,800 3,800 35,000 44,000 $ 92,600 $ 127,400 Variance $ 64,000 U $ 2,500 10,800 3,000 11,600 $ 27,900 F $ 36,100 U FFFFF $0 1,200 2,000 5,300 $ 4,500 $ 40,600 UFUN U U
Prepare a revised expense variance report for September, which is based on the flexible budget prepared in part (1).
Note: Indicate the effect of each variance by selecting "Favorable" or "Unfavorable". Select "None" and enter "0" for no effect (i.e., zero
variance). Round "per air mile" answers to 2 decimal places.
Variable expenses:
Total variable expenses
Fixed expenses:
Total fixed expenses
Total expenses
Formula Flexible
Budget (per air
mile)
$
$
Actual (21,000
air miles)
1.50
2.20
1.20
2.30
7.20 $
Per Month
9,800 $
3,800
35,000
44,000
92,600
$
35,000
44,200
27,000
45,900
152,100
9,800
5,000
33,000
49,300
97,100
249,200
Flexible Budget
(21,000 air miles)
$
$
0
0
Variance
Transcribed Image Text:Prepare a revised expense variance report for September, which is based on the flexible budget prepared in part (1). Note: Indicate the effect of each variance by selecting "Favorable" or "Unfavorable". Select "None" and enter "0" for no effect (i.e., zero variance). Round "per air mile" answers to 2 decimal places. Variable expenses: Total variable expenses Fixed expenses: Total fixed expenses Total expenses Formula Flexible Budget (per air mile) $ $ Actual (21,000 air miles) 1.50 2.20 1.20 2.30 7.20 $ Per Month 9,800 $ 3,800 35,000 44,000 92,600 $ 35,000 44,200 27,000 45,900 152,100 9,800 5,000 33,000 49,300 97,100 249,200 Flexible Budget (21,000 air miles) $ $ 0 0 Variance
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Organizational Ethics
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education