i need help finishing. please show formulas

F12 A E - C D F B K L G H 88 16 1 Problem 17.1A 2 You are only required to do the LIFO calculations for this spreadsheet. 3 4 Units Cost/Unit Total Cost 5 Beginning Inventory 200 113 $22,600 6 Purchases: 7 6-Jan 140 112 $15,680 8 15-Jan 108 112 $12,096 9 22-Jan 106 $9,328 10 Goods Available 536 $59,704 11 Ending inventory 200 $22,600 Withers, Breck: 12 #Units/Cost of Goods Sold 336 Formula Required. Hint: Use the COGS formula to 13 Correct simply subtract the ending 14 inventory value from the 15 LIFO Ending Inventory Valuations (Remember: Last-in, First-out means the OLDEST units are still in inventory): Units Cost/Unit Total Cost 17 200 113 $22,600 18 19 LIFO Cost of Goods Sold Calculations (consider which "layers" have been sold): 20 21 Units Cost/Unit Total Cost 22 6-Jan 23 15-Jan 24 22-Jan 25 Totals 26 27 28 29 30 31 32 33 34 35 36 37