Excel McGraw Hill Excel Question - Saved Search (Option - Q) File Home Insert Draw Formulas Data Review View Help Calibri 11 B General 122 A c D G 2 Required: Determine the cost assigned to ending inventory and to cost of goods sold using FIFO 3 4 Date Activities Units Acquired at Cost Units Sold at Retail Units Cod per unit Tutal cost Units Selling Total Sales price per unit 6 January 01 Beginning inventory 150 $7.50 $1.125.00 January 09 Sales 110 $16.50 $1.815.00 B January 19 Purchase 80 56 50 520.00 9 January 25 Sales 90 $16.50 1.485,00 10 January 30 Purchase 11 Totals 200 430l $6.00 1,200.00 $2.845.00 200 $3,300 00 12 13 21 *220*28GRAP 16 Perpetual FIFO Units available 150 units from beginning inventory 80 units purchased on January 19 200 units purchased on January 30 Units Cost of Goods Sold-Jan 9 Cost Cost of per unit goods sold Cost of Goods Sold-Jan 25 Units Cest Cunt of perunt gods sol Ending inventory Cint per unit Inventory $7.50 $750 $7.50 50.50 56 50 $6.50 5600 56.00 $6.00 Total 0 50.00 50.00 0 50.00 23 Students: The scratchpad ares is for you to do any additional work you need to solve this question or can be used to show your work Question Date BFIFO LIFO + Calculation Mode Automatic Workbook Statistics M N 0 P O McGraw Check A Check Legend: Graded needed. Scratch workspace Save i Gvm 234 File Home Insert Draw Formulas Data Review View Help Calibri BBY A General A1 A f Accessibility tab summary: A statement for student presentation is provided in row 2. A table for student presentation is provided in Cells A4 to K B D E F 2 Required: Determine the cost assigned to ending inventory and to cost of goods sold using LIFO. G H K M Date Activities Units Units Acquired at Cost Cost Total cost per unit Units Sold at Retail Units Selling price per Total Sales S unit 6 January 01 Beginning inventory 150 $7.50 $1,125.00 7 January 09 Sales 110 $16.50 $1,815.00 8 January 191 Purchase 80 $6.50 520.00 9 January 25 Sales 90 $16.50 1,485.00 10 January 30 Purchase 11 Totals 200 430 $6.00 1,200.00 $2,845.00 200 $3,300.00 12 13 Perpetual LIFO 14 Units available Cost of Goods Sold - Jan 9 Units Cost Cost of per unit goods sold Cost of Goods Sold-Jan 25 Units Cost Cost of Ending Inventory Units per unit goods sold Cost per unit Inventory 15 150 units from beginning inventory $7.50 $7.50 $7.50 16 80 units purchased on January 19 $6.50 $6.50 $6.50 17 200 units purchased on January 30 $6.00 111 $6.00 $6.00 18 Totals 0 $0.00 $0.00 $0.00 19 = Question Data FIFO LIFO + Calculation Mode: Automatic Workbook Statistics tv A