The Cheyenne Hotel in Big Sky, Montana, has accumulated records of the total electrical costs of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. Electrical Costs $ 1,620 Month January Occupancy-Days 540 February 3,810 $ 8,352 March 4,100 $ 8,736 April 1,730 $ 5,190 May 3,520 $ 7,968 June 1,320 $ 3,960 July 3,420 $ 7,668 August 4,120 $ 8,780 September 1,610 $ 4,830 October 830 $ 2,490 November December 1,420 $ 4,260 2,320 $ 6,960 Required: 1. Using the high-low method, estimate the fixed cost of electricity per month and the variable cost of electricity per occupancy-day. Note: 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 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. Electrical Costs $ 1,620 Month January Occupancy-Days 540 February 3,810 $ 8,352 March 4,100 $ 8,736 April 1,730 $ 5,190 May 3,520 $ 7,968 June 1,320 $ 3,960 July 3,420 $ 7,668 August 4,120 $ 8,780 September 1,610 $ 4,830 October 830 $ 2,490 November December 1,420 $ 4,260 2,320 $ 6,960 Required: 1. Using the high-low method, estimate the fixed cost of electricity per month and the variable cost of electricity per occupancy-day. Note: 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
Expert Answer:
Answer rating: 100% (QA)
To estimate the fixed cost of electricity per month and the variable cost of electricity per occupan... View the full answer
Related Book For
Managerial Accounting
ISBN: 978-1259307416
16th edition
Authors: Ray Garrison, Eric Noreen, Peter Brewer
Posted Date:
Students also viewed these accounting questions
-
Investigate the role of big data analytics in orchestrating operations management related activities in efficient and effective transformation of raw materials into finished goods Prompt: An integral...
-
4-27. Two identical 2.5-MVA, 1200-V 0.8-PF-lagging, 60-Hz, three-phase synchronous generators are connected in parallel to supply a load. The prime movers of the two generators happen to have...
-
Threat Management and Cybersecurity Resources 1. Identify and discuss the primary differences between threats, vulnerabilities, likelihood, and risk. Can all risks be countered? 2.Identify the rules...
-
You are the manager of a firm that produces products X and Y at zero cost. You know that different types of consumers value your two products differently, but you are unable to identify these...
-
What is the value of server farms and virtualization to any large organization?
-
Water at atmospheric pressure is boiling in a pot with a flat copper bottom on an electric range which maintains the surface temperature at 115?C. Calculate the boiling heat transfer...
-
Bank Reconciliation Romain Corporation received the following bank statement for the month of October: The cash records of Romain Corporation provide the following information: The items on the bank...
-
Brew Bottle Company (BBC) is in the process of planning a more advanced computer-based information system. Slavish & Moore, LLP, BBCs consulting firm, have recently been provided with an overview of...
-
Suppose the Coffee Bean has a new shop in a Cambridge village shopping center that sells high - end teas and coffees. Further, suppose it has added smoothic drinks to its product line. Below are the...
-
Let Cr(t) = The flux integral shares the properties of the vector line integral. (x(t), y(t)) for a t b, let F(x, y) = (f(x,y), g(x, y)), and let G(x, y) = (g(x, y), f(x, y)). = (a) Prove or...
-
The company has developed a target budget for selling 50,000 units in the upcoming year. The estimated budget is to sell 40,000 golf shirts and 10,000 pairs of shoes. Therefore the sales mix is 4...
-
Question 5 Lucy Manufacturing uses the FIFO method of process costing to account for inventory. Normal spoilage is 10% of goods units transferred out. Summary data for the current period are: Work in...
-
(1)Snow Fun Inc., a manufacturer of skis and snowboards, is 30% debt financed. Its current equity beta is 1.1 and its debt beta is 0. The company's cost of debt is 6%, and its tax rate is 35%. The...
-
If X is a continuous random variable on [A, B], then we could build up a data set by repeatedly running the random event associated to X. A data set is just a collection of numbers so we could...
-
Assume that you drink a $4 latte a day. Over the month the cost is $80 (= $4 5 4). Assume that you choose to forgo your daily latte and instead invest this amount at the end of each month in an...
-
how do you get the debt below the enterprise value?. Discounted Cash Flow valuation See our computation on the Excel spreadsheet, "DCF VALUATION". We use the formula FCF = EBIT - Income Tax ...
-
Digital Fruit is financed solely by common stock and has outstanding 25 million shares with a market price of $10 a share. It now announces that it intends to issue $160 million of debt and to use...
-
Continuation of SI 0-3: inventory, purchases, and cost of goods sold (Learning Objective 2) In SI0-3, Grippers expects cost of goods sold to average 65% of sales revenue and the company expects to...
-
Sales Budget (Learning Objective 2) In a series of Short Exercises, you will prepare parts of the master budget for Grippers, which sells its rock-climbing shoes worldwide. We will concentrate on...
-
Revise inventory, purchases, and cost of goods sold budget (Learning Objective 4) Refer to the original Whitewater Sporting Goods Data Set item 5. Suppose cost of goods sold averages 75% of sales...
Study smarter with the SolutionInn App