a. | |||
First-in, First-out | |||
Date | Purchase | Sales | Balance |
Jan.01 | Beginning Inventory | 1200 units X $18 = $21600 | |
Feb.11 | 1500 units X $19 = $28500 | 1200 units X $18 = $21600 | |
1500 units X $19 = $28500 | |||
Mar.1 | 1200 units X $18 = $21600 | ||
200 units X $19 = $3800 | 1300 units X $19 = $24700 | ||
May.18 | 1400 units X $21 = $29400 | 1300 units X $19 = $24700 | |
1400 units X $21 = $29400 | |||
July.1 | 1300 units X $19 = $24700 | ||
100 units X $21 = $2100 | 1300 units X $21 = $27300 | ||
Oct.23 | 1100 units X $23 = $25300 | 1300 units X $21 = $27300 | |
1100 units X $23 = $25300 | |||
Oct.29 | 1000 units X $21 = $21000 | 300 units X $21 = $6300 | |
1100 units X $23 = $25300 | |||
Total | 3800 unit = $73200 | 1400 units= $31600 | |
b. | |||
Last-in, First-out | |||
Date | Purchase | Sales | Balance |
Jan.01 | Beginning Inventory | 1200 units X $18 = $21600 | |
Feb.11 | 1500 units X $19 = $28500 | 1200 units X $18 = $21600 | |
1500 units X $19 = $28500 | |||
Mar.1 | 1400 units X $19 = $26600 | 1200 units X $18 = $21600 | |
100 units X $19 = $1900 | |||
May.18 | 1400 units X $21 = $29400 | 1200 units X $18 = $21600 | |
100 units X $19 = $1900 | |||
1400 units X $21 = $29400 | |||
July.1 | 1400 units X $21 = $29400 | 1200 units X $18 = $21600 | |
100 units X $19 = $1900 | |||
Oct.23 | 1100 units X $23 = $25300 | 1200 units X $18 = $21600 | |
100 units X $19 = $1900 | |||
1100 units X $23 = $25300 | |||
Oct.29 | 1000 units X $23 = $23000 | 1200 units X $18 = $21600 | |
100 units X $19 = $1900 | |||
100 units X $23 = $2300 | |||
Total | 3800 unit = $79000 | 1400 units= $25800 | |
c. | |||
weighted Average | |||
Date | Purchase | Sales | Balance |
Jan.01 | Beginning Inventory | 1200 units X $18 = $21600 | |
Feb.11 | 1500 units X $19 = $28500 | 1200 units X $18 = $21600 | |
1500 units X $19 = $28500 | |||
Mar.1 | 1400 units X $19 = $26600 | 1200 units X $18 = $21600 | |
100 units X $19 = $1900 | |||
May.18 | 1400 units X $21 = $29400 | 1200 units X $18 = $21600 | |
100 units X $19 = $1900 | |||
1400 units X $21 = $29400 | |||
July.1 | 1400 units X $21 = $29400 | 1200 units X $18 = $21600 | |
100 units X $19 = $1900 | |||
Oct.23 | 1100 units X $23 = $25300 | 1200 units X $18 = $21600 | |
100 units X $19 = $1900 | |||
1100 units X $23 = $25300 | |||
Oct.29 | 1000 units X $23 = $23000 | 1200 units X $18 = $21600 | |
100 units X $19 = $1900 | |||
100 units X $23 = $2300 | |||
Total | 3800 unit = $79000 |
1400 units= $25800 |
c. | |||||||
weighted Average | |||||||
Date | Purchase | Sales | Balance | ||||
Unit | Unit cost ($) | Total ($) | Unit | Unit cost ($) | Total ($) | Units and Cost | |
Jan.01 | 1200 | 18 | 21600 | 1200 units X $18 = $21600 | |||
Feb.11 | 1500 | 19 | 28500 | 2700 unit X $18.556 = $50100 | |||
Mar.1 | 1400 | 18.556 | 25978 | 1300 units X $18.556 = $24123 | |||
May.18 | 1400 | 21 | 29400 | 2700 units X $19.823 = $53523 | |||
July.1 | 1400 | 19.823 | 27752 | 1300 units X $19.823 = $25770 | |||
Oct.23 | 1100 | 23 | 25300 | 2400 units X $21.279 = $51070 | |||
Oct.29 | 1000 | 21.279 | 21279 | 1400 units X $21.279 = $29790 | |||
Total | 3800 | 75010 | 1400 units= $29790 | ||||
a | First-in, First-Out | ||||||
Ending Inventory | $31600 | ||||||
Cost of Goods Sold | $73200 | ||||||
b | Last-in, First-Out | ||||||
Ending Inventory | $25800 | ||||||
Cost of Goods Sold | $79000 | ||||||
c | Weighted Average | ||||||
Ending Inventory | $29790 | ||||||
Cost of Goods Sold | $75010 |
Inventory Costing Methods-Perpetual Method Using the data below, assume that Graham Corporation uses the perpetual inventory...
Inventory Costing Methods–Periodic Method The following data are for the Portet Corporation, which sells just one product: Units Unit Cost Beginning Inventory, January 1 1,200 $8 Purchases: February 11 1,500 May 18 1,400 10 October 23 1,100 14 March 1 Sales: 1,400 July 1 1,400 October 29 1,200 Calculate the value of ending inventory and cost of goods sold at year-end using the periodic method and (a) first-in, first-out, (b) last-in, first- out, and (c) weighted-average cost method. Round the...
Inventory Costing Methods-Periodic Method The following data are for the Portet Corporation, which sells just one product: Units Unit Cost Beginning Inventory, January 1 1.200 $13 Purchases: February 11 1,500 May 18 1,400 October 23 1,100 17 Sales: March 1 1,400 July 1 1,400 October 291,000 Calculate the value of ending inventory and cost of goods sold at year-end using the periodic method and (a) first-in, first-out, (b) last-in, first-out, and (c) weighted average cost method. Hint: For weighted-average cost,...
Calculate the value of ending inventory and cost of goods sold using the periodic method and a) first-in, first-out, b) last-in, first-out, and c) weighted-average cost method: Inventory Costing Methods—Periodic Method The following data are for the Portet Corporation, which sells just one product: Units Unit Cost Beginning Inventory, January 1 1.200 Purchases: February 11 1,500 May 18 1,400 October 23 1,100 Sales: March 1 1,400 July 1 1,400 October 291,000 Calculate the value of ending inventory and cost of...
Question 4 P lag question Not complete Marked out of 1.00 Inventory Costing Methods-Perlodic Method The following data are for the Portet Corporation, which sells just one product: Units Unit Cost Beginning Inventory, January 1 February 11 May 18 1,200 $15 Purchases: 1.500 $16 17 1,400 October 23 1,100 19 Sales: March 1 1400 1400 July 1 October 29 1,000 Calculate the value of ending inventory and cost of goods sold at year-end using the periodic method and (a) first-in,...
Inventory Costing Methods-Perpetual Method Merritt Company uses the perpetual inventory system. The following May data are for an item in Merritt's inventory: May 1 Beginning inventory 170 unit@ $32 per unit 12 Purchased 120 unit@ $37 per unit 16 sold 190 unit@ 24 Purchased 180 unit@ $38 per unit Calculate the cost of goods sold for the May 16 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...
Inventory Costing Methods—Perpetual Method The Luann Company uses the perpetual inventory system. The following July data are for an item in Luann’s inventory: July 1 Beginning inventory 30 Units@ $9 per unit 10 Purchased 50 Units@ $11 per unit 15 sold 60 Units 26 Purchased 25 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...
Inventory Costing Methods-Perpetual Method Shiloh Company uses the perpetual inventory system for its merchandise inventory. The June 1 inventory for one of the items in the merchandise inventory consisted of 60 units with a unit cost of $60. Transactions for this item during June were as follows: June 5 Purchased 40 units @ $70 per unit 13 Sold 50 units @ 110 per unit 25 Purchased 30 units @ 72 per unit 29 Sold 20 units Required a. Calculate the...
Inventory Costing Methods-Perpetual Method The Luann Company uses the perpetual inventory system. The following July data are for an item in Luann's inventory: July 1 Beginning inventory 30 units @ 10 Purchased $9 per unit 50 units @$11 per unit 15 Sold 60 units 26 Purchased 25 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...
Inventory Costing Methods - Periodic Method The following data are for the Cracker Corporation, which sells just one product Units Unit Cost Beginning inventory, January 1..........................................................1200 $18 Purchases February 11........................................................... 1500 $19 May 18...................................................................1400 $20 October 23............................................................1100 $23 Sales March 1..................................................................1400 July 1.....................................................................1400 October 29..............................................................1000 Required 1.) Calculate the value of ending inventory and cost of goods sold for the year using the periodic method and a.) First-in-first out b.) Last-in-first out c.) weighted average cost method 2.) If the...
Inventory Costing Methods-Perpetual Method Arrow Company is a retailer that uses the perpetual inventory system. August 1 Beginning inventory 5 Purchased 8 Purchased 11 Sold 80 units of Product A @ $1,600 total cost 100 units of Product A @ $2,116 total cost 200 units of Product A @ $4,416 total cost 170 units of Product A @ $4,800 total sale Calculate the inventory cost of item A on August 11 (after the sale) using (a) first-in, first-out, (b) last-in,...