Oyin Limited purchases and sells identical articles. The table below shows the inventory movement in the store, and the company has a policy of using the weighted average cost method in its storekeeping. The company’s accounting period ends on December 31 each year.

Month Quantity Purchased Unit Price (₦) Quantity Issued/Sold
Brought Forward 150 100
February 2020 350 150
April 2020 340
June 2020 440 180
August 2020 420
October 2020 420 210
December 2020 360

Required:
Present a table of the inventory movements from January to December 2020 and show the cost of inventory on December 31, 2020.

a)

Oyin Limited
Inventory ledger account, using weighted average cost