Specific Identification Method | |||||
Date | TOTAL Units Available | Sold | Balance | Rate ($) | Amount |
Mar-01 | 60 | 45 | 15 | 50.20 | 753 |
Mar-05 | 205 | 175 | 30 | 55.20 | 1,656 |
Mar-18 | 65 | 25 | 40 | 60.20 | 2,408 |
Mar-29 | 110 | 65 | 45 | 62.20 | 2,799 |
Total Closing Stock Value | 7,616 |
FIFO | |||||||||
Date | Particular (Debit) | Qty | Rate ($) | Amount | Date | Particular (Credit) | Qty | Rate ($) | Amount |
01/03/XXXX | Opening Inventory | 60 | 50.2 | 3012 | Closing Balance-1 | 60 | 50.2 | 3012 | |
05/03/XXXX | Purchase | 205 | 55.2 | 11316 | -2 | 205 | 55.2 | 11316 | |
Total | 265 | 14328 | Total | 265 | 14328 | ||||
Opening Balance -1 | 60 | 50.2 | 3012 | 09/03/XXXX | Sales | 60 | 50.2 | 3012 | |
-2 | 205 | 55.2 | 11316 | 09/03/XXXX | Sales | 160 | 55.2 | 8832 | |
Closing Balance-1 | 45 | 55.2 | 2484 | ||||||
Total | 265 | 14328 | Total | 265 | 14328 | ||||
Opening Balance | 45 | 55.2 | 2484 | Closing Balance-1 | 45 | 55.2 | 2484 | ||
18/03/XXXX | Purchase | 65 | 60.2 | 3913 | -2 | 65 | 60.2 | 3913 | |
Total | 110 | 6397 | Total | 110 | 6397 | ||||
Opening Balance -1 | 45 | 55.2 | 2484 | Closing Balance-1 | 45 | 55.2 | 2484 | ||
-2 | 65 | 60.2 | 3913 | -2 | 65 | 60.2 | 3913 | ||
25/03/XXXX | Purchase | 110 | 62.2 | 6842 | -3 | 110 | 62.2 | 6842 | |
Total | 220 | 13239 | Total | 220 | 13239 | ||||
Opening Balance -1 | 45 | 55.2 | 2484 | 29/03/XXXX | Sales | 45 | 55.2 | 2484 | |
-2 | 65 | 60.2 | 3913 | 29/03/XXXX | Sales | 45 | 60.2 | 2709 | |
-3 | 110 | 62.2 | 6842 | 31/03/XXXX | Closing Balance-1 | 20 | 60.2 | 1204 | |
31/03/XXXX | -2 | 110 | 62.2 | 6842 | |||||
Total | 220 | 13239 | 220 | 13239 |
LIFO | |||||||||
Date | Particular (Debit) | Qty | Rate ($) | Amount | Date | Particular (Credit) | Qty | Rate ($) | Amount |
01/03/XXXX | Opening Inventory | 60 | 50.2 | 3012 | Closing Balance-1 | 205 | 55.2 | 11316 | |
05/03/XXXX | Purchase | 205 | 55.2 | 11316 | -2 | 60 | 50.2 | 3012 | |
Total | 265 | 14328 | Total | 265 | 14328 | ||||
Opening Balance -1 | 205 | 55.2 | 11316 | 09/03/XXXX | Sales | 205 | 55.2 | 11316 | |
-2 | 60 | 50.2 | 3012 | 09/03/XXXX | Sales | 15 | 50.2 | 753 | |
Closing Balance-1 | 45 | 50.2 | 2259 | ||||||
Total | 265 | 14328 | Total | 265 | 14328 | ||||
Opening Balance | 45 | 50.2 | 2259 | Closing Balance-1 | 65 | 60.2 | 3913 | ||
18/03/XXXX | Purchase | 65 | 60.2 | 3913 | -2 | 45 | 50.2 | 2259 | |
Total | 110 | 6172 | Total | 110 | 6172 | ||||
Opening Balance -1 | 65 | 60.2 | 3913 | Closing Balance-1 | 110 | 62.2 | 6842 | ||
-2 | 45 | 50.2 | 2259 | -2 | 65 | 60.2 | 3913 | ||
25/03/XXXX | Purchase | 110 | 62.2 | 6842 | -3 | 45 | 50.2 | 2259 | |
Total | 220 | 13014 | Total | 220 | 13014 | ||||
Opening Balance -1 | 110 | 62.2 | 6842 | 29/03/XXXX | Sales | 90 | 62.2 | 5598 | |
-2 | 65 | 60.2 | 3913 | 31/03/XXXX | Closing Balance-1 | 20 | 62.2 | 1244 | |
-3 | 45 | 50.2 | 2259 | 31/03/XXXX | -2 | 65 | 60.2 | 3913 | |
31/03/XXXX | -3 | 45 | 50.2 | 2259 | |||||
Total | 220 | 13014 | 220 | 13014 |
WEIGHTED AVERAGE METHOD | |||||||||
Date | Particular (Debit) | Qty | Rate ($) | Amount | Date | Particular (Credit) | Qty | Rate ($) | Amount |
01/03/XXXX | Opening Inventory | 60 | 50.20 | 3012 | Closing Balance-1 | 265 | 54.07 | 14328 | |
05/03/XXXX | Purchase | 205 | 55.20 | 11316 | |||||
Total | 265 | 14328 | Total | 265 | 14328 | ||||
Opening Balance -1 | 265 | 54.07 | 14328 | 09/03/XXXX | Sales | 220 | 54.07 | 11895 | |
Closing Balance-1 | 45 | 54.07 | 2433 | ||||||
Total | 265 | 14328 | Total | 265 | 14328 | ||||
Opening Balance | 45 | 54.07 | 2433 | Closing Balance-1 | 110 | 57.69 | 6346 | ||
18/03/XXXX | Purchase | 65 | 60.20 | 3913 | |||||
Total | 110 | 6346 | Total | 110 | 6346 | ||||
Opening Balance -1 | 110 | 57.69 | 6346 | Closing Balance-1 | 220 | 59.95 | 13188 | ||
25/03/XXXX | Purchase | 110 | 62.20 | 6842 | |||||
Total | 220 | 13188 | Total | 220 | 13188 | ||||
Opening Balance -1 | 220 | 59.95 | 13188 | 29/03/XXXX | Sales | 90 | 59.95 | 5395 | |
31/03/XXXX | Closing Balance-1 | 130 | 59.95 | 7793 | |||||
Total | 220 | 13188 | 220 | 13188 |
Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions...
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 220 units @ $53.40 per unit Mar. 5 Purchase 285 units @ $58.40 per unit Mar. 9 Sales 380 units @ $88.40 per unit Mar. 18 Purchase 145 units @ $63.40 per unit Mar. 25 Purchase 270 units @ $65.40 per unit Mar. 29 Sales 250 units @...
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 220 units @ $53.40 per unit Mar. 5 Purchase 285 units @ $58.40 per unit Mar. 9 Sales 380 units @ $88.40 per unit Mar. 18 Purchase 145 units @ $63.40 per unit Mar. 25 Purchase 270 units @ $65.40 per unit Mar. 29 Sales 250 units @...
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 220 units @ $53.40 per unit Mar. 5 Purchase 285 units @ $58.40 per unit Mar. 9 Sales 380 units @ $88.40 per unit Mar. 18 Purchase 145 units @ $63.40 per unit Mar. 25 Purchase 270 units @ $65.40 per unit Mar. 29 Sales 250 units @...
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 220 units @ $53.40 per unit Mar. 5 Purchase 285 units @ $58.40 per unit Mar. 9 Sales 380 units @ $88.40 per unit Mar. 18 Purchase 145 units @ $63.40 per unit Mar. 25 Purchase 270 units @ $65.40 per unit Mar. 29 Sales 250 units @...
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 100 units @ $50.00 per unit 400 units @ $55.00 per unit 420 units @ $85.00 per unit Date Activities Mar. 1 Beginning inventory Mar. 5 Purchase Mar. 9 Sales Mar. 18 Purchase Mar. 25 Purchase Mar. 29 Sales Totals 120 units @ $60.00 per unit 200 units @ $62.00 per unit 160 units...
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 200 units @ $53.00 per unit 275 units@ $58.00 per unit Date Activities Mar. 1 Beginning inventory Mar. 5 Purchase Mar. 9 Sales Mar. 18 Purchase Mar. 25 Purchase Mar. 29 Sales Totals 360 units @ $88.00 per unit 135 units @ $63.00 per unit 250 units @ $65.00 per unit 230 units @...
Warnerwoods Company uses a perpetual Inventory system. It entered into the following purchases and sales transactions for March Units Sold at Retail Mar Mar 1 Beginning inventory 5 Purchase Units Acquired at Cost 240 units 553.80 per unit 205 units 558e per unit 600 units 588. Be per unit 155 units 290 units Mar. 18 Purchase Mar 25 Purchase Mar. 2 Sales Totals 563.80 per unit 565.8 per unit $98.8e per unit 278 units 670 units 3. Compute the cost...
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 60 units @ $50.20 per unit Mar. 5 Purchase 205 units @ $55.20 per unit Mar. 9 Sales 220 units @ $85.20 per unit Mar. 18 Purchase 65 units @ $60.20 per unit Mar. 25 Purchase 110 units @ $62.20 per unit Mar. 29 Sales 90 units @...
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 240 units @ $53.80 per unit Mar. 5 Purchase 295 units @ $58.89 per unit Mar 9 Sales 400 units @ $88.80 per unit Mar. 18 Purchase 155 units @ $63.80 per unit Mar. 25 Purchase 290 units@ $65.80 per unit Mar. 29 Sales 278 units @ $98.80...
Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March Units sold at Retail Date Activities Mar. 1 Beginning inventory Mar 5 Purchase Mar. 9 Sales Mar. 18 Purchase Mar. 25 Purchase Mar. 29 Sales Totals Units Acquired at Cost 248 units@ $53.8e pecunit 295 units@ $58.8e ped unit 155 units @ $63.89 per unit 298 units@ $65.88 per unit 400 units @ $88.80 per unit 270 units @ $98.89 per unit...