FIFO method |
||||||||||
transaction |
purchase |
cost of goods sold |
balanced inventory |
|||||||
date |
unit |
rate per unit |
total |
unit |
rate per unit |
total |
unit |
rate per unit |
total |
|
01-Jan |
beginning |
400 |
30 |
12,000 |
- |
- |
- |
400 |
30 |
12,000 |
02-Jan |
purchase |
200 |
28 |
5,600 |
400 |
30 |
12,000 |
|||
200 |
28 |
5,600 |
||||||||
15-Jan |
sale |
- |
- |
- |
125 |
30 |
3,750 |
275 |
30 |
8,250 |
200 |
28 |
5,600 |
||||||||
21-Jan |
purchase |
80 |
25 |
2,000 |
- |
- |
- |
275 |
30 |
8,250 |
200 |
28 |
5,600 |
||||||||
80 |
25 |
2,000 |
||||||||
27-Jan |
purchase |
100 |
32 |
3,200 |
- |
- |
- |
275 |
30 |
8,250 |
200 |
28 |
5,600 |
||||||||
80 |
25 |
2,000 |
||||||||
100 |
32 |
3,200 |
||||||||
29-Jan |
sale |
- |
- |
- |
175 |
30 |
5,250 |
100 |
30 |
3,000 |
200 |
28 |
5,600 |
||||||||
80 |
25 |
2,000 |
||||||||
100 |
32 |
3,200 |
||||||||
30-Jan |
sale |
- |
- |
- |
100 |
30 |
3,000 |
160 |
28 |
4,480 |
40 |
28 |
1,120 |
80 |
25 |
2,000 |
|||||
100 |
32 |
3,200 |
||||||||
780 |
22,800 |
440 |
13,120 |
340 |
9,680 |
LIFO method |
||||||||||
transaction |
purchase |
cost of goods sold |
balanced inventory |
|||||||
date |
unit |
rate per unit |
total |
unit |
rate per unit |
total |
unit |
rate per unit |
total |
|
01-Jan |
beginning |
400 |
30 |
12,000 |
- |
- |
- |
400 |
30 |
12,000 |
02-Jan |
purchase |
200 |
28 |
5,600 |
400 |
30 |
12,000 |
|||
200 |
28 |
5,600 |
||||||||
15-Jan |
sale |
- |
- |
- |
125 |
28 |
3,500 |
400 |
30 |
12,000 |
75 |
28 |
2,100 |
||||||||
21-Jan |
purchase |
80 |
25 |
2,000 |
- |
- |
- |
400 |
30 |
12,000 |
75 |
28 |
2,100 |
||||||||
80 |
25 |
2,000 |
||||||||
27-Jan |
purchase |
100 |
32 |
3,200 |
- |
- |
- |
400 |
30 |
12,000 |
75 |
28 |
2,100 |
||||||||
80 |
25 |
2,000 |
||||||||
100 |
32 |
3,200 |
||||||||
29-Jan |
sale |
- |
- |
- |
100 |
30 |
3,000 |
400 |
30 |
12,000 |
75 |
25 |
1,875 |
75 |
28 |
2,100 |
|||||
5 |
25 |
125 |
||||||||
30-Jan |
sale |
- |
- |
- |
5 |
25 |
125 |
|||
75 |
28 |
2,100 |
||||||||
60 |
30 |
1,800 |
340 |
30 |
10,200 |
|||||
780 |
22,800 |
440 |
12,400 |
340 |
10,200 |
FIFO |
LIFO |
|
sale |
15400 |
15400 |
cost of goods sold |
13,120 |
12,400 |
gross profit |
2,280 |
3,000 |
Prepare Store Ledger Card (SLC) form the following information on Jan 2017: 1. Opening Stock .........................400...
Bhakti Ltd provides you the following information in relation to the year 2016-17 Opening Stock(units) Value for 2016-17 Rs25000 100 Production (units) ? Fixed Cost Rs 1lacs Variable Cost 120000 Sales(units) 1900 Selling price (Rs/ per unit) 500 Closing Stock( units) 200 Calculate the value of closing stock using – a. FIFO basis b. LIFO basis
Prepare Store Leger Card (FIFO, LIFO and Comparative Cost Sheet from the following data. July 01 Balance b/d .... -50 Units ...............................@ 10 Each July 05 Purchases .. .30 Units ..... .......@ 12 Each July 09 Purchases ....... ..60 Units .................................@ 9 Each July 13 Sales ..... 70 Units .......... July 23 Purchases ............. 40 Units ..... ..@ 8 Each July 26 Purchases ..... 20 Units ......... ..........@ 16 Each July 30 Sales. ......... 90 Units ........ Each Unit was...
Required information Use the following information for the Exercises 3-7 below. (Algo) [The following information applies to the questions displayed below.] Laker Company reported the following January purchases and sales data for its only product. Units sold at Retail Units Acquired at Cost 165 units @ $9.00 = $1,485 125 units @ $18.00 Date Activities Jan. 1 Beginning inventory Jan. 10 Sales Jan. 20 Purchase Jan. 25 Sales Jan. 30 Purchase Totals 110 units @ $8.00 = 880 125 units...
INVENTORY ITEM 621AB UNITS DATE COST Beginning Inventory $6 $7 Jan 1 120 Purchase 200 Jan 7 Sale Jan 10 250 Purchase $8 Jan 15 300 Jan 17 Purchase $9 200 Sale 325 Jan 20 Sale Jan 25 100 Jan 28 Purchase $10 175 Smith Corporation uses a perpetual inventory system. Determine the costs assigned to Cost of Goods Sold and Ending Inventory using both FIFO and LIFO methods. DATE ITEM RED16 UNITS COST Beginning Inventory $10 Jan 1 100...
Required information (The following information applies to the questions displayed below.) Laker Company reported the following January purchases and sales data for its only product. Date Activities Jan. 1 Beginning van inventory Jan. 10 Sales Jan. 20 Purchase Jan. 25 Sales Jan. 30 Purchase Totals Units Acquired at Cost Units sold at Retail 185 units @ $11.00 - $2,035 145 units @ $ 20.00 100 units @ $10.00 - 1,000 125 units @ $20.00 270 units @ $ 9.50 -...
Required information Use the following information for the Exercises below. [The following information applies to the questions displayed below.) Laker Company reported the following January purchases and sales data for its only product. Date Activities Jan. 1 Beginning inventory Jan. 10 Sales Jan. 20 Purchase Jan. 25 Sales Jan. 30 Purchase Totals Units Acquired at Cost Units sold at Retail 185 units @ $11.00 - $2,035 145 units @ $20.00 100 units @ $10.00 - 1,000 125 units @ $20.00...
Required information Use the following information for the Exercises below. (The following information applies to the questions displayed below.) Laker Company reported the following January purchases and sales data for its only product. Units sold at Retail Units Acquired at Cost 225 units@ $15.00 = $ 3,375 175 units @ $24.00 Date Activities Jan. 1 Beginning inventory Jan. 10 Sales Jan. 20 Purchase Jan. 25 Sales Jan. 30 Purchase Totals 180 units@ $14.00 = 2,520 210 units @ $24.00 350...
Required information Use the following information for the Exercises below. The following information applies to the questions displayed below.) Hemming Co. reported the following current-year purchases and sales for its only product. Units Aequired at Cost 245 units $11.80 $2,891 Units sold at Retail 190 units e $41.80 390 units @ $16.80 - 6,552 Date Activities Jan. 1 beginning inventory Jan. 10 Sales Mar. 14 Purchase Mar. 15 Sales July 30 Purchase Det. 5 Sales Oct. 26 Purchase Totals 350...
Required information Use the following information for the Exercises below. [The following information applies to the questions displayed below.] Hemming Co. reported the following current-year purchases and sales for its only product. Date Activities Units Acquired at Cost Units Sold at Retail Jan. 1 Beginning inventory 220 units @ $10.80 = $ 2,376 Jan. 10 Sales 190 units @ $40.80 Mar. 14 Purchase 330 units @ $15.80 = 5,214 Mar. 15 Sales 280 units @ $40.80 July 30...
Required information (The following information applies to the questions displayed below.) Laker Company reported the following January purchases and sales data for its only product. Units Acquired at Cost 165 units@ $9.00 = $1,485 Units sold at Retail Date Activities Jan. 1 Beginning inventory Jan. 10 Sales Jan. 20 Purchase Jan. 25 Sales Jan. 30 Purchase Totals 125 units @ $18.00 110 units@ $8.00 880 125 units @ $18.00 230 units@ $7.50 505 units 1,725 $4,090 250 units The Company...