Question:
2. Chuck Stout is the RM for the Holiday Inn Express. His 220-room property normally sells 85 percent of its rooms on Tuesday nights at an ADR of $141.50. All variable costs related to selling his rooms are $55.00 per room. The DOSM at his Holiday Inn Express is proposing to place a bid to sell 125 rooms for a Tuesday night next month at a rate of $109.00 per room. Chuck believes that if the hotel wins this group rooms bid, the transient room sales for that day will ensure a sell-out at the rate of $141.50.
A. What would be the total amount of revenue the hotel will achieve if: It makes the group sale? _________________ It does not make the group sale? _________________
B. What would be the total amount of after-variable costs rooms’ revenue the hotel will achieve if it wins the group rooms contract? _________________
C. What would be the after-variable room’s income if the hotel does not win the contract? _________________
D. What additional factors might Chuck and the DOSM take into account before determining whether to bid on this piece of group rooms business?
3. The Brookshire Country Club rents its ballroom for weddings and provides food and beverages services for those using its facility. Last year, the Club hosted 25 wedding events. The total revenue derived from these events was $225,000. The product (food and beverage) costs associated with each wedding averaged 31.5 percent. All other variable costs for each event averaged 48.5 percent. What was the average after-costs revenue (in dollars and percent) achieved by the Club for each wedding event?
4. Gene Monte is president of the five-unit El Ray Taqueria chain of restaurants. His quickservice operations offer both dine-in and carry-out (drive through) service. Gene is considering keeping his operations open one additional hour per night. Based on his revenue estimates, the following data represent the incremental sales he believes he will achieve in each of his restaurants:
Assume Gene’s product cost is 30 percent and all other variable costs equal 45 percent of sales. Unit Number Additional Revenue 1 $850 2 $700 3 $650 4 $750 5 $900
A. What is the additional amount, per unit, that Gene could contribute to his fixed costs by extending his operating schedule by the additional hour?
B. What is the total amount of contribution to fixed costs he would achieve?
C. What additional factors should Gene take into account before implementing the extended schedule?
5. John Flowers owns Keneally’s Irish Pub. On the upcoming St. Patrick’s Day, John expects a capacity crowd. John normally operates with four servers. Because of seating limitations, John can only add a total of four more servers to his staff for St. Patrick’s Day. Each server costs John $12.00 per hour. His beverage costs are 25 percent. Each added server can generate an additional $600.00 in beverage sales per hour if they work a full 8-hour shift. Prepare a spreadsheet that details the increased revenue, labor costs, beverage costs, as well as the revenue remaining after John pays his product and labor costs if he places an additional one, two, three, or four full-time servers on his St Patrick’s Day employee schedule. What additional factors might John take into account before determining how many additional servers he should add?
Answer:
Chapter 5 Apply What You Know-Student Worksheet |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
5.2 |
|
|
|
|
|
Rooms Sold |
ADR |
Total Revenue |
Total Variable Cost @ $55.00/ room |
Net Revenue |
|
|
|
|
|
Without Group |
|
|
|
|
|
|
|
|
|
187 |
141.5 |
$ 26,460.50 |
$ 10,285.00 |
$ 16,175.50 |
|
|
|
|
|
With Group |
|
|
|
|
|
|
|
|
|
125 |
$141.50 |
$ 17,687.50 |
$ 6,875.00 |
$ 10,812.50 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total |
|
$ 44,148.00 |
$ 17,160.00 |
$ 26,988.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
If hotel does not win the contract |
|
|
|
|
|
Rooms Sold |
ADR |
Total Revenue |
Total Variable Cost @ $55.00/ room |
Net Revenue |
|
|
|
|
|
187 |
$141.50 |
$ 26,460.50 |
$ 10,285.00 |
$ 16,175.50 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Additional factors need to be consider while placing the bid on the piece of group room busienss is the market in which the hotel operates and also the prices of other competitor hotels. Another factor of approximating the number of guests travelling and estimation of the apprpraite season to travel is also required to be made. Apart from increased sales, trends of supply and demand must also be considered while pricing the rooms. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
5.3 |
|
|
|
|
|
|
|
|
Total Revenue |
$2,25,000.00 |
|
|
|
|
|
|
|
|
Less Product Cost @ (31.5%) |
$70,875.000 |
|
|
|
|
|
|
|
|
Less Other Variable Costs (48.5%) |
$1,09,125.000 |
|
|
|
|
|
|
|
|
Revenue less Product and Variable costs (20%) |
$45,000.000 |
|
|
|
|
|
|
|
|
Average per event (with 25 events) |
$1,800.000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
5.4 |
|
|
|
|
|
|
Unit Number |
Additional Revenue |
Variable Costs |
Contribution to Fixed Costs |
|
|
|
|
|
|
1 |
$850 |
$637.50 |
$213 |
|
|
|
|
|
|
2 |
$700 |
$525.00 |
$175 |
|
|
|
|
|
|
3 |
$650 |
$487.50 |
$163 |
|
|
|
|
|
|
4 |
$750 |
$562.50 |
$188 |
|
|
|
|
|
|
5 |
$900 |
$675.00 |
$225 |
|
|
|
|
|
|
Total |
$3,850 |
$2,888 |
$963 |
|
|
|
|
|
|
Additional amount per unit |
|
|
$770 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Apart from the incremental sales, the other factors which are needed to be consider while implementing the extended schedule is that Gene needs tocpnsider the employees’ opinion before extending their shift times. Issues related to the shift extension should be kept in mind at time of implementing the startegy. Other factors may include work load, server’s safety and Gene must make sure that his restaurant never goes out of stock, as the increase operational hour will also result in increase number of customers. |
5.5 |
|
|
|
|
|
|
|
|
|
Pub Staffing |
4 servers |
5servers |
6 servers |
7 servers |
8 servers |
|
|
|
|
Revenue @ $ 600 per server |
$ 2,400.00 |
$ 3,000.00 |
$ 3,600.00 |
$ 4,200.00 |
$ 4,800.00 |
|
|
|
|
Wages @ $ 96.00 per server |
$ 384.00 |
$ 480.00 |
$ 576.00 |
$ 672.00 |
$ 768.00 |
|
|
|
|
Bev Cost @ 25% |
$ 600.00 |
$ 750.00 |
$ 900.00 |
$ 1,050.00 |
$ 1,200.00 |
|
|
|
|
Revenue Remaining After Product and Labor Cost |
$ 1,416.00 |
$ 1,770.00 |
$ 2,124.00 |
$ 2,478.00 |
$ 2,832.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
After analysing the increased revenue and cost, John should also consider the amount of capital required for incresing the number of servers. Along with this, hiring of additional staff is also necessary as the number of server rises. John also needs to keep in mind the optimum level of its servers and should make efforts for enhancing their quality as and when required. Factors of CVP analysis should also be kept in mind. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
References
|
|
|
|
|
|
|
|
|
|
Ivanov, S., 2014. Hotel revenue management: From theory to practice. Varna: Zangador. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Verret, C., 2008. Hotel Sales and Revenue Management Book 2.0. iUniverse. |
|
|
|
|
|
|