Question

In: Accounting

ses a periodic inventory system. Its records show the following for the month of May, in...

ses a periodic inventory system. Its records show the following for the month of May, in which 166 units were sold.

Units

Unit Cost

Total Cost

May 1 Inventory

73

$9

$657

15 Purchases

61

12

732

24 Purchases

85

13

1,105

Totals

219

$2,494


Compute the ending inventory at May 31 and cost of goods sold using the FIFO and LIFO methods.

FIFO  

LIFO

Ending inventory at May 31

Cost of goods sold   FIFo LIFO

Solutions

Expert Solution

Ending Inventory :

FIFO:

Particulars

Purchases

Sales

Balance

May 1 Beginning inventory

73 units * $9 = $657

$657

May 15 Purchases

61 * $12 = 732

73 units * $9 = $657

61 units * $12 = $732

May 24 Purchases

85 * $13 = 1,105

73 units * $9 = $657

61 units * $12 = $732

85 units * $13 = $1,105

May 30 sales

166 units

73 units * $9 = $657

61 units * $12 = $732

32 units * $13 = $ 416

53 units * $13 = $ 689

(Ending inventory)

LIFO:

Particulars

Purchases

Sales

Balance

May 1 Beginning inventory

73 units * $9 = $657

$657

May 15 Purchases

61 * $12 = 732

73 units * $9 = $657

61 units * $12 = $732

May 24 Purchases

85 * $13 = 1,105

73 units * $9 = $657

61 units * $12 = $732

85 units * $13 = $1,105

May 30 sales

166 units

85 units * $13 = $1,105

61 units * $12 = $732

20 units * $9 = $180

53 units * $9 = $477

(Ending inventory)

Cost of goods sold:

= Beginning Inventory + Purchases during the period – Ending Inventory.

FIFO = $657 + ($735 + 1105) - $689 = $1,808

LIFO = $657 + ($735 + 1105) - $477 = $2,020

I hope this will help you. If requires clarification, you may comment below.


Related Solutions

