In: Accounting
Ferris Company began 2018 with 6,000 units of its principal
product. The cost of each unit is $8. Merchandise transactions for
the month of January 2018 are as follows:
Purchases | |||||||||
Date of Purchase | Units | Unit Cost* | Total Cost | ||||||
Jan. 10 | 5,000 | $ | 9 | $ | 45,000 | ||||
Jan. 18 | 6,000 | 10 | 60,000 | ||||||
Totals | 11,000 | 105,000 | |||||||
* Includes purchase price and cost of freight.
Sales | ||
Date of Sale | Units | |
Jan. 5 | 3,000 | |
Jan. 12 | 2,000 | |
Jan. 20 | 4,000 | |
Total | 9,000 | |
8,000 units were on hand at the end of the month.
Required:
Calculate January's ending inventory and cost of goods sold for the
month using each of the following alternatives:
1. FIFO, periodic system.
2. LIFO, periodic system.
3. LIFO, perpetual system.
4. Average cost, periodic system.
5. Average cost, perpetual system.
FIFO METHDO - PERIODICAL | COST OF GOODS AVAILABLE FOR SALE | COST OF GOODS SOLD | CLOSING STOCK | |||||||
Date | Particulars | Units | Cost Per unit | Total | Units | Cost Per unit | Cost of Goods Sold | Units | Cost Per unit | Ending inventory |
Jan,01 | Beginning Balance | 6,000 | $ 8.00 | $ 48,000 | 6,000 | $ 8.00 | $ 48,000 | |||
Jan,10 | Purchases | 5,000 | $ 9.00 | $ 45,000 | 3,000 | $ 9.00 | $ 27,000 | 2,000 | $ 9.00 | $ 18,000 |
Jan,18 | Purchases | 6,000 | $ 10.00 | $ 60,000 | 6,000 | $ 10.00 | $ 60,000 | |||
Total Goods Available For sale | 17,000 | $ 1,53,000 | 9,000 | $ 75,000 | 8,000 | $ 78,000 | ||||
LIFO METHDO - PERIODICAL | COST OF GOODS AVAILABLE FOR SALE | COST OF GOODS SOLD | CLOSING STOCK | |||||||
Date | Particulars | Units | Cost Per unit | Total | Units | Cost Per unit | Cost of Goods Sold | Units | Cost Per unit | Ending inventory |
Jan,01 | Beginning Balance | 6,000 | $ 8.00 | $ 48,000 | 6,000 | $ 8.00 | $ 48,000 | |||
Jan,10 | Purchases | 5,000 | $ 9.00 | $ 45,000 | 3,000 | $ 9.00 | $ 27,000 | 2,000 | $ 9.00 | $ 18,000 |
Jan,18 | Purchases | 6,000 | $ 10.00 | $ 60,000 | 6,000 | $ 10.00 | $ 60,000 | |||
Total Goods Available For sale | 17,000 | $ 1,53,000 | 9,000 | $ 87,000 | 8,000 | $ 66,000 | ||||
LIFO METHDO - PERPETUAL | COST OF GOODS AVAILABLE FOR SALE | COST OF GOODS SOLD | CLOSING STOCK | |||||||
Date | Particulars | Units | Cost Per unit | Total | Units | Cost Per unit | Cost of Goods Sold | Units | Cost Per unit | Ending inventory |
Jan,01 | Beginning Balance | 6,000 | $ 8.00 | $ 48,000 | ||||||
Jan,05 | Sales | 3,000 | $ 8.00 | $ 24,000 | 3,000 | $ 8.00 | $ 24,000 | |||
Jan,10 | Purchases | 5,000 | $ 9.00 | $ 45,000 | 3,000 | $ 8.00 | $ 24,000 | |||
5,000 | $ 9.00 | $ 45,000 | ||||||||
Jan,12 | Sales | 2,000 | $ 9.00 | $ 18,000 | 3,000 | $ 8.00 | $ 24,000 | |||
2,000 | $ 9.00 | $ 18,000 | ||||||||
Jan,18 | Purchases | 6,000 | $ 10.00 | $ 60,000 | 3,000 | $ 8.00 | $ 24,000 | |||
2,000 | $ 9.00 | $ 18,000 | ||||||||
6,000 | $ 10.00 | $ 60,000 | ||||||||
Jan,20 | Sales | 4,000 | $ 10.00 | $ 40,000 | 3,000 | $ 8.00 | $ 24,000 | |||
2,000 | $ 9.00 | $ 18,000 | ||||||||
2,000 | $ 10.00 | $ 20,000 | ||||||||
Total Goods Available For sale | 11,000 | $ 1,05,000 | 5,000 | $ 42,000 | 7,000 | $ 62,000 | ||||
AVERAGE COST - PERIODICAL | COST OF GOODS AVAILABLE FOR SALE | COST OF GOODS SOLD | CLOSING STOCK | |||||||
Date | Particulars | Units | Cost Per unit | Total | Units | Cost Per unit | Cost of Goods Sold | Units | Cost Per unit | Ending inventory |
Jan,01 | Beginning Balance | 6,000 | $ 8.00 | $ 48,000 | ||||||
Jan,10 | Purchases | 5,000 | $ 9.00 | $ 45,000 | ||||||
Jan,18 | Purchases |
Related SolutionsFerris Company began 2018 with 6,000 units of its principal product. The cost of each unit...Ferris Company began 2018 with 6,000 units of its principal
product. The cost of each unit is $6. Merchandise transactions for
the month of January 2018 are as follows:
Purchases
Date of Purchase
Units
Unit Cost*
Total Cost
Jan. 10
5,000
$
7
$
35,000
Jan. 18
6,000
8
48,000
Totals
11,000
83,000
*Includes purchase price and cost of freight.
Sales
Date of Sale
Units
Jan. 5
3,000
Jan. 12
2,000
Jan. 20
4,000
Total
9,000
8,000 units were on...
Ferris Company began 2018 with 6,000 units of its principal product. The cost of each unit...Ferris Company began 2018 with 6,000 units of its principal
product. The cost of each unit is $8. Merchandise transactions for
the month of January 2018 are as follows:
Purchases
Date of Purchase
Units
Unit Cost*
Total Cost
Jan. 10
5,000
$
9
$
45,000
Jan. 18
6,000
10
60,000
Totals
11,000
105,000
* Includes purchase price and cost of freight.
Sales
Date of Sale
Units
Jan. 5
3,000
Jan. 12
2,000
Jan. 20
4,000
Total
9,000
8,000 units were...
Ferris Company began 2018 with 6,000 units of its principal product. The cost of each unit...Ferris Company began 2018 with 6,000 units of its principal
product. The cost of each unit is $7. Merchandise transactions for
the month of January 2018 are as follows:
Purchases
Date of Purchase
Units
Unit Cost*
Total Cost
Jan. 10
5,000
$
8
$
40,000
Jan. 18
6,000
9
54,000
Totals
11,000
94,000
*Includes purchase price and cost of freight.
Sales
Date of Sale
Units
Jan. 5
3,000
Jan. 12
2,000
Jan. 20
4,000
Total
9,000
8,000 units were on...
Ferris Company began 2018 with 6,000 units of its principal product. The cost of each unit...Ferris Company began 2018 with 6,000 units of its principal
product. The cost of each unit is $7. Merchandise transactions for
the month of January 2018 are as follows:
Purchases
Date of Purchase
Units
Unit Cost*
Total Cost
Jan. 10
5,000
$
8
$
40,000
Jan. 18
6,000
9
54,000
Totals
11,000
94,000
*Includes purchase price and cost of freight.
Sales
Date of Sale
Units
Jan. 5
3,000
Jan. 12
2,000
Jan. 20
4,000
Total
9,000
8,000 units were on...
Ferris Company began January with 6,000 units of its principal product. The cost of each unit...Ferris Company began January with 6,000 units of its principal
product. The cost of each unit is $9. Merchandise transactions for
the month of January are as follows:
Purchases
Date of Purchase
Units
Unit Cost*
Total Cost
Jan. 10
5,000
$
10
$
50,000
Jan. 18
6,000
11
66,000
Totals
11,000
116,000
* Includes purchase price and cost of freight.
Sales
Date of Sale
Units
Jan. 5
3,000
Jan. 12
2,000
Jan. 20
4,000
Total
9,000
8,000 units were on...
Ferris Company began 2018 with 4,000 units of its principal product. The cost of each unit...Ferris Company began 2018 with 4,000 units of its principal
product. The cost of each unit is $7. Merchandise transactions for
the month of January 2018 are as follows:
Purchases
Date of
Purchase
Units
Unit Cost*
Total Cost
Jan. 10
3,000
$
8
$
24,000
Jan. 18
4,000
9
36,000
Totals
7,000
60,000
*Includes purchase price and cost of freight.
Sales
Date of
Sale
Units
Jan. 5
2,000
Jan. 12
1,000
Jan. 20
3,000
Total
6,000
5,000 units were on...
Ferris Company began 2018 with 4,000 units of its principal product. The cost of each unit...Ferris Company began
2018 with 4,000 units of its principal product. The cost of each
unit is $6. Merchandise transactions for the month of January 2018
are as follows:
Purchases
Date of
Purchase
Units
Unit Cost*
Total Cost
Jan. 10
3,000
$
7
$
21,000
Jan. 18
4,000
8
32,000
Totals
7,000
53,000
*Includes purchase
price and cost of freight.
Sales
Date of
Sale
Units
Jan. 5
2,000
Jan. 12
1,000
Jan. 20
3,000
Total
6,000
5,000 units were on...
Ferris Company began 2018 with 4,000 units of its principal product. The cost of each unit...Ferris Company began
2018 with 4,000 units of its principal product. The cost of each
unit is $6. Merchandise transactions for the month of January 2018
are as follows:
Purchases
Date of
Purchase
Units
Unit Cost*
Total Cost
Jan. 10
3,000
$
7
$
21,000
Jan. 18
4,000
8
32,000
Totals
7,000
53,000
*Includes purchase
price and cost of freight.
Sales
Date of
Sale
Units
Jan. 5
2,000
Jan. 12
1,000
Jan. 20
3,000
Total
6,000
5,000 units were on...
Ferris Company began 2018 with 7,000 units of its principal product. The cost of each unit...Ferris Company began 2018 with 7,000 units of its principal
product. The cost of each unit is $6. Merchandise transactions for
the month of January 2018 are as follows: Purchases Date of
Purchase Units Unit Cost* Total Cost Jan. 10 6,000 $ 7 $ 42,000
Jan. 18 7,000 8 56,000 Totals 13,000 98,000 *Includes purchase
price and cost of freight. Sales Date of Sale Units Jan. 5 3,000
Jan. 12 1,000 Jan. 20 4,000 Total 8,000 12,000 units were on...
Ferris Company began 2018 with 5,000 units of its principal product. The cost of each unit...Ferris Company began 2018 with 5,000 units of its principal
product. The cost of each unit is $9. Merchandise transactions for
the month of January 2018 are as follows: Purchases Date of
Purchase Units Unit Cost* Total Cost Jan. 10 6,000 $ 10 $ 60,000
Jan. 18 5,000 11 55,000 Totals 11,000 115,000 *Includes purchase
price and cost of freight. Sales Date of Sale Units Jan. 5 3,000
Jan. 12 3,000 Jan. 20 4,000 Total 10,000 6,000 units were on...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|