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 averagecost method in a periodic inventory system.
Weightedaverage unit cost
mathrmCmathrmEmathrmCmathrmEmathrmCmathrmEmathrmCmathrmCmathrmC
Round unit cost to decimals using the ROUND function
Cost of ending inventory
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
