Question

In: Accounting

The Lippert Company uses the perpetual inventory system. The following July data are for an item...

The Lippert Company uses the perpetual inventory system. The following July data are for an item in Lippert's inventory:

July 1 Beginning inventory 60 units @ $11 per unit
10 Purchased 80 units @ $12 per unit
15 Sold 90 units @
26 Purchased 55 units @ $13 per unit

Calculate the cost of goods sold for the July 15 sale using (a) first-in, first-out, (b) last-in, first-out, and (c) the weighted-average cost methods.

Round your final answers to the nearest dollar. For weighted-average cost, do not round the weighted-average unit cost

Solutions

Expert Solution

Cost of goods sold for July 15 sale =

FIFO LIFO Weighted Average
Cost of Goods Sold $                 1,020 $                   1,070 $             1,041

Working

Units Cost per unit value
Beginning Balance 60 $                   11.00 $ 660
Purchases
80 $                   12.00 $ 960
Total 140 $ 1,620

.

Average Cost of Inventory
Units (A) 140
Total Cost (B) $ 1,620
Average Cost (C=B/A) $              11.5714

.

FIFO
Total Units Available for sale 140
Units Sold 90
Closing Stock in Units 50
Valuation
Ending Inventory 50 @ $             12.00 $ 600
0 @ $             25.00 $ 0
Value Of Ending Inventory $ 600
Cost of Goods sold $ 1,020
LIFO
Total Units Available for sale 140
Units Sold 90
Closing Stock in Units 50
Valuation
Ending Inventory 50 @ $             11.00 $ 550
0 @ $             24.00 $ 0
Value Of Ending Inventory $                  550
Cost of Goods sold 1620 minus 550 $              1,070
Weighted Average method
Total Units Available for sale 140
Units Sold 90
Closing Stock in Units 50
Valuation
Ending Inventory 50 @ $        11.5714 $                  579
Value Of Ending Inventory $                  579
Cost of Goods sold (Total Purchase and opening stock Minus Closing Stock) $              1,041

Related Solutions

The Lippert Company uses the periodic inventory system. The following July data are for an item...
The Lippert Company uses the periodic inventory system. The following July data are for an item in loppers inventory: July 1 Beginning Inventory 100 units@ $8 per unit 10 Purchased 120 units@ $9 per unit 15 sold 130 units@ 26 Purchased 95 units@ $10 per unit Calculate the cost of goods sole for July and ending inventory at July 31 using (a) first-in, first out (b) last-in, first out and (c) the weighted- average cost methods. Round your final answers...
Inventory Costing Methods-Periodic Method The Lippert Company uses the periodic inventory system. The following July data...
Inventory Costing Methods-Periodic Method The Lippert Company uses the periodic inventory system. The following July data are for an item in Lippert's inventory: July 1 Beginning inventory 40 units @ $9 per unit 10 Purchased 60 units @ $10 per unit 15 Sold 70 units @ 26 Purchased 35 units @ $11 per unit Calculate the cost of goods sold for July and ending inventory at July 31 using (a) first-in, first-out, (b) last-in, first-out, and (c) the weighted-average cost...
Inventory Costing Methods-Periodic Method The Lippert Company uses the periodic inventory system. The following July data...
Inventory Costing Methods-Periodic Method The Lippert Company uses the periodic inventory system. The following July data are for an item in Lippert's inventory: July 1 Beginning inventory 40 units @ $9 per unit 10 Purchased 60 units @ $10 per unit 15 Sold 70 units @ 26 Purchased 35 units @ $11 per unit Calculate the cost of goods sold for July and ending inventory at July 31 using (a) first-in, first-out, (b) last-in, first-out, and (c) the weighted-average cost...
Inventory Costing Methods-Periodic Method The Lippert Company uses the periodic inventory system. The following July data...
Inventory Costing Methods-Periodic Method The Lippert Company uses the periodic inventory system. The following July data are for an item in Lippert's inventory: July 1 Beginning inventory 40 units @ $9 per unit 10 Purchased 60 units @ $10 per unit 15 Sold 70 units @ 26 Purchased 35 units @ $11 per unit Calculate the cost of goods sold for July and ending inventory at July 31 using (a) first-in, first-out, (b) last-in, first-out, and (c) the weighted-average cost...
Inventory Costing Methods-Periodic Method The Lippert Company uses the periodic inventory system. The following July data...
Inventory Costing Methods-Periodic Method The Lippert Company uses the periodic inventory system. The following July data are for an item in Lippert's inventory: July 1 Beginning inventory 40 units @ $9 per unit 10 Purchased 60 units @ $10 per unit 15 Sold 70 units @ 26 Purchased 35 units @ $11 per unit Calculate the cost of goods sold for July and ending inventory at July 31 using (a) first-in, first-out, (b) last-in, first-out, and (c) the weighted-average cost...
Addison Inc. uses a perpetual inventory system. The following information about one inventory item for the...
Addison Inc. uses a perpetual inventory system. The following information about one inventory item for the month of september: Sep. 1 Inventory 24 units at $15          5 sold 17 units         17 Purchased 10 units at $20          30 sold 8 units If Addison uses LIFO, the cost of the ending inventory on September 30 is a. $160 b.$125 c. $180 d. $145 Please help! I don't understand. Due at 11:59 p.m. Thanks!
The inventory data of Bilal Inc. is provided below, The company uses perpetual inventory system. Inventory:...
The inventory data of Bilal Inc. is provided below, The company uses perpetual inventory system. Inventory: 1st March = 200 units @ $4.00 (purchased) Purchases: 12th March = 500 units @ $4.50 (purchased) 15th March = 400 units @ $4.75 (purchased) 17th March = 828 units @ $5.00 (purchased) Sales: 20th March = 1928 units sold Instructions Under a perpetual inventory system, determine the cost of goods sold and ending inventory for the month of March under FIFO method
Harrison Company has a July 31 fiscal year end and uses a perpetual inventory system. The...
Harrison Company has a July 31 fiscal year end and uses a perpetual inventory system. The records of Harrison Company show the following data: 2021 2020 2019 Income statement:     Sales $350,000 $330,000 $310,000     Cost of goods sold 245,000 235,000 225,000     Operating expenses 76,000 76,000 76,000 Balance sheet:     Merchandise inventory 55,000 45,000 35,000 After its July 31, 2021, year end, Harrison discovered two errors: 1. At July 31, 2020, Harrison had $10,000 of goods held on consignment at another company that...
Crane Company has a July 31 fiscal year end and uses a perpetual inventory system. The...
Crane Company has a July 31 fiscal year end and uses a perpetual inventory system. The records of Crane Company show the following data: 2021 2020 2019 Income statement:     Sales $350,000 $325,000 $360,000     Cost of goods sold 247,000 228,000 273,000     Operating expenses 70,000 70,000 70,000 Balance sheet:     Merchandise inventory 52,000 44,000 35,000 After its July 31, 2021, year end, Crane discovered two errors: 1. At July 31, 2020, Crane had $10,000 of goods held on consignment at another company that...
Terando Co. began operations on July 1. It uses a perpetual inventory system. During July, the...
Terando Co. began operations on July 1. It uses a perpetual inventory system. During July, the company had the following purchases and sales. Date: July 1: 8 units $110 cost of units July 6: 7 sales units July 11: 12 units $126 cost of units July 14: 5 sales units July 21: 13 units $137 cost of units July 27: 10 sales units a) Calculate the average cost per unit at July 1, 6, 11, 14, 21, & 27. b)...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT