Question

In: Accounting

Potter Company has the following data​ available: Transaction Units Purchased Unit Cost Units Sold Beginning Inventory...

Potter Company has the following data​ available: Transaction Units Purchased Unit Cost Units Sold Beginning Inventory 500 ​$10 March 1 Purchase 200 ​$12 April 25 Sale 350 June 10 Purchase 300 ​$14 July 20 Sale 250 October 30 Purchase 300 ​$15 December 15 Sale 400 If Potter Company uses a perpetual movingminus average inventory​ system, the cost of goods sold for the year is​ ________. ​ (Round average cost per unit to four decimal places and all other numbers to two decimal​ places.) correct answer is $12,087.88 ( I would like to see the break down of calculations pls)

Solutions

Expert Solution

Average cost

Beginning inventory

Purchase of goods

Cost of goods sold Average cost

Ending inventory Average cost

Units

Cost per unit

Amount

Units

Cost per unit

Amount

Units sold

Cost per unit

Amount

Units

Cost per unit

Amount

Beginning inventory

500

10

5000

500

10

5000

Mar-01

500

10

5000

200

12

2400

700

10.5714

7400

Apr-25

700

10.5714

7400

350

10.5714

3700

350

10.5714

3700

Jun-10

350

10.5714

3700

300

14

4200

650

12.1538

7900

Jul-20

650

12.1538

7900

250

12.1538

3038.45

400

12.1538

4861.55

Oct-30

400

12.1538

4861.55

350

15

5250

750

13.4821

10111.5

Dec-15

750

13.4821

10111.5

400

13.4821

5392.84

350

13.4821

4718.7

So cost of goods sold = $12,131.29

If any difference is due to rounding off


Related Solutions

Philips Company has the following data available Transaction Units purchased Unit cost Units sold Transaction 300...
Philips Company has the following data available Transaction Units purchased Unit cost Units sold Transaction 300 10 March 1 Purchase 200 12 April 25 sale 330 June 10 Purchase 370 14 July 20 sale 250 October 30 Purchase 340 11 December 15 sale 390 if Philips uses a perpetual FIFO inventory system, the cost of ending inventory on Dec 31 is I need the steps in the form of table
Coopers Company reported the following information: Units Unit Cost Units Sold Jan 1 Beginning inventory 190...
Coopers Company reported the following information: Units Unit Cost Units Sold Jan 1 Beginning inventory 190 $50 Mar 8 Sale 100 Apr 10 Purchase 320 55 Jun 20 Sale 240 Oct 10 Purchase 570 60 Nov 30 Sale 450 Total Selling price per unit during the year: $75    790 Required Complete the following table. Cost Total Periodic Perpetual Date Purchased per Unit Cost Sold FIFO Weighted Average Units $ $ Units Units $ $ Units $ $
Use the following data of Makrel ​Sales, Inc.: Unit Total Units Units Cost Cost Sold Beginning...
Use the following data of Makrel ​Sales, Inc.: Unit Total Units Units Cost Cost Sold Beginning inventory 18 $6 $108 Purchase on Apr 25 35 7 245 Purchase on Nov 16 13 10 130 Sales 45 ? ? MakrelMakrel ​Sales' LIFO cost of ending inventory would be A.$186. B.$129. C.$154. D.$450.
AU Company has the following inventory transactions for the month of March: Units Unit Cost Beginning,...
AU Company has the following inventory transactions for the month of March: Units Unit Cost Beginning, Mar. 1 10,000 15 Purchases, Mar. 10 20,000 18 Sold, Mar. 15 15,000 Purchases, Mar. 18 5,000 23 Sold, Mar. 25 6,000 The company uses the perpetual inventory system. Determine the cost of inventory on March 31 and cost of goods sold under: Inventory Cost Flow Ending Inventory Cost of Goods Sold First in, first out (FIFO) Moving Average Last in, first out (LIFO)
EBECEDE Company has the following inventory transactions for the month of February: Units Unit Cost Beginning,...
EBECEDE Company has the following inventory transactions for the month of February: Units Unit Cost Beginning, Feb. 1 10,000 40 Purchases, Feb. 10 10,000 43 Sold, Feb. 15 15,000 Purchases, Feb. 18 5,000 44 Sold, Feb. 25 2,000 The company uses the perpetual inventory system. Determine the cost of inventory on February 29 and cost of goods sold under: Inventory Cost Flow Ending Inventory Cost of Goods Sold (COGS First in, first out (FIFO) Weighted Average Last in, first out...
Inventory records for a company revealed the following: Date Transaction Number of Units Unit Cost Apr....
Inventory records for a company revealed the following: Date Transaction Number of Units Unit Cost Apr. 1 Beginning inventory 500 $2.40 Apr. 20 Purchase 400 $2.50 The company sold 700 units of inventory during the month. Cost of goods sold assuming FIFO would be: a. $1,690 b. $1,720. c. $1,700. d. $1,730. e. $1,710. If management can estimate the amount of loss that will occur due to litigation against the company, and the likelihood of the loss is reasonably possible,...
Courtney Company uses a periodic inventory system. The following data were available: beginning inventory, 1,900 units...
Courtney Company uses a periodic inventory system. The following data were available: beginning inventory, 1,900 units at $20; purchases, 5,700 units at $25; operating expenses (excluding income taxes), $96,000; ending inventory per physical count at December 31, 1,200 units; sales price per unit, $50; and average income tax rate, 30%. Required: 1. Prepare income statements under the FIFO, LIFO, and weighted average costing methods. (Do not round intermediate calculations. Round your final answers to the nearest dollar amount.) Between FIFO...
Inventory records for Marvin Company revealed the following: Date Transaction Number of Units Unit Cost Mar....
Inventory records for Marvin Company revealed the following: Date Transaction Number of Units Unit Cost Mar. 1 Beginning inventory 960 $7.15 Mar. 10 Purchase 540 7.65 Mar. 16 Purchase 395 8.25 Mar. 23 Purchase 530 8.95 Marvin sold 1,790 units of inventory during the month. Ending inventory assuming FIFO would be (Do not round your intermediate calculations. Round your answer to the nearest dollar amount): $5,610 $1,156 $6,864 $1,541
Inventory records for Marvin Company revealed the following: Date Transaction Number of Units Unit Cost Mar....
Inventory records for Marvin Company revealed the following: Date Transaction Number of Units Unit Cost Mar. 1 Beginning inventory 1,000 $ 7.26 Mar. 10 Purchase 540 7.71 Mar. 16 Purchase 760 8.14 Mar. 23 Purchase 590 8.54 Marvin sold 1,910 units of inventory during the month. Cost of goods sold assuming FIFO would be:
Inventory records for Marvin Company revealed the following: Date Transaction Number of Units Unit Cost   Mar....
Inventory records for Marvin Company revealed the following: Date Transaction Number of Units Unit Cost   Mar. 1 Beginning inventory 1,070    $7.29      Mar. 10 Purchase 580    7.79      Mar. 16 Purchase 445    8.39      Mar. 23 Purchase 550    9.09    Marvin sold 1,960 units of inventory during the month. Ending inventory assuming FIFO would be
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT