Excel Spreadsheet please! 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 00 units s15 each s units @ $20 each o units $17 each 120 units $21 each 90 units @ $18 eaclh s0 units @ $19 each 100 its $22 each Prepare all journal entries for the month including any month-end closing entries assuming that the company uses the PERIODIC and LIFO methods. A) Jan 31: Compute cost of goods sold and Ending Inventory values. A physical count of the warehouse finds total units remaining is ss. B) Ignore A: prepare all journal entries for the month including any month-end closing entries assuming that the company uses the PERPETUAL and FIFO methods. Jan 31: Compute COGS and Ending Inventory values A physical count of the warehouse finds total units remaining is ss