Calculate a) cost of goods sold, b) ending inventory, and c) gross margin for A76 Company, considering the following transactions under three different cost allocation methods and using perpetual inventory updating. Provide calculations for first-in, first-out (FIFO).   Number of Units Unit Cost Sales Beginning Inventory 260     $140        Sold 160        $180   Purchased 510     143        Sold 400        182   Purchased 420     150        Sold 370        184   Ending Inventory 260           FIFO (perpetual) Inventory   Cost of Goods Purchased Cost of Goods Sold Cost of Inventory Remaining   Number of Units Unit Cost Total Cost Number of Units Unit Cost Total Cost Number of Units Unit Cost Total Cost Beginning             fill in the blank 1 $fill in the blank 2 $fill in the blank 3 Sale       fill in the blank 4 $fill in the blank 5 $fill in the blank 6 fill in the blank 7 fill in the blank 8 fill in the blank 9 Purchase fill in the blank 10 $fill in the blank 11 $fill in the blank 12       fill in the blank 13 fill in the blank 14 fill in the blank 15               fill in the blank 16 fill in the blank 17 fill in the blank 18 Sale       fill in the blank 19 fill in the blank 20 fill in the blank 21               fill in the blank 22 fill in the blank 23 fill in the blank 24 fill in the blank 25 fill in the blank 26 fill in the blank 27 Purchase fill in the blank 28 fill in the blank 29 fill in the blank 30       fill in the blank 31 fill in the blank 32 fill in the blank 33               fill in the blank 34 fill in the blank 35 fill in the blank 36 Sale       fill in the blank 37 fill in the blank 38 fill in the blank 39               fill in the blank 40 fill in the blank 41 fill in the blank 42 fill in the blank 43 fill in the blank 44 fill in the blank 45   Total Purchases $fill in the blank 46 Total COGS $fill in the blank 47         Gross Margin, FIFO perpetual Sales $fill in the blank 48 COGS fill in the blank 49 Gross Margin $fill in the blank 50

REQUIRED: Determine the cost assigned to ending inventory and to cost of goods sold using LIFO. Each yellow cell must include a formula using cell references, EVEN IF THE FORMULA RESULT IS ZERO. Date Jan. 1 Beginning inventory Jan. 11: Sales Jan. 15 Purchase Jan. 17: Sales Jan, 21:Purchase Jan. 23: Sales Totals Units purchased Cost of Goods Sold - Perpetual LIFO: 560 840 890: Ending Inventory-Perpetual LIFO: 2,290 Calculate cost of goods sold for the January 11 sale of 450 units. Calculate cost of goods sold for the January 17 sale of 670 units. Cost per unit $14 17 19 Units Sold 450 Total Cost of Goods Sold for January - 1,920 units Units in Ending Inventory Total Cost Units Sold Selling Price Total Sales of Purchase per unit Total Ending Inventory for January - 370 units $7,840 14,280 16,910 $39,030 units @ units units@ 450 670 800 1,920 Cost per unit $14 $14 Cost per unit $40: $40 $40 per unit= units @ units $18,000 26,800 32,000 $76,800 Cost of Goods Sold $6,300 Inventory Balance

Required: 2. Determine the cost assigned to ending inventory and to cost of goods sold using weighted average. Date January 01 January 10 January 20 January 25 January 30 Date January 01 January 10 January 20 January 25 January 30 Activities Beginning inventory Sales Purchase Sales Purchase Totals Weighted Average Activities Beginning inventory Sales Purchase Sales Purchase Totals Units Units Acquired at Cost Cost 195 290 605 Units 120 $11.00 155 per unit 135 $12.00 290 Cost of Goods Sold Cost per unit $10.50 Total cost $2,340.00 $1,320.00 $3,045.00 $6,705.00 Cost of goods sold $0.00 Units 155 135 290 Units 195 Units Sold at Retail Selling price per unit $21.00 $21.00 Inventory Balance Cost per unit $12.00 Total Sales $3,255.00 $2,835.00 $6,090.00 Total Cost $2,340.00

Given the following:     Numberpurchased Costper unit Total January 1 inventory 39 $ 5   $ 195 April 1 59   8     472 June 1 49   9     441 November 1 54   10     540   201       $ 1,648   a. Calculate the cost of ending inventory using the FIFO (ending inventory shows 60 units).   b. Calculate the cost of goods sold using the FIFO (ending inventory shows 60 units).