Question

In: Accounting

Marigold Corp. had a beginning inventory of 110 units of Product RST at a cost of...

Marigold Corp. had a beginning inventory of 110 units of Product RST at a cost of $7 per unit. During the year, purchases were:

Feb. 20 660 units at $8

Aug. 12 430 units at $10

May 5 530 units at $9

Dec. 8 110 units at $11

Marigold uses a periodic inventory system. Sales totaled 1,560 units.

What are the ending inventory and cost of goods sold in FIFO LIFO AVERAGE-COST.

Solutions

Expert Solution

First let us compute the ending inventory balance unit

Ending inventory = Opening + Purchase - Sales

= (110) + (660 + 430 + 530 + 110) - (1560)

= 280 units

1) Now let us compute inventory amount and cost of goods sold under FIFO method

First in fist out means - all the inventory from the beginning gets consumed first and the ending balance basically comes from last purchased units. Last purchased batch are 110 units @ 11. So the balance of 170 units (280 - 110) comes from May 5th batch of 530 units purchased at 9 per unit.

Hence ending inventory cost = 110*11 + 170*9

= 1,210 + 1,530

Ending inventory of 280 units under FIFO method = $ 2,740

Cost of goods sold units = Opening + Purchase - ending

= 110*7 + (660*8 + 430*10 + 530*9 + 110*11) - 2,740

= 770 + 5280 + 4300 + 4770 + 1210 - 2740

CGS under FIFO = 3,310

2) Ending inventory and CGS under LIFO method

Under LIFO the opening units and early putrchases will remain in the closing balance as later purchases are consumed early. Hence the inventory of 280 units will comprise of 110 units @7 from opening balance and 170 units from Feb 20 purchase of units @ 8.

Hence ending inventory cost = 110*7 + 170*8

= 770 + 1,360

= 2,130

Ending inventory of 280 units under LIFO method = $ 2,130

Cost of goods sold units = Opening + Purchase - ending

= 110*7 + (660*8 + 430*10 + 530*9 + 110*11) - 2,130

= 6050 - 2130

CGS under LIFO = 3,920

3) Inventory and CGS under Average cost method

Need to compute weighted average cost per unit

110*7 = 770

660*8 = 5,280

430*10 = 4,300

530*9 = 4,770

110*11 = 1210

Total cost = 16,330

Total units = 1,840

Average cost = 8.875 per unit

Ending inventory = 280 units * 8.875

Ending inventory under average cost methods = $ 2,485

Cost of goods sold units = Opening + Purchase - ending

= 110*7 + (660*8 + 430*10 + 530*9 + 110*11) - 2,485

= 6050 - 2,485

Cost of goods sold under average inventory method = 3,565

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

Whispering Winds Corp. Inc. had a beginning inventory of 95 units of Product RST at a...

Whispering Winds Corp. Inc. had a beginning inventory of 95 units of Product RST at a cost of $7 per unit. During the year, purchases were: Feb. 20 610 units at $8 Aug. 12 395 units at $10 May 5 480 units at $9 Dec. 8 100 units at $11 Whispering Winds Corp. uses a periodic inventory system. Sales totaled 1,535 units. Determine the ending inventory and the cost of goods sold under each of the assumed cost flow methods...

Swifty Corporation had a beginning inventory of 120 units of Product RST at a cost of...

Swifty Corporation had a beginning inventory of 120 units of Product RST at a cost of $7 per unit. During the year, purchases were: Feb. 20 630 units at $8 Aug. 12 445 units at $10 May 5 535 units at $9 Dec. 8 120 units at $11 Swifty uses a periodic inventory system. Sales totaled 1,500 units. The cost of goods available for sale 16465 Average Cost 8.9 Determine the ending inventory and the cost of goods sold under...

Concord Corporation Inc. had a beginning inventory of 100 units of Product RST at a cost...

