Question

In: Accounting

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 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 the average cost per unit to two decimal places.)
1. FIFO

FRATE COMPANY
Computation of Inventory for Product Ply Under FIFO Inventory Method
March 31, 2016
Units Unit cost Total cost
$ $
March 31, 2016 inventory $

2. LIFO

FRATE COMPANY
Computation of Inventory for Product Ply Under LIFO Inventory Method
March 31, 2016
Units Unit cost Total cost
$ $
March 31, 2016 inventory $

3. Weighted average

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

Solutions

Expert Solution

Please hit LIKE button if this helped. For any further explanation, please put your query in comment, will get back to you.
1. FIFO Means ending inventory will be having units from latest purchases
Units Unit Cost Total Cost
Mar 27 2016 3000 $          7.50 $       22,500
Feb 27, 2016 2700 $          7.00 $       18,900
Jan 25 2016 5800-3000-2700 100 $          6.50 $             650
Mar 31 2016 Inventory $       42,050
2. LIFO Means ending inventory will be having units from oldest/first purchases
Units Unit Cost Total Cost
Jan 1 2016 2900 $          5.00 $       14,500
Jan 6 2016 5800-2900 2900 $          6.00 $       17,400
Mar 31 2016 Inventory $       31,900
3. Weighted Average
Units Unit cost Total cost
Beginning inventory 2900 $          5.00 $       14,500
January 6, 2016 3600 $          6.00 $       21,600
January 25, 2016 3300 $          6.50 $       21,450
February 17, 2016 2700 $          7.00 $       18,900
March 27, 2016 3000 $          7.50 $       22,500
Total 15500 $       98,950
Weighted average cost 98950/15500 $          6.38
March 31, 2016 inventory 5800*6.38 $       37,004

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, 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...
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 $...
Daniel Company uses a periodic inventory system. Data for 2015: beginning merchandise inventory (December 31, 2014),...
Daniel Company uses a periodic inventory system. Data for 2015: beginning merchandise inventory (December 31, 2014), 2,000 units at $38; purchases, 7,970 units at $40; expenses (excluding income taxes), $193,100; ending inventory per physical count at December 31, 2015, 1,780; sales, 8,190 units; sales price per unit, $79; and average income tax rate, 34 percent Required: 1. Compute cost of goods sold and prepare income statements under the FIFO, LIFO, and average cost inventory costing methods. (Do not round your...
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)...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT