ACCTG 230 Lecture Notes - Lecture 19: Inventory Turnover, Gross Profit
Get access
Related Documents
Related Questions
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 | |||||||||
Rock Slide is a distributor that assembles power units. Using the material presented in Schedules A and Schedule B:
(1) Determine Rock Slideâs cost of goods sold and the ending inventory using the inventory costing methods of FIFO, LIFO, and Weighted Averages;
(2) Determine Rock Slideâs gross profit (margin) using the inventory costing methods of
FIFO, LIFO and Weighted Averages;
S c h e d u l e A A s s e m b l y o f P o w e r U n i t s Rock Slide
Assembly Activity | Units | Cost/Unit | Total Cost |
Beginning Inventory 1/1/12 | 70 | $105 | $7,350 |
Assembly Units Placed Into Inventory | |||
2/15/12 | 85 | $110 | $9,350 |
4/20/12 | 90 | $112 | $10,080 |
9/18/12 | 65 | $112 | $7,280 |
11/16/12 | 110 | $112 | $12,320 |
12/20/12 | 80 | $120 | $9,600 |
Total Assembled Units Available for Sale- 2012 | 500 | $55,980 |
Schedule B
Sales of Power Units Rock Slide
Sales Activity | Units | Unit Sales Price | Total Sales |
1/15/12 | 60 | $145 | $8,700 |
3/20/12 | 80 | $150 | $12,000 |
5/2/12 | 100 | $150 | $15,000 |
10/8/12 | 60 | $150 | $9,000 |
11/30/12 | 110 | $150 | $16,500 |
12/28/12 | 30 | $175 | $5,250 |
Total 2012 Sales | 440 | $66,450 |
Use the following information for the Exercisesbelow.
[The following information applies to the questionsdisplayed below.]
Laker Company reported the following January purchases and salesdata for its only product.
Date | Activities | Units Acquired at Cost | Units sold at Retail | ||||||||||||||
Jan. | 1 | Beginning inventory | 140 | units | @ | $ | 6.00 | = | $ | 840 | |||||||
Jan. | 10 | Sales | 100 | units | @ | $ | 15 | ||||||||||
Jan. | 20 | Purchase | 60 | units | @ | $ | 5.00 | = | 300 | ||||||||
Jan. | 25 | Sales | 80 | units | @ | $ | 15 | ||||||||||
Jan. | 30 | Purchase | 180 | units | @ | $ | 4.50 | = | 810 | ||||||||
Totals | 380 | units | $ | 1,950 | 180 | units | |||||||||||
The Company uses a perpetual inventory system. For specificidentification, ending inventory consists of 200 units, where 180are from the January 30 purchase, 5 are from the January 20purchase, and 15 are from beginning inventory.
Exercise 6-3 Perpetual: Inventory costing methods LO P1
Required:
1. Complete the table to determine the costassigned to ending inventory and cost of goods sold using specificidentification.
2. Determine the cost assigned to ending inventoryand to cost of goods sold using weighted average.
3. Determine the cost assigned to ending inventoryand to cost of goods sold using FIFO.
4. Determine the cost assigned to ending inventoryand to cost of goods sold using LIFO.
Required 3
Required 4
Complete the table to determine the cost assigned to endinginventory and cost of goods sold using specific identification.
|
Determine the cost assigned to ending inventory and to cost ofgoods sold using weighted average. (Round cost per unit to 2decimal places.)
|
Determine the cost assigned to ending inventory and to cost ofgoods sold using FIFO.
|
Determine the cost assigned to ending inventory and to cost ofgoods sold using LIFO.
|