Please see the picture below. I cannot figure this out. I know I have the right answer but the formula seems to be wrong for the first box and the sumproduct formula didn't work either. Please be sure to include the appropriate cell reference and order of operations.

IV Formatting as Table SE fx =(E10*C10+E11*C11+E12C12)/(C104C11+C12) A B D E F G 1 J L M N 1 Function: ROUND; Formula: Add, Multiply, Divide; Cell Referencing 2 3 Using Excel to Cost Inventory Student Work Area 4 PROBLEM Required: Provide input into cells shaded in yellow in this template.Use only 5 In its first month of operations, McLanie Company made three purchases. mathematical formulas with cell references to compute the unit cost and the 6 Information concerning these purchases and units on hand are: cost of ending inventory. 0 Q R 00 9 Units Cost per Unit 10 300 $ 6.00 11 400 8.00 12 500 9.00 13 14 Units on hand at period end 200 15 16 Purchases of merchandise were made in the sequence listed above. 17 Compute the cost of the ending inventory under the average-cost method in a periodic inventory system. Incorrect Weighted average unit cost $5+ 7.91667 Score: 0.0 out of 0.417 Feedback: The cost of each purchase is determined Round unit cost to 3 decimals using the 7.917 by multiplying the cost per unit by the units ROUND function acquired. These purchase cost amounts are added and divided by the total units of the three purchases. Cost of ending inventory $ 1,583.40 All amounts must be cell referenced to the Problem area and formulas must be used to add, multiple and divide the respective amounts. 18 19 20 21