Question

Brian Propp operates a bed & breakfast hotel in Banff, Alberta, Canada. His forecasts for next...

Brian Propp operates a bed & breakfast hotel in Banff, Alberta, Canada. His forecasts for next year follow:  

Annual rental costs  

$44,000

Maintenance staff monthly salaries  

$11,000

Cleaning staff monthly salaries  

$15,000

Security cost per room rental  

$7

Cost of food per room rental  

$8

Average room rental revenue  

$130

Monthly average no. of room rentals  

                         350  

REQUIRED:  

Calculate the number of room rentals per year that Brian needs to break even.  

Calculate the annual sales revenue required to break even.  

Calculate the annual number of room rentals required to earn a profit before tax of $50,000.  

Homework Answers

Answer #1

Solution a:

Contribution margin per room rental = $130 - $7 - $8 = $115 per room rental

Annual Fixed cost = $44000 + $11000*12 + 15000*12 = $356,000

Number of room rentals per year to break even = Fixed cost / Contribution margin per room rental

= $356000 / $115 = 3096 room rental

Solution b:

annual sales revenue required to break even = 3096 * $130 = $402,480

Solution c:

annual number of room rentals required to earn a profit of 50000 =  ($356000 + $50000) / $115 = 3530

Know the answer?
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
Similar Questions
Sue Locke operates a bed and breakfast hotel with 20 units in a resort area of...
Sue Locke operates a bed and breakfast hotel with 20 units in a resort area of northern Michigan. Fixed overhead is $160,000 per year. The rooms rent for an average of $70 per night (including a free breakfast which costs Sue $4 per rented room per night). Other costs per rental are laundry and cleaning at $10 per night. Show your work in detail A) Determine the number of room rentals per year so Sue can break even. B) If...
A 200-room hotel has an annual fixed cost of $1,050,000 and a profit goal of 12%...
A 200-room hotel has an annual fixed cost of $1,050,000 and a profit goal of 12% return on investment of $5,000,000. With an average room rate of $78 and average variable cost of $34 per room. Calculate the followings and show your work and answer. Number of room sales (annual) Occupancy rate Revenue required
Delaware Medical Center operates a general hospital. The medical center also rents space and beds to...
Delaware Medical Center operates a general hospital. The medical center also rents space and beds to separately owned entities rendering specialized services, such as Pediatrics and Psychiatric Care. Delaware charges each separate entity for common services, such as patients’ meals and laundry, and for administrative services, such as billings and collections. Space and bed rentals are fixed charges for the year, based on bed capacity rented to each entity. Delaware Medical Center charged the following costs to Pediatrics for the...
Betty Buns is a student run hot fruit bun stand operating on a university campus, open...
Betty Buns is a student run hot fruit bun stand operating on a university campus, open ten months of the year. Fruit buns are bought partially pre-baked and then heated in the sales cart and sold. You are given the following figures pertaining to next year’s budget: Expected annual sales – 73,000 buns at $0.70 each Staff salaries - $21,700 p.a. Monthly hire of cart $ 50. The cart is only hired in the months required. Cost of buying part-baked...
1. Mauro Products distributes a single product, a woven basket whose selling price is $22 per...
1. Mauro Products distributes a single product, a woven basket whose selling price is $22 per unit and whose variable expense is $19 per unit. The company’s monthly fixed expense is $8,100. Required: 1. Calculate the company’s break-even point in unit sales. 2. Calculate the company’s break-even point in dollar sales. (Do not round intermediate calculations.) 3. If the company's fixed expenses increase by $600, what would become the new break-even point in unit sales? In dollar sales? (Do not...
Splendid Glasses operates a kiosk at the local? mall, selling sunglasses for $ 20 each.Splendid Glasses...
Splendid Glasses operates a kiosk at the local? mall, selling sunglasses for $ 20 each.Splendid Glasses currently pays ?$1,920 a month to rent the space and pays two? full-time employees to each work 110 hours a month at $8 per hour. The store shares a manager with a neighboring kiosk and pays? 50% of the? manager's annual salary of $ 43,000 and benefits of $8,600. The wholesale cost of the sunglasses to the company is $ 9 a pair. Requirement...
The Fashion Shoe Company operates a chain of women’s shoe shops that carry many styles of...
The Fashion Shoe Company operates a chain of women’s shoe shops that carry many styles of shoes that are all sold at the same price. Sales personnel in the shops are paid a sales commission on each pair of shoes sold plus a small base salary. The following data pertains to Shop 48 and is typical of the company’s many outlets: Per Pair of Shoes Selling price $ 30.00 Variable expenses: Invoice cost $ 11.00 Sales commission 4.00 Total variable...
Sunrise Hotels (B) January 2018. The GM has asked you to prepare a CVP analysis to...
Sunrise Hotels (B) January 2018. The GM has asked you to prepare a CVP analysis to aid in discussing next year’s financial expectations at the upcoming Area Managers’ Meeting. The meeting brings together 45 hotel managers and three district managers from the Southwest Region. From your managerial accounting class, you learned that break-even sales volume is computed using fixed costs and the unit contribution margin. Since you will be forecasting break-even for this year (2018), you need to make several...
You have been recruited by a former classmate, Susanna Wu, to join the finance team of...
You have been recruited by a former classmate, Susanna Wu, to join the finance team of a company that she founded recently. The company produces a unique product line of hypoallergenic cosmetics and relies for its success on an aggressive marketing program. The company is in a start-up phase and therefore has no significant history of expenses and revenues upon which to rely for budgeting and planning purposes. Given the restriction on available funds (most of the available capital has...
The Harborside Inn, located on the New England coast, is a 125-room luxury hotel. The inn's...
The Harborside Inn, located on the New England coast, is a 125-room luxury hotel. The inn's guests are predominantly upper middle class in that the going rate is about $100 per day per person. The hotel grounds include 30 acres of lawns and gardens. Their nine-hole golf course winds its way around a picturesque trout pond. The hotel grounds were meticulously cared for and yet efforts at cultivating beauty could not match the natural beauty which was so much a...