Required information PR 11-45 (Algo) Preparing and Using a Columnar Flexible Budget; Tour Company; Ethical Issues...
Fantastic news! We've Found the answer you've been seeking!
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/66478e619bd8b_53766478e6111f5d.jpg)
Transcribed Image Text:
Required information PR 11-45 (Algo) Preparing and Using a Columnar Flexible Budget; Tour Company; Ethical Issues (LO 11-1, 11-2, 11-6) 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 FLAMING FOLIAGE SKY TOURS Performance Report For the Month of September Formula Flexible Budget (per air mile) $ 10.00 $ 1.30 2.10 Per Month Actual (50,000 air miles) $ 500,000 $ 68,600 102,900 67,000 117,500 Static Budget (55,000 air miles) $550,000 $ 71,500 115,500 71,500 132,000 Variance $ 50,000 U $ 2,900 F 12,600 F 4,500 F 14,500 F $ 34,500 1.30 2.40 $ 7.10 $ 356,000 $ 2.90 $ 144,000 $ 390,500 $ 159,500 F $ 15,500 U $ 9,900 $ 9,900 5,200 $ 0 1,300 U Supervisory salaries 36,000 Selling and administrative 45,000 33,500 50,400 36,000 2,500 F 45,000 5,400 U Total fixed expenses $ 94,800 $ 99,000 $ 94,800 $ 4,200 U Operating income $ 45,000 $ 64,700 $ 19,700 U $ 9,900 3,900 3,900 PR 11-45 (Algo) Part 1: Prepare a columnar flexible budget Required: 1. Prepare a columnar flexible budget for Flaming Foliage Sky Tours' expenses, using air miles as the cost driver at the following activity levels: 50,000 air miles, 55,000 air miles, and 58,000 air miles. 2. In spite of several favorable expense variances shown on the report above, the company's September operating income was only about two-thirds of the expected level. Identify some of the possible reasons. 4. Prepare a revised expense variance report for September, which is based on the flexible budget prepared in part (1). 5. Jacqueline Frost presented the revised expense report to Leif along with the memo explaining why the original performance report was misleading. Leif did not take it well. He complained of Frost's "interference" and pointed out that the company had been doing just fine without her. "I'm taking my report to the owner tomorrow," Leif insisted. "Yours just makes us look bad." What are Frost's ethical obligations in this matter? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 4 Required 5 Prepare a columnar flexible budget for Flaming Foliage Sky Tours' expenses, using air miles as the cost driver at the following activity levels: 50,000 air miles, 55,000 air miles, and 58,000 air miles. Variable expenses: Total variable expenses Fixed expenses: Total fixed expenses Total expenses 50,000 Activity Level (Air Miles) 55,000 58,000 < Required 1 Required 2 > Required information PR 11-45 (Algo) Preparing and Using a Columnar Flexible Budget; Tour Company; Ethical Issues (LO 11-1, 11-2, 11-6) 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 FLAMING FOLIAGE SKY TOURS Performance Report For the Month of September Formula Flexible Budget (per air mile) $ 10.00 $ 1.30 2.10 Per Month Actual (50,000 air miles) $ 500,000 $ 68,600 102,900 67,000 117,500 Static Budget (55,000 air miles) $550,000 $ 71,500 115,500 71,500 132,000 Variance $ 50,000 U $ 2,900 F 12,600 F 4,500 F 14,500 F $ 34,500 1.30 2.40 $ 7.10 $ 356,000 $ 2.90 $ 144,000 $ 390,500 $ 159,500 F $ 15,500 U $ 9,900 $ 9,900 5,200 $ 0 1,300 U Supervisory salaries 36,000 Selling and administrative 45,000 33,500 50,400 36,000 2,500 F 45,000 5,400 U Total fixed expenses $ 94,800 $ 99,000 $ 94,800 $ 4,200 U Operating income $ 45,000 $ 64,700 $ 19,700 U $ 9,900 3,900 3,900 PR 11-45 (Algo) Part 1: Prepare a columnar flexible budget Required: 1. Prepare a columnar flexible budget for Flaming Foliage Sky Tours' expenses, using air miles as the cost driver at the following activity levels: 50,000 air miles, 55,000 air miles, and 58,000 air miles. 2. In spite of several favorable expense variances shown on the report above, the company's September operating income was only about two-thirds of the expected level. Identify some of the possible reasons. 4. Prepare a revised expense variance report for September, which is based on the flexible budget prepared in part (1). 5. Jacqueline Frost presented the revised expense report to Leif along with the memo explaining why the original performance report was misleading. Leif did not take it well. He complained of Frost's "interference" and pointed out that the company had been doing just fine without her. "I'm taking my report to the owner tomorrow," Leif insisted. "Yours just makes us look bad." What are Frost's ethical obligations in this matter? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 4 Required 5 Prepare a columnar flexible budget for Flaming Foliage Sky Tours' expenses, using air miles as the cost driver at the following activity levels: 50,000 air miles, 55,000 air miles, and 58,000 air miles. Variable expenses: Total variable expenses Fixed expenses: Total fixed expenses Total expenses 50,000 Activity Level (Air Miles) 55,000 58,000 < Required 1 Required 2 >
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
The next 7 questions refer to the following data set. Age of residents in a neighbourhood 26 45 27 50 40 52 12 28 48 52 14 20 32 9 36 10 36 51 42 1 30 21 40 37 13 35 57 47 42 53 What is the...
-
Answer the following questions regarding the effects of indirect intervention. Suppose that the government of Chile reduces one if its key interest rates. The values of several other Latin American...
-
Consider the items below. Specifically, you must address the following rubric criteria: Identify a creator from the twentieth or twenty-first century who you think made an important contribution to...
-
A credit card contains 16 digits. It also contains a month and year of expiration. Suppose there are one million users of a credit card with unique card numbers. A hacker randomly selects a 16 digit...
-
Number in order the following steps in the accounting cycle. a. Prepare a trial balance. b. Post journal entries to the accounts in the ledger. c. Journalize and post the adjusting entries from the...
-
Let us introduce Athena, a medium-sized consultancy company, employing around 100 consultants. Athena delivers custom-made software applications for their customers, pri- marily knowledge management...
-
Rewrite the following percentages in decimal form: 1. \(14 \%\) 2. \(7 \%\)
-
Part proliferation: role for activity-based costing An article in the Wall Street Journal by Neal Templin and Joseph B. White (June 23, 1993) reported on the major changes occurring at General...
-
A new machine tool cost $ 15,000 and has a $5000 salvage value at the end of 5 yrs. The interest rate is 10%. The annual cost of capital recovery is the annual depreciation charge (use straight-line...
-
Find the exact arc length of the curve over the stated interval. 69. x = e"(sin t+ cos t), y = e"(sin t - cos 1) (-1
-
Explain three reasons why corporate risk is important even if a firm's stockholders are well diversified.
-
High Growth Thinking Exercise Discuss cryptocurrency and blockchain technology and how they might impact the economy. Discuss some of the ethical considerations associated with AI and Automation and...
-
18.5 FL The Orphane Company buys raw materials from an outside supplier at $40 per unit; total annual needs are 6,400 units. The material is used evenly throughout the year. Order costs are $100 per...
-
Madison has decided to lease a new car. The price of the car is $28,675. Determine her monthly lease payment if she obtains a 3 year lease at 2.35% interest. The residual value of the car is $19,500
-
What steps are involved in the process of evaluating marketing performance? Outline control and evaluation for steps for the key performance indicators of content marketing, website enhancement, and...
-
In preparation for retirement and to provide an emergency fund, Simran sold a number of rare coins directly to a dealer this year for $14,200. The adjusted cost base (ACB) on the coins was $4,600....
-
Calculate the change in entropy when 100 kJ of energy is transferred reversibly and isothermally as heat to a large block of copper at (i) 0 C, (ii) 50 C.
-
Question: To ensure that its employees did not use illegal drugs in or outside of the workplace, Rain Co. required all employees to take a lie detector test. Moreover, managers began to screen the...
-
Question: Pippa became pregnant the week she started work as an administrator at Awesome University. Her supervisor was so annoyed at her that he would not consider her for promotion to another job...
-
Question: When Theodore Staats went to his company's "Council of Honor Con- vention," he was accompanied by a woman who was not his wife although he told everyone she was. The company fired him....
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App