In: Accounting
Stevens Ltd is the leading retailer of Gym equipment. The following information occurred during May 2020. Stevens Ltd had an opening inventory balance of $8,400,000.
May
1 Returned to the suppliers $80,000 of the opening inventory and received cash.
12 Purchased additional inventory on credit from the supplier for $12,000,000.
18 Sold inventory for $6,000,000 cash (Cost price to Stevens Ltd $2,400,000).
19 Paid the suppliers the account from 12 May.
31 The closing stocktake at year-end revealed an inventory balance of $17,800,000.
Required:
I need this ASAP.
a.
Date | Account Titles | Debit | Credit |
May-01 | Cash | $ 80,000 | |
Inventory | $ 80,000 | ||
May-12 | Inventory | $ 12,000,000 | |
Accounts Payable | $ 12,000,000 | ||
May-18 | Cash | $ 6,000,000 | |
Sales Revenue | $ 6,000,000 | ||
Cost of Goods Sold | $ 2,400,000 | ||
Inventory | $ 2,400,000 | ||
May-19 | Accounts Payable | $ 12,000,000 | |
Cash | $ 12,000,000 | ||
May-31 | Cost of Goods Sold | $ 120,000 | |
Inventory | $ 120,000 |
b.
Date | Account Titles | Debit | Credit |
May-01 | Cash | $ 80,000 | |
Purchase Returns | $ 80,000 | ||
May-12 | Purchases | $ 12,000,000 | |
Accounts Payable | $ 12,000,000 | ||
May-18 | Cash | $ 6,000,000 | |
Sales Revenue | $ 6,000,000 | ||
May-19 | Accounts Payable | $ 12,000,000 | |
Cash | $ 12,000,000 | ||
May-31 | Inventory, Ending | $ 17,800,000 | |
Purchase Returns | $ 80,000 | ||
Cost of Goods Sold | $ 2,520,000 | ||
Inventory, Beginning | $ 8,400,000 | ||
Purchases | $ 12,000,000 |
c.
Income Statement | |
Sales Revenue | $ 6,000,000 |
Cost of Goods Sold | $ 2,520,000 |
Gross Profit | $ 3,480,000 |
d. Advantages
1. Gives details of inventory on each date and helps in maintaining
appropriate amount of stock and also helps in preventing stock
out.
2 It reduces investment in material, since real time position of inventory is known.