Merge & Center % 2 00 - Conditional Format as Cell Insert Delete Format Formatting ~ Table Styles ~ Filt Clipboard Font Alignment Number Styles Cells Ed A1 fx Formula: Multiply; Cell Referencing C D G H Q R Formula: Multiply; Cell Referencing 2 3 Using Excel to Determine Ending Inventory Student Work Area PROBLEM Required: Provide input into cells shaded in yellow in this 5 In its first month of operations, McLanie Company made template. Use a cell references and mathematical 6 three purchases of merchandise in the following sequence formulas for calculations. Purchase $ Units Unit Cost 300 at $ 6.00 Compute the cost of the ending inventory under the 10 400 at WN 8.00 a. FIFO method 11 500 at 9.00 12 Units Unit Cost Total Cost 13 McLanie uses a periodic inventory system. It also provided FIFO 200 14 the following information: 15 Compute the cost of the ending inventory under the 16 Units on hand 200 b. LIFO method 17 18 Units Unit Cost Total Cost 19 LIFO 200 20 21 22 Enter Answer + Ready Accessibility: Investigate 16 17 18 19 20 Search D L O V E W X O C hp