Question

In: Accounting

Alternative Inventory Methods Frate Company was formed on December 1, 2018, and uses the periodic inventory...

Alternative Inventory Methods

Frate Company was formed on December 1, 2018, and uses the periodic inventory system. The following information is available from Frate's inventory records for Product Ply:

Units Unit Cost
January 1, 2019 (beginning inventory) 4,400 $5.00
Purchases:
      January 6, 2019 5,100 6.00
      January 25, 2019 4,800 6.50
      February 17, 2019 4,200 7.00
      March 27, 2019 4,500 7.50

A physical inventory on March 31, 2019, shows 8,800 units on hand.

Required:

Prepare schedules to compute the ending inventory at March 31, 2019, under each of the following inventory methods.

1. FIFO

FRATE COMPANY
Computation of Inventory Under FIFO Inventory Method
March 31, 2019
Units Unit cost Total cost
March 27, 2019
February 17, 2019
January 25, 2019 (portion)
March 31, 2019 inventory

2. LIFO

FRATE COMPANY
Computation of Inventory Under LIFO Inventory Method
March 31, 2019
Units Unit cost Total cost
Beginning inventory
January 6, 2019 (portion)
March 31, 2019 inventory

3. Weighted average

FRATE COMPANY
Computation of Inventory Under Weighted Average Inventory Method
March 31, 2019
Units Unit cost Total cost
Beginning inventory
January 6, 2019
January 25, 2019
February 17, 2019
March 27, 2019
Total
Weighted average cost
March 31, 2019 inventory

Solutions

Expert Solution

FIFO
Date Particulars Units Cost per Unit Total Cost
Jan 1 Beginning Inventory 4400 5.0 22,000
Jan 6 Purchase 5100 6 30,600
Jan 25 Purchase 4800 6.50 31,200
FEb 17 Purchase 4200 7.00 29,400
Marc 27 Purchase 4500 7.50 33,750
Cost of Goods Available for Sale 23000 83,800
Less: Ending Inventory (4500*7.5+4200*7+100*6.5) 8800 63,800
Cost of Goods Sold 14200 20,000
LIFO (Periodic)
Date Particulars Units Cost per Unit Total Cost
JAn 1 Beginning Inventory 4400 5.0 22,000
JAn 6 Purchase 5100 6 30,600
JAn 25 Purchase 4800 6.50 31,200
Feb 17 Purchase 4200 7.00 29,400
MAr 27 Purchase 4500 7.50 33,750
Cost of Goods Available for Sale 23000 83,800
Less: Ending Inventory (4400*5+4400*6) 8800 48,400
Cost of Goods Sold 14200 35,400
Weighted Average Cost method
Date Particulars Units Cost per Unit Total Cost
JAn 1 Beginning Inventory 4400 5.0 22,000
Jan 6 Purchase 5100 6 30,600
Jan 25 Purchase 4800 6.50 31,200
Feb 17 Purchase 4200 7.00 29,400
Mar 27 Purchase 4500 7.50 33,750
Cost of Goods Available for Sale 23000 83,800
Less: Ending Inventory 8800 3.643478 32,063
Cost of Goods Sold 14200 51,737

Related Solutions

