January 2018. The GM has asked you to prepare a CVP analysis to aid in discussing...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
January 2018. The GM has asked you to prepare a CVP analysis to aid in discussing next year's financial expectations at the upcoming Area Managers' Meeting. The meeting brings together 45 hotel managers and three district managers from the Southwest Region. From your managerial accounting class, you learned that break-even sales volume is computed using fixed costs and the unit contribution margin. Since you will be forecasting break-even for this year (2018), you need to make several adjustments to the three years of historical data you obtained. These adjustments are described as follows: • Price. You examine the average selling price (i.e., average daily rate) for the past two years and decide that the hotel's room rate for next year will continue the same trend; in other words, you will realize the same percentage increase (or decrease) that was experienced in the past year. For example, if your rate increased 8% from 2016 to 2017, you will then forecast the 2018 room rate to be 8% above 2017's room rate. . Costs. Your hotel's variable and fixed costs are obtained from the (A) case, in which you estimated the hotel's cost equation. After consultation with industry experts, you predict fixed costs will be the same next year. Further, you expect the variable cost per room-night to increase 4% due to inflation. Based on your analysis of local market data, you believe that sales volumes will remain flat; that is, the number of rooms rented in 2018 will be unchanged from the 2017 sales volume. Required 1. What are the assumptions of CVP analysis? 2. Compute the breakeven sales volume for 2018. 3. Calculate the margin of safety. 4. Determine the degree of operating leverage. What happens to leverage at different levels of planned sales volume? Hint: Compute operating leverage at sales volumes of 50% and 120% of the 2018 planned sales volume. 5. Draw a CVP plot and label the different attributes of the plot. Provide a brief interpretation of your figure. January 2018. The GM has asked you to prepare a CVP analysis to aid in discussing next year's financial expectations at the upcoming Area Managers' Meeting. The meeting brings together 45 hotel managers and three district managers from the Southwest Region. From your managerial accounting class, you learned that break-even sales volume is computed using fixed costs and the unit contribution margin. Since you will be forecasting break-even for this year (2018), you need to make several adjustments to the three years of historical data you obtained. These adjustments are described as follows: • Price. You examine the average selling price (i.e., average daily rate) for the past two years and decide that the hotel's room rate for next year will continue the same trend; in other words, you will realize the same percentage increase (or decrease) that was experienced in the past year. For example, if your rate increased 8% from 2016 to 2017, you will then forecast the 2018 room rate to be 8% above 2017's room rate. . Costs. Your hotel's variable and fixed costs are obtained from the (A) case, in which you estimated the hotel's cost equation. After consultation with industry experts, you predict fixed costs will be the same next year. Further, you expect the variable cost per room-night to increase 4% due to inflation. Based on your analysis of local market data, you believe that sales volumes will remain flat; that is, the number of rooms rented in 2018 will be unchanged from the 2017 sales volume. Required 1. What are the assumptions of CVP analysis? 2. Compute the breakeven sales volume for 2018. 3. Calculate the margin of safety. 4. Determine the degree of operating leverage. What happens to leverage at different levels of planned sales volume? Hint: Compute operating leverage at sales volumes of 50% and 120% of the 2018 planned sales volume. 5. Draw a CVP plot and label the different attributes of the plot. Provide a brief interpretation of your figure.
Expert Answer:
Related Book For
Financial Management for Public Health and Not for Profit Organizations
ISBN: 978-0132805667
4th edition
Authors: Steven A. Finkler, Thad Calabrese
Posted Date:
Students also viewed these accounting questions
-
Your boss has asked you to prepare a feasibility report to determine whether the company should advertise its custom-crafted cabinetry in the weekly neighborhood newspaper. Based on your primary...
-
The bookkeeper at Martin Company has asked you to prepare a bank reconciliation as of May 31. The May 31 bank statement and the May T- account for cash (summarized) are on the next page. Martin...
-
The bookkeeper at Tony Company has asked you to prepare a bank reconciliation as of February 29. The February bank statement and the February T- account for cash showed the following (summarized):...
-
The following matrix is row-equivalent to the augmented matrix of a linear system. Describe the solution set of that system. 1 0 1 5 0000 0013 0000 Find all possible values of a for which the...
-
Consider steady, parallel flow of atmospheric air over a flat plate. The air has a temperature and free stream velocity of 300 K 25 m/s? (a) Evaluate the boundary layer thickness at distances of x =...
-
The location of the sliding bar in Figure 9.5 is given by x = 5t + 2t 3 , and the separation of the two rails is 20 cm. Let B = 0.8x 2 a z T. Find the voltmeter reading at (a) t = 0.4 s; (b) x = 0.6...
-
Bosworth Company is considering a capital investment of \($168,000\) in additional productive facilities. The new machinery is expected to have a useful life of 6 years with no salvage value....
-
Ivanhoe Industries is calculating its Cost of Goods Manufactured at year- end. Ivanhoes accounting records show the following: The Raw Materials Inventory account had a be-ginning balance of $ 17,000...
-
14. Prior to recording adjusting entries, the Office Supplies account had a $359 debit balance. A physical count of the supplies showed $105 of unused supplies available. The required adjusting entry...
-
The Dinosaur Adventure Theme Park needs $200 million to build a monorail that will run through the park. The park's financial advisors believe that it will be able to borrow the the money by issuing...
-
Solve the system of equations by graphing: Jy= -2x+2 (3x+6y Solution = = -6 6+ 5 4 3 2 -3 -2 2 -1 -2 -3 -4 -5 w
-
Explain the concept of correlation & regression and point out its importance in: getting a prediction model use in business forecasting. including the role of regression analysis in business...
-
Balloons By Sunset (BBS) is considering the purchase of two new hot air balloons so that it can expand its desert sunset tours. Various information about the proposed investment follows: (Future...
-
1.Explain the concept of contingency planning and discuss the value of cross-training. 2.Explain outsourcing, off-shoring, and globalization.
-
Use the Annual Percentage Rate Table per $100 to calculate the estimated APR for each of the previous purchases. Sale price Down payment # of monthly payments Monthly payment Annual percentage rate...
-
Please answer Question 5 The following information is available for plastic grade RX3 Annual demand-225,000 kgs Annual holding cost per kilogram - 0.50 . Fixed ordering cost - 2.50 (a) Calculate...
-
Problem 1. What amount should Jon Snow Co. report as Cash & Cash Equivalents in its December 31, 2020 statement of financial position? Problem 2. In its December 31, 2020 statement of financial po...
-
With your classmates, form small teams of skunkworks. Your task is to identify an innovation that you think would benefit your school, college, or university, and to outline an action plan for...
-
What are the major sources of financing for the federal government, state and local governments, the health sector, and the not- for- profit sector?
-
Because of the downturn in the states economy, the mayor of Stratton thinks that uncollectible taxes are likely to increase from 5 percent of total tax bills to 10 percent in the coming fiscal year....
-
A Greener World expects to have $ 15,000 in fixed costs. If its fixed costs do not change but the amount each marcher raises through pledges declines from $ 55 to $ 50 and its variable cost/ unit...
-
How many months does it take to save $200,000.00 based on the information provided in this problem?---
-
What is the amount oi the credit to employee city income tax payable?
-
Milat is the total yearly gross pay for all employees?
Study smarter with the SolutionInn App