In: Accounting
Pam’s Creations had the following sales and purchase transactions during Year 2. Beginning inventory consisted of 280 items at $96 each. The company uses the FIFO cost flow assumption and keeps perpetual inventory records.
Date | Transaction | Description | |||
Mar. 5 | Purchased | 260 items @ | $ | 106 | |
Apr. 10 | Sold | 150 items @ | $ | 207 | |
June 19 | Sold | 275 items @ | $ | 207 | |
Sept. 16 | Purchased | 210 items @ | $ | 111 | |
Nov. 28 | Sold | 140 items @ | $ | 212 | |
Required
a. Record the inventory transactions in general
journal format.
b. Calculate the gross margin Pam’s Creations would report on the Year 2 income statement.
c. Determine the ending inventory balance Pam’s Creations would report on the December 31, Year 2, balance sheet.
Solution a:
Computation of ending inventory COGS under FIFO | ||||||||||||
Date | Beginning Inventory | Purchase | Cost of Goods Sold | Ending Inventory | ||||||||
Qty | Rate | Amount | Qty | Rate | Amount | Qty | Rate | Amount | Qty | Rate | Amount | |
1-Mar | 280 | $96.00 | $26,880.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 280 | $96.00 | $26,880.00 |
5-Mar | 280 | $96.00 | $26,880.00 | 260 | $106.00 | $27,560.00 | 0 | $0.00 | $0.00 | 280 | $96.00 | $26,880.00 |
260 | $106.00 | $27,560.00 | ||||||||||
10-Apr | 280 | $96.00 | $26,880.00 | 0 | $0.00 | $0.00 | 150 | $96.00 | $14,400.00 | 130 | $96.00 | $12,480.00 |
260 | $106.00 | $27,560.00 | 260 | $106.00 | $27,560.00 | |||||||
19-Jun | 130 | $96.00 | $12,480.00 | 0 | $0.00 | $0.00 | 130 | $96.00 | $12,480.00 | 115 | $106.00 | $12,190.00 |
260 | $106.00 | $27,560.00 | 145 | $106.00 | $15,370.00 | |||||||
16-Sep | 115 | $106.00 | $12,190.00 | 210 | $111.00 | $23,310.00 | 0 | $0.00 | $0.00 | 115 | $106.00 | $12,190.00 |
210 | $111.00 | $23,310.00 | ||||||||||
28-Nov | 115 | $106.00 | $12,190.00 | 0 | $0.00 | $0.00 | 115 | $106.00 | $12,190.00 | 185 | $111.00 | $20,535.00 |
210 | $111.00 | $23,310.00 | 25 | $111.00 | $2,775.00 | |||||||
Total | 565 | $57,215.00 | 185 | $20,535.00 |
Journal Entries - Pam's Creations | |||
Date | Particulars | Debit | Credit |
5-Mar | Inventory Dr | $27,560.00 | |
To Accounts Payable | $27,560.00 | ||
(To record purchase of inventory) | |||
10-Apr | Accounts receivables Dr | $31,050.00 | |
To Sales Revenue | $31,050.00 | ||
(To record sales revenue) | |||
10-Apr | Cost of goods sold Dr | $14,400.00 | |
To Inventory | $14,400.00 | ||
(To record COGS) | |||
19-Jun | Accounts receivables Dr | $56,925.00 | |
To Sales Revenue | $56,925.00 | ||
(To record sales revenue) | |||
19-Jun | Cost of goods sold Dr | $27,850.00 | |
To Inventory | $27,850.00 | ||
(To record COGS) | |||
16-Sep | Inventory Dr | $23,310.00 | |
To Accounts Payable | $23,310.00 | ||
(To record purchase of inventory) | |||
28-Nov | Accounts receivables Dr | $29,680.00 | |
To Sales Revenue | $29,680.00 | ||
(To record sales revenue) | |||
28-Nov | Cost of goods sold Dr | $14,965.00 | |
To Inventory | $14,965.00 | ||
(To record COGS) |
Solution b:
Gross Margin = Sales revenue - COGS = ($31,050 + $56,925 + $29,680) - $57,215 = $60,440
Solution c:
Ending inventory balance Pam’s Creations would report on the December 31, Year 2, balance sheet = $20,535