5

Empire Stores experienced a computer malfunction that accidently wiped out some of the inventory details for the month of January Management was able to partially reconstruct the following spreadsheet for the month of January inventory transactions: Empire uses the perpetual inventory system and the weighted average cost flow assumption for valuing inventory. All units sold in January were priced at $72.00/unit. Calculate amounts for (a) through (p) to Assist Empire's management by completing the table. (Round calculations for cost per unit to 4 decimal places, e.g. 10.5264 and other answers to 0 decimal places, eg. 61,052) Date Units Cost/Unit Amount 4 8.300 Jan 1 Beginnig Inventory $: Sale (7.700) 600 Purchase 4,400 5,000 Purchase 800 3 13 17 (c) $27.10 $27.10 $29.60 $34.60 in $1 51 24 17 Purchase 27 Sale 29 Purchase. 31 Sale Totals 5,000 800 5,800 (3,600) 2,200 4,900 2.000 D(i) (k) $ $ $34.60 $30,0310 $37.10 $33.9260 (e) (F) $1 $ $1 $1 $1 Using the information in the completed table. (Round calculations for cost per unit to 4 decimal places, eg 10.5264 and other answers to 0 decimal places, eg. 61,052) L Determine the value of weighted average cost of goods sold. Determine the value of ending inventory. Determine the gross margin. Weighted average cost of goods sold $ $ Ending inventory $ Gross margin eTextbook and Media ii. it $27.10 $27.10 $29.60 $34.60 300010 $37.10 (e) (f) ( $ Amount $224,930 16260 $130,240 $146.500 $27,680 $174,180 $66.068 $100.170 $166.238 (d) $ COGS 208670 (a) $ Sales 554400 (b) (h) $34.60 30.0310 $37.10 (f) $33.9260 ( $ eTextbook and Media $27,680 $174,180 $66,068 $100,170 $166,238 $ $ $ $ (1) $ (0) $ (h) (m) (p)