Question

The manager of a local motel asked you to figure out his cost structure to project...

The manager of a local motel asked you to figure out his cost structure to project his future operations. According to his records, the motel recorded the total costs of $72,000 by selling 7,500 rooms during the busiest month of the past year. During the slowest month, it sold 4,500 rooms at the total costs of $48,000. Based on the given information, please answer the following questions.

Find out the motel’s fixed cost amount per month

Find out the motel’s variable cost per room sold?   

0 0
Add a comment Improve this question Transcribed image text
Answer #1
Total Costs Number of Rooms Sold
At High Point $     72,000 7500
At Low Point $     48,000 4500
Change $     24,000 3000

Working:

Variable cost per room sold = $24000/3000 = $8 per room

Fixed cost per month (at the high point) = $72000 - (7500 x $8) = $72000 - $60000 = $12000 per month

Fixed cost per month (at the low point) = $48000 - (4500 x $8) = $48000 - $36000 = $12000 per month

Add a comment
Know the answer?
Add Answer to:
The manager of a local motel asked you to figure out his cost structure to project...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • The owner of a local motel told you to help him set up his budget with...

    The owner of a local motel told you to help him set up his budget with the following information: Its monthly Fixed Cost amount is $120,000, while its Variable Cost is $15 per room sold. During the slowest month, he will reduce his ADR to $30 to sell 6,000 rooms. However, the Variable Cost per room will not change. Using the information provided, complete the Pro Forma Income Statements (Operating Budget); and provide your answer to the question below.     Slowest...

  • The owner of a local motel told you to help him set up his budget with the following information: Its monthly Fixed Cost...

    The owner of a local motel told you to help him set up his budget with the following information: Its monthly Fixed Cost amount is $120,000, while its Variable Cost is $15 per room sold. During the slowest month, he will reduce his ADR to $30 to sell 6,000 rooms. However, the Variable Cost per room will not change. Using the information provided, complete the Pro Forma Income Statements (Operating Budget); and provide your answer to the question below.     Slowest...

  • A hotel wishes is to analyze its electricity cost and its rooms department in terms of...

    A hotel wishes is to analyze its electricity cost and its rooms department in terms of fixed and variable elements. Monthly income statements show that during its busiest and slowest months, cost and rooms occupied information is as follows: --------> room cost rooms sold busiest $4,080 2,800 slowest 3,100 1,400 P7.8 A hotel wishes to ar terms of fixed and va that during its busiest shes to analyze its electricity cost in its rooms department in ved and variable elements....

  • Problem 12 The Myer Motel (MM), a rooms-only fifty-room lodging operation, has a cost structure as...

    Problem 12 The Myer Motel (MM), a rooms-only fifty-room lodging operation, has a cost structure as follows: Monthly fixed costs = $20,000 Variable costs/room sold = $20 ADR = $60 Average Tax Rate = 20 percent Required: 1 What is MM's CMR? 2. What is MM's breakeven point? (in rooms sold) 3. If MM is to make $10,000 of monthly profit (after tax), what must its total revenue be? 4. If the MM makes $10,000 of monthly profit during June,...

  • 4) SUMPRODUCT Question 16 (1 point) You own a motel with 115 rooms. Fixed daily cost...

    4) SUMPRODUCT Question 16 (1 point) You own a motel with 115 rooms. Fixed daily cost for Mortgage is 1,054. Other fixed costs (including staff salaries, maintenance) amount to $771 per day. Variable cost per room is $11 per day (includes extra utility cost, room cleanup, etc). Customers pay $78 per room per day. A local company rented all the rooms of the hotel for 26 days for a workshop. What was the profit (or loss) of the hotel during...

  • Ouestion 3 Rest & Fun Motel operates a 50-room motel near an amusement park. During September,...

    Ouestion 3 Rest & Fun Motel operates a 50-room motel near an amusement park. During September, Rest & Fun experienced a 65% occupancy rate from Monday evening through Thursday evening (weeknights). On Friday through Sunday evenings (weekend nights), however, occupancy increases to 90%. There were 18 weeknights and 12 weekend nights in September. All rooms are similar and Rest & Fun charges RM80 per room per night (room-night). The company recently hired Adam Haikal to manage the motel to increase...

  • Tim Urban, owner/manager of Urban's Motor Court in Key West, is considering outsourcing the daily room...

    Tim Urban, owner/manager of Urban's Motor Court in Key West, is considering outsourcing the daily room cleanup for his motel to Duffy's Maid Service. Tim rents an average of 50 rooms for each of 365 nights (365 x 50 equals the total rooms rented for the year). Tim's cost to clean a room is $13.50. The Duffy's Maid Service quote is $18.50 per room plus a fixed cost of $24,000 for sundry items such as uniforms with the motel's name....

  • As the manager of a 60-unit motel you know that all units are occupied when you...

    As the manager of a 60-unit motel you know that all units are occupied when you charge $80 a day per unit. Each occupied room costs $56 for service and maintenance a day. You have also observed that for every x dollars increase in the daily rate above $80, there are 2x units vacant. Determine the daily price that you should charge in order to maximize profit. Calculate the number of occupied units. Assuming that fixed cost is $258 calculate...

  • The director of surgery at a local hospital is interested in understanding his unit’s costs. An...

    The director of surgery at a local hospital is interested in understanding his unit’s costs. An assistant collected data for the past 36 months on unit cost (labor, supplies, and so on) along with the number of procedures performed in the unit. The assistant analyzed the data using a spreadsheet program, and the following output was generated: Equation Intercept $ 1,008,000 Coefficient on procedures $ 240 Statistical data Correlation coefficient 0.528 R2 0.278 The unit is planning to perform an...

  • 1. Ralph owns a small pizza restaurant, where he works full-time in the kitchen. His total revenue last year was $100,000, and his rent was $3,000 per month. He pays his one employee $2,000 per month,...

    1. Ralph owns a small pizza restaurant, where he works full-time in the kitchen. His total revenue last year was $100,000, and his rent was $3,000 per month. He pays his one employee $2,000 per month, and the cost of ingredients and overhead averages $500 per month. Ralph could earn $35,000 per year as the manager of a competing pizza restaurant nearby. His total explicit costs for the year were a. $24,000. b. $66,000. c. $72,000. d. $60,000. e. $6,000....

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT