Ch 6 Excel Assignment Inventory cost flow assumptions 3-18-2021 (7) Protected View Search (Alt+Q) out Formulas Data Review A B View Help D E F G H 1 Before you begin, print out all the pages in this workbook. 2 3 Northgate Products Corp. sells gadgets and uses the perpetual inventory system. During the 4 month of January 2019, the number of gadgets purchased and sold was as follows: 5 6 Purchased Sold Balance in inventory 7 Date 8 Units Unit cost Total $ Units 9 Unit cost Total $ Units Unit cost $2 Total $ 200 Jan. 1 10 3 400 $3 11 8 400 $5 12 10 700 13 15 300 $7 2000 14 20 300 15 27 400 $7 16 17 Units were sold for the following amount: 18 Jan 10 19 Jan 20 20 $11 $12 21 *for specific identification, units sold on June 10 came from: Opening inventory 22 23 Jan. 3 purchase 24 Jan. 8 purchase 25 26 0 380 320 700 27 **for specific identification, units sold on June 20 came from: 28 Opening inventory 0 29 Jan. 3 purchase 0 30 Jan. 8 purchase 60 31 Jan. 15 purchase 240 ose 22 200 Required FIFO LIFO Spec. Ident. Wtd. Avg. Jnl. Entries Compare M