Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Vernon Cabins is a small motel chain located near state and national parks. Each property is made up of separate cabins. The chain has 10

Vernon Cabins is a small motel chain located near state and national parks. Each property is made up of separate cabins. The chain has 10 properties with an average of 22 cabins at each property. In year 1, the occupancy rate (the number of rooms filled divided by the number of rooms available) was 80 percent, based on a 180-day season. The properties are closed from late fall until early spring. The average rate was $260 per night per cabin.

The operating income for year 1 is as follows.

Vernon Cabins
Operating Income
Year 1
Sales revenue
Lodging $ 4,930,000
Incidentals 918,720
Forfeited deposits 253,440
Total revenues $ 6,102,160
Costs
Labor $ 2,750,400
Incidentals 966,800
Miscellaneous 95,040
Utilities, etc. 130,000
Depreciation 585,000
Management 155,000
Marketing 265,000
Property taxes 1,710,000
Total costs $ 6,657,240
Operating profit (loss) $ (555,080)

Other revenues consist of incidentals (vending machine purchases, supplies, and so on) and forfeited deposits. In year 1, incidentals revenue averaged $29 per night. Reservations require a deposit. Guests who fail to cancel before three nights prior to a stay forfeit the deposit. In year 1, forfeited deposits averaged $8 per night.

In year 1, the average fixed labor cost was $180,000 per property. The remaining labor cost was variable with respect to the number of nights. The costs of incidentals include $65,000 per season per property. The remaining cost of incidentals is variable with respect to the number of nights. Miscellaneous costs are all variable with respect to the number of nights. Utilities and depreciation are fixed for each property. The remaining costs (management, marketing, and property taxes) are fixed for the firm.

At the beginning of year 2, Vernon will close one of its properties with no change in the average number of rooms per property. The occupancy rate is expected to decrease to 70 percent. Management has made the following additional assumptions for year 2:

The average room rate will increase by 10 percent.

Incidental revenues per night are expected to increase by 5 percent.

The forfeited deposit revenue per night is not expected to change.

The fixed labor cost is expected to increase by 12 percent per property. The variable labor cost per night is not expected to change.

Incidental cost factors are not expected to change.

The miscellaneous cost for a night is expected to increase by 25 percent.

Utilities costs per property are expected to increase by 20 percent.

Depreciation costs per property are forecast to remain unchanged.

Management costs will increase by 4 percent and marketing costs will decrease by 6 percent.

Property taxes will decrease by $194,000 with the closing of the one property.

Prepare a budgeted income statement for year 2.

Note: Do not round intermediate calculations. Round final answers to the nearest dollar.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

To prepare a budgeted income statement for Year 2 we need to follow a systematic approach The steps below will walk through the calculation using the information provided for Vernon Cabins Step 1 Calc... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting with International Financial Reporting Standards

Authors: Jerry J. Weygandt, Paul D. Kimmel, Donald E. Kieso

4th edition

1119504309, 1-119-50340-8, 9781119503408 , 978-1119504306

More Books

Students also viewed these Accounting questions