JDL Enterprises manufactures 3 different products within its Main Boards division at the Omaha location. To manufacture the Main Boards, each product requires materials. labor, and manufacturing overhead. Manufacturing overhead includes costs that are not traceable directly to the product, but they are part of the manufacturing process (such as factory rent, factory utilities, equipment depreciation, and materials handling). When each product is finished, the cost of each product will include all three costs (materials, Ishor, and overhead). While the materials and labor can be easily traced to each product line, it is more difficult to assign overhead to each product line. The Company has decided to use the following criteria to allocate the overhead Overhead Cost Factory Reni & Utilities Equipment Depreciation Materials Handling Allocation Base Square Footage Occupied Number of Machine Hours Number of parts Using the data below, construct a spreadsheet to determine the cost and profitability of each product line. Product: 4824 (Units produced 3,000, Selling price $130 per unit) Cost of Materials: Cost of Labor: $60,000 $90,000 Overhead Data: Building Occupancy: 8,000 square feet Machine Hours: 4,000 hours Materials Handling: 9,000 parts Product: #179 (Units produced 4,000; Selling Price $110 per unit) $70,000 Cost of Materials: Cost of Labor: $130,000 Overhead Data: Building Occupancy: 6,000 square feet Machine Hours: 3,000 hours Materials Handling: 7,000 parts Product: #R35 (Units produced 2,000; Selling Price $115 per unit) Cost of Materials: Cost of Labor: $40,000 $50,000 Total Cost $80,000 $40,000 $90,000 Overhead Data: Building Occupancy: 10,000 square feet Machine Hours: 7,000 hours Materials Handling: 8,000 parts