S27 X v D E FI G H M N O P Q R B 1 Given Data: Jan. 1 Beginning inventory 3. Feb. 20 Purchased May 16 Purchased 5 Dec. 11. Purchased 5 Units available for sale Moving 510 units @ $ 26 $ 13,260 1.410 units @ $ 28 $ 39,480 610 units @ $ 32 $ 19,520 Type your class here> 3,210 units @ $ 33 = $ 105,930 Excel Templates Problem 6 8A 5,740 Analysis Date Jan. 1 3 Sales price per unit $81 If the manager of Fresh Express Company ears a bonus based on a percentage of gross profit, which method of inventory costing will she prefer? Feb. 20 0 Sales units 1 Sept. 10 2,410 units 2 Dec. 22 2,550 units 3 Operating expenses per unit $ 11 4 5 Z Excel Templates Problem 6-8A B Part 1a (Place your answer on the sheet below. If you click near the middle of the sheet, a blinking cursor will appear in the upper left comer of the sheet. If you click on the curled portion of the sheet in the lower right comer, the sheet will be selected so that you can increase or decrease its size) May 16 D FIFO perpetual Purchases Balance Sales (at cost) Cost of Unit Cost Goods Sold Units Units Unit Cost Total Cost Date Jan. 1 Units Unit Cost Total Cost Beginning inventory 510 S 26.00 S 13,260.00 1 sType your name here> Sept. 1 2. Type your class here> 31. Excel Templates Problem 6-8A 4 Part 1 Dec. 11 5 See 'FIFO' and 'Moving Average for supporting calculations 6 FRESH EXPRESS COMPANY Dec. 22 Income Statement Comparing FIFO and Moving Weighted 8 Average Inventory Costing Methods 9 For Year Ended December 31, 2020 Totals 10 Moving Weighted 11 FIFO Average 12 Sales $ -0- $ -0- + 13 Cost of goods sold -0 -0- 14 Gross profit -0 -0- 15 Operating expenses -0 -0- 16 Profit $ -0-$ -0- Feb. 20 May 16 Sept. 10 Dec. 11