1. Merry, the Knight is a bookstore specializing in J. R. R. Tolkien and other fantasy...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Merry, the Knight is a bookstore specializing in J. R. R. Tolkien and other fantasy literature. Recently, the bookstore has taken on a side business in New Zealand package tours of the places where the filming for the movie trilogy took place. The last three years results follow: Year Sales in units (tours) 2019 5,000 2020 3,000 2021 6,000 Sales Revenue ($ 11,000 a tour) $ 55,000,000 $ 33,000,000 $ 66,000,000 Expenses Travel costs $ 7,350,000 $ 7,000,000 $ 11,500,000 Meals and lodging 13,500,000 7,500,000 15,000,000 Guide salaries, and exp. 5,000,000 5,250,000 9,000,000 Insurance 7,500,000 7,500,000 7,500,000 Advertising 4,750,000 4,750,000 4,750,000 Net Operating Income $ 16,900,000 $ 1,000,000 $18,250,000 The budget is being written up for the 2022 season, in which demand is expected to stabilize, and the expected number of tours sold is 5800. In order to estimate net operating income for 2022, an analysis of the costs of doing business so far needs to be done. Assuming that the last three years costs can be used (they are typical and carefully compiled), identify each of the company's expenses as either a pure variable, a mixed, or a fixed expense. Using the hi-lo method, separate each of the mixed expenses into fixed and variable elements. Redo the company's expense totals (for all the expenses separately) at the 5800 units sales level, and use it to estimate net operating income. Finally, since the company expects to be able to sell 6,500 tours in 2023, what would you say they should estimate their operating income for that year to be, given the data? A 1 Year 2 Sales in Units (tours) 3 4 Sales Revenue ($11,000 a tour) Expenses 5 Travel costs B C D E F G H J 2019 2020 2021 Income Statement $5,000 $3,000 $6,000 2022 2023 $55,000,000 $33,000,000 $66,000,000 Tours $5,800 $6,500 Sales $63,800,000 $177,067,855 $7,350,000 $7,000,000 $11,500,000 Travel cost 8 Meals and lodging 7 Guide salaries, and exp. $13,500,000 $5,000,000 8 Insurance 9 Advertising $7,500,000 $15,000,000 $5,250,000 $9,000,000 $7,500,000 $7,500,000 $7,500,000 $4,750,000 $4,750,000 $4,750,000 Meals $11,200,000 $12,250,000 $14,500,000 $16,250,000 Guided Salaries Insurance Advertising $8,750,000 $9,625,000 $7,500,000 $7,500,000 $4,750,000 $4,750,000 10 Net Operating Income $17,100,000 $126,692,855 11 Net Operating Income $16,900,000 $1,000,000 $18,250,000 12 13 14 2019 2020 2021 15 Travel cost $1,470 $2,333.33 $1,916.67 Mixed 16 Meals and lodging $2,700 $2,500 $2,500 Pure Variable 17 Guide salaries, and exp. $1,000 $1,750 18 Insurance $7,500,000 $7,500,000 $1,500 $7,500,000 Mixed Fixed 19 Advertising $4,750,000 $4,750,000 $4,750,000 Fixed 20 21 Low 22 Hi $3,000 $6,000 23 24 Travel costs = change in variable costs/change in units 25 1500 per unit 26 Total cost = fixed cost + variable cost 27 $11,500,000 fixed cost + 1500 (6000) 28 Fixed costs = $2,500,000 Guide salaries, and exp. 1250 per tour Total cost = fixed cost + variable cost $9,000,000 fixed cost +$1,250 (6000) Fixed costs $1,500,000 B D E F G H J 1 Year 2019 2020 2021 Income Statement 2 Sales in Units (tours) $5,000 3 Sales Revenue ($11,000 a tour) $55,000,000 $3,000 $33,000,000 $6,000 2022 2023 $66,000,000 4 Expenses Tours Sales $5,800 $6,500 5 Travel costs $7,350,000 8 Meals and lodging $13,500,000 7 Guide salaries, and exp. 8 Insurance 9 Advertising $5,000,000 $7,500,000 $7,500,000 $4,750,000 $4,750,000 $7,000,000 $11,500,000 $7,500,000 $15,000,000 $5,250,000 $9,000,000 $7,500,000 $4,750,000 Travel cost |=(C3/C2)*13 =(C3/C1)*J3 =2500000+(A25=2500000+(A25 Meals =E16*13 =E16*J3 Guided Salaries =1500000+(E25=1500000+(E25 Insurance $7,500,000 $7,500,000 Advertising $4,750,000 $4,750,000 10 Net Operating Income -14-15-16-17-18-19-J4-J5-J6-J7-J8 11 Net Operating Income $16,900,000 $1,000,000 $18,250,000 12 13 14 2019 2020 2021 15 Travel cost =C5/C2 =D5/D2 |=E5/E2 Mixed 16 Meals and lodging |=C6/C2 =D6/D2 |=E6/E2 Pure Variable 17 Guide salaries, and exp. =C7/C2 =D7/D2 =E7/E2 Mixed 18 Insurance =C8 =D8 |=E8 Fixed 19 Advertising =C9 =D9 =E9 Fixed 20 21 Low =D2 22 Hi =E2 23 24 25 = (E5-D5)/(E2-D per unit 26 27 28 Fixed costs Travel costs = change in variable costs/change in units Total cost fixed cost + variable cost = $11,500,000 fixed cost + 1500 (6000) $2,500,000 Guide salaries, and exp. =(E7-D7)/(E2-D2 per tour Total cost fixed cost + variable cost $9,000,000 fixed cost +$1,250 (6000) Fixed costs $1,500,000 1. Merry, the Knight is a bookstore specializing in J. R. R. Tolkien and other fantasy literature. Recently, the bookstore has taken on a side business in New Zealand package tours of the places where the filming for the movie trilogy took place. The last three years results follow: Year Sales in units (tours) 2019 5,000 2020 3,000 2021 6,000 Sales Revenue ($ 11,000 a tour) $ 55,000,000 $ 33,000,000 $ 66,000,000 Expenses Travel costs $ 7,350,000 $ 7,000,000 $ 11,500,000 Meals and lodging 13,500,000 7,500,000 15,000,000 Guide salaries, and exp. 5,000,000 5,250,000 9,000,000 Insurance 7,500,000 7,500,000 7,500,000 Advertising 4,750,000 4,750,000 4,750,000 Net Operating Income $ 16,900,000 $ 1,000,000 $18,250,000 The budget is being written up for the 2022 season, in which demand is expected to stabilize, and the expected number of tours sold is 5800. In order to estimate net operating income for 2022, an analysis of the costs of doing business so far needs to be done. Assuming that the last three years costs can be used (they are typical and carefully compiled), identify each of the company's expenses as either a pure variable, a mixed, or a fixed expense. Using the hi-lo method, separate each of the mixed expenses into fixed and variable elements. Redo the company's expense totals (for all the expenses separately) at the 5800 units sales level, and use it to estimate net operating income. Finally, since the company expects to be able to sell 6,500 tours in 2023, what would you say they should estimate their operating income for that year to be, given the data? A 1 Year 2 Sales in Units (tours) 3 4 Sales Revenue ($11,000 a tour) Expenses 5 Travel costs B C D E F G H J 2019 2020 2021 Income Statement $5,000 $3,000 $6,000 2022 2023 $55,000,000 $33,000,000 $66,000,000 Tours $5,800 $6,500 Sales $63,800,000 $177,067,855 $7,350,000 $7,000,000 $11,500,000 Travel cost 8 Meals and lodging 7 Guide salaries, and exp. $13,500,000 $5,000,000 8 Insurance 9 Advertising $7,500,000 $15,000,000 $5,250,000 $9,000,000 $7,500,000 $7,500,000 $7,500,000 $4,750,000 $4,750,000 $4,750,000 Meals $11,200,000 $12,250,000 $14,500,000 $16,250,000 Guided Salaries Insurance Advertising $8,750,000 $9,625,000 $7,500,000 $7,500,000 $4,750,000 $4,750,000 10 Net Operating Income $17,100,000 $126,692,855 11 Net Operating Income $16,900,000 $1,000,000 $18,250,000 12 13 14 2019 2020 2021 15 Travel cost $1,470 $2,333.33 $1,916.67 Mixed 16 Meals and lodging $2,700 $2,500 $2,500 Pure Variable 17 Guide salaries, and exp. $1,000 $1,750 18 Insurance $7,500,000 $7,500,000 $1,500 $7,500,000 Mixed Fixed 19 Advertising $4,750,000 $4,750,000 $4,750,000 Fixed 20 21 Low 22 Hi $3,000 $6,000 23 24 Travel costs = change in variable costs/change in units 25 1500 per unit 26 Total cost = fixed cost + variable cost 27 $11,500,000 fixed cost + 1500 (6000) 28 Fixed costs = $2,500,000 Guide salaries, and exp. 1250 per tour Total cost = fixed cost + variable cost $9,000,000 fixed cost +$1,250 (6000) Fixed costs $1,500,000 B D E F G H J 1 Year 2019 2020 2021 Income Statement 2 Sales in Units (tours) $5,000 3 Sales Revenue ($11,000 a tour) $55,000,000 $3,000 $33,000,000 $6,000 2022 2023 $66,000,000 4 Expenses Tours Sales $5,800 $6,500 5 Travel costs $7,350,000 8 Meals and lodging $13,500,000 7 Guide salaries, and exp. 8 Insurance 9 Advertising $5,000,000 $7,500,000 $7,500,000 $4,750,000 $4,750,000 $7,000,000 $11,500,000 $7,500,000 $15,000,000 $5,250,000 $9,000,000 $7,500,000 $4,750,000 Travel cost |=(C3/C2)*13 =(C3/C1)*J3 =2500000+(A25=2500000+(A25 Meals =E16*13 =E16*J3 Guided Salaries =1500000+(E25=1500000+(E25 Insurance $7,500,000 $7,500,000 Advertising $4,750,000 $4,750,000 10 Net Operating Income -14-15-16-17-18-19-J4-J5-J6-J7-J8 11 Net Operating Income $16,900,000 $1,000,000 $18,250,000 12 13 14 2019 2020 2021 15 Travel cost =C5/C2 =D5/D2 |=E5/E2 Mixed 16 Meals and lodging |=C6/C2 =D6/D2 |=E6/E2 Pure Variable 17 Guide salaries, and exp. =C7/C2 =D7/D2 =E7/E2 Mixed 18 Insurance =C8 =D8 |=E8 Fixed 19 Advertising =C9 =D9 =E9 Fixed 20 21 Low =D2 22 Hi =E2 23 24 25 = (E5-D5)/(E2-D per unit 26 27 28 Fixed costs Travel costs = change in variable costs/change in units Total cost fixed cost + variable cost = $11,500,000 fixed cost + 1500 (6000) $2,500,000 Guide salaries, and exp. =(E7-D7)/(E2-D2 per tour Total cost fixed cost + variable cost $9,000,000 fixed cost +$1,250 (6000) Fixed costs $1,500,000
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
This assignment requires you to complete the 2022 tax reporting for a fictional woman named Anna Smith. Question 1 T1 - step 4 - line 66 This is Anna's taxable income Answer: Question 2 T1 - step...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Derek borrows $32,311.00 to buy a car. He will make monthly payments for 6 years. The car loan has an interest rate of 6.49%. After a 13.00 months Derek decides to pay off his car loan. How much must...
-
Daniels Inc., a skate board manufacturer, needs help planning production for next year. Demand for skateboards follows a seasonal pattern, as shown here. Given the following costs and demand...
-
A 1 . 0 kg mass is located at the origin. A second, 1 . 0 kg mass is located at position ( - 8 , 3 ) m . They both experience equal and opposite gravitational forces towards each other. The magnitude...
-
Number of classes: 6 Data set: Ages of the U.S. presidents at Inauguration Construct a frequency distribution and a frequency polygon for the data set using the indicated number of classes. Describe...
-
On January 1, 2018, Marshall Company acquired 100 percent of the outstanding common stock of Tucker Company. To acquire these shares, Marshall issued $200,000 in long-term liabilities and 20,000...
-
Imagine that you oversee quality control for a production line in a candy company. The production line is responsible for filling 12 ounces of candy in packages labeled with weight of 12 oz. Package...
-
Assume that 12 jurors are selected from a population in which 80% of the people are Mexican-Americans. The random variable x is the number of Mexican-Americans on the jury. X 0 1 2 3 4 5 6 7 8 9 10...
-
Which of the two assumptions: uniform pressure and uniform wear would you like to use in designing friction clutch? Explain the reasons.
-
Describe the historical trend from non-enforceability to enforceability of premarital agreements. In this context, indicate the significance of the Posner case.
-
Define the following mechanical properties: ( i) Strength, (ii) Hardness, (iii) Ductility, and (iv) Toughness.
-
Identify the primary purposes of an initial client interview.
-
Define the following terms: (i) Toughness, (ii) Hardness, (iii) Normalizing, and (iv) Case hardening.
-
Consider the following B- decay chain with the half-lives indicated. 210 Pb (22y) -> 210 Bi (5d) -> 210 Po A sample contains 30 Mbq of 210 Pb and 15 MBq of 210 Bi at time zero. (a) Calculate...
-
Information graphics, also called infographics, are wildly popular, especially in online environments. Why do you think infographics continue to receive so much attention? How could infographics be...
-
Explain the difference between isotropic total cross-section and the transport crosssection as in Eq. (5.49). Why transport cross-section is not used in the transport theory? Data From Equation...
-
Following up on question number 3, assume the school conducts a manifestation determination meeting. Tim attends the meeting with his parents. At the meeting, Tim tells the team that smoking helps...
-
Which of the following is not a characteristic of a defined benefit plan? A. A guaranteed retirement benefit. B. Risk of preretirement inflation assumed by employer. C. Benefits based upon the...
Study smarter with the SolutionInn App