Answer:
Greg's Bicycle Shop
Ending Inventory:
a. Specific Identification:
Beginning inventory 1 * $230 = $230
March 9 purchase 2 * $250 = 500
March 22 purchase 2 * $260 = 520
March 30 Purchase 8 * $280 =2,240
Total value of inventory 13 units = $3,490
Cost of goods sold = Cost of goods available for sale Minus Ending Inventory
= $11,940 - $3,490
= $8,450
b. FIFO:
March 22 Purchase 5 260 1,300
March 30 Purchase 8 280 2,240
Ending Inventory 13 $3,540
Cost of goods sold = Goods available for sale Minus Ending Inventory
= $11,940 - $3,540
= $8,400
c. LIFO:
Ending Inventory:
March 1 Inventory 13 $230 $2,990
Cost of goods sold = Goods available for sale Minus Ending Inventory
= $11,940 - $2,990
= $8,950
d) Weighted -Average Cost:
Ending Inventory = $248.75 * 13 = $3,233.75
Cost of Goods Sold = $248.75 * 35 = $8,706.25
Specific FIFO LIFO Weighted
Identification Average
Sales $13,900 $13,900 $13,900 $13,900.00
Cost of goods sold 8,450 8,400 8,950 $8,706.25
Gross profit $5,450 $5,500 $4,950 $5,193.75
Explanation:
Dat and Calculations:
Shop uses periodic inventory system
Date Transactions Units Unit Cost Total Cost Total
March 1 Beginning inventory 20 $230 $4,600 Sales
March 5 Sale ($360 each) 15 $360 $5,400
March 9 Purchase 10 250 2,500
March 17 Sale ($410 each) 8 $410 $3,280
March 22 Purchase 10 260 2,600
March 27 Sale ($435 each) 12 $435 $5,220
March 30 Purchase 8 280 2,240
Total Goods available for sale 48 35 $11,940 $13,900
Ending Inventory = 13 (48 - 35)
Weighted average cost = Cost of goods available for sale/Units of Goods available for sale
= $11,940/48 = $248.75
Specific Identification:
March 5 sale 15 consists of bikes from 15 beginning inventory Bal 5 - 4 = 1
March 17 sale 8 consists of bikes from the March 9 purchase Bal = 2
March 27 sale 12 consists of four bikes from beginning inventory and eight bikes from the March 22 purchase Bal = 2
Ending Inventory:
Specific Identification:
Beginning inventory 1 * $230 = $230
March 9 purchase 2 * $250 = 500
March 22 purchase 2 * $260 = 520
March 30 Purchase 8 * $280 =2,240
Total value of inventory 13 units = $3,490
FIFO:
March 22 Purchase 5 260 1,300
March 30 Purchase 8 280 2,240
Ending Inventory 13 $3,540
LIFO:
March 1 Beginning inventory 13 $230 $2,990
Weighted-Average Costs:
Ending Inventory = $248.75 * 13 = $3,233.75
Cost of Goods Sold = $248.75 * 35 = $8,706.25
