Managerial Accounting / Cost Accounting

Attached is the detail/scenario for the questions.

- Prepare an analysis based on the data presented that will show which product or products Fred's, 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.

- Discuss some qualitative factors that might affect Fred's Inc. decision.

I'd appreciate if you could show detailed work in the attached spreadsheet and return it by end of day.

If that timeline doesn't work, please let me know.

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