Required: Prepare a budgeted Income statement for year 2. Sales revenue Lodging Incidentals Forfeited deposits Total...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Required: Prepare a budgeted Income statement for year 2. Sales revenue Lodging Incidentals Forfeited deposits Total revenues Costs Vernon Cabins Operating Income Year 2 Labor Incidentals Miscellaneous Utilities, etc. Depreciation Management Marketing Property taxes Total costs Operating profit Required information [The following information applies to the questions displayed below.] 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. Sales revenue Lodging Incidentals Forfeited deposits Total revenues Costs Vernon Cabins Operating Income Year 1 Labor Incidentals Miscellaneous Utilities, etc. Depreciation Management Marketing Property taxes Total costs Operating profit $ 4,860,000 475,200 129,600 $ 5,464,800 . $ 1,748,000 451,200 86,400 95,000 550,000 120,000 230,000 1,640,000 $ 4,928,600 $ 544,200 Other revenues consist of Incidentals (vending machine purchases, supplies, and so on) and forfelted deposits. In year 1, Incidentals revenue averaged $22 per night. Reservations require a deposit. Guests who fall to cancel before three nights prior to a stay forfelt the deposit. In year 1, forfelted 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: The average room rate will increase by 10 percent. Incidental revenues per night are expected to increase by 5 percent. The forfelted 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. Required: Prepare a budgeted Income statement for year 2. Sales revenue Lodging Incidentals Forfeited deposits Total revenues Costs Vernon Cabins Operating Income Year 2 Labor Incidentals Miscellaneous Utilities, etc. Depreciation Management Marketing Property taxes Total costs Operating profit Required information [The following information applies to the questions displayed below.] 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. Sales revenue Lodging Incidentals Forfeited deposits Total revenues Costs Vernon Cabins Operating Income Year 1 Labor Incidentals Miscellaneous Utilities, etc. Depreciation Management Marketing Property taxes Total costs Operating profit $ 4,860,000 475,200 129,600 $ 5,464,800 . $ 1,748,000 451,200 86,400 95,000 550,000 120,000 230,000 1,640,000 $ 4,928,600 $ 544,200 Other revenues consist of Incidentals (vending machine purchases, supplies, and so on) and forfelted deposits. In year 1, Incidentals revenue averaged $22 per night. Reservations require a deposit. Guests who fall to cancel before three nights prior to a stay forfelt the deposit. In year 1, forfelted 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: The average room rate will increase by 10 percent. Incidental revenues per night are expected to increase by 5 percent. The forfelted 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.
Expert Answer:
Answer rating: 100% (QA)
To prepare a budgeted income statement for year 2 and summarize the information provided we can use the given assumptions and calculations Heres the b... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
HomeSuites is a chain of all-suite, extended-stay hotel properties. The chain has 20 properties with an average of 150 rooms in each property. In year 1, the occupancy rate (the number of rooms...
-
HomeSuites is a chain of all-suite, extended-stay hotel properties. The chain has 19 properties with an average of 200 rooms in each property. In year 1, the occupancy rate (the number of rooms...
-
Home Suites is a chain of all-suite, extended-stay hotel properties. The chain has 15 properties with an average of 200 rooms in each property. In year 1, the occupancy rate (the number of rooms...
-
Benny sells an apartment building. His adjusted basis for regular income tax purposes is $450,000, and it is $475,000 for AMT purposes. He receives $700,000 from the sale. a. Calculate Bennys gain...
-
Synthesize the following compounds using 1-butyne as the only source of carbon, along with any inorganic reagents you need. More than one step may be needed. (a) 1, 1, 2, 2-Tetrachlorobutane (b) 1, 1...
-
Identify the directional change in consumers surplus and producers surplus when we move from free trade to tariffs. Is the change in consumers surplus greater than, less than, or equal to the change...
-
Selected information follow for Bush Company: Required a. Calculate the following ratios for 2019. The 2018 results are given for comparative purposes. b. Comment on the changes between the two...
-
Spelling Sports, which produces basketballs, has two departments: cutting and stitching. Each department has one direct-cost category (direct materials) and one indirect-cost category (conversion...
-
How much extra interest do you gain by starting today rather than waiting one year if you want to deposit $1710 per year for 28 years? You are able to earn 7.07% compounded annually
-
Foster Corporation issued three-year bonds with a $180,000 face value on March 1, 2011, in order to pay for a new computer system. The bonds mature on March 1, 2014, with interest payable on March 1...
-
53. The following are production and cost data for two products, buckets and pails, produced in batches of 600 each. Contribution margin per batch Machine set-ups needed per batch Buckets Pails $360...
-
A positively charged particle of mass \(m\) and charge \(+q\) moves in a circle of radius \(r\) in a uniform magnetic field of magnitude \(B\). How does the radius of the particle's motion change...
-
Why is it hard to reuse traditional model in the world of changing requirements.
-
List some of the related design patterns used in formulating the trust stable pattern.
-
List three test cases to test the class members of the trust pattern.
-
List some of the testing patterns that can be applied for testing the trust stable analysis pattern.
-
On March 1 , 2 0 1 3 Simple Inc. had $ 1 2 5 of supplies. Throughout the month of March 2 0 1 3 Simple Inc. purchased $ 3 7 3 of additional supplies. On March 3 1 , 2 0 1 3 , Simple determined that...
-
A local politician is concerned that a program for the homeless in her city is discriminating against blacks and other minorities. The following data were taken from a random sample of black and...
-
Plant House operates a commercial plant nursery where it propagates plants for garden centers throughout the region. Plant House has $ 5.0 million in assets. Its yearly fixed costs are $ 600,000, and...
-
Layne Containers currently uses a recycled plastic to make bottles for the food industry. Current bottle production information: The cost and time standards per batch of 10,000 bottles are as...
-
Use the information from the Crystal Cruiseline Data Set. Draw a graph of Crystal Cruise-lines CVP relationships. Include the sales revenue line, the fixed expense line, and the to-tal expense line....
-
Which of the following techniques is the most efficient way to process customer payments and update accounts receivable? a. EFT b. VMI c. FEDI d. ACH
-
Which report would be most useful for estimating likely bad debts? a. accounts receivable aging schedule b. profitability analysis c. sales analysis d. cash budget
-
Which method is most likely used when a company offers customers discounts for prompt payment? a. open-invoice method b. balance-forward method c. accounts receivable aging method d. cycle billing...
Study smarter with the SolutionInn App