Ending Inventory | ||||||||||||
FIFO | 7080 | |||||||||||
LIFO | 8010 | |||||||||||
Weighted | 7545.6 | |||||||||||
Cost of goods sold = opening inventory + Purchase - Ending inventory | ||||||||||||
FIFO | 2790+(4800+4200)-7080 = 4710 | |||||||||||
LIFO | 2790+(4800+4200)-8010 = 3780 | |||||||||||
Weighted | 2790+(4800+4200)-7545.6 = 4244.4 | |||||||||||
Working Note | ||||||||||||
FIFO | ||||||||||||
Inwards | Outwards | Balance | ||||||||||
unit | unit cost | Total cost | unit | unit cost | Total cost | unit | unit cost | Total cost | ||||
Mar-01 | Begging inventory | 100 | 27.9 | 2790 | ||||||||
Mar-06 | Purchase | 200 | 24 | 4800 | ||||||||
Mar-10 | Purchase | 200 | 21 | 4200 | ||||||||
Mar-15 | Sales | 100 | 27.9 | 2790 | ||||||||
80 | 24 | 1920 | ||||||||||
180 | 4710 | 120 | 24 | 2880 | ||||||||
200 | 21 | 4200 | ||||||||||
320 | 7080 | |||||||||||
LIFO | ||||||||||||
Inwards | Outwards | Balance | ||||||||||
unit | unit cost | Total cost | unit | unit cost | Total cost | unit | unit cost | Total cost | ||||
Mar-01 | Begging inventory | 100 | 27.9 | 2790 | ||||||||
Mar-06 | Purchase | 200 | 24 | 4800 | ||||||||
Mar-10 | Purchase | 200 | 21 | 4200 | ||||||||
Mar-15 | Sales | 180 | 21 | 3780 | ||||||||
180 | 3780 | 100 | 27.9 | 2790 | ||||||||
200 | 24 | 4800 | ||||||||||
20 | 21 | 420 | ||||||||||
320 | 8010 | |||||||||||
Weighted Average | ||||||||||||
Inwards | Outwards | Balance | ||||||||||
unit | unit cost | Total cost | unit | unit cost | Total cost | unit | unit cost | Total cost | ||||
Mar-01 | Begging inventory | 100 | 27.9 | 2790 | ||||||||
Mar-06 | Purchase | 200 | 24 | 4800 | ||||||||
Mar-10 | Purchase | 200 | 21 | 4200 | ||||||||
500 | 23.58 | 11790 | ||||||||||
Mar-15 | Sales | 180 | 23.58 | 4244.4 | ||||||||
180 | 4244.4 | 320 | 23.58 | 7545.6 | ||||||||
320 | 7545.6 | |||||||||||
Inventory Costing Methods-Periodic Method Spangler Company is a retailer that uses the periodic inventory system. March...
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,...
Inventory Costing Methods-Periodic Method Merritt Company uses the periodic inventory system. The following May data are for an item in Merritt's inventory: May 1 Beginning inventory 450 units $34 per unit 12 Purchased 400 units 539 per unit 16 Sold 480 units 24 Purchased 460 units @ $40 per unit Calculate the cost of goods sold for May and ending inventory at May 31 using (a) first-in, first-out, (b) last-in, first-out, and (c) the weighted average cost methods. Do not...
Inventory Costing Methods . Periodic Method Fortune Stores uses the periodic inventory system for its merchandise inventory. The April 1 inventory for one of the items in the merchandise inventory consisted of 120 units with a unit cost of $335. Transactions for this item during April were as follows: April 9 Purchased 40 units $355 per unit 14 Sold 80 units @ $560 per unit 23 Purchased 20 units @ $360 per unit 29 Sold 40 units Required a. Calculate...
__________ ____________ __________ ______________ Inventory Costing Methods - Periodic Method The Kali Company uses the periodic 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 $45. Transactions for this item during June were as follows: June 5 Purchased 40 units @ $50 per unit 13 Sold 50 units @ $95 per unit 25 Purchased 40 units @ $53 per unit 29...
Inventory Costing Methods-Periodic Method The Gleem Sales Corporation uses the periodic inventory system. On January 1.2015. Gleem had 2,600 units of product B with a unit cost of s40 per unit. A summary of purchases and sales during 2015 follows: Unit Units Units Cost Purchased Sold Jan.3 Mar.8 $44 3,000 June 13 Sept.19 46 Nov.23 Dec.28 1,600 2,000 800 48 1,200 1,800 Required a. Assume that Gleem uses the first-in, first-out method Compute the cost of goods sold for 2015...
LO2E6-2A. Inventory Costing Methods--Periodic Method The Lippert Company uses the periodic inven- tory system. The following July data are for an item in Lippert's inventory: July 1 Beginning inventory, 30 units @ $9 per unit. 10 Purchased 50 units @ $10 per unit. 15 Sold 60 units. 26 Purchased 25 units Sil per unit. Calculate the cost of goods sold for July and ending inventory at July 31 using (a) first-in, first-our, (b) last-in, first-out, and (c) the weighted average...
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,...
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...
periodic inventory system merchandise inven LO2 • P6-2A. Inventory Costing Methods-Periodic Method Tally Stores uses the periodic inventory for its merchandise inventory. The April 1 inventory for one of the items in the merchandise tory consisted of 120 units with a unit cost of $330. Transactions for this item during April follows: April 9 Purchased 40 units @ $345 per unit. 14 Sold 80 units @ $550 per unit. 23 Purchased 20 units @ $360 per unit. 29 Sold 40...
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...