Question

In: Accounting

Cullumber Company uses a perpetual inventory system. The following information is available for November: Units Purchase...

Cullumber Company uses a perpetual inventory system. The following information is available for November:
Units Purchase Price Sales Price
Nov. 1 Balance 8 $6.00
4 Purchase 18 $6.50
7 Purchase 20 $7.00
10 Sale (8) $9.00
12 Sale (30) $9.00

Calculate the cost of goods sold and ending inventory under FIFO. (Round answers to 0 decimal places, e.g. 5,275.)

FIFO
Cost of goods sold $
Ending inventory $

Calculate the cost of goods sold and ending inventory under weighted average. (Round the weighted average cost per unit to two decimal places, e.g. 5.27 and final answers to 0 decimal places, e.g. 5,275.)

Weighted average
Cost of goods sold $
Ending inventory $

Solutions

Expert Solution

Part 1

Available for sale Cost of goods sold Ending Inventory
Date Units Unit cost Total Cost Units Unit cost Total Cost Units Unit Cost Total Cost
Nov-01 8 6.00 48.00
Nov-04 18 6.50 117.00 8 6.00 48.00
18 6.50 117.00
Nov-07 20 7.00 140.00 8 6.00 48.00
18 6.50 117.00
20 7.00 140.00
Nov-10 8 6.00 48.00 18 6.50 117.00
20 7.00 140.00
Nov-12 18 6.50 117.00
12 7.00 84.00 8 7.00 56.00
Total 249.00 8 56.00
FIFO
Cost of goods sold $249
Ending inventory $56

Part 2

Available for sale Cost of goods sold Ending Inventory
Date Units Unit cost Total Cost Units Unit cost Total Cost Units Unit Cost Total Cost
Nov-01 8 6.00 48
Nov-04 18 6.50 117.00 26 6.35 165
Nov-07 20 7.00 140.00 46 6.63 305
Nov-10 8 6.63 53 38 6.63 252
Nov-12 30 6.63 199 8 6.63 53
Total 252 8 53
Weighted average
Cost of goods sold $252
Ending inventory $53

Related Solutions

Sheridan Company uses a perpetual inventory system. The following information is available for November: Units Purchase...
Sheridan Company uses a perpetual inventory system. The following information is available for November: Units Purchase Price Sales Price Nov. 1 Balance 8 $4.00 4 Purchase 20 $4.50 7 Purchase 20 $5.00 10 Sale (8) $8.00 12 Sale (32) $8.00 Calculate the cost of goods sold and ending inventory under FIFO and Calculate the cost of goods sold and ending inventory under weighted average
Kayla Company uses the perpetual inventory system and the LIFO method. The following information is available...
Kayla Company uses the perpetual inventory system and the LIFO method. The following information is available for the month of June: June 1 Beginning inventory 200 units @ $5 12 Purchase on account 400 units @ $6 15 Sales on account 440 units 23 Purchase on account 300 units @ $7 27 Sales on account 360 units The selling price (price the company charged the customers) was $10 per unit. a) Show the calculation of cost of goods sold and...
Consider the following information for Maynor Company, which uses a perpetual inventory system:    Transaction Units...
Consider the following information for Maynor Company, which uses a perpetual inventory system:    Transaction Units Unit Cost Total Cost January 1 Beginning Inventory 10 $ 60 $ 600 March 28 Purchase 20 66 1,320 August 22 Purchase 20 70 1,400 October 14 Purchase 25 76 1,900 Goods Available for Sale 75 $ 5,220 The company sold 25 units on May 1 and 20 units on October 28. Required: Calculate the company's ending inventory and cost of goods sold using...
Consider the following information for Maynor Company, which uses a perpetual inventory system:    Transaction Units...
Consider the following information for Maynor Company, which uses a perpetual inventory system:    Transaction Units Unit Cost Total Cost January 1 Beginning Inventory 26 $ 76 $ 1,976 March 28 Purchase 36 82 2,952 August 22 Purchase 52 86 4,472 October 14 Purchase 57 92 5,244 Goods Available for Sale 171 $ 14,644 The company sold 57 units on May 1 and 52 units on October 28. Required: Calculate the company's ending inventory and cost of goods sold using...
The following information is available for the month ofApril. The company uses the perpetual inventory method....
The following information is available for the month ofApril. The company uses the perpetual inventory method. April 1 inventory balance 120 units @$8.04 each April 10purchase 200 units @ $8.20 each April 20purchase 410 units @ $8.40 each April 22sale 630 units @ $15.00 each April 25purchase 310 units @ $8.59 each a. Compute the value of ending inventory under LIFO,show steps. b. Compute the value of ending inventory under FIFO,show steps. c. Which inventory costing method results in the...
Cullumber Company uses the periodic inventory system and had 100 units in beginning inventory at a...
Cullumber Company uses the periodic inventory system and had 100 units in beginning inventory at a total cost of $10,000. The company purchased 200 units at a total cost of $26,000. At the end of the year, Cullumber had 60 units in ending inventory. Compute the cost of the ending inventory and the cost of goods sold under FIFO, LIFO, and average-cost.
The CAL Company maintains a perpetual inventory system. The following information is available related to its...
The CAL Company maintains a perpetual inventory system. The following information is available related to its December 31, 2020 year end: 1. Inventory costing $5,500 was received on December 20, 2020, on consignment from PPC. No journal entry has been made. 2. An invoice for $2,500, terms f.o.b. shipping point, was received and entered on December 30, 2020. The receiving report shows that the inventory was received on January 4, 2021, and the bill of lading shows that the inventory...
Flint Company uses the periodic inventory method and had the following inventory information available: Units Unit...
Flint Company uses the periodic inventory method and had the following inventory information available: Units Unit Cost Total Cost 1/1 Beginning Inventory 92 $4 $368 1/20 Purchase 460 $5 2,300 7/25 Purchase 92 $7 644 10/20 Purchase 276 $8 2,208 Total 920 $5,520 A physical count of inventory on December 31 revealed that there were 322 units on hand. Answer the following independent questions. (Round average cost per unit to 2 decimal places, e.g. 5.25 and final answers to 0...
Hansen Company uses the periodic inventory method and had the following inventory information available: Units Unit...
Hansen Company uses the periodic inventory method and had the following inventory information available: Units Unit Cost Total Cost 1/1 Beginning Inventory 100 $3 $300 1/20 Purchase 500 $4 2,000 7/25 Purchase 100 $5 500 10/20 Purchase 300 $6 1,800 1,000 $4,600 A physical count of inventory on December 31 revealed that there were 380 units on hand. Answer the following independent questions. 1. Assume that the company uses the FIFO method. The value of the ending inventory at December...
Morton Company uses the periodic inventory method and had the following inventory information available: Units Unit...
Morton Company uses the periodic inventory method and had the following inventory information available: Units Unit Cost Total Cost 1/1 Beginning Inventory 100 $4 $400 1/20 Purchase 400 $5 2,000 7/25 Purchase 200 $7 1,400 10/20 Purchase 300 $8 2,400 1,000 $6,200 A physical count of inventory on December 31 revealed that there were 350 units on hand. Determine the difference in the amount of income that the company would have reported if it had used the FIFO method instead...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT