Cost-Volume-Profit with Multiple Products, Sales Mix Changes, Changes in Fixed and Variable Costs Artistic Woodcrafting Inc. began several years ago as a one-person, cabinet-making operation. Employees were added as the business expanded. Last year, sales volume totaled $850,000. Volume for the first five months of the current year totaled $600,000, and sales were expected to be $1.6 million for the entire year. Unfortunately, the cabinet business in the region where Artistic is located is highly competitive. More than 200 cabinet shops are all competing for the same business. Artistic currently offers two different quality grades of cabinets: Grade I and Grade II, with Grade I being the higher quality. The average unit selling prices, unit variable costs, and direct fixed costs are as follows: Unit Price Unit Variable Cost Direct Fixed Cost $3,400 $95,000 Grade I $2,686 Grade II 1,328 1,600 95,000 Common fixed costs (fixed costs not traceable to either cabinet) are $35,000. Currently, for every three Grade I cabinets sold, seven Grade II cabinets are sold. Required: Note: Round your answers to the nearest whole number. 1. Calculate the number of Grade I and Grade II cabinets that are expected to be sold during the current year. 224 units Grade I Grade II Vunits 524 2. Calculate the number of Grade I and Grade II cabinets that must be sold for Artistic to break even V units Grade I 168 2. Calculate the number of Grade I and Grade II cabinets that must be sold for Artistic to break even Vunits Grade I 168 Grade II units 392 3. Artistic can buy computer-controlled machines that will make doors, drawers, and frames. If the machines are purchased, the variable costs for each type of cabinet will decrease by 9%, but common fixed cost will increase by $44,000. Compute the effect on operating income. $73,602 X Increase Calculate the new break-even point. Assume the machines are purchased at the beginning of the sixth month. Fixed costs for the company are incurred uniformly throughout the year. X units Grade I 141 X units Grade II 329 4. Refer to the original data. Artistic is considering adding a retail outlet. This will increase common fixed cost by $70,000 per year. As a result of adding the retail outlet, the additional publicity and emphasis on quality will allow the firm to change the sales mix to 1:1. The retail outlet is also expected to increase sales by 30%. Assume that the outlet is opened at the beginning of the sixth month. Calculate the effect on the company's expected profits for the current year. $66,198 X Increase Calculate the new break-even point. Assume that fixed costs are incurred uniformly throughout the year. Grade I Vunits 262 Vunits Grade II 374 Cost-Volume-Profit with Multiple Products, Sales Mix Changes, Changes in Fixed and Variable Costs Artistic Woodcrafting Inc. began several years ago as a one-person, cabinet-making operation. Employees were added as the business expanded. Last year, sales volume totaled $850,000. Volume for the first five months of the current year totaled $600,000, and sales were expected to be $1.6 million for the entire year. Unfortunately, the cabinet business in the region where Artistic is located is highly competitive. More than 200 cabinet shops are all competing for the same business. Artistic currently offers two different quality grades of cabinets: Grade I and Grade II, with Grade I being the higher quality. The average unit selling prices, unit variable costs, and direct fixed costs are as follows: Unit Price Unit Variable Cost Direct Fixed Cost $3,400 $95,000 Grade I $2,686 Grade II 1,328 1,600 95,000 Common fixed costs (fixed costs not traceable to either cabinet) are $35,000. Currently, for every three Grade I cabinets sold, seven Grade II cabinets are sold. Required: Note: Round your answers to the nearest whole number. 1. Calculate the number of Grade I and Grade II cabinets that are expected to be sold during the current year. 224 units Grade I Grade II Vunits 524 2. Calculate the number of Grade I and Grade II cabinets that must be sold for Artistic to break even V units Grade I 168 2. Calculate the number of Grade I and Grade II cabinets that must be sold for Artistic to break even Vunits Grade I 168 Grade II units 392 3. Artistic can buy computer-controlled machines that will make doors, drawers, and frames. If the machines are purchased, the variable costs for each type of cabinet will decrease by 9%, but common fixed cost will increase by $44,000. Compute the effect on operating income. $73,602 X Increase Calculate the new break-even point. Assume the machines are purchased at the beginning of the sixth month. Fixed costs for the company are incurred uniformly throughout the year. X units Grade I 141 X units Grade II 329 4. Refer to the original data. Artistic is considering adding a retail outlet. This will increase common fixed cost by $70,000 per year. As a result of adding the retail outlet, the additional publicity and emphasis on quality will allow the firm to change the sales mix to 1:1. The retail outlet is also expected to increase sales by 30%. Assume that the outlet is opened at the beginning of the sixth month. Calculate the effect on the company's expected profits for the current year. $66,198 X Increase Calculate the new break-even point. Assume that fixed costs are incurred uniformly throughout the year. Grade I Vunits 262 Vunits Grade II 374