Question: Please help me with inserting the cell references!! I keep getting the solution right but the cell reference equations wrong Using Excel to Cost Inventory

Please help me with inserting the cell references!! I keep getting the solution right but the cell reference equations wrong
Using Excel to Cost Inventory
PROBLEM
In its first month of operations, McLanie Company made three purchases. Information concerning these purchases and units on hand are:
Units on hand at period end
Purchases of merchandise were made in the sequence listed above.
Student Work Area
Required: Provide input into cells shaded in yellow in this template.Use only mathematical formulas with cell references to compute the unit cost and the cost of ending inventory.
Compute the cost of the ending inventory under the average-cost method in a periodic inventory system.
Weighted-average unit cost
\(=(\mathrm{C}10*\mathrm{E}10+\mathrm{C}11*\mathrm{E}11)+\mathrm{C}12*\mathrm{E}12)/\mathrm{C}10+\mathrm{C}11+\mathrm{C}12\)
Round unit cost to 3 decimals using the ROUND function
Cost of ending inventory
Please help me with inserting the cell

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!