Integrative Exercise Cost Behavior and Cost-Volume-Profit Analysis for Many Glacier Hotel Using the High-Low Method to Estimate Variable and Fixed Costs paddle manufacturing and marketing activities (Years 1 through 12 give the data for the years in which the new accounting system was active): \begin{tabular}{cccccc} Manufacturing Data & & & & \\ \hline & NumberofCanoes & TotalCanoeMarketing & & Number of & Total Paddle \\ Paddles & Marketing \\ Year & Sold & Costs & Year & Sold & Costs \\ \hline 1 & 250 & $45,000 & 1 & 900 & $7,500 \\ 2 & 240 & 47,000 & 2 & 1,200 & 9,000 \\ 3 & 275 & 43,000 & 3 & 1,000 & 8,000 \\ 4 & 310 & 51,000 & 4 & 1,100 & 8,500 \\ 5 & 350 & 62,000 & 5 & 1,400 & 10,000 \\ 6 & 380 & 53,000 & 6 & 1,700 & 11,500 \\ 7 & 415 & 68,500 & 7 & 1,720 & 11,600 \\ 8 & 430 & 63,000 & 8 & 1,850 & 12,250 \\ 9 & 450 & 65,000 & 9 & 1,900 & 12,500 \\ 10 & 470 & 67,000 & 10 & 2,020 & 13,100 \\ 11 & 480 & 52,000 & 11 & 2,050 & 13,250 \\ 12 & 500 & 73,000 & 12 & 2,200 & 14,000 \end{tabular} a. Use the high-low method to estimate the per-unit variable costs and total fixed costs for the canoe product line. Variable cost per unit Total fixed cost xx b. Use the high-low method to estimate the per-unit variable costs and total fixed costs for the paddle product line. Variable cost per unit Total fixed cost $$xx 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) BE units canoes b. The paddle product line only (i.e., single-product setting) BE units paddles 3. Cost-Volume-Profit Analysis, Multiple-Product Setting calculate the break-even 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 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 of $96,000 ? Assume the same sales mix and additional fixed costs as in Requirement 3. Canoe target income units canoes Paddle target income units paddles The total MOS units equal The MOS in sales dollars equals \& Integrative Exercise Cost Behavior and Cost-Volume-Profit Analysis for Many Glacier Hotel Using the High-Low Method to Estimate Variable and Fixed Costs paddle manufacturing and marketing activities (Years 1 through 12 give the data for the years in which the new accounting system was active): \begin{tabular}{cccccc} Manufacturing Data & & & & \\ \hline & NumberofCanoes & TotalCanoeMarketing & & Number of & Total Paddle \\ Paddles & Marketing \\ Year & Sold & Costs & Year & Sold & Costs \\ \hline 1 & 250 & $45,000 & 1 & 900 & $7,500 \\ 2 & 240 & 47,000 & 2 & 1,200 & 9,000 \\ 3 & 275 & 43,000 & 3 & 1,000 & 8,000 \\ 4 & 310 & 51,000 & 4 & 1,100 & 8,500 \\ 5 & 350 & 62,000 & 5 & 1,400 & 10,000 \\ 6 & 380 & 53,000 & 6 & 1,700 & 11,500 \\ 7 & 415 & 68,500 & 7 & 1,720 & 11,600 \\ 8 & 430 & 63,000 & 8 & 1,850 & 12,250 \\ 9 & 450 & 65,000 & 9 & 1,900 & 12,500 \\ 10 & 470 & 67,000 & 10 & 2,020 & 13,100 \\ 11 & 480 & 52,000 & 11 & 2,050 & 13,250 \\ 12 & 500 & 73,000 & 12 & 2,200 & 14,000 \end{tabular} a. Use the high-low method to estimate the per-unit variable costs and total fixed costs for the canoe product line. Variable cost per unit Total fixed cost xx b. Use the high-low method to estimate the per-unit variable costs and total fixed costs for the paddle product line. Variable cost per unit Total fixed cost $$xx 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) BE units canoes b. The paddle product line only (i.e., single-product setting) BE units paddles 3. Cost-Volume-Profit Analysis, Multiple-Product Setting calculate the break-even 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 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 of $96,000 ? Assume the same sales mix and additional fixed costs as in Requirement 3. Canoe target income units canoes Paddle target income units paddles The total MOS units equal The MOS in sales dollars equals \&