Preview

Skyview Manor

Powerful Essays
Open Document
Open Document
809 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Skyview Manor
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 6. Increased telephone expense $1120

B. Open swimming pool for 12 months

Annual incremental expenses that are not related to rooms/days occupied
In addition to the above listed 1. Depreciation Expense of $8000 2. Increased loan interest expense to build pool of 5% annually on $40,000 3. Lifeguard Expense of $400/month 4. Insurance and Taxes of $ 1200 5. Maintenance Costs of $1800 6. Heating Costs $1000

C. Open swimming pool for summer months

Annual

You May Also Find These Documents Helpful

  • Satisfactory Essays

    In the income statement depreciation expense has not been included. The balance sheet shows a depreciation of $675 which is an expense…

    • 454 Words
    • 4 Pages
    Satisfactory Essays
  • Good Essays

    hsm 260 week 4 assign 2

    • 514 Words
    • 2 Pages

    45,000 meals – 43,992 meals = 1008 meals x $1.84 revenue per meal = $1,854.72 profit.…

    • 514 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    Revenue Estimates Revenue Item 100% Monthly 75% Monthly 50% Monthly Notes Rooms $2,956,500 $2,217,375 $1,478,250 8,100 daily Leases $180,000 $135,000 $90,000 TOTAL REVENUE $3,136,500 $2,352,375 $1,568,250 Expences TOTAL VARIABLE COSTS $454,000 $340,500 $227,000 TOTAL FIXED COSTS $1,403,000 $1,403,001 $1,403,002 TOTAL EXPENSE BEFORE IT $1,857,000 $1,743,501 $1,630,002 EBIT $1,279,500 $608,874 -$61,752 Depreciation $320,000 $320,001 $320,002 EBITDA $1,599,500 $928,875 $258,250 Furnishing Interest $110,000 $110,000 $110,000 20yr Mortgage Interest $182,000 $182,000 $182,000 TOTAL INTEREST $292,000 $292,000 $292,000 TAXES (40%) $395,000.00 $126,749.60 -$141,500.80 Furnishing Principal $180,160 $180,160 $180,160 20yr Mortgage Principal $49,713 $49,713 $49,713 TOTAL PRINCIPAL $229,873 $229,873 $229,873 NET INCOME $362,627 -$39,749 -$442,124 DIVIDEND PAYMENT $29,010 -$3,180 -$35,370 RETAINED EARNINGS $333,617 -$36,569 EBIT/INTEREST 4.38 2.09 (0.21) EBITDA/INTEREST 5.48 3.18 0.88 BURDEN $675,121.67 $675,121.67 $675,121.67 EBIT/BURDEN 1.90 0.90 (0.09) ROE= Net Income/OE (H1) 32.97% -3.61% -40.19% Revenue Estimates Revenue Item 100% Monthly 75%…

    • 1302 Words
    • 21 Pages
    Satisfactory Essays
  • Good Essays

    A) Commercial = $1,000/hr , 30% demand decrease Intracompany: 223 hrs * $400/hr = $89,200 Commercial: 97 hrs * $1,000/hr = $97,000 Total: 320 hrs $186,200 Variable Exp: 320 hrs * 28.7/hr = $9,184 Sales $186,200 Variable Expenses ($9,184) Contribution Margin $177,016 Fixed Expenses…

    • 454 Words
    • 4 Pages
    Good Essays
  • Good Essays

    48 Kayla and Zhejia expect the price they charge per hour to increase by 6 each year. Variable costs are expected to increase by 3 per year. All payments for costs are made in the year incurred. Depreciation is 20,000 per year so no calculation is need for depreciation. Each owner will bill 30 hours per week for 48 weeks. There will be no other employees. Kayla and Zhejia plan to sell the business for 1.5 times what they paid for the building and the land at the end of the 15th year (750,000). Neither the land nor the building will appreciate in value during the 15 year period. The gain on the sale of the business will equal the sales price minus the book value of the land and the…

    • 1986 Words
    • 5 Pages
    Good Essays
  • Satisfactory Essays

    Wk4fixedcosts

    • 123 Words
    • 1 Page

    1,008 revenue 1,008 meals at $5.77-$5,816.16 for total cost per meal 1,008 at $3.971.44 for a total profit of $5,816.16-$3961.44=$1854.72…

    • 123 Words
    • 1 Page
    Satisfactory Essays
  • Satisfactory Essays

    Hallstead Jewelers

    • 448 Words
    • 2 Pages

    Question 1 Break even point in number of sales tickets 2003 2004 average sales tickets variable cost fixed cost sales tickets to break even 1607 725 2954 3349 1524 768 2990 3955…

    • 448 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    From the data collected, 62 families (31% of the sample) earn an income of more than $100,000 while 69% of the sample (138 bookings) had income less than $100,000. From the group that had an income of less than $100,000, the average number of people per booking is 3.2581, the average age of the group is 40.9032, the average length of stay is 2.5806 and the average expenditure per day is calculated to be $208.9798. From the group with income more than $100,000, the average number of people per booking is 3.6232, the length of stay is 5.7754, the average age is 48.0217 and the average expenditure is $248.3643 per day.…

    • 1256 Words
    • 6 Pages
    Powerful Essays
  • Good Essays

    Borders Hotel Corp. Case

    • 837 Words
    • 4 Pages

    She has to consider overall effectiveness of financing choices by taking earnings and expenses depending on occupancy levels .Because Daniels think that profitability forecasting of the hotel is related to occupancy levels that are 75 per cent (realistic) and 50 percent (lowest possibility). Any proposal that will give the maximum earnings should be selected in order to raise $2,275,000 for BHC.…

    • 837 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Bus 630 Week 2 Assignment

    • 404 Words
    • 2 Pages

    * Calculate the annual break-even point in dollar sales and in unit sales for Shop 48.…

    • 404 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    17. When selling buildings back to the bank, how much do you receive? Half the price…

    • 372 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    – Assume patients stay for 4 nights, and level demand – Number of patients per day (Sun – Thur) = 89 rooms/4 = 22 – Capacity = 5days/wk x 22/day = 110 patients/wk…

    • 673 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Hubbart Formula

    • 418 Words
    • 2 Pages

    The Casa Vana Inn, a 200 room property, is projected to cost $9,900,000 inclusive of land, building, equipment, and furniture. An additional $100,000 is needed for working capital, bringing the total cost of construction and opening to $10,000,000. The hotel is financed with a loan of $7,500,000 at 12% annual interest and cash of $2,500,000 provided by the owners. The owners desire a 15% annual return on their investment. A 75% occupancy is estimated; thus, 54,750 rooms will be sold during the year (200 x 0.75 x 365). The income tax rate is 40%. Additional expenses are estimated as follows:…

    • 418 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Stenden Hots Part C

    • 3817 Words
    • 16 Pages

    at the company which makes a high turnover and a bad staff satibout . e in the HOTS game.…

    • 3817 Words
    • 16 Pages
    Powerful Essays