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.| Month | Occupancy-Days | Electrical Costs ||-------------|----------------|------------------|| January | 2,640 | $13,200 || February | 2,860 | $14,300 || March | 980 | $4,900 || April | 2,420 | $12,100 || May | 2,090 | $10,450 || June | 4,470 | $18,860 || July | 4,020 | $17,160 || August | 3,940 | $16,760 || September | 1,630 | $8,150 || October | 1,090 | $5,450 || November | 1,390 | $6,950 || December | 2,910 | $14,550 |The table portrays the correlation between the number of occupancy-days and the corresponding electrical costs for each month. The data shows increased occupancy and electrical costs during peak seasons, reflecting the hotel's seasonal business pattern. **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 | per occupancy-day | | Fixed cost of electricity | per month |

Variable cost is the cost that changes with change in the activity of cost driver used. The variable…

Answered: The Cheyenne Hotel in Big Sky, Montana,…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Munoz Boat Company makes inexpensive aluminum fishing boats. Production is seasonal, with considerable activity occurring in the spring and summer. Sales and production tend to decline in the fall and winter months. During year 2, the high point in activity occurred in June when it produced 207 boats at a total cost of $153,880. The low point in production occurred in January when it produced 33 boats at a total cost of $46,000. Required a. Use the high-low method to estimate the amount of fixed cost incurred each month by Munoz Boat Company. b. Determine the total estimated cost if 140 boats are made. a. Fixed cost (b. Total estimated cost
Green Earth Landscaping Company provides monthly and weekly landscaping and maintenance services to residential customers in the tri-city area. Green Earth has no variable administrative expense. Fixed administrative expenses for June, July, and August include: Salaries $9,300 Insurance 2,000 Depreciation 3,500 Accounting services 900 Required: Question Content Area 1. Construct an administrative expense budget for Green Earth Landscaping Company for the three summer months. Show total amounts by month and in total for the three-month period. Green Earth Landscaping CompanyAdministrative Expense BudgetFor the Summer Months June July August Total Salaries $fill in the blank f20bfe024036faf_1 $fill in the blank f20bfe024036faf_2 $fill in the blank f20bfe024036faf_3 $fill in the blank f20bfe024036faf_4 Insurance fill in the blank f20bfe024036faf_5 fill in the blank f20bfe024036faf_6 fill in the blank f20bfe024036faf_7 fill in the blank…
Green Earth Landscaping Company provides monthly and weekly landscaping and maintenance services to residential customers in the tri-city area. Green Earth has no variable administrative expense. Fixed administrative expenses for June, July, and August include: Salaries $9,400 Insurance 2,250 Depreciation 4,000 Accounting services 600 Required: Question Content Area 1. Construct an administrative expense budget for Green Earth Landscaping Company for the three summer months. Show total amounts by month and in total for the three-month period. Green Earth Landscaping CompanyAdministrative Expense BudgetFor the Summer Months June July August Total Salaries $___ $___ $___ $___ Insurance ____ ____ ____ ____ Depreciation ____ ____ ____ ____ Accounting services ____ ____ ____ ____ Total administrative expense $_____ $____ $____ $____ Question Content Area 2. What if Green Earth Landscaping Company's insurance rates increased at the beginning…
Harrison, Inc. is preparing their budget for the upcoming year and requires a breakdown of the costs of power used in its factory into the fixed and variable components. They have determined the number of direct labor hours worked affects the cost of power. The following data on the cost of power used and direct labor hours worked are available for the last six months of this year: Month July August September October High-Low Method November December Total Cost of Power $ 14,850 15,400 16,370 19,800 17,600 18,500 $102.520 Direct Labor Hours 3,000 2,050 2,900 3,650 2,670 2,650 16.920 1. Assuming that Harrison uses the high-low method of analysis, calculate the cost function to be used to estimate the power costs. 2. They have determined that production needs will require 8,467 direct labor hours. Using the cost function calculated above, what is the estimated cost of power?
Vernon Boat Company makes inexpensive aluminum fishing boats. Production is seasonal, with considerable activity occurring in the spring and summer. Sales and production tend to decline in the fall and winter months. During year 2, the high point in activity occurred in June when it produced 205 boats at a total cost of $163,890. The low point in production occurred in January when it produced 38 boats at a total cost of $52,000. Required a. Use the high-low method to estimate the amount of fixed cost incurred each month by Vernon Boat Company. b. Determine the total estimated cost if 110 boats are made. a. Fixed cost b. Total estimated cost
The Department of Roads for a large Canadian city has several depots throughout the city where they store rock- salt. The rock-salt is used during the winter. The fiscal year starts on April 1 and ends on the following March 31. At April 1 2021, they had an inventory of 2,000 tons of rock-salt worth $800,000. The following are transactions occurred during the fiscal year:< Summer and Fall 2021: Purchased 68,000 tons at an average price of $300/ton< Months of December 2021 and January 2022: used 62,000 tons February 1 2022: purchased 40,000 tons at $505/ton Month of February 2022: used 20,000 tons March 12 2022: helped a neighbouring city that had run out of salt by giving them 20,000 tons in exchange for equipment worth $12.2 million Required: 1. Calculate the value of the rock salt in the remaining inventory at March 31 2022 based on: FIFO • Weighted average - Periodic 2. Which method of inventory valuation do you recommend they use? Explain your response.<
Sunrise Suites and Nationwide Inns operate competing hotel chains across the region. Hotel capacity information for both hotels is as follows: Number of Hotels Average Number of Rooms per Hotel Sunrise Suites 120 90 Nationwide Inns 150 76 Information on the number of guests for each hotel and the average length of visit for June were as follows: Number of Guests Average Length of Visit (in Nights) Sunrise Suites 183,600 1.5 Nationwide Inns 228,000 1.2 a. Determine the guest nights for each hotel in June. Guest Nights Sunrise Suites fill in the blank 1 Nationwide Inns fill in the blank 2 b. Determine the room nights for each hotel in June. Room Nights Sunrise Suites fill in the blank 3 Nationwide Inns fill in the blank 4 c. Determine the occupancy rate of each hotel in June. Occupancy Rate Sunrise Suites fill in the blank 5 % Nationwide Inns fill…
Production workers for Adams Manufacturing Company provided 5,000 hours of labor in January and 2,100 hours in February. The company, whose operation is labor intensive, expects to use 48,000 hours of labor during the year. Adams paid a $100,800 annual premium on July 1 of the prior year for an insurance policy that covers the manufacturing facility for the following 12 months. Required Based on this information, how much of the insurance cost should be allocated to the products made in January and to those made in February? Note: Do not round intermediate calculations. Month January February Allocated Cost
The Bella Vista Oceano Barca Company manufactures disposable two-person rubber rafts for use by tourists in exploring the area coast line. During the current month, direct materials costing $1,500,000 were put into production. Direct labor of $500,000 was incurred, and overhead equaled $1,000,000. Selling and administrative expenses totaled $100,000 for the month and the company manufactured 20,000 rubber rafts. Assume there was no beginning inventory and that 2,800 rubber rafts were sold. Required: A. Compute the per-unit product cost. $ B. Compute the per-unit prime cost. $ C. Compute the per-unit conversion cost. $ D. What is the cost of goods sold for the month? E. What is the cost of ending finished goods for the month? $
The following information is available about electricity costs for the first six months of the year. Management think that electricity costs are likely to be related to how long machines are running. Month Machinehours ElectricityCost January 2,800 $2,925 February 5,600 $5,526 March 6,200 $5,980 April 3,500 $3,620 May 2,300 $2,470 June 4,500 $4,450 You may wish to refer to the formula sheet to answer this question. If you haven't already downloaded it, you can download it here. Required: Using the high-low method, (a) calculate the fixed costs b. state the cost formula for estimating the electricity cost based on the machine hours
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. Month Occupancy-Days Electrical Costs January 3,180 $ 6,510 February 2,920 $ 6,261 March 3,780 $ 7,392 April $ 5,569 May $ 1,820 June 2,050 $ 5,261 July 4,050 $ 7,829 August 4,070 $ 7,896 September 1,780 $ 4,984 October 570 $ 1,596 $4,424 $5,908 Using the high-low method, estimate the fixed cost of electricity per month and the variable cost of electricity per occupancy-day. 2,160 650 November 1,580 December 2,680

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS