The Cheyenne Hotel in Big Sky, Montana, recorded its total electrical costs and 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 January February March April May June July August September October November December Occupancy- Days 3,250 3,470 3,660 1,760 1,350 4,350 3,280 1,610 700 1,300 1,640 2,220 Electrical Costs $9,660 $10,185 $ 10,360 $ 6,160 $ 4,725 $ 11,575 $ 9,765 $ 5,635 $ 2,450 $ 4,550 $ 5,740 $ 7,770 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 Answer is complete but not entirely correct. $ 3.50 per occupancy-day $ 3,650 per month

The Cheyenne Hotel in Big Sky, Montana, recorded its total electrical costs and 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 January February March April May June July August September October November December Occupancy- Days 3,250 3,470 3,660 1,760 1,350 4,350 3,280 1,610 700 1,300 1,640 2,220 Electrical Costs $9,660 $10,185 $ 10,360 $ 6,160 $ 4,725 $ 11,575 $ 9,765 $ 5,635 $ 2,450 $ 4,550 $ 5,740 $ 7,770 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 Answer is complete but not entirely correct. $ 3.50 per occupancy-day $ 3,650 per month

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…
Fanning 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 208 boats at a total cost of $164,860. The low point in production occurred in January when it produced 37 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 Fanning Boat Company. b. Determine the total estimated cost if 160 boats are made. a. Fixed cost b. Total estimated cost
Bodow is an entertainment complex located in Trinidad & Tobago. It offers various activitiessuch as music, rides, slides, and souvenir shopping, and customers pay a fixed fee to enter.The complex has been in operation for the past seven years and remains open throughout theyear. However, weather-related issues often lead to a significant decrease in customerattendance, usually by 50%, on approximately 30 days each year.Bodow has experienced substantial success, with customer numbers increasing byapproximately 15% annually. Sales at Bodow are categorized as cash sales and credit cardsales. All ticket sales are recorded on a computer, including the amount of each sale and thenumber of tickets issued. This information is electronically transferred to the accounts office.Cash collected from each ticket office is counted by two accounts clerks and two securityguards before being banked daily. The total cash from each ticket office is reconciled with thesales information transferred from…
Show the solution in good accounting form
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?
The Sandhill Acres Inn is trying to determine its break-even point during its off - peak season. The inn has 50 rooms that it rents at $120 a night. Operating costs are as follows: Salaries $5,400 per month Property tax $1,300 per month Depreciation (straight-line) $1,100 per month Maintenance $120 per month Maid service $33 per room Other costs $ 63 per room Determine the inn's break-even point in number of rented rooms per month. Break - even point 1584 rooms eTextbook and Media Solution Attempts: 4 of 4 used (b) * Your answer is incorrect. Determine the inn's break- even point in sales dollars. Break-even point in sales. $
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
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…
PepsiCo sells its soft drinks in approximately 400,000 retail establishments, such as supermarkets, discount stores, and convenience stores. Sales representatives call on each retail account weekly, which means each account is called on by a sales rep 52 times per year. The average length of a sales call is 75 minutes (or 1.25 hours). An average salesperson works 2,000 hours per year (50 weeks per year * 40 hours per week), but each spends 10 hours a week on non-selling activities, such as administrative tasks and travel. How many salespeople does PepsiCo need?
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