Question

A company uses a perpetual inventory system. At the beginning of August the company had 60 units of inventory with a per unit

0 0
Add a comment Improve this question Transcribed image text
Answer #1

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
Add a comment
Know the answer?
Add Answer to:
A company uses a perpetual inventory system. At the beginning of August the company had 60...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • A company began August with 75 units of inventory that cost $20 each. Assume a perpetual inventory system. During Augus...

    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,...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT