Question: 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





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 $ 76.00/unit. Calculate amounts for () through (p) to Assist Empire's management by completing the table. (Round calculations for cost per unit to 4 decimal places, c.8. 10.5264 and other answers to 0 decimal places, c.3, 61,052.) Date Units Cost/Unit Amount Jan 1 Beginnig Inventory 8.400 $29.70 $24 3 (7.500) (c) $29.70 $ 13 Purchase 4.600 $32.40 $14 5,500 $ (e) $ 1: 17 Purchase 700 $37.40 $ 6,200 $ (0 $26 27 Sale (3.500) 2.700 $32 5726 $ Date Units Cost/Unit o Amount Ace Jan 1 Beginnig Inventory 8.400 $29.70 $24 3 Sale (7.500 Qu Acco (c) $29.70 $ Vie Acco 13 Purchase 4,600 $32.40 $14 Que Accou 5,500 $ (e) $11 17 Purchase 700 $ 37.40 $4 Ques Accoun 6,200 () $20 27 Sale Quest Account (3,500) 2,700 $325726 SE Questi Account 29 Purchase (0) $ 40,00 $10 Questio Account 5,300 $ $15 31 Sale (k) Question Accounting 2.300 $36.2161 5 Question COGS Sales Init Amount $ 29.70 $ 249,480 $ b (b) $29.70 (d) $32.40 $ 149,040 le) $ 175,770 $37.40 $ 26,180 00 $ 201,950 $ ( (g) $ (h) $32.5726 $ 87.946 $ 40,00 $ 104.000 $191.946 $ (m) $36.2161 (n) 3 Sale (7.500) (c) $29.70 $ $ 149,0 13 Purchase 4,600 $32.40 5,500 $ (e) $ 175,7 17 Purchase 700 $37.40 $ 26,1 6,200 (f) ) $ 201,9 27 Sale (3,500) 2,700 $32.5726 $ 87,9 29 Purchase 00 $ 40.00 $ 104,0 5.300 $ $ $191,9 1 31 Sale (k) 2,300 $36.2161 $ Totals $ 29.70 (d) $32.40 $ 149,040 le) $ 175,770 $ 37.40 $26.180 (6) $ 201,950 $ (8) $ $ (h) $32.5726 $87.946 $ 40.00 $ 104,000 0) $191,946 $ 00 (1) $ (m) $36.2161 $ (o) $ (p) ) Using the information in the completed table. (Round calculations for cost per unit to 4 decimal places. e.3. 10.5264 and other answers to o decimal places, c.8. 61,052.) IL Determine the value of weighted average cost of goods sold. Determine the value of ending inventory Determine the gross marpin li Weighted average cost of goods sold $ Ending inventory $ Gross marin 5
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
