CALCULATION OF COST OF ENDING INVENTORY AND COST OF GOODS SOLD UNDER FIFO METHOD | ||||||||||||
PURHASES | COST OF GOODS SOLD | CLOSING BALANCE | ||||||||||
Date | Particulars | Units (A) | Rate Per unit | Total Cost | Units (A) | Rate Per unit | Total Cost | Units (A) | Rate Per unit | Total Cost | ||
Mar , 01 | Opening Inventory | 100 | $50 | $5,000 | ||||||||
Mar , 05 | Purchases | 400 | $55 | $22,000 | 100 | $50 | $5,000 | |||||
400 | $55 | $22,000 | ||||||||||
100 | $50 | $5,000 | ||||||||||
; | Mar, 09 | Sales | 320 | $55 | $17,600 | 80 | $55 | $4,400 | ||||
Mar, 16 | Purchases | 120 | $ 60.00 | $7,200 | 80 | $55 | $4,400 | |||||
120 | $ 60.00 | $7,200 | ||||||||||
Mar, 25 | Purchases | 200 | $ 62.00 | $12,400 | 80 | $55 | $4,400 | |||||
120 | $ 60.00 | $7,200 | ||||||||||
200 | $ 62.00 | $12,400 | ||||||||||
Mar, 29 | Sales | 80 | $55 | $4,400 | ||||||||
80 | $ 60.00 | $4,800 | 40 | $ 60.00 | $2,400 | |||||||
200 | $ 62.00 | $12,400 | ||||||||||
720 | 580 | $31,800 | 240 | $14,800 | ||||||||
Cost of Ending inventory= | $14,800 | |||||||||||
Cost o Goods Sold = | $31,800 | |||||||||||
CALCULATION OF COST OF ENDING INVENTORY AND COST OF GOODS SOLD UNDER LIFO METHOD | ||||||||||||
PURHASES | COST OF GOODS SOLD | CLOSING BALANCE | ||||||||||
Date | Particulars | Units (A) | Rate Per unit | Total Cost | Units (A) | Rate Per unit | Total Cost | Units (A) | Rate Per unit | Total Cost | ||
Mar , 01 | Opening Inventory | 100 | $50 | $5,000 | ||||||||
Mar , 05 | Purchases | 400 | $55 | $22,000 | 100 | $50 | $5,000 | |||||
400 | $55 | $22,000 | ||||||||||
400 | $55 | $22,000 | ||||||||||
Mar, 09 | Sales | 20 | $50 | $1,000 | 80 | $50 | $4,000 | |||||
Mar, 16 | Purchases | 120 | $ 60.00 | $7,200 | 80 | $50 | $4,000 | |||||
120 | $ 60.00 | $7,200 | ||||||||||
Mar, 25 | Purchases | 200 | $ 62.00 | $12,400 | 80 | $50 | $4,000 | |||||
120 | $ 60.00 | $7,200 | ||||||||||
200 | $ 62.00 | $12,400 | ||||||||||
Mar, 29 | Sales | 160 | $ 62.00 | $9,920 | 40 | $ 62.00 | $2,480 | |||||
120 | $ 60.00 | $7,200 | ||||||||||
80 | $50 | $4,000 | ||||||||||
720 | 580 | $32,920 | 240 | $13,680 | ||||||||
Cost of Ending inventory= | $13,680 | |||||||||||
Cost o Goods Sold = | $32,920 | |||||||||||
CALCULATION OF COST OF ENDING INVENTORY AND COST OF GOODS SOLD UNDER WEIGHTED AVERAGE COST | ||||||||||||
PURHASES | COST OF GOODS SOLD | CLOSING BALANCE | ||||||||||
Date | Particulars | Units (A) | Rate Per unit | Total Cost | Units (A) | Rate Per unit | Total Cost | Units (A) | Rate Per unit | Total Cost | ||
Mar , 01 | Opening Inventory | 100 | $50 | $5,000 | ||||||||
Mar , 05 | Purchases | 400 | $55 | $22,000 | 500 | $54 | $27,000 | |||||
Mar, 09 | Sales | 420 | $54 | $22,680 | 80 | $54 | $4,320 | |||||
Mar, 16 | Purchases | 120 | $ 60.00 | $7,200 | 200 | $57.60 | $11,520 | |||||
Mar, 25 | Purchases | 200 | $ 62.00 | $12,400 | 400 | $59.80 | $23,920 | |||||
Mar, 29 | Sales | 160 | $ 59.80 | $9,568 | 240 | $59.80 | $14,352 | |||||
720 | 580 | $32,248 | 240 | $14,352 | ||||||||
Cost of Ending inventory= | $14,352 | |||||||||||
Cost o Goods Sold = | $32,248 | |||||||||||
CALCULATION OF COST OF ENDING INVENTORY AND COST OF GOODS SOLD UNDER SPECIFIC IDENTIFICATION | ||||||||||||
PURHASES | COST OF GOODS SOLD | CLOSING BALANCE | ||||||||||
Date | Particulars | Units (A) | Rate Per unit | Total Cost | Units (A) | Rate Per unit | Total Cost | Units (A) | Rate Per unit | Total Cost | ||
Mar , 01 | Opening Inventory / Sales | 100 | $50 | $5,000 | 100 | $50 | $5,000 | |||||
Mar , 05 | Purchases | 400 | $55 | $22,000 | 100 | $50 | $5,000 | |||||
400 | $55 | $22,000 | ||||||||||
Mar, 09 | Sales | 80 | $50 | $4,000 | ||||||||
340 | $55 | $18,700 | 20 | $50 | $1,000 | |||||||
60 | $55 | $3,300 | ||||||||||
Mar, 18 | Purchases | 120 | $ 60.00 | $7,200 | 20 | $50 | $1,000 | |||||
60 | $55 | $3,300 | ||||||||||
120 | $ 60.00 | $7,200 | ||||||||||
Mar, 25 | Purchases | 200 | $ 62.00 | $12,400 | 20 | $50 | $1,000 | |||||
60 | $55 | $3,300 | ||||||||||
120 | $ 60.00 | $7,200 | ||||||||||
200 | $ 62.00 | $12,400 | ||||||||||
Mar, 29 | Sales | 40 | $ 60.00 | $2,400 | ||||||||
120 | $ 62.00 | $7,440 | 20 | $50 | $1,000 | |||||||
60 | $55 | $3,300 | ||||||||||
80 | $ 60.00 | $4,800 | ||||||||||
80 | $ 62.00 | $4,960 | ||||||||||
820 | 580 | $32,540 | 240 | $14,060 | ||||||||
Cost of Ending inventory= | $14,060 | |||||||||||
Cost o Goods Sold = | $32,540 | |||||||||||
Cost of Ending Inventory | Cost of Goods Sold | |||||||||||
FIFO | $ 14,800.00 | $31,800 | ||||||||||
LIFO | $ 13,680.00 | $32,920 | ||||||||||
Weighted aVerage Cost | $ 14,352.00 | $32,248 | ||||||||||
Specific Identification | $ 14,060.00 | $32,540 | ||||||||||
INCOME STATEMENT | Specific Identification | Weighted Average | FIFO | LIFO | ||||||||
Sales | ||||||||||||
Mar, 09 Sales | $35,700 | $35,700 | $35,700 | $35,700 | ||||||||
Mar, 18 Sales | $15,200 | $15,200 | $15,200 | $15,200 | ||||||||
Total Sales | $50,900 | $50,900 | $50,900 | $50,900 | ||||||||
LEsS: Cost of Goods Sold | $32,540 | $32,248 | $31,800 | $32,920 | ||||||||
Gross Profit | $18,360 | $18,652 | $19,100 | $17,980 | ||||||||
Saved Required Informatlon Problem 6-1A Perpetual: Alternative cost flows LO P1 The following Information applies to...
Required information Problem 5-1A Perpetual: Alternative cost flows LO P1 [The following information applies to the questions displayed below) Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March Units sold at Retail Units Acquired at Cost 120 units $51.40 per unit 235 units @ $56.40 per unit 280 units $86.40 per unit Date Activities Mar. 1 Beginning inventory Mar. 5 Purchase Mar. 9 Sales Mar. 18 Purchase Mar 25 Purchase Mar....
Required information Problem 6-1A Perpetual: Alternative cost flows LO P1 [The following information applies to the questions displayed below.) Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March Units Sold at Retail Units Acquired at Cost 170 units @ $52.40 per unit 260 units @ $57.40 per unit 330 units @ $87.40 per unit Date Activities Mar. 1 Beginning inventory Mar. 5 Purchase Mar. 9 Sales Mar 18 Purchase...
Required information Problem 6-1A Perpetual: Alternative cost flows LO P1 The following information applies to the questions displayed below) Warnerwoods Company uses a perpetual Inventory system. It entered into the following purchases and sales transactions for March lonn I w Unita Sold at Retail Activities Beginning inventory Unita Mequired at Coat 100 units $50.00 per unit 420 units $85.00 per unit 200 units $62.00 per upit 160 units 595.00 per unit Problem 6-1A Part 3 3. Compute the cost assigned...
Problem 5-1A Perpetual: Alternative cost flows LO P1
[The following information applies to the questions
displayed below.]
Warnerwoods Company uses a perpetual inventory system. It entered
into the following purchases and sales transactions for
March.
Date
Activities
Units Acquired at Cost
Units Sold at Retail
Mar.
1
Beginning inventory
100
units
@ $51.00 per unit
Mar.
5
Purchase
225
units
@ $56.00 per unit
Mar.
9
Sales
260
units
@ $86.00 per unit
Mar.
18
Purchase
85
units
@ $61.00...
Homework - Chapter 5 0 Help Seve Required information Problem 5-1A Perpetual: Alternative cost flows LO P1 The following information applies to the questions displayed below) Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March. Units Required at Coat 150 units $52.00 per unit 250 units $57.00 per unit Units sold at Retail Date Activities Mar. 1 Beginning inventory Har 5 Purchase Mar. 9 Sales Mar. 18 Purchase Mar. 25 Purchase...
Check my Problem 5-1A Perpetual: Alternative cost flows LO P1 (The following information applies to the questions displayed below.) Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March Part 1 of 4 Units Sold at Retail Units Acquired at Cost 100 units @ $50.00 per unit 400 units $55.00 per unit 12.5 points 420 unitse $85.00 per unit Date Activities Mar. 1 Beginning inventory Mar. 5 Purchase Mar. 9 Sales Mar....
Problem 5-1A Perpetual: Alternative cost flows LO P1 The following information applies to the questions displayed below) Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March Units sold at Retail Units Acquired at Cost 150 unitse $52.00 per unit 250 units $57.00 per unit Date Activities Mar. 1 Beginning inventory Mar. 5 Purchase Mar. Sales Mar. 18 Purehase Mar. 25 Purchase MAT. 29 Sales Totals 310 unitse $87.00 per unit 110...
Problem 5-1A Perpetual: Alternative cost flows LO P1 The following information applies to the questions displayed below.] Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March. Date Mar. 1 Beginning inventory Mar. 5 Purchase Mar. 9 Sales Mar. 18 Purchase Mar. 25 Purchase Mar. 29 Sales Activities Units Acquired at Cost 60 units $50.20 per unit 205 units $55.20 per unit Units Sold at Retail 220 units $85.20 per unit 65...
PROBLEM SET A connect Problem 6-1A Perpetual: Alternative cost flows P1 Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March. (For specific identification, the March 9 sale consisted of 8o units from beginning inventory and 340 units from the March 5 purchase; the March 29 sale consisted of 40 units from the March 18 purchase and 120 units from the March 25 purchase.) Date Activities Units Acquired at Cost Units Sold...
Problem 6-1A Perpetual: Alternative cost flowsP Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March. (For specific identification, the March 9 sale consisted of 80 units from beginning inventory and 340 units from the March 5 purchase; the March 29 sale consisted of 40 units from the March 18 purchase and 120 units from the March 25 purchase.) Units Acquired at Cost Date Activities Units Sold at Retail Beginning inventory 100...