Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

  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 2011 2012 2013

Sales in units (tours) 4,500 5,000 3,500

Sales Revenue ( $ 5,300 a tour) $ 23,850,000 $ 26,500,000 $ 18,550,000

Expenses

Travel costs $ 3,850,000 $ 3,700,000 $ 3,550,000

Meals and lodging 6,950,000 7,500,000 5,250,000

Guide salaries, and exp. 5,350,000 6,000,000 5,400,000

Insurance 1,600,000 1,600,000 1,600,000

Advertising 2,000,000 2,000,000 2,000,000

Net Operating Income $ 4,100,000 $ 5,700,000 $ 750,000

The budget is being written up for the 2014 season, in which demand is expected to head back up, and the expected number of tours sold is 4700. In order to estimate net operating income for 2014, 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 companys 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 companys expense totals (for all the expenses separately) at the 4700 units sales level, and use it to estimate net operating income. Finally, since the company expects to be able to sell 5,300 tours in 2015, what would you say they should estimate their operating income for that year to be, given the data?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Brinks Modern Internal Auditing A Common Body Of Knowledge

Authors: Robert R. Moeller

7th Edition

0470293039, 978-0470293034

More Books

Students also viewed these Accounting questions