Question

Samuelson and Messenger (S&M) began 2018 with 300 units of its one product. These units were purchased near the end of 2017 for $22 each. During the month of January, 200 units were purchased on January 8 for $25 each and another 260 units were purchased on January 19 for $27 each. Sales of 190 units and 200 units were made on January 10 and January 25, respectively. There were 370 units on hand at the end of the month. S&M uses a periodic inventory system.

Required:


1. Calculate ending inventory and cost of goods sold for January using FIFO.


2. Calculate ending inventory and cost of goods sold for January using average cost.

Answer 1

1. ending inventory $9,770 and cost of goods sold $8,850

2.ending inventory $9,135.30 and cost of goods sold $9,346

Step-by-step explanation:

FIFO Inventory System Sells the Older Inventory Acquired First Followed by the Recent Acquired Inventory

Cost of Sale :

10 January (190 units × $22) = $4,180

25 January : (110 units × $22) = $2,420

(90 units × $25) = $2,250

Total = $8,850

Inventory :

110 units × $ 25 = $2,750

260 units × $27 = $7,020

Total = $9,770

Weighted Average Cost Method Calculates a New Cost of Inventory with each purchase made

New Cost 8 January

Unit Cost = Total Cost / Total Number of Units

=((300 units × $22) + (200 units × $ 25)) / (300 units + 200 units)

= $23.20

New Cost 19 January

Unit Cost = Total Cost / Total Number of Units

=((310 units × $23.20) + (200 units × $ 27)) / (310 units + 200 units)

= $24.69

Cost of Sale :

10 January (190 units × $23.20) = $4,408

25 January : (200 units × $24.69) = $4,938

Total = $9,346

Inventory :

370 units × $24.69 = $9,135.30