now . Cell A17: Use CONCAT to enter the text LIFO Inventory Balance: (with colon). (PG-4a) . Cell B17: Enter a formula that calculates the ending inventory balance under LIFO. (PG-4b) Row 18: . Cell A18: Use CONCAT to enter the text FIFO Inventory Balance: (with colon). (PG-4C) . Cell B18: Enter a formula that calculates the ending inventory balance under FIFO. (PG-4C) Row 19: . Cell A19: Use CONCAT to enter the text WA Inventory Balance: (with colon). (PG-4d) . Cell B19: Enter a formula that calculates the ending inventory balance under the weighted average method. (PG-4d). . . A B C D E F G Construction Paper 2 Inventory Costing Method Comparison 4 Methods to be used: Units in Ending Inventory: 571 5 Last-In, First-Out 6 First-In, First-Out Weighted Average 8 Cost per 9 Units Unit Total 10 Beginning Inventory 490 14 $ 6,860 11 Purchase #1 127 S 15 $ 1,905 12 Purchase #2 240 17 $ 4,080 13 Purchase #3 85 18 $ 1,530 14 Purchase #4 505 19 $ 9,595 15 1447 $ 23,970 16