Green boxes are for answers, orange boxes are to show excel functions used. Thank you!
Cost Behavior and Cost-Volume-Profit Analysis for Many Glacier Hotel However, a new system put into place before the 204 season provides the following aggregated data for the hotel's canoe and paddle manufacturing and marketing activities: 1. 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 for canoes Excel Formula Used for BE Units: b. The paddle product line only (i.e. single-product setting) BE units for paddles Excel Formula Used for BE Units: 2. Cost-Volume-Profit Analysis, Multiple-Product Setting The hotel's accounting system data show an average sales mix of approximately 500 canoes and 1,250 paddles each season. Significantly more paddles are sold relative and relatives. In addition, for this multiple-product CVP analysis, assume the existence of an additional $40,000 of common fixed costs for a customer service 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). Show excel formulas used for calculations 3. 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. Show Formula Used: All marketing costs and customer hotline costs are costs. If both the variable and fixed production costs (refer to your answer to Requirement 1) associated with the canoe product line increased by 5%, how and paddles would need to be sold in order to earn a target income of $84,000 ? Assume the same sales mix and additional fixed costs as in Requirement 2. TargetincomeCostincreasepercentage$105%84,000 New package CM Total target income units Canoe target income units Paddle target income units 5. 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 2, and assuming that it sells 850 canoes and 4,300 paddles next year. Planned sales for canoes 850 Planned sales for paddles MOS units above BE units MOS in sales dollars Cost Behavior and Cost-Volume-Profit Analysis for Many Glacier Hotel However, a new system put into place before the 204 season provides the following aggregated data for the hotel's canoe and paddle manufacturing and marketing activities: 1. 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 for canoes Excel Formula Used for BE Units: b. The paddle product line only (i.e. single-product setting) BE units for paddles Excel Formula Used for BE Units: 2. Cost-Volume-Profit Analysis, Multiple-Product Setting The hotel's accounting system data show an average sales mix of approximately 500 canoes and 1,250 paddles each season. Significantly more paddles are sold relative and relatives. In addition, for this multiple-product CVP analysis, assume the existence of an additional $40,000 of common fixed costs for a customer service 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). Show excel formulas used for calculations 3. 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. Show Formula Used: All marketing costs and customer hotline costs are costs. If both the variable and fixed production costs (refer to your answer to Requirement 1) associated with the canoe product line increased by 5%, how and paddles would need to be sold in order to earn a target income of $84,000 ? Assume the same sales mix and additional fixed costs as in Requirement 2. TargetincomeCostincreasepercentage$105%84,000 New package CM Total target income units Canoe target income units Paddle target income units 5. 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 2, and assuming that it sells 850 canoes and 4,300 paddles next year. Planned sales for canoes 850 Planned sales for paddles MOS units above BE units MOS in sales dollars
