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 15 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 $225 per night per cabin. The basic unit of operation is the "night," which is one cabin occupied for one night. The operating income for year 1 is as follows. Vernon Cabins Operating Income Year 1 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 $180,000 with the closing of the one property. Sales revenue Lodging Incidentals $ 4,860,000 475,200 Forfeited deposits Total revenues Costs Labor Incidentals Miscellaneous Utilities, etc. Depreciation Management Marketing Property taxes Total costs Operating profit 129,600 $ 5,464,800 $ 1,748,000 451,200 86,400 95,000 550,000 120,000 230,000 1,640,000 $ 4,920,600 $ 544,200 Other revenues consist of incidentals (vending machine purchases, supplies, and so on) and forfeited deposits. In year 1, Incidentals revenue averaged $22 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 $6 per night. In year 1, the average fixed labor cost was $110,000 per property. The remaining labor cost was variable with respect to the number of nights. The costs of incidentals include $30,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: Required: Prepare a budgeted income statement for year 2. Vernon Cabins Operating Income Sales revenue Year 2 Lodging Incidentals Forfeited deposits Total revenues
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 15 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 $225 per night per cabin. The basic unit of operation is the "night," which is one cabin occupied for one night. The operating income for year 1 is as follows. Vernon Cabins Operating Income Year 1 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 $180,000 with the closing of the one property. Sales revenue Lodging Incidentals $ 4,860,000 475,200 Forfeited deposits Total revenues Costs Labor Incidentals Miscellaneous Utilities, etc. Depreciation Management Marketing Property taxes Total costs Operating profit 129,600 $ 5,464,800 $ 1,748,000 451,200 86,400 95,000 550,000 120,000 230,000 1,640,000 $ 4,920,600 $ 544,200 Other revenues consist of incidentals (vending machine purchases, supplies, and so on) and forfeited deposits. In year 1, Incidentals revenue averaged $22 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 $6 per night. In year 1, the average fixed labor cost was $110,000 per property. The remaining labor cost was variable with respect to the number of nights. The costs of incidentals include $30,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: Required: Prepare a budgeted income statement for year 2. Vernon Cabins Operating Income Sales revenue Year 2 Lodging Incidentals Forfeited deposits Total revenues
Managerial Accounting
15th Edition
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:Carl Warren, Ph.d. Cma William B. Tayler
Chapter1: Introduction To Managerial Accounting
Section: Chapter Questions
Problem 6BE: Jakes Cabins is a small motel chain with locations near the national parks of Utah, Wyoming, and...
Related questions
Question
please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Recommended textbooks for you
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub