Question

In: Accounting

Problem 6-7AA Periodic: Alternative cost flows LO P3 Seminole Company began year 2017 with 23,000 units...

Problem 6-7AA Periodic: Alternative cost flows LO P3

Seminole Company began year 2017 with 23,000 units of product in its January 1 inventory costing $15.60 each. It made successive purchases of its product in year 2017 as follows. The company uses a periodic inventory system. On December 31, 2017, a physical count reveals that 41,000 units of its product remain in inventory.
  

Mar. 7 34,000 units @ $18.60 each
May 25 36,000 units @ $22.60 each
Aug. 1 26,000 units @ $24.60 each
Nov. 10 36,000 units @ $27.60 each


Required:
1. Compute the number and total cost of the units available for sale in year 2017.
2. Compute the amounts assigned to the 2017 ending inventory and the cost of goods sold using (a) FIFO, (b) LIFO, and (c) weighted average.

Solutions

Expert Solution

1 Units Rate Amount
Opening Inventory 23000 15.60 358800
Add: Purchases
07-Mar 34000 18.60 632400
25-May 36000 22.60 813600
01-Aug 26000 24.60 639600
10-Nov 36000 27.60 993600
Total Inventory Available 155000 3438000
Closing Inventory 41000
Sold Units 114000
2 Periodic Inventory System:
FIFO:(First In First Out i.e Ending Inventory will be from Latest Purchases) LIFO:(Last In First Out i.e Ending Inventory will be from Opening and First Purchases)
Ending Inventory: Units Rate Amount Ending Inventory: Units Rate Amount
10-Nov 36000 27.60 993600 Opening Inventory 23000 15.60 358800
01-Aug 5000 24.60 123000 07-Mar 18000 18.60 334800
41000 1116600 41000 693600
Total Inventory Available 155000 3438000 Total Inventory Available 155000 3438000
Less: Ending Inventory 41000 1116600 Less: Ending Inventory 41000 693600
Cost of Goods Sold 114000 2321400 Cost of Goods Sold 114000 2744400
Average Cost:
Units Rate Amount
Opening Inventory 23000 15.60 358800
Add: Purchases
07-Mar 34000 18.60 632400
25-May 36000 22.60 813600
01-Aug 26000 24.60 639600
10-Nov 36000 27.60 993600
Total Inventory Available 155000 22.18 3438000
(3438000/155000)
Units Rate Amount
Closing Inventory 41000 22.18 909406.5
Sold Units 114000 22.18 2528594
3438000

Related Solutions

Problem 6-7AA Periodic: Alternative cost flows LO P3 Seminole Company began year 2017 with 23,000 units...
Problem 6-7AA Periodic: Alternative cost flows LO P3 Seminole Company began year 2017 with 23,000 units of product in its January 1 inventory costing $15.60 each. It made successive purchases of its product in year 2017 as follows. The company uses a periodic inventory system. On December 31, 2017, a physical count reveals that 41,000 units of its product remain in inventory.    Mar. 7 34,000 units @ $18.60 each May 25 36,000 units @ $22.60 each Aug. 1 26,000...
Problem 6-7AA Periodic: Alternative cost flows LO P3 Seminole Company began year 2017 with 28,000 units...
Problem 6-7AA Periodic: Alternative cost flows LO P3 Seminole Company began year 2017 with 28,000 units of product in its January 1 inventory costing $16.60 each. It made successive purchases of its product in year 2017 as follows. The company uses a periodic inventory system. On December 31, 2017, a physical count reveals that 51,000 units of its product remain in inventory. Mar. 7 44,000 units@ $19.60 each May 25 46,000 units @ $23.60 each Aug. 1 36,000 units @...
Problem 6-4AA Periodic: Alternative cost flows LO P3 Montoure Company uses a periodic inventory system. It...
Problem 6-4AA Periodic: Alternative cost flows LO P3 Montoure Company uses a periodic 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 670 units @ $70.00 per unit Feb. 10 Purchase 435 units @ $67.00 per unit Mar. 13 Purchase 235 units @ $52.00 per unit Mar. 15 Sales 835 units @ $100.00 per unit Aug. 21 Purchase 170 units @ $75.00 per...
Problem 6-4AA Periodic: Alternative cost flows LO P3 Montoure Company uses a periodic inventory system. It...
Problem 6-4AA Periodic: Alternative cost flows LO P3 Montoure Company uses a periodic 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 @ $45.00 per unit Feb. 10 Purchase 400 units @ $42.00 per unit Mar. 13 Purchase 200 units @ $27.00 per unit Mar. 15 Sales 800 units @ $75.00 per unit Aug. 21 Purchase 100 units @ $50.00...
Problem 6-4AA Periodic: Alternative cost flows LO P3 Montoure Company uses a periodic inventory system. It...
Problem 6-4AA Periodic: Alternative cost flows LO P3 Montoure Company uses a periodic 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 790 units @ $85.00 per unit Feb. 10 Purchase 495 units @ $82.00 per unit Mar. 13 Purchase 295 units @ $67.00 per unit Mar. 15 Sales 895 units @ $115.00 per unit Aug. 21 Purchase 290 units @ $90.00...
Problem 6-2AA Periodic: Alternative cost flows LO P3 [The following information applies to the questions displayed...
Problem 6-2AA Periodic: Alternative cost flows LO P3 [The following information applies to the questions displayed below.] Warnerwoods Company uses a periodic 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 125 units @ $60 per unit Mar. 5 Purchase 425 units @ $65 per unit Mar. 9 Sales 445 units @ $95 per unit Mar. 18 Purchase 170 units @ $70...
Problem 6-2AA Periodic: Alternative cost flows LO P3 [The following information applies to the questions displayed...
Problem 6-2AA Periodic: Alternative cost flows LO P3 [The following information applies to the questions displayed below.] Warnerwoods Company uses a periodic 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 200 units @ $90 per unit Mar. 5 Purchase 500 units @ $95 per unit Mar. 9 Sales 520 units @ $125 per unit Mar. 18 Purchase 320 units @ $100...
Problem 6-2AA Periodic: Alternative cost flows LO P3 [The following information applies to the questions displayed...
Problem 6-2AA Periodic: Alternative cost flows LO P3 [The following information applies to the questions displayed below.] Warnerwoods Company uses a periodic 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 190 units @ $80 per unit Mar. 5 Purchase 490 units @ $85 per unit Mar. 9 Sales 510 units @ $115 per unit Mar. 18 Purchase 300 units @ $90...
Problem 6-2AA Periodic: Alternative cost flows LO P3 [The following information applies to the questions displayed...
Problem 6-2AA Periodic: Alternative cost flows LO P3 [The following information applies to the questions displayed below.] Warnerwoods Company uses a periodic 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 125 units @ $60 per unit Mar. 5 Purchase 425 units @ $65 per unit Mar. 9 Sales 445 units @ $95 per unit Mar. 18 Purchase 170 units @ $70...
Problem 6-2AA Periodic: Alternative cost flows LO P3 Skip to question [The following information applies to...
Problem 6-2AA Periodic: Alternative cost flows LO P3 Skip to question [The following information applies to the questions displayed below.] Warnerwoods Company uses a periodic 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 150 units @ $40 per unit Mar. 5 Purchase 450 units @ $45 per unit Mar. 9 Sales 470 units @ $75 per unit Mar. 18 Purchase 220...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT