Skyview Manor Solution

Topics: Variable cost, Income statement, Contribution margin Pages: 12 (1380 words) Published: April 27, 2015
Skyview 1

Question 1— On average, how many rooms must be rented
each night in season for the hotel to breakeven?
Calculating the break-even occupancy level requires splitting the costs in Exhibit 1 into the fixed and variable components:
a) Variable Costs:
Cleaning supplies
$ 1,920
Linen service
$13,920
1/2 Misc. expense
$ 3,657
$19,497
b) Per Occupied Room Night = $19,497 ÷ 7,680 (120  80  80%) = $2.54
c) Contribution Margin:
Average revenue $160,800 ÷ 7,680 = $20.94
Revenue - Variable Cost = $20.94 -$2.54 = $18.40
d) Fixed Costs:
Total Costs - Variable Costs = Fixed Costs
$138,410 - $19,497 = $118,913
e) Break Even = $118,913 / $18.40 = 6,463 room nights
Per night (÷ 120) = 54 rooms (68% occupancy)

Skyview 2

Question 2 — The hotel is full on weekends in the ski season. If all room rates were raised $5 on weekend nights, but occupancy fell to 72 rooms instead of 80, what is the revised profit before taxes for the year, per Exhibit 1?

The easiest way to make the calculation is to calculate the change in Contribution Margin (CM) since fixed costs will not change.
Lost CM
8 rooms  34 weekend nights (120  2/7 = 34)  $18.40 = $5,005. Added CM
72 rooms  34 nights  $5 = $12,240.
Net Change
$12,240 - $5,005 = $7,235 more profit (before tax)
The breakeven number for lost rooms per night is give by:
X = Breakeven lost rooms
X • $18.40 = (80 - X) $5
$18.4X + $5X = $400
$23.4X = $400
X = 17
The price increase is a good idea as long as we can rent at least 63 rooms per weekend night.

Skyview 3

Question 3 — Contribution Margin in the Off Season
1) Revenue
Single = $10, Double = $15, weighted average = $14.
2) Variable Cost, from question 1 = $2.54/room night
3) Contribution Margin
Revenue - Variable Cost = #14 - $2.54 = $11.46/room night

Skyview 4

Question 4 — The Options
1.
2.
3.
4.
5.
6.
7.

Do nothing.
Stay open—no advertising—no pool
Stay open—advertise—no pool
Stay open—no advertising—pool only
Stay open—advertise—pool only
Stay open—no advertising—pool and bubble
Stay open—advertise—pool and bubble
Pool
No

Yes
Bubble
No
Yes

(2)

(4)

(6)

(3)

(5)

(7)

No
Advertise

Yes

Skyview 5

Incremental Fixed Expenses
DECISION
ALTERNATIVE

Repair

Insurance

Mrs. K

$2000

$500

(a)
$4200

$15,415 2. adv no, pool no







$19,415 3. adv yes, pool no







$24,615 4. adv no, pool yes,
bubble no







$28,615 5. adv yes, pool yes
bubble no







$32,215 6. adv no, pool yes
bubble yes













Total
0

Adv.

$4000

Pool
Dep'n
(b)
$5000

Bubble
Dep'n
(c)
$3000

Pool Ex. Phone

Elect.

Maids

(d)
4200 or
8800

(e)
$720

(f)
$3675

(g)
4320













1. Status Quo

$36,215 7. adv yes, pool yes
bubble yes



















































Skyview 6

(a)
(b)
(c)
(d)

35 weeks x $100/week @ $3500 x 1.2 = $4200
25000/5 = $5000
15000/5 = $3000
Pool expense, if only open off season,
and no bubble=
Lifeguard (3x400)= $ 1200
Insurance & Taxes 1200
Maintenance
1800 $4200
Pool expense if opened year round
with bubble =
From above
$ 4200
Additional Lifeguard 3600
Heating
1000 $8800

