Fupction. SuM. Divide. Cell Referencino

Function: SUM; Divide; Cell Referencing BEI 1.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 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 indicated. How much total cost does Funenstiens need to account for this month? production that is presented here. Direct materials costs added to production Conversion costs added to production Direct materials costs in beginning inventory Conversion costs in beginning inventory Equivalent units completed during the month For Direct materials For conversion costs 3,400 3,875 600 800 4,600 4,450 Direct Materials Conversion Costs Tota I Total costs to account for Determine the company's cost per equivalent unit for both DM and conversion costs. For the current month. Direct Materials Cost per equivalent unit Conversion Costs