Project One Part Four Problem (9 points) All-American Sports uses operations costing in one of its manufacturing divisions. Conversion costs are accumulated by department, and process-costing methods are used to assign these costs to products. Direct materials costs are accumulated by batch and job order costing is used to assign material costs to products. The company produces two different grades of soccer balls: professional balls with genuine leather exteriors and scholastic balls with the use of imitation leather. The cutting and stiching operations for the two different products are identifical. Scholastic balls are sold without special packaging. The professional balls are packaged in an attractive cardboard box. The following represents the data associated with two batches introduced and completed during the month of April. Direct materials costs: Batch P76 (1,000 professional balls) Batch S43 (3,000 scholastic balls) Total direct materials costs $20,000 (includes $5,000 for packaging) $30,000 $50,000 Conversion Costs (Budgeted) Preparation Department Finishing Department $30,000 $24,000 Packaging Department Total Conversion Costs $500 $54,500 Required: Calculate the unit product cost for each type of soccer ball by using Excel formulas with your designated answer in the highlighted cells below. Direct materials (Batch P76) Direct materials (Batch S43) Conversion: Preparation Department Conversion: Finishing Department Conversion: Packaging Department Total Product Cost Professional Scholastic