Question
In: Finance
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 $:
Solutions
Expert Solution
| Ans. | Specific Identification: | |||||||||
| Available for sale | Cost of goods sold | Ending inventory | ||||||||
| Purchase date | Units | Rate | Cost | Units | Rate | Cost | Units | Rate | Cost | |
| 1-Mar | 15 | $275 | $4,125 | 13 | $275 | $3,575 | 2 | $275 | $550 | |
| 1-Apr | 45 | $250 | $11,250 | 30 | $250 | $7,500 | 15 | $250 | $3,750 | |
| 1-May | 60 | $240 | $14,400 | 48 | $240 | $11,520 | 12 | $240 | $2,880 | |
| Total | $29,775 | Cost of goods sold | $22,595 | Ending inventory | $7,180 | |||||
| Ending Inventory | $7,180 | |||||||||
| Cost of goods sold | $22,595 | |||||||||
| Units sold = Units available for sale - Ending inventory units | ||||||||||
| *Calculations: | ||||||||||
| Date | Units available | Ending inventory | Sold units | |||||||
| (a) | units (b) | (a - b) | ||||||||
| 1-Mar | 15 | 2 | 13 | |||||||
| 1-Apr | 45 | 15 | 30 | |||||||
| 1-May | 60 | 12 | 48 | |||||||
jeff jeffy answered 8 months agoRelated Solutions
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
$
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
Beginning Inventory # of units Cost per unit Total Beginning Inventory 15 $10 $150 Jan 1....
Beginning Inventory
# of units
Cost per unit
Total
Beginning Inventory
15
$10
$150
Jan 1. Purchase
15
$11
$165
Jan 10. Purchase
15
$12
$180
Total
45
1. During January, AA sold 20 units at $30 per unit.
Under FIFO, how much is the Gross
Profit?
$365
$380
$390
$395
2. During January, AA sold 20 units at $30 per unit
Under the Weighted Average Method, how much is the
Gross Profit?.
$365
$380
$395
$400
3. During January,...
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...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Suppose that a firm finds that its low-productivity workers have a marginal revenue product of $21,000...
- The specific enthalpy of liquid n-hexane at 1 atm varies linearly with temperature and equals 85.8...
- Write pseudocode for an algorithm that calculates the Hamming distance between two strings s1 and s2...
- 1. Discuss how race and class overlap. Does conflict theory provide a coherent pattern for understanding...
- Select a publicly-traded company and access the company’s most recent annual report (select the “Investors” menu...
- Suppose that as a financial manager you have collected the following information on your company. Before-tax...
- A settling tank treating 5.5x10*6 L of water per day has dimensions as follows: length, 12.2m;...
ADVERTISEMENT