Alternative Inventory Methods Frate Company was formed on December 1, 2015, and uses the periodic inventory...
Alternative Inventory Methods Frate Company was formed on December 1, 2015, and uses the periodic inventory system. The following information is available from Frate's inventory records for Product Ply: Units Unit Cost January 1, 2016 (beginning inventory) 800 $ 9.00 Purchases:       January 6, 2016 1,500 10.00       January 25, 2016 1,200 10.50       February 17, 2016 600 11.00       March 27, 2016 900 11.50 A physical inventory on March 31, 2016 shows 1,600 units on hand. Required: For each method, enter your answers...
Alternative Inventory Methods Frate Company was formed on December 1, 2015, and uses the periodic inventory...
Alternative Inventory Methods Frate Company was formed on December 1, 2015, and uses the periodic inventory system. The following information is available from Frate's inventory records for Product Ply: Units Unit Cost January 1, 2016 (beginning inventory) 1,500 $9.00 Purchases:       January 6, 2016 2,200 10.00       January 25, 2016 1,900 10.50       February 17, 2016 1,300 11.00       March 27, 2016 1,600 11.50 A physical inventory on March 31, 2016 shows 3,000 units on hand. Required: For each method, enter your answers in...
Alternative Inventory Methods Frate Company was formed on December 1, 2015, and uses the periodic inventory...
Alternative Inventory Methods Frate Company was formed on December 1, 2015, and uses the periodic inventory system. The following information is available from Frate's inventory records for Product Ply: Units Unit Cost January 1, 2016 (beginning inventory) 2,900 $5.00 Purchases:       January 6, 2016 3,600 6.00       January 25, 2016 3,300 6.50       February 17, 2016 2,700 7.00       March 27, 2016 3,000 7.50 A physical inventory on March 31, 2016 shows 5,800 units on hand. Required: For each method, enter your answers in...
Frate Company was formed on December 1, 2015, and uses the periodic inventory system. The following information is available from Frate's inventory records for Product Ply:
Frate Company was formed on December 1, 2015, and uses the periodic inventory system. The following information is available from Frate's inventory records for Product Ply:UnitsUnit CostJanuary 1, 2016 (beginning inventory)3,600$10.00Purchases:      January 6, 20164,30011.00      January 25, 20164,00011.50      February 17, 20163,40012.00      March 27, 20163,70012.50A physical inventory on March 31, 2016 shows 7,200 units on hand.Required:For each method, enter your answers in chronological order.Prepare schedules to compute the ending inventory at March 31, 2016, under each of the following inventory methods:(For the weighted average method, round...
Alternative Inventory Methods Nevens Company uses a periodic inventory system. During November, the following transactions occurred:...
Alternative Inventory Methods Nevens Company uses a periodic inventory system. During November, the following transactions occurred: Date Transaction Units Cost/Unit November 1 Balance 500 $3.50 8 Sale 350 13 Purchase 300 4.00 21 Purchase 200 5.00 28 Sale 150 Required: 1. Compute the cost of goods sold for November and the inventory at the end of November for each of the following cost flow assumptions. If required, round your answers to the nearest dollar. FIFO Cost of Goods Sold $...
Inventory Costing Methods-Periodic Method Spangler Company is a retailer that uses the periodic inventory system. March...
Inventory Costing Methods-Periodic Method Spangler Company is a retailer that uses the periodic inventory system. March 1 Beginning inventory 110 units of Product M @ $1,590 total cost 6 Purchased 210 units of Product M @ $3,600 total cost 10 Purchased 160 units of Product M @ $3,000 total cost 15 Sold 190 units of Product M Calculate the March cost of goods sold and the ending inventory at March 31 using (a) first-in, first-out, (b) last-in, first-out, and (c)...
Inventory Costing Methods-Periodic Method Archer Company is a retailer that uses the periodic inventory system August...
Inventory Costing Methods-Periodic Method Archer Company is a retailer that uses the periodic inventory system August 1 Beginning Inventory 150 Units of product A @ $1700 total cost 5 Purchased 170 Units of product A @ $2716 total cost purchased 270 Units of product A @ $5716 total cost Sold 230 Units of product A @ Calculate the August cost of goods sold and the ending inventory at August 31 using (a) first-in, first-out, (b) last-in, first-out, and (c) the...
Inventory Costing Methods—Periodic Method Archer Company is a retailer that uses the periodic inventory system. August...
Inventory Costing Methods—Periodic Method Archer Company is a retailer that uses the periodic inventory system. August 1 Beginning inventory 80 units of Product A @ $1,600 total cost 5 Purchased 100 units of Product A @ $2,116 total cost 8 Purchased 200 units of Product A @ $4,416 total cost 11 Sold 165 units of Product A @ $4,800 total sale Calculate the August cost of goods sold and the ending inventory at August 31 using (a) first-in, first-out, (b)...
Inventory Costing Methods-Periodic Method Archer Company is a retailer that uses the periodic inventory system. August...
Inventory Costing Methods-Periodic Method Archer Company is a retailer that uses the periodic inventory system. August 1 Beginning inventory 190 units of Product A @ $1,600 total cost 5 Purchased 210 units of Product A @ $2,116 total cost 8 Purchased 310 units of Product A @ $4,416 total cost 11 Sold 260 units of Product A Calculate the August cost of goods sold and the ending inventory at August 31 using (a) first-in, first-out, (b) last-in, first-out, and (c)...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT