Assume that ABC Company sells one product. The January activity for that product follows: Jan 1 Jan 4 Jan 11 Jan 13 Jan 20 Jan 24 Jan 27 Inventory Sale Purchase Sale Purchase Purchase Sale 90 units @ $11 each 75 units@ $20 each 120 units @ $15 each 75 units @ $23 each 160 units $18 each 60 units@ $20 each 200 units @ $22 each A) Using an EXCEL spreadsheet and formulas within the Spreadsheet, prepare all journal entries for the month including any month-end closing entries assuming that the company uses the PERIODIC and LIFO methods. Compute the COGS and Ending Inventory values as of 1/31. A physical count of the warehouse finds total units remaining is 80. B) Ignore your answer to A). Using an EXCEL spreadsheet and formulas within the Spreadsheet, prepare all journal entries for the month including any month-end closing entries assuming that the company uses the PERPETUAL and FIFO methods. Compute the COGS and Ending Inventory values as of 1/31. A physical count of the warehouse finds total units remaining is 80. C) Ignore your answers to A) & B). Using an EXCEL spreadsheet and formulas within the Spreadsheet, prepare all journal entries for the month including any month-end closing entries assuming that the company uses the PERPETUAL and Average Cost methods. Compute the COGS and Ending Inventory values as of 1/31. A physical count of the warehouse finds total units remaining is 80.