Integrative Exercise
Cost Behavior and Cost-Volume-Profit Analysis for Many GlacierHotel
Using the High-Low Method to Estimate Variable and FixedCosts
Located on Swiftcurrent Lake in Glacier National Park, ManyGlacier Hotel was built in 1915 by the Great Northern Railway. Inan effort to supplement its lodging revenue, the hotel decided in20X1 to begin manufacturing and selling small wooden canoesdecorated with symbols hand painted by Native Americans living nearthe park. Due to the great success of the canoes, the hotel beganmanufacturing and selling paddles as well in 20X3. Many hotelguests purchase a canoe and paddles for use in self-guided tours ofSwiftcurrent Lake. Because production of the two products began indifferent years, the canoes and paddles are produced in separateproduction facilities and employ different laborers. Each canoesells for $500, and each paddle sells for $50. A 20X3 firedestroyed the hotelΓ’ΒΒs accounting records. However, a new system putinto place before the 20X4 season provides the following aggregateddata for the hotelΓ’ΒΒs canoe and paddle manufacturing and marketingactivities:
| Manufacturing Data: |
| Year | Number of
Canoes
Manufactured | Total Canoe
Manufacturing
Costs | | Year | Number of
Paddles
Manufactured | Total Paddle
Manufacturing
Costs |
| 20X9 | | 250 | | | $103,000 | | | 20X9 | | 900 | | | $38,500 | |
| 20X8 | | 275 | | | 128,000 | | | 20X8 | | 1,200 | | | 49,000 | |
| 20X7 | | 240 | | | 108,000 | | | 20X7 | | 1,000 | | | 44,000 | |
| 20X6 | | 310 | | | 114,000 | | | 20X6 | | 1,100 | | | 45,500 | |
| 20X5 | | 350 | | | 141,500 | | | 20X5 | | 1,400 | | | 52,000 | |
| 20X4 | | 400 | | | 140,000 | | | 20X4 | | 1,700 | | | 66,500 | |
| Marketing Data: |
| Year | Number of
Canoes
Sold | Total Canoe
Marketing
Costs | | Year | Number of
Paddles
Sold | Total Paddle
Marketing
Costs |
| 20X9 | | 250 | | | $45,000 | | | 20X9 | | 900 | | | $7,500 | |
| 20X8 | | 275 | | | 43,000 | | | 20X8 | | 1,200 | | | 9,000 | |
| 20X7 | | 240 | | | 44,000 | | | 20X7 | | 1,000 | | | 8,000 | |
| 20X6 | | 310 | | | 51,000 | | | 20X6 | | 1,100 | | | 8,500 | |
| 20X5 | | 350 | | | 62,000 | | | 20X5 | | 1,400 | | | 10,000 | |
| 20X4 | | 400 | | | 60,000 | | | 20X4 | | 1,700 | | | 11,500 | |
Required:
1. High-Low Cost Estimation Method
a. Use the high-low method to estimate the per-unit variablecosts and total fixed costs for the canoe productline.
| Variable cost per unit | $ |
| Total fixed cost | $ |
b. Use the high-low method to estimate the per-unit variablecosts and total fixed costs for the paddle productline.
| Variable cost per unit | $ |
| Total fixed cost | $ |
2. Cost-Volume-Profit Analysis, Single-ProductSetting
Use CVP analysis to calculate the break-even point in units for
a. The canoe product line only (i.e.,single-product setting)
b. The paddle product line only (i.e.,single-product setting)
3. Cost-Volume-Profit Analysis,Multiple-Product Setting
The hotel's accounting system data show an average sales mix ofapproximately 300 canoes and 1,200 paddles each season.Significantly more paddles are sold relative to canoes because someinexperienced canoe guests accidentally break one or more paddles,while other guests purchase additional paddles as presents forfriends and relatives. In addition, for this multiple-product CVPanalysis, assume the existence of an additional $30,000 of commonfixed costs for a customer service hotline used for both canoe andpaddle customers. Use CVP analysis to calculate the break-evenpoint in units for both the canoe and paddle product lines combined(i.e., the multiple-product setting).
| Canoe BE units | canoes |
| Paddle BE units | paddles |
4. Cost Classification
a. Classify the manufacturing costs, marketing costs, andcustomer service hotline costs either as production costs or periodcosts.
All manufacturing costs are costs. All marketing costs andcustomer hotline costs are costs
b. For the period costs, further classify them into eitherselling expenses or general and administrative expenses.
Marketing costs are selling oriented; therefore, the marketingperiod costs would be further classified as . Customer hotlinecosts relate to the customer service section of the value chain andwould be further classified as .
5. Sensitivity Cost-Volume-Profit Analysis andProduction Versus Period Costs, Multiple- Product Setting
If both the variable and fixed production costs (refer to youranswer to Requirement 1) associated with the canoe product lineincreased by 5% (beyond the estimate from the high-low analysis),how many canoes and paddles would need to be sold in order to earna target income of $96,000? Assume the same sales mix andadditional fixed costs as in Requirement 3.
| Canoe target income units | canoes |
| Paddle target income units | paddles |
6. Margin of Safety
Calculate the hotelΓ’ΒΒs margin of safety (both in units and insales dollars) for Many Glacier Hotel, assuming the same facts asin Requirement 3, and assuming that it sells 700 canoes and 2,500paddles next year.
total MOS units above total BE units
$ MOS in sales dollars
