Cost Behavior And Cost-Volume-Profit Analysis Cost Behavior and CostVolumeProfit Analysis for Many Glacier Hotel Using the HighLow 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 2003 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 2006. Many hotel guests purchase a canoe and paddles for use in selfguided 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 2006 fire destroyed the hotel’s accounting records. However, a new system put into place before the 2007 season provides the following aggregated data for the hotel’s canoe and paddle manufacturing and marketing activities: Required: 1. HighLow Cost Estimation Method a. Use the highlow method to estimate the perunit variable costs and total fixed costs for the canoe product line. Variable cost per unit $ Total fixed cost $ b. Use the highlow method to estimate the perunit variable costs and total fixed costs for the paddle product line. Variable cost per unit $ Total fixed cost $ 2. CostVolumeProfit Analysis, SingleProduct Setting Use CVP analysis to calculate the breakeven point in units for a. The canoe product line only (i.e., singleproduct setting) BE units canoes b. The paddle product line only (i.e., singleproduct setting) BE units paddles 3. CostVolumeProfit Analysis, MultipleProduct 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 multipleproduct 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 breakeven point 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, and customer service hotline costs either as production expenses or period expenses. The input in the box below will not be graded, but may be reviewed and considered by your instructor. b. For the period expenses, further classify them into either selling expenses or general and administrative expenses. The input in the box below will not be graded, but may be reviewed and considered by your instructor. 5. Sensitivity CostVolumeProfit Analysis and Production Versus Period Expenses, MultipleProduct Setting