Super Skis Inc. (SSI), a small private company in Ontario, manufactures skis and snowboards. It is July 4, 2019, and you, CPA, are the finance manager at SSI, reporting to Andy Thomas, the CEO and owner. The company just completed its year end on June 30, 2019.

SSI's departments are divided by its three product lines. Until last year, SSI produced only two established products, Extra-glide downhill skis and Super-board snowboards, but in July 2018 it introduced Cross-fit cross-country skis. Cross-fit's launch was very successful. Andy had expected this new product would increase the company's profitability, but he had not expected the results to be so impressive. The product immediately became the company's most profitable, representing more than 40% of SSI's gross profit. As a result, he wonders whether SSI should shift its sales and production focus to Cross-fit. SSI has a strong reputation for quality products, which may have been the reason for Cross-fit's success. Also, most of SSI's customers are happy with SSI's fast delivery.

Andy regularly organizes meetings with the three departments' production managers to share news and ideas. At the latest meeting, he says, "Our new product launch was successful. However, I'm disappointed to see decreased gross profit from Extra-glide and Super-board last year."

The Extra-glide production manager says, "I don't think the financial results make sense. My department produced and sold 4,000 more units than in the previous year. The sales volume did not decline, yet gross profit has fallen by more than half. The cost of direct materials and the hourly rates of the employees have increased slightly this year, but I thought we had increased the selling price sufficiently to compensate for these increases."

Andy replies "We will need to have a close look at these financial results. I've gathered the current financial information from the accounting team and demand forecasts from the sales team (Appendix I). Based on the information, we can't meet all the demand with our current capacity. If the gross profits continue to decrease, I think we should drop production of Extra-glide and Super-board and focus on Cross-fit in the long term. CPA, please prepare production plan that would maximize the overall profit for SSI, and let me know which product we should actually focus on."

The Super-board manager says, "CPA, my friend is also an accountant and she suggested that we should be using activity-based costing. Do you think implementing activity-based costing will help increase gross profits of Extra-glide and Super-board and SSI's overall gross profit? Can you please run the numbers under this method?" He provides you with cost information (Appendix II).

The Cross-fit manager adds, "Well, I knew that the Cross-fit launch would contribute significant profit to the company. The results proved I was right. After only a few months of Cross-fit sales, we were able to generate a much higher gross profit than the other two products. We should produce more of Cross-fit, which would increase gross profit across the company. Also, since the Cross-fit requires less labor, this might speed up our process and shorten the delivery time. I've gathered information about further increasing automation of the manufacturing process for the Extra-glide and Super-board lines (Appendix III). CPA, can you please have a look at it and tell us whether this investment is worthwhile?"

Andy finishes up by asking you to analyze the reason for the decrease in gross profits in Extra-glide and Super-board this year; and provide recommendations for the company.

1) Will using ABC costing improve gross profits?

2) Recalculate the OH using ABC costing method.

3) Prepare production schedule to maximize profits using ABC costing method.

4) Prepare NPV analysis for the investment opportunity to increase automation.

APPENDIX I k FINANCIAL INFORMATION As ofJune 30, 2019 Extra-glide Super-hoard E ross-t Total Total sales $3, 000 ,?50 $4, 635, 000 $1, 43? ,500 $9,031,250 Direct materials 5 54-4 ,580 $ 927 000 : 301,225 $1, 052 ,912 Direct labour 5 551 ,050 $ 000, 650 01400 $1, 520 ,000 Manufacturing overhead costs $1,452,500 5 450,513 $2,31T,500 $ 509,850 5 230,000 $4,000,000' 5 733,3?5 $1,700,330 Unit information: Extraglide Superboard Crosst Number of units produced and sold {Note 2} 20,?50 11,500 Price per unit $145.00 $125.00 Direct material cost per unit $ 25.25 $ 33.15 Direct labour cost per unit Demand forecast per year {units} {Note 4} Notes: 1. Manufacturing overhead costs [MOH] amounted to $4,000,000, which is a $750,000 increase from the previous year. The increase was caused by costs for equipment dedicated to the newr product. These costs are allocated to the products based on the direct labour hours. {'The amount of MOH is a rounded number.) 2. SSI holds no inventory, since it manufactures on the basis ot orders received. 3. Maximum capacity is 100,000 machine hours. remain the same forthe next ve years. . The sales team estimated that the unit demand will increase as shown in the table and will APPENDIX II COST DRIVERS AND COST INFORMATION Expected Cost Manufacturing per Overhead Cost Activities Cost Drivers Cost Driver Unit by Activity Direct materials handling Direct material cost (DM$) $0.50 per DMS $ 926,500 Parts manufacturing Machine hours (MH) $15.00 per MH $1,477,500 Assembly Direct labour hours (DLH) $11.25 per DLH $ 900,000 Product packaging Number of units $12.00 per unit $ 696,000 Total manufacturing overhead costs $4,000,000 The cost driver usage for machine hours and direct labour hours were as follows: Extra-glide Super-board Cross-fit Total Machine hours used (MH) 31,126 38,626 28,750 98,502 MH Direct labour hours used (DLH) 29,050 46,350 4.600 80,000 DLH