Integrative Exercise
Cost Behavior and Cost-Volume-Profit Analysis for Many Glacier Hotel

Using the High-Low Method to Estimate Variable and Fixed Costs

Located on Swiftcurrent Lake in Glacier National Park, Many Glacier Hotel was built in 1915 by the Great Northern Railway. In an effort to supplement its lodging revenue, the hotel decided in 20X1 to begin manufacturing and selling small wooden canoes decorated with symbols hand painted by Native Americans living near the park. Due to the great success of the canoes, the hotel began manufacturing and selling paddles as well in 20X3. Many hotel guests purchase a canoe and paddles for use in self-guided tours of Swiftcurrent Lake. Because production of the two products began in different years, the canoes and paddles are produced in separate production facilities and employ different laborers. Each canoe sells for $500, and each paddle sells for $50. A 20X3 fire destroyed the hotel’s accounting records. However, a new system put into place before the 20X4 season provides the following aggregated data for the hotel’s canoe and paddle manufacturing and marketing activities:

Required:

1. High-Low Cost Estimation Method

a. Use the high-low method to estimate the per-unit variable costs and total fixed costs for the canoe product line.

b. Use the high-low method to estimate the per-unit variable costs and total fixed costs for the paddle product line.

2. Cost-Volume-Profit Analysis, Single-Product Setting
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 of approximately 300 canoes and 1,200 paddles each season. Significantly more paddles are sold relative to canoes because some inexperienced canoe guests accidentally break one or more paddles, while other guests purchase additional paddles as presents for friends and relatives. In addition, for this multiple-product CVP analysis, assume the existence of an additional $30,000 of common fixed costs for a customer service hotline used for both canoe and paddle customers. Use CVP analysis to calculate the break-even point in units for both the canoe and paddle product lines combined (i.e., the multiple-product setting).

4. Cost Classification

a. Classify the manufacturing costs, marketing costs, and customer service hotline costs either as production costs or period costs.

All manufacturing costs are costs. All marketing costs and customer hotline costs are costs

b. For the period costs, further classify them into either selling expenses or general and administrative expenses.

Marketing costs are selling oriented; therefore, the marketing period costs would be further classified as . Customer hotline costs relate to the customer service section of the value chain and would be further classified as .

5. Sensitivity Cost-Volume-Profit Analysis and Production Versus Period Costs, Multiple- Product Setting

If both the variable and fixed production costs (refer to your answer to Requirement 1) associated with the canoe product line increased by 5% (beyond the estimate from the high-low analysis), how many canoes and paddles would need to be sold in order to earn a target income of $96,000? Assume the same sales mix and additional fixed costs as in Requirement 3.

6. Margin of Safety

Calculate the hotel’s margin of safety (both in units and in sales dollars) for Many Glacier Hotel, assuming the same facts as in Requirement 3, and assuming that it sells 700 canoes and 2,500 paddles next year.
total MOS units above total BE units

$ MOS in sales dollars

Cost Behavior and Cost-Volume-Profit Analysis for Many Glacier Hotel

Using the High-Low Method to Estimate Variable and Fixed Costs

Located on Swiftcurrent Lake in Glacier National Park, Many Glacier Hotel was built in 1915 by the Great Northern Railway. In an effort to supplement its lodging revenue, the hotel decided in 20X1 to begin manufacturing and selling small wooden canoes decorated with symbols hand painted by Native Americans living near the park. Due to the great success of the canoes, the hotel began manufacturing and selling paddles as well in 20X3. Many hotel guests purchase a canoe and paddles for use in self-guided tours of Swiftcurrent Lake. Because production of the two products began in different years, the canoes and paddles are produced in separate production facilities and employ different laborers. Each canoe sells for $500, and each paddle sells for $50. A 20X3 fire destroyed the hotel’s accounting records. However, a new system put into place before the 20X4 season provides the following aggregated data for the hotel’s canoe and paddle manufacturing and marketing activities:

Required:

1. High-Low Cost Estimation Method

