F Proverka Control # 2 (2).xlsx : B D E G H 1 J 1 2 First in, First out, FIFO 3 PURCHASES SALES CPU STOCK BALANCE AT THE END CPU CPU 4 month action units total unit Total Units Total 5 January 100 50 5000 6 February purchases bal I purchases bal 7 50 55 2750 8 March bal Sales 10 30 11 April bal 12 bal purchases 13 80 61 4880 14 May bal bal 15 16 Sales 110 17 June 18 bal bal Sales 19 50 20 21 Total 230 12630 190 40 22 23 Inventory balance = 230 units = 190 (sold) +40 (stock at the end) 12630 = 24 25 26 27 28 Last in, First out LIFO 29 SALES CPU STOCK BALANCE AT THE END Units CPU Total 30 PURCHASES CPU 100 month units total unit Total 31 January 50 5000 action purchases bal purchases 32 February 33 50 55 2750 34 March bal bal 35 36 Sales 30 37 April 38 bal bal purchases bal 39 80 61 4880 40 May 41 bal Sales 42 110 43 June bal bal 44 45 Sales 50 46 47 Total 230 12630 190 40 48 49 Inventory balance = 230 units = 190 (sold) + 40 (stock at the end) 12630 = 50 51 52 53 54 AVCO (Average Cost) 55 SALES CPU STOCK BALANCE AT THE END Units CPU Total 56 PURCHASES CPU 100 month units total unit Total 57 January 50 5000 action purchases bal purchases 58 February 59 50 55 2750 60 March bal 61 bal Sales 62 30 63 April bal 64 bal purchases 65 80 61 4880 66 May bal bal 67 68 Sales 110 69 June bal 70 bal 71 Sales 50 72 73 Total 230 12630 190 40 74 75 Inventory balance = 230 units = 190 (sold) +40 (stock at the end) 12630 76 77 78 79 FIFO AVCO 80 Income Statement for the 6 months LIFO 1. Sales 14720 14720 2. Cost of Sales: Opening stocks 14720 81 82 Sheet1 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 Income Statement for the 6 months FIFO LIFO AVCO 1. Sales 14720 14720 14720 2. Cost of Sales: Opening stocks Purchases Closing Stock Cost of Goods Sold 3. Gross Profit