1.518,545 Excel 1st F32 260 PR 7-58 Periodic inventory by three methods OBJ. 2,4 Pappa's Appliances uses the periodic inventory system. Details regarding the inventory of appliances at January 1, purchases invoices during the year, and the inventory count at December 31 are summarized as follows: Purchases invoices Inventory Inventory Count. Model January 1 2nd 3rd December 31 CSS 3 at $1,040 3 at $1,054 3 at $1,060 3 at $1,070 9 at 639 7 at 645 6 at 666 6 at 675 11 Sat 240 3 at 1 at 260 1 at 280 H29 6 at 305 3 at 310 3 at 316 4 at 317 4 K47 6 at 520 8 at 531 4 ar 549 6 at 542 8 533 4 at 222 4 at 232 X74 4 at 35 6 at 36 8 at 37 7 at 39 7 Instructions 1. Determine the cost of the inventory on December 31 by the first-in, first-out method. Present data in columnar form, using the following headings Model Quantity Unit Cost Total Cost If the inventory of a particular model comprises one entire purchase plus a portion of another purchase acquired at a different unit cost, use a separate line for each purchase. 2. Determine the cost of the inventory on December 31 by the last-in, first-out method. following the procedures indicated in (1). 3. Determine the cost of the inventory on December 31 by the weighted average cost method, using the columnar headings indicated in (1), Discuss which method (FIFO or LIFO) would be preferred for income tax purposes in periods of (a) rising prices and (b) declining prices