Buffalo Industries uses a periodic inventory system. Its records show the following for the month of...
Buffalo Industries uses a periodic inventory system. Its records show the following for the month of May, in which 68 units were sold. Date Explanation Units Unit Cost Total Cost May 1 Inventory 35 $9 $315 15 Purchase 25 10 250 24 Purchase 40 11 440 Total 100 $1,005 (a) Calculate the weighted-average unit cost. (Round answer to 3 decimal places, e.g. 5.125.) Weighted-average unit cost $Enter the Weighted-average unit cost in dollars Calculate the ending inventory at May 31...
SAP Co. uses a periodic inventory system. It records show the following for the month of...
SAP Co. uses a periodic inventory system. It records show the following for the month of February: Date Units UnitPrice Total Cost 2/1 40 $20.00 $800 2/15 Purchases 130 22.00 2,860 2/24 Purchases 110 23.50 2,585 Totals   280 $6,245 2/20 Sales 100 47.00 2/27 Sales 130 47.00 Given the information above, please calculate COGS,Ending Inventory, and Gross Profit under each of the following methods. (Please explain) 1) FIFO: 2) LIFO: 3) Average Cost:
Inventory Costing Methods—Periodic System Oxendine Company's inventory records for the month of November reveal the following:...
Inventory Costing Methods—Periodic System Oxendine Company's inventory records for the month of November reveal the following: Inventory, November 1 200 units @ $18.00 November 4, purchase 250 units @ $18.50 November 7, sale 300 units @ $42.00 November 13, purchase 220 units @ $18.90 November 18, purchase 150 units @ $19.00 November 22, sale 380 units @ $42.50 November 24, purchase 200 units @ $19.20 November 28, sale 110 units @ $43.00 Selling and administrative expenses for the month were...
Grouper Limited uses a perpetual inventory system. The inventory records show the following data for its first month of operations:
Grouper Limited uses a perpetual inventory system. The inventory records show the following data for its first month of operations:DateExplanationUnitsUnit CostTotal CostBalance in UnitsAug.2Purchases251$72$18,0722513Purchases49810351,29474910Sales(300)44915Purchases902118106,4361,35125Sales(332)1,019Calculate the cost of goods sold and ending inventory using the FIFO cost method.Cost of goods sold$enter a dollar amountEnding inventory$enter a dollar amount    Calculate the cost of goods sold and ending inventory using the average cost method. (Round average cost per unit and final answers to 2 decimal places, e.g. 1.25.)Cost of goods sold$enter a dollar amountEnding...
Crane Company uses a periodic inventory system and its accounting records include the following inventory information...
Crane Company uses a periodic inventory system and its accounting records include the following inventory information for the month of July: Units Unit Cost Total Cost July 1 Inventory on hand 150 $6.00 $900.00 12 Purchase 230 7.00 1,610.00 20 Sale (250) 0 28 Purchase 490 9.00 4,410.00 A physical inventory count determined that 620 units were on hand at July 31. (a) Calculate the ending inventory and the cost of goods sold under (1) FIFO and (2) weighted average....
Bailey Company uses a periodic inventory system and its inventory records contain the following information: Units...
Bailey Company uses a periodic inventory system and its inventory records contain the following information: Units Total Cost Beginning Inventory: 300 $780 Purchased on May 10 400 1,170 Purchased on June 15 500 1,260 Purchased on August 28     300      990 1,500 $4,200 The company sold 1,000 units during June. There were no additional purchases or sales during the remainder of the year. The company had 500 units were in its ending inventory at the end of the year....
Tess Company's inventory records show the following data for the month of May: Units Unit Cost...
Tess Company's inventory records show the following data for the month of May: Units Unit Cost Inventory, May 1 200 $2.00 Purchases: May 8 200 3.00 May 15 100 4.00 The company uses a periodic inventory system. A physical inventory on May 30 shows 150 units on hand. Assuming FIFO (First-In-First-Out) inventory costing, calculate the cost of goods sold. a. $1,100 b. $850 c. $700 d. $980
Simple Plan Enterprises uses a periodic inventory system. Its records showed the following: Inventory, December 31,...
Simple Plan Enterprises uses a periodic inventory system. Its records showed the following: Inventory, December 31, using FIFO → 36 Units @ $15 = $540 Inventory, December 31, using LIFO → 36 Units @ $11 = $396 Transactions in the Following Year Units Unit Cost Total Cost Purchase, January 9 48 16 $ 768 Purchase, January 20 98 17 1,666 Sale, January 11 (at $39 per unit) 78 Sale, January 27 (at $40 per unit) 54 Required: Compute the number...
Simple Plan Enterprises uses a periodic inventory system. Its records showed the following: Inventory, December 31,...
Simple Plan Enterprises uses a periodic inventory system. Its records showed the following: Inventory, December 31, using FIFO → 58 Units @ $24 = $1,392 Inventory, December 31, using LIFO → 58 Units @ $20 = $1,160 Transactions in the Following Year Units Unit Cost Total Cost Purchase, January 9 70 25 $ 1,750 Purchase, January 20 120 26 3,120 Sale, January 11 (at $48 per unit) 100 Sale, January 27 (at $49 per unit) 76 Required: Compute the number...
Simple Plan Enterprises uses a periodic inventory system. Its records showed the following: Inventory, December 31,...
Simple Plan Enterprises uses a periodic inventory system. Its records showed the following: Inventory, December 31, using FIFO → 50 Units @ $20 = $1,000 Inventory, December 31, using LIFO → 50 Units @ $16 = $800 Transactions in the Following Year Units Unit Cost Total Cost Purchase, January 9 62 21 $ 1,302 Purchase, January 20 112 22 2,464 Sale, January 11 (at $44 per unit) 92 Sale, January 27 (at $45 per unit) 68 Required: Compute the number...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT