Question

In: Accounting

FIFO & LIFO periodic inventory system

Below is the information relating to Montel purchases of snowboards during september ,during the same month 120 snoeboards were sold .Montel uses periodic inventory system.

 

Date Transaction                              Unit unit cost
1-Sep Inventory 20 $100.00 
12-Sep Purchase 45 $103.00 
19-Sep Purchase 20 $104.00 
26-Sep Purchase 50 $105.00 

Compute the ending Inventory under FIFO and LIFO method and Cost of Goods sold.

What you notice about in the both method regarding Cost of Goods sold and ending inventory

Solutions

Expert Solution

a).  Ending inventory using FIFO method =$1,575

Cost of goods sold for FIFO=$12,390

 ai) Ending inventory using LIFO =$1,500

Cost of goods sold for LIFO =$12,465

b). Sum of Ending inventory and cogs for FIFO= $13,965

bii). sum of ending inventory and cogs for LIFO =$13,965

 

EXAPLANATION:

FIFO stands for  “first in first out” and simply means you need to label your food with the dates you store them, and put the older foods in front or on top so that you use them first. This system allows you to find your food quicker and use them more efficiently.

LIFO on the other hand stands for The Last-In, First-Out (LIFO) method assumes that the last unit to arrive in inventory or more recent is sold first.

so:- 

Solution for part (a) with FIFO method

FIFO-goods purchase first are sold first;

ai). Ending inventory=Total units-sales unit

given :

total cost=135 units

sales units =120

hence;

ending inventory  =135-120

          =15 units

value of ending inventory=ending inventory *purchases

                                       = 15*105

                                                =$1,575

aii). Cost of goods sold;

= (20*100) + (45*103) + (20*104)+ (35*105)

cost of goods sold = 2000+4635 +2080 +3675

= $12,390

Solution for part (a) with LIFO method:

LIFO-Goods purchased last are sold first;

so;

ai) Ending inventory =15 units

value of ending inventory = 15*100 

= $1,500

aii). Cost of goods sold;

(5*100) +(45*103) +(20*104) + (50*105)

= 500+4635 +2080 +5250

= $12,465


a).  Ending inventory using FIFO method =$1,575

Cost of goods sold for FIFO=$12,390

 ai) Ending inventory using LIFO =$1,500

Cost of goods sold for LIFO =$12,465

b). Sum of Ending inventory and cogs for FIFO= $13,965

bii). sum of ending inventory and cogs for LIFO =$13,965

 

Related Solutions

FIFO & LIFO periodic inventory system
Below is the information relating to Montel purchases of snowboards during september ,during the same month 120 snoeboards were sold .Montel uses periodic inventory system.   Date Transaction                              Unit unit cost 1-Sep Inventory 20 $100.00  12-Sep Purchase 45 $103.00  19-Sep Purchase 20 $104.00  26-Sep Purchase 50 $105.00  Compute the ending Inventory under FIFO and LIFO method and Cost of Goods sold. What you notice about in...
Periodic (FIFO, LIFO, Average) Spring River sells bottled water using a periodic inventory system. The following...
Periodic (FIFO, LIFO, Average) Spring River sells bottled water using a periodic inventory system. The following is a list of beginning inventory and purchases for bottles used in manufacturing their spring water.                         Beginning Inventory                           6,000 bottles at $0.20                         First Purchase                                      4,500 bottles at $0.22                         Second Purchase                                 5,600 bottles at $0.24                         Third Purchase                                    2,000 bottles at $0.26 At the end of the year, 2,500 bottles remained in ending inventory. What is cost of merchandise sold and ending...
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available...
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory 10 units at $36 $360 Aug. 7 Purchase 15 units at $38 570 Dec. 11 Purchase 15 units at $39 585 40 units $1,515 There are 18 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using (a) the first-in, first-out...
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available...
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory 15 units at $36 $540 Aug. 7 Purchase 20 units at $37 740 Dec. 11 Purchase 15 units at $38 570 50 units $1,850 There are 19 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using (a) the first-in, first-out...
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available...
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory 9 units at $28 $252 July 7 Purchase 6 units at $31 186 Nov. 23 Purchase 14 units at $33 462 29 units $900 There are 17 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using (a) the first-in, first-out...
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Method. The units of an item available...
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Method. The units of an item available for sale during the year were as follows: Jan. 1 Inventory 14 units at $27 $378 Aug. 13 Purchase 19 units at $30 570 Nov. 30 Purchase 11 units at $32 352 Available for sale 44 units $1,300 There are 17 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using (a)...
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available...
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory 10 units at $26 $260 Aug. 7 Purchase 15 units at $28 420 Dec. 11 Purchase 10 units at $29 290 35 units $970 There are 16 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using (a) the first-in, first-out...
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available...
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory 5 units at $37 $185 Aug. 7 Purchase 18 units at $39 702 Dec. 11 Purchase 13 units at $40 520 36 units $1,407 There are 16 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using (a) the first-in, first-out...
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available...
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory 13 units at $41 $533 Aug. 7 Purchase 19 units at $44 836 Dec. 11 Purchase 13 units at $46 598 45 units $1,967 There are 16 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using (a) the first-in, first-out...
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available...
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory 5 units at $34 $170 Aug. 7 Purchase 19 units at $35 665 Dec. 11 Purchase 14 units at $37 518 38 units $1,353 There are 19 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using (a) the first-in, first-out...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT