Solution:
Computation of ending inventory COGS under FIFO | ||||||||||||
Date | Beginning Inventory | Purchase | Cost of Goods Sold | Ending Inventory | ||||||||
Qty | Rate | Amount | Qty | Rate | Amount | Qty | Rate | Amount | Qty | Rate | Amount | |
1-Aug | 60 | $25.00 | $1,500.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 60 | $25.00 | $1,500.00 |
3-Aug | 60 | $25.00 | $1,500.00 | 0 | $0.00 | $0.00 | 45 | $25.00 | $1,125.00 | 15 | $25.00 | $375.00 |
8-Aug | 15 | $25.00 | $375.00 | 65 | $41.00 | $2,665.00 | 0 | $0.00 | $0.00 | 15 | $25.00 | $375.00 |
65 | $41.00 | $2,665.00 | ||||||||||
21-Aug | 15 | $25.00 | $375.00 | 0 | $0.00 | $0.00 | 15 | $25.00 | $375.00 | 25 | $41.00 | $1,025.00 |
65 | $41.00 | $2,665.00 | 40 | $41.00 | $1,640.00 | |||||||
30-Aug | 25 | $41.00 | $1,025.00 | 20 | $56.00 | $1,120.00 | 0 | $0.00 | $0.00 | 25 | $41.00 | $1,025.00 |
20 | $56.00 | $1,120.00 | ||||||||||
Total | 100 | $3,140.00 | 45 | $2,145.00 |
Computation of ending inventory COGS under LIFO | ||||||||||||
Date | Beginning Inventory | Purchase | Cost of Goods Sold | Ending Inventory | ||||||||
Qty | Rate | Amount | Qty | Rate | Amount | Qty | Rate | Amount | Qty | Rate | Amount | |
1-Aug | 60 | $25.00 | $1,500.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 60 | $25.00 | $1,500.00 |
3-Aug | 60 | $25.00 | $1,500.00 | 0 | $0.00 | $0.00 | 45 | $25.00 | $1,125.00 | 15 | $25.00 | $375.00 |
8-Aug | 15 | $25.00 | $375.00 | 65 | $41.00 | $2,665.00 | 0 | $0.00 | $0.00 | 15 | $25.00 | $375.00 |
65 | $41.00 | $2,665.00 | ||||||||||
21-Aug | 15 | $25.00 | $375.00 | 0 | $0.00 | $0.00 | 55 | $41.00 | $2,255.00 | 15 | $25.00 | $375.00 |
65 | $41.00 | $2,665.00 | 10 | $41.00 | $410.00 | |||||||
30-Aug | 15 | $25.00 | $375.00 | 20 | $56.00 | $1,120.00 | 0 | $0.00 | $0.00 | 15 | $25.00 | $375.00 |
10 | $41.00 | $410.00 | 10 | $41.00 | $410.00 | |||||||
20 | $56.00 | $1,120.00 | ||||||||||
Total | 100 | $3,380.00 | 45 | $1,905.00 |
Computation of ending inventory COGS under Weighted Average Cost | ||||||||||||
Date | Beginning Inventory | Purchase | Cost of Goods Sold | Ending Inventory | ||||||||
Qty | Rate | Amount | Qty | Rate | Amount | Qty | Rate | Amount | Qty | Rate | Amount | |
1-Aug | 60 | $25.00 | $1,500 | 0 | $0.00 | $0 | 0 | $0.00 | $0 | 60 | $25.00 | $1,500 |
3-Aug | 60 | $25.00 | $1,500 | 0 | $0.00 | $0 | 45 | $25.00 | $1,125 | 15 | $25.00 | $375 |
8-Aug | 15 | $25.00 | $375 | 65 | $41.00 | $2,665 | 0 | $0.00 | $0 | 80 | $38.00 | $3,040 |
21-Aug | 80 | $38.00 | $3,040 | 0 | $0.00 | $0 | 55 | $38.00 | $2,090 | 25 | $38.00 | $950 |
30-Aug | 25 | $38.00 | $950 | 20 | $56.00 | $1,120 | 0 | $0.00 | $0 | 45 | $46.00 | $2,070 |
Total | 100 | $3,215 | 45 | $2,070 |
Income Statement | |||
Particulars | Weighted Average | FIFO | LIFO |
Sales | $7,970 | $7,970 | $7,970 |
Cost of goods sold | $3,215 | $3,140 | $3,380 |
Gross Profit (Sales - COGS) | $4,755 | $4,830 | $4,590 |
A company uses a perpetual inventory system. At the beginning of August the company had 60...
A company began August with 75 units of inventory that cost $20 each. Assume a perpetual inventory system. During August, the company had the following transactions: E (Click the icon to view the transactions.) Determine the company's cost of goods sold for August using each of the inventory costing methods indicated. (For weighted-average calculations, round per unit costs to the nearest cent and all other amounts to the nearest dollar.) i Data Table The cost of goods sold amount for...
Iron Man began August with 75 units of iron inventory that cost $20 each. During August, the company completed the following inventory transactions: (Click the icon to view the transactions.) i Data Table Units Unit Cost Unit Sales Price $ 59 Aug. 3 Sale 8 Purchase 21 Sale $ 28 70 60 75 30 Purchase Print Done Requirem Requirements 1. Prepare a perpetual inventory record for the merchandise inventory using the FIFO inventory costing method. 2. Prepare a perpetual inventory...
A company sells tires and uses a perpetual inventory system. The following is available for the month: (Click the icon to view the transactions.) () Indicate gross profit for the month assuming FIFO inventory costing. Gross profit is $ using the FIFO inventory costing method. (ii) Indicate gross profit for the month assuming LIFO inventory costing Gross profit is $ L u sing the LIFO inventory costing method. (iii) Indicate gross profit for the month assuming weighted average inventory costing....
Montoure Company uses a perpetual inventory system. It entered into the following calendar-year purchases Date Activities Units Acquired at Cost Units sold at Retail Jan. 1 Beginning inventory 540 units @ $40 per unit Feb. 10 Purchase 320 units @ $36 per unit Mar. 13 Purchase 100 units @ $24 per unit Mar. 15 Sales 650 units @ $85 per unit Aug. 21 Purchase 120 units @ $45 per unit Sept. 5 Purchase 520 units @ $41 per unit Sept....
Montoure Company uses a perpetual inventory system. It entered into the following calendar-year purchases and sales transactions Date Activities Units Acquired at Cost Units Sold at Retail Jan. 1 Beginning inventory 600 units $40 per unit Feb. 10 Purchase 400 units@ $37 per unit Mar. 13 Purchase 190 units@ $15 per unit Mar. 15 Sales 805 units@ $70 per unit Aug. 21 Purchase 190 units @ $45 per unit Sept. 5 Purchase 550 units @ $43 per unit Sept. 10...
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 @...
Montoure Company uses a perpetual inventory system. It entered into the following calendar-year purchases and sales transactions Date Activities Units Acquired at Cost Units Sold at Retail Jan. 1 Beginning inventory 600 units @ $35 per unit Feb. 10 Purchase 300 units @ $32 per unit Mar. 13 Purchase 150 units @ $20 per unit Mar. 15 Sales 725 units @ $80 per unit Aug. 21 Purchase 190 units @ $40 per unit Sept. 5 Purchase 540 units @ $37...
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...
Montoure Company uses a perpetual inventory system. It entered into the following calendar-year 2015 purchases and sales transactions. Units Sold at Retail Date Activities Jan. 1 Beginning inventory Feb. 10 Purchase Units Acquired at Cost 540 units @ $55,00 per unit 460 units @ $53 per unit 100 units @ $40 pe Mar. 13 Purchase unit Mar. 15 Sales 745 units @ $80 per unit 170 units @ $ 61 per unit Aug. 21 Purchase Sept. 5 Purchase Sept. 10...
Montoure Company uses a perpetual Inventory system. It entered into the following calendar-year purchases and sales transactions Units sold at Retail Unite Aequired at Cost 680 units 540 per unit 320 units @ $35 per unit 100 units $23 per unit Date Activities Jan. Beginning inventory Feb. 10 Purchase Mar. 13 Purchase Mar. 15 Sales Aug. 21 Purchase Sept. 5 Purchase Sept. 10 Sales Totals 720 unitse $75 per unit 130 units 490 units $45 per unit $41 per unit...