--%>

Determine & Analysis on Income Statements

The DU Inn

The DU Inn is an 80-room hotel located on some mountaintop in Colorado. That has no bar or restaurant &is positioned as a mid-priced, good quality "homey" hotel.  It is open only during the ski season. It opens on Dec 1 and closes the last day of March (assume 30 days a month all year). The ski mountain it serves operates on a permit from the state which allows only 120 days of operation per year. The primary source of revenue comes from the rental of rooms. There are no food and beverage facilities on-site. Guests can dine at various restaurants that are located nearby.  Each of the 50 rooms in the east wing rents for $75 per night for single occupancy or $100 for double occupancy. The west wing of the hotel has 30 rooms, all of which have spectacular views of the skiing slopes, the mountains and the village. Rooms in this wing rent for $100 and $150 for single or double occupancy respectively. The average occupancy rate during the season is 80% for the east and west wing. The ratio of single versus double occupancy is 2:8, on average for both the east wing and west wing.

Mr. Kaching is the general manager of the hotel earning a salary of $15,000 for the entire ski season ($3,750 a month). The general manager's salary is paid over 12 months. He acts as a caretaker of the facilities during the off-season and also contracts most of the repair and maintenance work during that time. Mr. Kaching is concerned about the off-season months, which show losses each month and reduce the high profits reported during the ski season. He has provided a proposal to the owners who had recently acquired the hotel.  The proposal is to reduce the off-season losses by keeping the west wing of the hotel operating year-round. He estimates the average occupancy rate for the off-season to be about 30% for the next few years. Kaching estimates that with careful attention to the off-season clientele, a 40% occupancy rate for the 30 rooms during the off-season would be much more likely if the owners would commit $40,000 for advertising each year ($5,000 for each of 8 months). There is no evidence to indicate that the 2:8 ratios of singles vs. doubles would be any different during the remainder of the year in the future. Rates however, would have to be drastically reduced. Present plans are to reduce them to $75 and $100 for singles and doubles for the off-season.

Mrs. Kaching is paid a salary of $2,400 a month for supervising the room attendants and helping with the check-in. The regular desk clerk and each room attendant (4 room attendants on staff) are paid on a daily basis at the rate of $15 and $10 per hour respectively for 8 hours a day and these amounts are not expected to change. The taxes and other fringe benefits on the total salaries and wages are estimated at 20%.  The current annual depreciation expenses on the hotel are $50,000 per year. Property taxes and insurance are expected to be fixed at $40,000 and $30,000 respectively per year.  Repairs and maintenance expenses are also fixed and estimated at $27,000. 

Although depreciation and property taxes would not be affected by the decision to keep the west wing open during the off-season, insurance would increase by $10,000 for the year.  Using the west wing during the off-season would also not interfere with the work of the general manager, but would cause an estimated additional $6,000 per year for repair and maintenance. During the off-season, it is estimated that Mr. and Mrs. Kaching could handle the front desk without any increase in personnel.  Mrs. Kaching would however, be paid and additional $1,000 a month in salary.

The cleaning supplies are considered a direct function of the number of rooms occupied.  Cleaning supplies are estimated at $6.00 per room occupied.  Miscellaneous expenses are a mixed cost with the variable portion estimated at $4.75 per room occupied and a fixed portion estimated at $35,000 which will not change with 12 months operations.  Linen is rented from a supply house and the cost also depends on the number of rooms occupied. Linen expenses are $8 per room occupied, but are twice on average for double occupancy rooms.  The utilities expenses include telephone expenses and other utilities such as electricity, gas, water, sewer and heating. The telephone bills for each of the four seasonal months were as follows: 80 telephones @ $30/month for each phone and a basic monthly service charge of $5000. All other utilities (electric, water, gas, sewer, heating) are a function of the number of rooms available for sale to the public at a rate of $2.50 per room.  The hotel pays a federal income tax rate of 35%. In addition, the hotel is currently collateralized by a bank loan that had an original principal sum of $5 million. This loan is for a term of 10 years with interest only annual payments of 5%.

If the hotel is open during the off-season, the basic monthly telephone service charge is reduced by half and the monthly telephone charge will apply only to active telephones in the west wing. In addition, the other utilities expenses (water, electric, gas, sewer, heating) would be reduced to $1.50 per available room. 

Questions:

1. Using the above information, create a traditional income statement for the ski season to show the amount the hotel would generate in net income after taxes.

2. List the variable costs and fixed costs and their respective amounts for the ski season. Sum the total variable costs and fixed costs

3. Convert your traditional income statement from question 1 into a contribution income statement.

4. What is the overall contribution margin per room and contribution margin ratio per room during the ski season?

5. Compute the breakeven point in the number of rooms sold and room revenues during the ski season. What is the breakeven occupancy rate?

6. If the hotel wanted to generate $100,000 in operating income before taxes, what is the number of rooms it must sell and the revenues it must generate during the ski season? What is the occupancy rate?

7. If the hotel wanted to generate $104,000 in net income after taxes, what is the number of rooms it must sell and the revenues it must generate during the ski season? What is the occupancy rate? Create a contribution income statement to prove your answer?

Hint:  The formula to adjust for income taxes is : [FC + (NI/(1-Tax rate)]/CM

8. What is the incremental total variable cost and total fixed cost that will be incurred during the off-season? What is the incremental contribution margin per room and contribution margin ratio per room?

9. Create an incremental contribution income statement for the off-season and compute the net income after taxes?

10. Based on your incremental analysis, what is the breakeven point in number of rooms sold and revenues generated during the off-season? What is the occupancy necessary to breakeven during the off-season?

 

 

 

 

   Related Questions in Managerial Accounting

  • Q : Analysis on Business Profile BUSINESS

    BUSINESS PROFILES:Go to the following webpage by clicking on the link or by copying and pasting the URL into your web browser:After opening the link, you will see a small cover page of the West Newsmagazine’s publication titled “Business Profiles&rdq

  • Q : Information that a manager need to make

    What is the various information that a manager need to make a decision?

  • Q : Techniques to liberate the function of

    Write down the different techniques employed to liberate the function of management accounting?

  • Q : Adjunct account An account in financial

      An account in financial reporting that increases the book value of a liability account. An adjunct account is a valuable account from which cred

  • Q : Operation of business

    What are the main reasons that the operation of business environment has become ever more turbulent and competitive?

  • Q : Human relation discuss the limitations

    discuss the limitations of human relations approaches to management

  • Q : Explain Managerial Cost Accounting

    Managerial Cost Accounting System: The organization and processes, whether automated or not, and whether portion of the general ledger or stand-alone, which accumulates and reports constant and trustworthy cost information and perform

  • Q : Define the term Strategic management

    Briefly define the term Strategic management and also state the reason why it is designed?

  • Q : Insurance premium in Arrears What are

    What are the Insurance premium in Arrears?

  • Q : Bonds payable A form of long-term debt

    A form of long-term debt that appears  in the liabilities section of the balance sheet. A company sells bond as a way to borrow large amount of cash. The buyer pays for the bond and receives regular interest payment, annually or semiannually, for the duration of