Periodic Inventory Method Better Bottles, Inc. uses a PERIODIC inventory system
ID: 2583766 • Letter: P
Question
Periodic Inventory Method
Better Bottles, Inc. uses a PERIODIC inventory system and has the following information available:
Description
# of Units
Cost per Unit
Total Cost
Beginning inventory
20
$20.00
$400
Jan 5 sold
15
Jan 15 purchase
27
$22.00
594
Jan 18 sold
21
Jan 20 purchase
33
$30.00
990
Total goods available for sale
80
$1,984
Total goods sold
36
Required:
1
Calculate both Cost of goods sold and Ending inventory using the Periodic FIFO Method.
2
Calculate both Cost of good sold and Ending Inventory using Periodic LIFO Method.
3
Use your calculations from 1-2 and complete the Income Statement.
The company income tax rate:
0.25
1
FIFO Cost of Goods Sold - PERIODIC
Units Sold Taken From:
# of Units
Cost per Unit
Total Cost
Total Cost of Goods Sold FIFO
FIFO Ending Inventory - PERIODIC
Inventory Available
# of Units
Cost per Unit
Total Cost
Beginning inventory
+Purchase
+Purchase
(Less Cost of Goods Sold)
Ending Inventory FIFO
2
LIFO Cost of Goods Sold - PERIODIC
Units Sold Taken From:
# of Units
Cost per Unit
Total Cost
Total Cost of Goods Sold LIFO
LIFO Ending Inventory - PERIODIC
Inventory Available
# of Units
Cost per Unit
Total Cost
Beginning inventory
+Purchase
+Purchase
(Less Cost of Goods Sold)
Ending Inventory LIFO
3
Income Statement - Periodic Inventory Method
FIFO
LIFO
Sales revenue, net
25,000
25,000
Cost of goods sold
Gross profit
Operating expenses
8,000
8,000
Operating income before tax
Income tax expense
Net income
Periodic Inventory Method
Better Bottles, Inc. uses a PERIODIC inventory system and has the following information available:
Description
# of Units
Cost per Unit
Total Cost
Beginning inventory
20
$20.00
$400
Jan 5 sold
15
Jan 15 purchase
27
$22.00
594
Jan 18 sold
21
Jan 20 purchase
33
$30.00
990
Total goods available for sale
80
$1,984
Total goods sold
36
Required:
1
Calculate both Cost of goods sold and Ending inventory using the Periodic FIFO Method.
2
Calculate both Cost of good sold and Ending Inventory using Periodic LIFO Method.
3
Use your calculations from 1-2 and complete the Income Statement.
The company income tax rate:
0.25
1
FIFO Cost of Goods Sold - PERIODIC
Units Sold Taken From:
# of Units
Cost per Unit
Total Cost
Total Cost of Goods Sold FIFO
FIFO Ending Inventory - PERIODIC
Inventory Available
# of Units
Cost per Unit
Total Cost
Beginning inventory
+Purchase
+Purchase
(Less Cost of Goods Sold)
Ending Inventory FIFO
2
LIFO Cost of Goods Sold - PERIODIC
Units Sold Taken From:
# of Units
Cost per Unit
Total Cost
Total Cost of Goods Sold LIFO
LIFO Ending Inventory - PERIODIC
Inventory Available
# of Units
Cost per Unit
Total Cost
Beginning inventory
+Purchase
+Purchase
(Less Cost of Goods Sold)
Ending Inventory LIFO
3
Income Statement - Periodic Inventory Method
FIFO
LIFO
Sales revenue, net
25,000
25,000
Cost of goods sold
Gross profit
Operating expenses
8,000
8,000
Operating income before tax
Income tax expense
Net income
Explanation / Answer
1)
2)
3)
1 FIFO Cost of Goods Sold - PERIODIC Units Sold Taken From: Number of Units Cost per Unit Total Cost Sale on Jan 5 Beginning Inventory 15 $ 20 $ 300 Sale on Jan 18 Beginning Inventory 5 $ 20 $ 100 Jan 15 purchase 16 $ 22 $ 352 Total Cost of Goods Sold FIFO 36 $ 752 FIFO Ending Inventory - PERIODIC Inventory Available Number of Units Cost per Unit Total Cost Beginning inventory 20 $ 20 $ 400 +Purchase 27 $ 22 $ 594 +Purchase 33 $ 30 $ 990 (Less Cost of Goods Sold) 36 $ -752 Ending Inventory FIFO $ 238