Please note: I require ALL work to be demonstrated, please do not assume anything. I need an explanation, formula, or cell references to be provided. If not, I will NOT accept answers as correct, If I can't reach the exact same conclusion as you. Note: This is NOT an easy problem, it will require unit contribution AND analysis of Direct Labor. If the analysis of Direct Labor is not done, I will NOT accept your answer.

Required:

1) Prepare an analysis based on the data presented that will show which product or products Sportway, Inc., should manufacture and/or purchase in order to maximize the companys profitability. It should also show the associated financial impact. Support your answer with appropriate calculations.

2) Discuss some qualitative factors that might affect Sportways decision.

Sportway, Inc. Sportway, Inc., is a wholesale distributor supplying a wide range of moderately priced sporting equipment to large chain stores. About 60 percent of Sportway's products are purchased from other companies, while the remaining products are manufactured by Sportway. The company's Plastics Department is currently manufacturing molded fishing tackle boxes. Sportway is able to manufacture and sell 8,000 tackle boxes annually, making full use of its direct labor capacity at available workstations. Following are the selling price and costs associated with Sportway's tackle boxes. Selling price per box Costs per box: Molded plastic Hinges, latches, handle Direct labor ($15/hour) Manufacturing overhead Selling and administrative expenses Profit per box $86.00 $8.00 9.00 18.75 12.50 17.00 65.25 $20.75 Because Sportway believes it could sell 12,000 tackle boxes if it had sufficient manufacturing capacity, the company has looked into the possibility of purchasing the tackle boxes for distribution. Maple Products, a steady supplier of quality products, would be able to provide up to 9,000 tackle boxes per year at a price of $68 per box delivered to Sportway's facility. Bart Johnson, Sportway's product manager, has suggested that the company could make better use of its Plastics Department by manufacturing skateboards. To support his position, Bart has a market study that indicates an expanding market for skateboards and a need for additional suppliers. He believes that Sportway could expect to sell 17,500 skateboards annually at a price of $45 per skateboard. Bart's estimate of the costs to manufacture the skateboards follows: Selling price per skateboard Costs per skateboard: Molded plastic $5.50 Wheels, hardware 7.00 Direct labor ($15/hour) 7.50 Manufacturing overhead 5.00 Selling and administrative expenses 9.00 1 $45.00 34.00 Profit per skateboard $11.00 In the Plastic Department, Sportway uses direct labor hours as the application base for manufacturing overhead. Included in the manufacturing overhead for the current year is $50,000 of factory-wide, fixed manufacturing overhead that has been allocated to the Plastics Department. For each unit of product that Sportway sells, regardless of whether the product has been purchased or is manufactured by Sportway, an allocated $6 fixed overhead cost per unit for distribution is included in the selling and administrative expenses for all products. Total selling and administrative expenses for the purchased tackle boxes would be $10 per unit. Required: 1) Prepare an analysis based on the data presented that will show which product or products Sportway, Inc., should manufacture and/or purchase in order to maximize the company's profitability. It should also show the associated financial impact. Support your answer with appropriate calculations. 2) Discuss some qualitative factors that might affect Sportway's decision. 2