Question
In: Finance
Using the specific identification method: Date Units purchased Cost per unit Ending inventory March 1 20...
Using the specific identification method:
| Date | Units purchased | Cost per unit | Ending inventory | ||
| March 1 | 20 Xbox?s 360 | $ | 275 | 5 Xbox?s from March | |
| April 1 | 41 Xbox?s 360 | 250 | 11 Xbox?s from April | ||
| May 1 | 70 Xbox?s 360 | 240 | 8 Xbox?s from May | ||
a. Calculate the ending inventory.
Ending inventory
$
b. Calculate the cost of goods sold.
Cost of goods sold
$
Solutions
Expert Solution
| a. | |||||||
| Ending Inventory | $ 6,045 | ||||||
| b. | |||||||
| Cost of goods sold | $ 26,505 | ||||||
| Working: | |||||||
| a. | Calculation of cost of goods available for sale | ||||||
| Date | Units | Cost per unit | Total | ||||
| March 1 | 20 | $ 275 | $ 5,500 | ||||
| April 1 | 41 | 250 | 10,250 | ||||
| May 1 | 70 | 240 | 16,800 | ||||
| Cost of goods available for sale | 32,550 | ||||||
| b. | Calculation of cost of ending Inventory | ||||||
| Date | Units | Cost per unit | Total | ||||
| March 1 | 5 | $ 275 | $ 1,375 | ||||
| April 1 | 11 | 250 | 2,750 | ||||
| May 1 | 8 | 240 | 1,920 | ||||
| Cost of Ending Inventory | 6,045 | ||||||
| c. | Cost of goods available for sale | 32,550 | |||||
| Less:Cost of ending inventory | 6,045 | ||||||
| Cost of goods sold | 26,505 | ||||||
jeff jeffy answered 2 years agoRelated Solutions
Using the specific identification method: Date Units purchased Cost per unit Ending inventory March 1 15...
Using the specific identification method: Date Units purchased
Cost per unit Ending inventory March 1 15 Xbox′s 360 $ 275 2 Xbox′s
from March April 1 45 Xbox′s 360 250 15 Xbox′s from April May 1 60
Xbox′s 360 240 12 Xbox′s from May
a. Calculate the ending inventory.Ending inventory $:
b. Calculate the cost of goods sold. Cost of goods sold $:
Complete the table to determine the cost assigned to ending inventory and cost of goods sold using specific identification.
Laker Company reported the following January purchases and sales data 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
...
Football teams ending inventory includes the following items product units cost per unit market per unit...
Football teams ending inventory includes the following items
product
units
cost per unit
market per unit
caps
200
$15
$22
travel Jerseys
55
$40
$125
windbreakers
18
$60
$85
signature stadium cushions
500
$20
$10
Compute the lower of cost or market for the ending inventory
separately for each product.
per unit
per unit
total inventory
total inventory
inventory items
units
cost
market
cost
market
LCM Applied to individual items
caps
travel jerseys
windbreakers
signature stadium cushion
Calculating the Value of Ending Inventory and Cost of Goods Sold: Perpetual Method Total Units Unit...
Calculating the Value of Ending Inventory and Cost of Goods Sold:
Perpetual Method
Total Units
Unit Cost
Total Cost
Beginning inventory on hand
1-Jan
60,000
$2.00
$120,000
Purchases during month
5-Jan
103,600
$2.00
$207,200
20-Jan
293,900
$2.10
$617,190
Sales of inventory
25-Jan
383,900
Beginning
inventory at
1-Feb
73,600
Purchases during month
8-Feb
282,200
$2.20
$620,840
23-Feb
153,500
$2.60
$399,100
Sales of inventory
27-Feb
407,600
Ending Inventory
101,700
LIFO
Jan
Feb
Cost of goods sold
Cost of goods sold
Ending inventory...
Calculating the Value of Ending Inventory and Cost of Goods Sold: Perpetual Method Total Units Unit...
Calculating the Value of Ending Inventory and Cost of Goods
Sold: Perpetual Method
Total Units
Unit Cost
Total Cost
Beginning inventory on hand
1-Jan
60,000
$2.00
$120,000
Purchases during month
5-Jan
103,600
$2.00
$207,200
20-Jan
293,900
$2.10
$617,190
Sales of inventory
25-Jan
383,900
Beginning
inventory at
1-Feb
73,600
Purchases during month
8-Feb
282,200
$2.20
$620,840
23-Feb
153,500
$2.60
$399,100
Sales of inventory
27-Feb
407,600
Ending Inventory
101,700
FIFO
Jan
Feb
Cost of goods sold
Cost of goods sold
Ending inventory...
Calculating the Value of Ending Inventory and Cost of Goods Sold: Perpetual Method Total Units Unit...
Calculating the Value of Ending Inventory and Cost of Goods Sold:
Perpetual Method
Total Units
Unit Cost
Total Cost
Beginning inventory on hand
1-Jan
60,000
$2.00
$120,000
Purchases during month
5-Jan
103,600
$2.00
$207,200
20-Jan
293,900
$2.10
$617,190
Sales of inventory
25-Jan
383,900
Beginning inventory at
1-Feb
73,600
Purchases during month
8-Feb
282,200
$2.20
$620,840
23-Feb
153,500
$2.60
$399,100
Sales of inventory
27-Feb
407,600
Ending Inventory
101,700
LIFO
Jan
Feb
Cost of goods sold
Cost of goods sold
Ending inventory...
The quantity purchased and purchase price is tracked through: A. specific identification method only. B. inventory...
The quantity purchased and purchase price is tracked
through:
A.
specific identification method only.
B.
inventory layers.
C.
inventory charting.
D.
FIFO and LIFO only.
Describe the specific identification inventory cost method. Explain and provide three examples of real life inventory...
Describe the specific identification inventory cost method.
Explain and provide three examples of real life inventory that
would be used for the specific identification inventory cost
method.
Data: Date Item Units Cost per unit Dec. 1 Inventory 30 $12 Dec. 10 Purchase 60...
Data:
Date Item Units Cost per unit
Dec. 1 Inventory 30 $12
Dec. 10 Purchase 60 $13
Dec. 20 Purchase 40 $14
Dec. 12 Sale 40
Dec. 27 Sale 15
Required: (1) Find the ending inventory and the cost of goods
sold for December under the
periodic inventory system using the following inventory costing
methods.
(a) average cost
(b) FIFO
(2) Also find ending inventory and the cost of goods sold for
the month of December
under the perpetual inventory...
There are 10 units in ending inventory compute the value of the ending inventory using the...
There are 10 units in ending inventory compute the value of
the ending inventory
using the periodic inventory method. Compute the answer using
FIFO, LIFO and the average
cost methods. (round your answer to the nearest whole
number)
Price Cost
Number Per Per
Date Transaction of units unit Purchase
Apr. 3 Inventory 2 10 20
8 Purchase 2 15 30
11 Purchase 3 20 60
30 Purchase 2 25 50
May 8 Purchase 3 25 75
10 Purchase 3 30...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Exercise 21-27 Statement of cash flows; direct method [LO21-3, 21-5, 21-6, 21-8] Comparative balance sheets for...
- Simon recently received a credit card with a 12% nominal interest rate. With the card, he...
- Year 1 Jan. 8. Purchased a used delivery truck for $61,440, paying cash. Mar. 7. Paid...
- 2. The current price level in the U.S. is $14,000 per consumption bundle, and £10,000 per...
- In C++, there are 4 students that are running for class president. Create three arrays: the...
- Suppose your company needs to raise $36.3 million and you want to issue 23-year bonds for...
- 18-1 Beedles Inc. needed to raise $14 million in an IPO and chose Security Brokers Inc....
ADVERTISEMENT