a. Use the high-low method to estimate the per-unit variable costs and total fixed costs for the canoe product line.

b. Use the high-low method to estimate the per-unit variable costs and total fixed costs for the paddle product line.

2. Cost-Volume-Profit Analysis, Single-Product Setting
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 of approximately 300 canoes and 1,200 paddles each season. Significantly more paddles are sold relative to canoes because some inexperienced canoe guests accidentally break one or more paddles, while other guests purchase additional paddles as presents for friends and relatives. In addition, for this multiple-product CVP analysis, assume the existence of an additional $30,000 of common fixed costs for a customer service hotline used for both canoe and paddle customers. Use CVP analysis to calculate the break-even point in units for both the canoe and paddle product lines combined (i.e., the multiple-product setting).

4. Cost Classification

a. Classify the manufacturing costs, marketing costs, and customer service hotline costs either as production costs or period costs.

All manufacturing costs are product  costs. All marketing costs and customer hotline costs are period  costs

b. For the period costs, further classify them into either selling expenses or general and administrative expenses.

Marketing costs are selling oriented; therefore, the marketing period costs would be further classified as selling expenses . Customer hotline costs relate to the customer service section of the value chain and would be further classified as general and administrative expense .

5. Sensitivity Cost-Volume-Profit Analysis and Production Versus Period Costs, Multiple- Product Setting

If both the variable and fixed production costs (refer to your answer to Requirement 1) associated with the canoe product line increased by 5% (beyond the estimate from the high-low analysis), how many canoes and paddles would need to be sold in order to earn a target income of $96,000? Assume the same sales mix and additional fixed costs as in Requirement 3.

6. Margin of Safety

Calculate the hotel’s margin of safety (both in units and in sales dollars) for Many Glacier Hotel, assuming the same facts as in Requirement 3, and assuming that it sells 700 canoes and 2,500 paddles next year.
total MOS units above total BE units

$ MOS in sales dollars

(A) If the answer in (c) is greater than 0.01 then we conclude at the 1% significance
level that the average weight of a bear in Yellowstone National Park is different from 187 lb.

(B) If the answer in (c) is less than 0.01 then we cannot conclude at the 1% significance
level that the average weight of a bear in Yellowstone National Park is different from 187 lb.

(C) If the answer in (a) is greater than the answer in (b) then we cannot conclude at the 1% significance
level that the average weight of a bear in Yellowstone National Park is different from 187 lb.

(D) If the answer in (c) is less than 0.01 then we conclude at the 1% significance
level that the average weight of a bear in Yellowstone National Park is different from 187 lb.

(E) If the answer in (a) is greater than the answer in (c) then we cannot conclude at the 1% significance
level that the average weight of a bear in Yellowstone National Park is different from 187 lb.

(F) If the answer in (b) is greater than the answer in (c) then we cannot conclude at the 1% significance
level that the average weight of a bear in Yellowstone National Park is different from 187 lb.

(G) If the answer in (a) is greater than the answer in (c) then we conclude at the 1% significance
level that the average weight of a bear in Yellowstone National Park is different from 187 lb.

(H) If the answer in (b) is greater than the answer in (c) then we conclude at the 1% significance
level that the average weight of a bear in Yellowstone National Park is different from 187 lb.

Suppose that oil fouls the beaches along the Florida panhandle. Vacationers are the primary customers of the hotels along the panhandle. The oil _____ the price of a hotel room and _____ the quantity of hotel rooms rented

How is the concept of resort hotel different from other types of hotels? From a manager’s perspective, how is managing a resort hotel different from running other properties?

As a concerned employee of 'Delexis Hotel', Sunyani, write a letter to the General Manager informing him of four (4) inherent challenges inhibiting the success of interpersonal communications within the hotel.

What are the knowledge important for hotel business (Customer, supplier, administrator)(Small hotels like darwin city hotel)? How they use these knowledge? Develop a KMS framework for the business

In the US, airlines and hotel companies use different types of generic strategies. What types of generic strategies do airlines and hotel companies use, and why? (Short Essay)