Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Cheyenne Hotel in Big Sky, Montana, has accumulated records of the total electrical costs of the hotel and the number of occupancy-days over the

The Cheyenne Hotel in Big Sky, Montana, has accumulated records of the total electrical costs of the hotel and the number of occupancy-days over the last year. An occupancy-day represents a room rented for one day. The hotel's business is highly seasonal, with peaks occurring during the ski season and in the summer. Occupancy Days Electrical Costs Month January 3,400 $ 10,234 February 3,280 $ 10,052 March 4,370 $ 11,605 April 1,950 $ 6,825 May 680 $ 2,380 June 1,960 $ 6,860 July 4,040 $ 11,060 August 4,080 $ 11,100 September 2,240 $ 7,602 October 1,030 $ 3,605 November 1,460 $ 4,634 December 2,700 $ 8,974 Required: 1. Using the high-low method, estimate the fixed cost of electricity per month and the variable cost of electricity per occupancy-day. (Do not round your intermediate calculations. Round your Variable cost answer to 2 decimal places and Fixed cost element answer to nearest whole dollar amount.) Variable cost of electricity Fixed cost of electricity per occupancy-day per month Miller Company's contribution format income statement for the most recent month is shown below: Sales (42,000 units). Variable expenses Contribution margin Fixed expenses Total $420,000 Per Unit $ 10.00 294,000 126,000 7.00 $ 3.00 42,000 Net operating income Required: (Consider each case independently): $ 84,000 1. What is the revised net operating income if unit sales increase by 15% ? 2. What is the revised net operating income if the selling price decreases by $1.40 per unit and the number of units sold increases by 20%? 3. What is the revised net operating income if the selling price increases by $1.40 per unit, fixed expenses increase by $9,000, and the number of units sold decreases by 7% ? 4. What is the revised net operating income if the selling price per unit increases by 20%, variable expenses increase by 10 cents per unit, and the number of units sold decreases by 14%? 1. Net operating income $ 104,160 2. Net operating income 3. Net operating income 4. Net operating income

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

Understanding Your Financial Calculator

Authors: Kaplan Financial

1st Edition

1419559818, 978-1419559815

More Books

Students also viewed these Accounting questions

Question

KEY QUESTION Refer to the table in question

Answered: 1 week ago