Question

Assume that we use a perpetual inventory system and that five identical units are purchased at the following dates and costs: April 5 $10 April 10 $12 April 15 $14 April 20 $16 April 22 $17 One unit is sold on April 25. The company uses the weighted average inventory costing method. Identify the cost of the ending inventory on the balance sheet. (Round your answer to 2 decimal places.)

Answer 1

Answer:

Cost of goods sold on April 25 is $13.80 and the inventory balance is $55.20

Explanation:

Data given:total unit

Cost of purchase with  data;

Date                  Amount

April 5                 $10

April 10                $12

April 15                $14

April 20                 $16

April 22                 $17

Total cost             69    

Average cost = total cost /total quantity

                       = 69/5

                       =13.8

The cost of the ending inventory is given on the balance sheet below

Date      Purchases              Cost of            Inventory Bal.   Avg Cost

                                            goods sold

April 5   $10* 1 unit= $10                -                        $10               10/1 = $10

April  10  $12* 1 unit=$12               -               10+ 12 = 22            22/2 = 11

April  15   $14* 1 unit=$14                  -           22+14 =36              36/3 = 12

April 20   $16* 1 unit= $16                  -          36 +16 =52            52/4 = 13

April 22    $17* 1 unit = $17                 -          52+17 =69            69/5 = 13.8

April 25             -           1 unit*13.8 = 13.80      69 - 13.8 = 55.20