In: Accounting
Boston Cycles started October with 12 bicycles that cost $42 each. On October 16, Boston bought 40 bicycles at $68 each. On October 31, Boston sold 34 bicycles for $100 each. Preparing a perpetual inventory record and journal entries—FIFO Requirements
1.PrepareBostonCycle’sperpetualinventoryrecordassumingthecompanyusesthe FIFO inventory costing method.
2. Journalize the October 16 purchase of merchandise inventory on account and the October 31 sale of merchandise inventory on account.
S6-5 Preparing a perpetual inventory record and journal entries—LIFO Requirements
1. PrepareBostonCycle’sperpetualinventoryrecordassumingthecompanyusesthe LIFO inventory costing method.
2. Journalize the October 16 purchase of merchandise inventory on account and the October 31 sale of merchandise inventory on account.
Solution:
Requirement 1:
As per FIFO Inventory System
Date | Purchases | Cost of Goods Sold | Inventory on Hand | ||||||
Quantity | Unit Cost | Total Cost | Quantity | Unit Cost | Total Cost | Quantity | Unit Cost | Total Cost | |
Oct. 1 | 12 | $ 42 | $ 504 | ||||||
Oct. 16 | 40 | $ 68 | $ 2,720 | 12 | $ 42 | $ 504 | |||
40 | $ 68 | $ 2,720 | |||||||
Oct. 31 | 12 | $ 42 | $ 504 | 18 | $ 68 | $ 1,224 | |||
22 | $ 68 | $ 1,496 | |||||||
Totals | 40 | $ 68 | $ 2,720 | 34 | $ 2,000 | 18 | $ 68 | $ 1,224 |
Journal Entries:
Date | Account Titles and Explanation | Debit | Credit |
Oct. 16 | Inventory | $ 2,720 | |
Account Payable | $ 2,720 | ||
(To record inventory purchased) | |||
Oct. 31 | Account Receivable [$ 34*100 ] | $ 3,400 | |
Sales | $ 3,400 | ||
(To record sales made) | |||
Oct. 31 | Cost Of Goods Sold | $ 2,000 | |
Inventory | $ 2,000 | ||
( To record Cost of goods sold) |
Requirement 2:
As per LIFO Inventory System
Date | Purchases | Cost of Goods Sold | Inventory on Hand | ||||||
Quantity | Unit Cost | Total Cost | Quantity | Unit Cost | Total Cost | Quantity | Unit Cost | Total Cost | |
Oct. 1 | 12 | $ 42 | $ 504 | ||||||
Oct. 16 | 40 | $ 68 | $ 2,720 | 12 | $ 42 | $ 504 | |||
40 | $ 68 | $ 2,720 | |||||||
Oct. 31 | 34 | $ 68 | $ 2,312 | 6 | $ 68 | $ 408 | |||
12 | $ 42 | $ 504 | |||||||
Totals | 40 | $ 68 | $ 2,720 | 34 | $ 2,312 | 18 | $ 912 |
Journal Entries:
Date | Account Titles and Explanation | Debit | Credit |
Oct. 16 | Inventory | $ 2,720 | |
Account Payable | $ 2,720 | ||
(To record inventory purchased) | |||
Oct. 31 | Account Receivable [$ 34*100 ] | $ 3,400 | |
Sales | $ 3,400 | ||
(To record sales made) | |||
Oct. 31 | Cost Of Goods Sold | $ 2,312 | |
Inventory | $ 2,312 | ||
( To record Cost of goods sold) |