81 9 . 1 2 Function: SUM; Divide; Cell Referencing BE11.7-Using Excel to Calculate Cost per Equivalent Unit PROBLEM Funenstiens roasts peanuts and uses the FIFO method of process costing. roasting process The company has provided information relating to this month's production that is presented here. Direct materials costs added to production $ 3,400 Student Work Area Required: Provide input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as How much total cost does Funenstiens need to account for this month? Conversion costs added to production 3,875 Direct Materials Conversion Costs Total Direct materials costs in beginning inventory 600 Conversion costs in beginning inventory 800 Total costs to account for Equivalent units completed during the month For Direct materials 4,600 For conversion costs 4,450 Determine the company's cost per equivalent unit for both DM and conversion costs. For the current month. Cost per equivalent unit Direct Materials Conversion Costs