BMCC Fall 2020 Homework #3 (1) (Protected View] - Excel (Unlicensed Product) Ga Share X File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing i SUBSCRIPTION EXPIRED Most of the features of Excel have been disabled. . Reactivate SIGN IN TO OFFICE It looks like your stored credentials are out of date. Please sign in as moharrimadsarrinbiswas 1996@gmail.com so we can verify your subscription. D19 fi Sign In X M N o Q R S T FIFO Purchases Cost of Goods Sold Unit Total Cost Cost Date Quantity Total Cost Quantity Quantity Cost B . D E F G H H 1 1 10 points 2 Ornamental Iron Works began Jan with 45 units of iron inventory that cost $24 each. 3 During January the company completed the following inventory transactions: 4 5 Units Unit Cost Unit Sale Price b 3-Jan Sale 35 $51.00 7 8 Purchase 70 $32.00 8 21 Sale 65 $73.00 9 30 Purchase 25 $47.00 10 10 11 Requirements: 12 1 Prepare a pepetual inventory record for the inventory using FIFO 13 13 2 Prepare a pepetual inventory record for the inventory using LIFO 14 3 Prepare a pepetual inventory record for the inventory using average cost 15 4 Determine the company's cost of goods sold for Jan using FIFO, LIFO, and Average Cost 16 " 5 Compute gross profit for January using FIFO, LIFO, and Average cost 17 18 19 20 21 22 Chapter 5 Chapter 6 + Tatals LIFO 100% I Type here to search ( 3:17 AM 11/13/2020 5 BMCC Fall 2020 Homework #3 (1) (Protected View] - Excel (Unlicensed Product) Ga Share X File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do PROTECTED VIEW Be careful_files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing SUBSCRIPTION EXPIRED Most of the features of Excel have been disabled. Reactivate SIGN IN TO OFFICE It looks like your stored credentials are out of date. Please sign in as moharrimadsarrinbiswas 1996@gmail.com so we can verify your subscription D19 fi Sign In X B D E F G H 1 J L M N Q Q R S LIFO Purebases Liit Cost of Goods Sold Uut Total Cost Cost Date Quantity Total Cost Quantity Quantity Cost 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 2 36 37 38 39 40 40 41 42 43 Totals Averape Cost Purchases Cost of Goods Sold Unit tinit Date Quantity Total Cost Quantity Total Cost Quantity Cost Cost Chapter 5 Chapter 6 + E 100% I Type here to search 3:18 AM 11/13/2020