In: Accounting
John Bilodeau is the managing partner of a business that has just finished building a 60-room motel. Bilodeau anticipates that he will rent these rooms for 12,000 nights next year (or 12,000
room-nights). All rooms are similar and will rent for the same price. Bilodeau estimates the following operating costs for next year:
The capital invested in the motel is $1,040,000. The partnership's target return on investment is 30%.
Bilodeau expects demand for rooms to be uniform throughout the year. He plans to price the rooms at full cost plus a markup on full cost to earn the target return on investment.
Requirements
| 
 1.  | 
 What price should Bilodeau charge for a room-night? What is the markup as a percentage of the full cost of a room-night?  | 
|||
| 
 2.  | 
 Bilodeau's market research indicates that if the price of a room-night determined in requirement 1 is reduced by 55%, the expected number of room-nights Bilodeau could rent would increase by 55%. Should Bilodeau reduce prices by 55%? Show your calculations.  | 
|||
| 
 Variable operating costs  | 
 $ 3 per room night  | 
|||
| 
 Fixed costs  | 
||||
| 
 Salaries and wages  | 
 $170,000  | 
|||
| 
 Maintenance of building and pool  | 
 52,000  | 
|||
| 
 Other operating and administration costs  | 
 222,000  | 
|||
| 
 Total fixed costs  | 
 $444,000  | 
|||
| 
 $444,000  | 
||||
1.
On a full cost mark-up basis, the profits are based on the stated percentage of mark-up added to the total cost incurred (Fixed and Variable). Here’s what Bilodeau should charge for a room-night:
| Break-up of price per room night | ||
| Variable Cost: | ||
| $3 x 12000 | 36000 | |
| Total Variable cost | 36000 | |
| Fixed Cost: | ||
| Salaries & Wages | 170000 | |
| Maintenance of building and pool | 52000 | |
| Other operating & Administrative costs | 222000 | |
| Total Fixed Cost | 444000 | |
| Total Cost | 480000 | |
| Add: Mark-up | ||
| (30% on $1040000) | 312000 | |
| Total Price | 792000 | |
| Available room-nights | 12000 | |
| Price per room-night | 66 | 
2.
| What if price dropped by 55% and Room-nights shot up by 55% | ||
| Price per room-night (Existing) | 66 | |
| Less: Reduced | 36.3 | |
| Price per room-night (New) | 29.7 | |
| Number of room-nights (Existing) | 12000 | |
| Add: Increase | 6600 | |
| Number of room-nights (New) | 18600 | |
| Total Earnings (18600 x $29.70) | 552420 | |
| Less: Variable Cost | ||
| (18600 x $3) | 55800 | |
| Contribution | 496620 | |
| Total Fixed Cost | 444000 | |
| Profit | 52620 | |
| Drop in Profit ($312000-$52620)/$312000 x 100 | 
 83%  | 
|
Therefore, Bilodeau should never drop his price per room-night as this will amount to 83% reduction in profits which is far way down below his targeted return on investment.