(e) (30 rooms) ($3 per room) = $90 x (8 months) = $720
(f) Total Utility Cost, from the case $6360
less Phone Expense
$(1560) = [(290x4) + (50x8) = $1,560]
= Electricity Expense
$4800 (for 9600 available rooms)
For 7350 available rooms = 7350/9600 x $4800 = $3,675
(g) We pay four maids during the season for 7,680 occupied nights (120x80x.8) which is 1920 rooms per maid. Each maid cleans 16 rooms (average) during the week and 20 rooms on the weekend. With only 30 rooms open off-season and only 40% maximum occupancy expected—12 rooms—only one extra maid is needed. The cost is $15/day x 240 days...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Essay about Skyview Manor

    ...occupancy) Skyview 1 Skyview 2 Question 2 — The hotel is full on weekends in the ski season. If all room rates were raised $5 on weekend nights, but occupancy fell to 72 rooms instead of 80, what is the revised profit before taxes for the year, per Exhibit 1? The easiest way to make the calculation is to calculate the change in Contribution Margin (CM) since fixed costs will not change. Lost CM 8 rooms 34 weekend nights (120 2/7 = 34) $18.40 = $5,005. Added CM 72 rooms 34 nights $5 = $12,240. Net Change $12,240 - $5,005 = $7,235 more profit (before tax) The breakeven number for lost rooms per night is give by: X = Breakeven lost rooms X  •  $18.40  =  (80  - X) $5 $18.4X + $5X = $400 $23.4X = $400 X = 17 The price increase is a good idea as long as we can rent at least 63 rooms per weekend night. Question 3 — Contribution Margin in the Off Season 1) Revenue Single = $10, Double = $15, weighted average = $14. 2) Variable Cost, from question 1 = $2.54/room night 3) Contribution Margin Revenue - Variable Cost = #14 - $2.54 = $11.46/room night Skyview 3 (2) (5) (4) No (7) (6) Yes Bubble Yes Pool (3) No Do nothing. Stay open—no advertising—no pool Stay open—advertise—no pool Stay open—no advertising—pool only Stay open—advertise—pool only Stay open—no advertising—pool and bubble Stay open—advertise—pool and bubble Question 4 — The Options 1. 2....

    Read More
    1069 Words 12 Pages
  • Skyview Manor Essay

    ...1. On average, how many rooms must be rented each night in season for the hotel to breakeven? We calculate the blended rate for each of the wings using the single room and double room rates and occupancy ratios. The daily expense during the season is - Hence to break even we must have occupancy to cover $1,153.42 in costs on a daily basis. Assuming equal occupancy (x) in East Wing and West Wing we get the equation as (24*30 + 19*50)*x = 1153.42. We get occupancy as 69.1 percent. Hence hotel must rent approximately 56 rooms per night to breakeven 2. The hotel is full on weekends in the ski season. If all room rates were raised $5 on weekend nights, but occupancy fell to 72 rooms instead of 80, what is the revised profit before taxes for the year, per Exhibit 1? 3. What is the proposed incremental contribution margin per occupied room/day during the off-season? Assuming 40% occupancy that can be expected due to the advertising budget 4. For each alternative in the case, list the annual expenses that are incremental to that decision alternative but are not related to the room/days occupied? A. Open West wing during offseason Annual incremental expenses that are not related to rooms/days occupied 1. Increased Advertising expense $4000 2. Increased Repair and Maintenance of $2000 3. Increase Insurance of $500 4. Increased Mrs. Kacheck wages of $3200 5. Increased payroll taxes and fringe benefits of $1312...

    Read More
    809 Words 3 Pages
  • Skyview Manor Essay

    ... SkyView Manor Case Question 1 variable Cost Linen service $13,920.00 Supplies $1,920.00 1/2 Misc Exp $3,657.00 Total $19,497.00 Revenue $160,800.00 CM Ratio = 1- (19497/160800) 0.87875 Average room 160800/7680 rooms $20.94 contribution margin per room $18.40 Fixed Cost Depreciation 30000 Property tax 4000 Insurance 3000 Mortgage 21716 Salaries $27,480.00 payroll Tax $5,496.00 Repairs $17,204.00 Utilities $6,360.00 1/2 misc $3,657.00 Total 118913 Break even 6463 rooms / 120 nights 54 rooms per night Question #2 Rooms 17 weekends of 2 nights 34 nights Lost Contribution Margin 8 rooms x34 (120 x2/7) 5005 Incremental CM 72 Rooms x 34 nights x $5 12240 Additional profit = 12240 - 5005 $7,725 Question #3 West wing Rooms 30 40% occupied on average 12 Single 2.5 $10 a night Double 9.5 $15 a night Increase per night $167.50 Rate per night $14.00 Total increase 8 months or 245 days Incremental Revenue $41,160 Incremental Variable Cost Cleaning Sup $.2667 per day x units 2940 $784.10 Linens 1/2 Misc (7314/ 2) / 120) x 245 =30.48 x 245 $7,467.60 Total VC $8,252 Incremental CM $32,908 2940 Room = $11.2 per room Question 4: Alternatives Heated covered Swimming pool $40,000 Life Guard 400 *8 $3,200 Tax and Ins $2,200 Maintenance $1,800 Total $47,200 Swimming pool non-heated or covered $25,000 Life Guard 400 *3 warm months $1,200 Taxes $1,200 Total $27,400 Question 5...

    Read More
    601 Words 3 Pages
  • Skyview Manor Case Study Essay

    ... Question 1. Break-even point (per unit) = Total Fixed Costs / Average Revenue – Variable Costs per Unit Total Fixed Costs = Total Costs – Variable Costs Total Costs = $138,410 (Total Expenses, Exhibit 1) In this case, Variable Costs would include Cleaning Supplies, Linen Service, and one half of Miscellaneous expenses; therefore, Total Variable Costs = 1,920 + 13,920 + 3,657 = $19,497 Thus, Total Fixed Costs = $138,410 - $19,497 = $118,913 Average number of rooms occupied per season = 120 days x 80 rooms x 80% occupancy rate = 7,680 Variable Cost per Unit = $19,497/7,680 = $2.54 Average revenue (price) = $160,800/7,680 = $20.94 Thus, break-even point = $118,913/($20.94 - $2.54) = 6462 room nights total / 120 days = 54 rooms Question 2. Weekend nights for the season = 120 nights/7 nights in a week x 2 weekend nights = 34 weekend nights Contribution margin from question 1 or Average Revenue – Variable Cost per Unit = = $20.94 - $2.54 = $18.4 Loss: 80 – 72 = 8 rooms x 34 weekend nights x $18.4 = $5,005 Profit: 72 rooms x 34 weekend nights x $5 increase in rates = $12,240 Difference = $12,240 - $5,005 = $7,235 (number if positive; therefore, we have a profit and we should add it to profit before taxes) Therefore, revised profit before taxed would be equal to $22,390 + $7,235 = $29,625 Question 3. Contribution Margin = Average Revenue – Variable Cost per Unit According to the case, the plans were to reduce the rates for the off-season to $10 and $15 for...

    Read More
    709 Words 2 Pages
  • skyview manor Essay

    ...SKYVIEW MANOR OVERVIEW Hotel Skyview Manor hanya buka pada musim ski. Hotel buka pada tanggal 2 Desember dan tutup pada akhir Maret. Pegunungan ski beroperasi hanya selama 120 hari per tahun. Setiap 50 kamar di sebelah timur disewakan sebesar $15 untuk satu orang atau $20 untuk dua orang. Untuk 30 kamar di sebelah barat disewakan sebesar $20 untuk satu orang dan $25 untuk dua orang. Rata-rata tingkat penyewa kamar hotel selama musim ski adalah sebesar 80% (dengan kondisi hotel penuh disaat akhir bulan dan rata-rata kamar disewa sebanyak 50-60 kamar pada akhir minggu). Rasio penyewa kamar single dan double adalah rata rata sebesar 2 : 8. Mr. Kachack, manager hotel berfokus pada bulan off-season dimana terjadi kerugian dan mengurangi laba tinggi yang diperoleh pada saat high season. Dia menyarankan kepada pemiliknya untuk tetap mengoperasikan kamar sebelah barat secara penuh dalam satu tahun. Dia mengestimasikan rata-rata tingkat sewa kamar sebesar 20% dan 40% untuk beberapa tahun ke depan. Kacheck mengestimasikan dengan adanya perhatian yang lebih pada saat off season akan mencapai tingkat sewa sebesar 40% atau sebanyak 30 kamar jika pemilik mengeluarkan biaya sebesar $4,000 untuk biaya iklan setiap tahun ($500 per bulan selama 8 bulan). Tidak ada bukti bahwa rasio sewa kamar untuk single dan double adalah sebesar 2:8. Akan tetapi bisa terjadi penurunan. Rencana saat ini untuk tariff sewa kamarnya adalah sebesar $10...

    Read More
    515 Words 5 Pages
  • Skyview Manor Case Essay

    ... ACC 5850 Skyview Manor Case 1. On average, how many rooms must be rented each night in season for the hotel to break even? Variable Costs: Cleaning Supplies $1,920 Linen Service $13,920 ½ Misc Expenses $3,657 $19,497 (Total Variable Cost) Variable Cost per Occupied Room Night: = =$2.54. Contribution Margin: Average Revenue = = $20.94 Contribution Margin = Revenue – Variable Cost = $20.94 – $2.54 = 18.40. Fixed Costs: = Total Costs – Variable Costs = $138,410 - $19,497 = $118,913. Break Even: =. Per night: = = 54 rooms. 54 rooms on average (or 67.3% occupancy) must be rented each night in season for the hotel to break even. 2. The hotel is full on weekends in the ski season. If all room rates were raised to $5 on weekend nights, but occupancy fell to 72 rooms instead of 80, what is the revised profit before taxes for the year, per Exhibit 1? Subtracted Contribution Margin: Weekend nights = 120 * = 34 Subtracted CM = 8 rooms * 34 weekend nights * $18.40 = $5,005. Added Contribution Margin: = 72 rooms * 34 weekend nights * $5.00 = $12,240. Net Change in Contribution Margin: = $12,240 - $5,005 = $7,235 added profit before tax. Revised Profit before tax: = $22,390 + $7,235 = $29,625 3. What is the proposed incremental contribution margin per occupied room/day during the off-season? Cleaning Supplies = = = 0.25 per room occupied. Linen...

    Read More
    792 Words 6 Pages
  • Essay about Skyview Manor Case

    ...The principal question of the case study is whether Skyview Manor should stay open during the off-season or not. Currently, Skyview Manor is operating during the skiing season which opens a total of 120 hotel operating days but if they remain open the hotel will operate 365 days a year. The manager of the hotel, Mr. Kacheck, is worried about off-season losses. Mr. Kacheck proposed following ideas in order to increase the occupancy and decrease the losses. * Stay open in the off-season and advertise * Stay open in the off-season, advertise, and add a heated/covered pool * Stay open in the off-season and add a heated/covered pool (no advertising) * Stay open in the off-season, advertise and add a seasonal pool To begin our analysis, Skyview Manor’s Contribution Margin Income Statement must be analyzed for cost behaviors. A cost behavior refers to how a cost changes as an activity changes. Fixed costs remain unchanged when activity changes. Average fixed cost per unit goes down as activity goes up. This is an inverse relationship. Variable costs, however, change when activity changes. The variable cost per unit remains the same over wide ranges of activity within the relevant range. Total variable costs change directly and in proportion to changes in activity. Break-even point for Skyview Manor is based on the number of rooms that must be rented out during...

    Read More
    3234 Words 14 Pages
  • Skyview Essay

    ...Note that to answer this question, I’ve made the following assumptions: 1) The hotel only opens in the ski season just as did it last year thus all operating expenses of the year would need to be absorbed; 2) Telephone is only active in occupied rooms Based on these assumptions, I used the excel solver to find a solution making sure the revenue generated covers all the expenses. These chart below shows how each item on the IS is computed. Based on these amounts, the average occupancy rate needs to be 55 rooms per night. 2. The hotel is full on weekends in the ski season. If all room rates were raised by $5 on weekend nights, but occupancy fell to 72% instead of 80%, what would be the revised profit before taxes for the year, per exhibit 1? Note that to answer this question, I’ve made the following assumptions: 1) The hotel only opens in the ski season just as did it last year thus all operating expenses of the year would need to be absorbed; 2) Telephone is only active in occupied rooms; 3) There are 17 weekends within the season; 4) 72% rate applied throughout the season, not just over the weekends Based on these assumptions, I used Excel to compute a solution, which give me a revised profit before tax of $15,969. 3. What is the proposed incremental contribution margin per occupied room/day during the offseason? The incremental contribution margin per room/day is $5 as indicated in the chart above. 4. For each alternative in the...

    Read More
    373 Words 2 Pages

Popular Essays

Become a StudyMode Member

Sign Up - It's Free