^{Please also add how answer was solved if possible thanks.}

A1 A 1 Function: SUM; Formula: Divide; Cell Referencing 2 3 Using Excel To Compute Units of Production 4 PROBLEM 5 The following is available for Mordica Company's process costing system. 6 7 8 9 LO 11 fx Function: SUM; Formula: Divide; Cell Referencing 234567 B Costs for production Total material costs Total conversion costs Equivalent units of production Materials Conversion costs C $ 33,000 54,000 10,000 12,000 D E F G Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem or work area as indicated. Compute the unit costs for materials, conversion costs, and total manufacturing costs. Unit materials cost H Unit conversion cost Total unit manufacturing cost K