Concord Corporation Inc. had a beginning inventory of 100 units of Product RST at a cost of $6 per unit. During the year, purchases were: Feb. 20 585 units at $7 Aug. 12 405 units at $9 May 5 495 units at $8 Dec. 8 100 units at $10 Concord Corporation uses a periodic inventory system. Sales totaled 1,570 units. Determine the ending inventory and the cost of goods sold under each of the assumed cost flow methods (FIFO, LIFO,...

Problem 6-03A Blue Spruce Corp. had a beginning inventory of 100 units of Product RST at...

Problem 6-03A Blue Spruce Corp. had a beginning inventory of 100 units of Product RST at a cost of $9 per unit. During the year, purchases were: Feb. 20 650 units at $10 Aug. 12 460 units at $12 May 5 590 units at $11 Dec. 8 100 units at $13 Blue Spruce uses a periodic inventory system. Sales totaled 1,510 units. Determine the cost of goods available for sale. The cost of goods available for sale $enter the cost...

Groves Company Inc. had a beginning inventory of 300 units of Product MLN at a cost...

Groves Company Inc. had a beginning inventory of 300 units of Product MLN at a cost of $8 per unit. During the year, purchases were: Feb. 20 700 units at $9 Aug. 12 600 units at $11 May 5 500 units at $10 Dec. 8 100 units at $12 Groves Company uses a periodic inventory system. Sales totaled 1,800 units. Instructions: (a) determine the cost of goods available for sale. (b) Determine the ending inventory and the cost of goods...

Monty Corp. uses the periodic inventory system and had 150 units in beginning inventory at a...

Monty Corp. uses the periodic inventory system and had 150 units in beginning inventory at a total cost of $15,000. The company purchased 300 units at a total cost of $39,000. At the end of the year, Monty had 80 units in ending inventory. Compute the cost of the ending inventory and the cost of goods sold under FIFO, LIFO, and average-cost. (Round average-cost per unit and final answers to 0 decimal places, e.g. 1,250.) FIFO LIFO Average-cost The cost...

Cheyenne Corp. uses the periodic inventory system and had 160 units in beginning inventory at a...

Cheyenne Corp. uses the periodic inventory system and had 160 units in beginning inventory at a total cost of $20,000. The company purchased 320 units at a total cost of $49,600. At the end of the year, Cheyenne had 85 units in ending inventory. (a) Compute the cost of the ending inventory and the cost of goods sold under FIFO, LIFO, and average-cost.

Campbell Company had 400 units of product in work in process inventory at the beginning of...

Campbell Company had 400 units of product in work in process inventory at the beginning of the period. It started 1,300 units during the period and transferred 1,100 units to finished goods inventory. The ending work in process inventory was estimated to be 60 percent complete. Cost data for the period follow: Product Costs Beginning balance $ 37,560 Added during period 58,800 Total $ 96,360 Required Calculate the number of equivalent units of production. Calculate the product cost per equivalent...

Ace Corp. had the following information for the year. Beginning Inventory at January 1 200 units...

Ace Corp. had the following information for the year. Beginning Inventory at January 1 200 units @ $160 per unit Inventory Purchase, March 400 units @ $180 per unit Inventory Purchase, August 300 units @ $200 per unit Inventory Purchase, October 25 units @ $21 per unit Ending Inventory at December 31 350 units What is Ace Corp’s: Cost of goods sold for the year, using FIFO? Ending inventory at December 31, using FIFO? Cost of goods sold for the...

During the most recent year, Boston Corp. had the following data: Beginning inventory in units - ...

During the most recent year, Boston Corp. had the following data: Beginning inventory in units - Units produced 15,000 Units sold ($125 per unit) 12,000 Variable costs per unit: Direct materials $15 Direct labor $20 Variable overhead $10 Fixed costs: Fixed overhead per unit produced $20 Fixed selling and administrative $ 200,000 Required: A. How many units are in ending inventory? B. Using absorption costing, calculate the per-unit product cost....

Subjects