[go: up one dir, main page]
Scribd
Upload
97 views29 pages

Inventory Cost Analysis Report

The document shows inventory calculations using different costing methods (FIFO, WAVE, MAVE) for multiple periods. It begins with an opening inventory of 10,000 units costing $400,000. Purchases were made in April for 15,000 units costing $750,000 and in October for 25,000 units costing $1,500,000, bringing total goods available to 50,000 units costing $2,650,000. Cost of goods sold and ending inventory were calculated for each method, with ending inventory ranging from $795,000 to $900,000 depending on the costing method used.

Uploaded by

pink
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
97 views29 pages

Inventory Cost Analysis Report

The document shows inventory calculations using different costing methods (FIFO, WAVE, MAVE) for multiple periods. It begins with an opening inventory of 10,000 units costing $400,000. Purchases were made in April for 15,000 units costing $750,000 and in October for 25,000 units costing $1,500,000, bringing total goods available to 50,000 units costing $2,650,000. Cost of goods sold and ending inventory were calculated for each method, with ending inventory ranging from $795,000 to $900,000 depending on the costing method used.

Uploaded by

pink
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 29

FIFO UNITS UC TOTAL

Beginning 10,000 52.0 520,000


Net Purchases
December 7 30,000 50.0 1,500,000
December 17 60,000 45.0 2,700,000
December 22 20,000 43.0 860,000
Goods Available for Sale 120,000 5,580,000
Ending Inventory (30,000) (1,310,000)
COGS (20,000 + 70,000) 90,000 4,270,000

COGS:
December 12
From Beginning 10,000 52.0 520,000.00
From Dec 7 Purchases 10,000 50.0 500,000.00
December 28
From Dec 7 Purchases 20,000 50.0 1,000,000.00
From Dec 17 Purchases 50,000 45.0 2,250,000.00
90,000 4,270,000.00

Ending Inventory
December 22 Purchases 20,000 43.0 860,000.00
December 17 Purchases 10,000 45.0 450,000.00
30,000 1,310,000.00

WAVE: UNITS UC TOTAL


Beginning 10,000 52.0 520,000
Net Purchases
December 7 30,000 50.0 1,500,000
December 17 60,000 45.0 2,700,000
December 22 20,000 43.0 860,000
Goods Available for Sale 120,000 5,580,000
Ending Inventory (30,000) 46.500 (1,395,000)
COGS (20,000 + 70,000) 90,000 4,185,000

4,185,000.00
GAS at Cost 5,580,000.00
Divide GAS in Units 120,000.00
Average Cost per unit 46.50

MAVE: UNITS UC TOTAL


Beginning 10,000 52.0 520,000
Net Purchases
December 7 30,000 50.0 1,500,000
December 17 60,000 45.0 2,700,000
December 22 20,000 43.0 860,000
Goods Available for Sale 120,000 5,580,000
Ending Inventory (30,000) (1,371,000)
COGS (20,000 + 70,000) 90,000 4,209,000

UNITS UC TOTAL
Beginning 10,000 52.00 520,000.00
Purchases 30,000 50.00 1,500,000.00
40,000 50.50 2,020,000.00
Sale (20,000) 50.50 (1,010,000.00)
20,000 50.50 1,010,000.00
Purchases 60,000 45.00 2,700,000.00
80,000 46.38 3,710,000.00
Purchases 20,000 43.00 860,000.00
100,000 45.70 4,570,000.00
Sales (70,000) 45.70 (3,199,000.00)
30,000 1,371,000.00

(4,209,000.00)
FIFO WAVE MAVE
Sale 8,100,000 8,100,000 8,100,000
COGS (4,270,000) (4,185,000) (4,209,000)
GP 3,830,000 3,915,000 3,891,000
Beginning xx Selling Price
Net Purchases xx 600.00
Goods Available for Sale xx
Ending (xx)
COGS xx

FIFO:
UNITS UC TOTAL
Beginning 6,000 150.00 900,000.00
Purchases
January 5 2,000 200.00 400,000.00
January 20 2,500 300.00 750,000.00
January 25 2,000 400.00 800,000.00
Goods Available for Sale 12,500 2,850,000.00
Ending Inventory (4,500) (1,550,000.00)
COGS 8,000 1,300,000.00

Cost of Goods Sold:


From Beginning 6,000 150.00 900,000.00
January 5 2,000 200.00 400,000.00
1,300,000.00

Ending Inventory:
January 25 2,000 400.00 800,000.00
January 20 2,500 300.00 750,000.00
1,550,000.00

WAVE:
UNITS UC TOTAL
Beginning 6,000 150.00 900,000.00
Purchases
January 5 2,000 200.00 400,000.00
January 20 2,500 300.00 750,000.00
January 25 2,000 400.00 800,000.00
Goods Available for Sale 12,500 2,850,000.00
Ending Inventory (4,500) (1,026,000.00)
COGS 8,000 1,824,000.00

GAS at Cost 2,850,000


Divide: GAS in Units 12,500
WAVE cost per unit 228.00

Ending Inventory in Units 4,500


WAVE cost per unit 228
Ending Inventory at Cost 1,026,000.00

MAVE:
UNITS UC TOTAL
Beginning 6,000 150.00 900,000.00
Purchases
January 5 2,000 200.00 400,000.00
January 20 2,500 300.00 750,000.00
January 25 2,000 400.00 800,000.00
Goods Available for Sale 12,500 2,850,000.00
Ending Inventory (4,500) (1,222,490.00)
COGS 8,000 1,627,510.00

UNITS UC TOTAL
Beginning 6,000 150.00 900,000.00
Purchase 2,000 200.00 400,000.00
8,000 162.50 1,300,000.00
Sale (4,000) 162.50 (650,000.00)
4,000 162.50 650,000.00
Sale (1,000) 162.50 (162,500.00)
3,000 162.50 487,500.00
Purchases 2,500 300.00 750,000.00
5,500 225.00 1,237,500.00
Purchase 2,000 400.00 800,000.00
7,500 271.67 2,037,500.00
Sale (3,000) 271.67 (815,010.00)
4,500 1,222,490.00
Selling Price
600.00

4,000.00
1,000.00
3,000.00
8,000.00

FIFO WAVE MAVE


Sales 4,800,000.00 4,800,000.00 4,800,000.00
COGS (1,300,000.00) (1,824,000.00) (1,627,510.00)
GP 3,500,000.00 2,976,000.00 3,172,490.00
COGS:
3,000 x 60 180,000.00
9,000 x 75 675,000.00
COGS 855,000.00
Beg
Revenue 1,200,000.00 Purchase
COGS 855,000.00 COGS
Gross Income 345,000.00 End
2,018 2,019 2,020
0 1,000 3,000
5,000 9,000 15,000
4,000 7,000
1,000 3,000
10,000
(5,000)
15,000
(18,000)
25,000
(12,000)
15,000

FIFO: UNITS COST


Beginning 10,000 400,000.00
Purchases
April 15,000 750,000.00
October 25,000 1,500,000.00
GAS 50,000 2,650,000
Ending (15,000) (900,000.00)
COGS 35,000 1,750,000.00

FIFO:
October 1 15,000 60.00 900,000.00

WAVE:
UNITS COST
Beginning 10,000 400,000.00
Purchases
April 15,000 750,000.00
October 25,000 1,500,000.00
GAS 50,000 2,650,000
Ending (15,000) (795,000.00)
COGS 35,000 1,855,000.00

GAS (Cost) 2,650,000


GAS (units) 50,000
Average Cost 53.00

WAVE: Ending Inventor


Units 15,000
Average Cost 53
Ending Inventory 795,000

MAVE:
Balance 10,000 40.00 400,000.00
Sale (5,000) 40.00 (200,000.00)
5,000 200,000.00
Purchases 15,000 50.00 750,000.00
20,000 47.50 950,000.00
Sale (18,000) 47.50 (855,000.00)
2,000 95,000.00
Purchases 25,000 60.00 1,500,000.00
27,000 59.07 1,595,000.00
Sale (12,000) 59.07 (708,840.00)
15,000 886,160.00

UNITS COST
Beginning 10,000 400,000.00
Purchases
April 15,000 750,000.00
October 25,000 1,500,000.00
GAS 50,000 2,650,000
Ending (15,000) (886,160.00)
COGS 35,000 1,763,840.00
FIFO MAVE WAVE
COGS 1,750,000.00 1,763,840.00 1,855,000.00
EI 900,000.00 886,180.00 795,000.00
3,000 2,500
7,500 6,500
4,000 3,000
6,000 6,000
3,500 4,500
2,500
26,500 22,500 4,000

FIFO:
June 30 2,500 313.00 782,500.00
June 21 1,500 330.00 495,000.00
1,277,500.00

WAVE:
3,000 300 900,000.00
7,500 304 2,280,000.00
4,000 320 1,280,000.00
6,000 325 1,950,000.00
3,500 330 1,155,000.00
2,500 313 782,500.00
26,500 315.00 8,347,500.00
WAVE:
4,000 315.00 1,260,000.00
Lots SP per Lot Sales Value Fraction
1 20.00 3,000,000.00 60,000,000.00 0.571
2 10.00 2,500,000.00 25,000,000.00 0.238
3 10.00 2,000,000.00 20,000,000.00 0.190
105,000,000.00
70,350,000.00

Allocated Cost Unit Cost


40,200,000.00 2,010,000.00
16,750,000.00 1,675,000.00
13,400,000.00 1,340,000.00
WAVE:
GAS (Cost)
GAS (units)
Average Cost per unit

Sales
Divide by: SP
Units Sold

Average Cost per unit


Units Sold
COGS (WAVE)

FIFO:
Begining
Purchases - 7/25
Purchases - 8/25
Purchases - 9/5
1,753,500.00
42,000
41.75

2,800,000.00
100.00
28,000

41.75
28,000.00
1,169,000.00

10,000 40.00 400,000.00


8,000 42.00 336,000.00
5,000 41.30 206,500.00
5,000 43.00 215,000.00
1,157,500.00
UNITS
Beginning 10,000
Purchases
Lot 1 2,000
Lot 2 8,000
Lot 3 6,000
Lot 4 9,500
Lot 5 14,500
GAS 50,000
Ending (15,000)
COGS 35,000

FIFO (ENDING)
Lot 5 14,500
Lot 4 500

WAVE (ENDING)
GAS (Cost)
GAS (Units)
Average Cost
Multiply by: EI
Ending Inventory

SPECIFIC ID (ENDING)
Lot 3 6,000
Lot 4 9,000
UC TOTAL COSTS
80.00 800,000.00

100.00 200,000.00
110.00 880,000.00
120.00 720,000.00
100.00 950,000.00
90.00 1,305,000.00
4,855,000.00

4,855,000.00

90.00 1,305,000.00
100.00 50,000.00
1,355,000.00

GAS 4,855,000.00
EI (1,355,000.00)
COGS 3,500,000.00

4,855,000.00
50,000.00
verage Cost 97.10
ultiply by: EI 15,000.00
nding Inventory 1,456,500.00

GAS 4,855,000.00
EI (1,456,500.00)
COGS 3,398,500.00

120.00 720,000.00
100.00 900,000.00
1,620,000.00

GAS 4,855,000.00
EI (1,620,000.00)
COGS 3,235,000.00
Beginning
Purchases
Apri 5
October 1

Ending
COGS

FIFO (Ending)
October 1

WAVE (Ending
GAS (Cost)
GAS (units)
Average Cost per unit
Multiply by Units
200 7,500.00 1,500,000

300 9,000.00 2,700,000


500 10,000.00 5,000,000
1,000 9,200,000
(300)
700

300 10,000.00 3,000,000


3,000,000

GAS 9,200,000
EI (3,000,000)
COGS 6,200,000

9,200,000.00
1,000.00
age Cost per unit 9,200.00
iply by Units 300.00
2,760,000.00

GAS 9,200,000
EI (2,760,000)
COGS 6,440,000
Purchase Price 18,000,000.00
Appraisal Cost 500,000.00
Construction 41,500,000.00
Total Cost 60,000,000.00

Number of Lots SP per Lot SALES VALUE


Highland 20 1,000,000.00 20,000,000.00
Midland 40 750,000.00 30,000,000.00
Lowland 100 500,000.00 50,000,000.00
100,000,000.00

SOLD UNITS UC COGS


Highland 15 600,000.00 9,000,000.00
Midland 30 450,000.00 13,500,000.00
Lowland 80 300,000.00 24,000,000.00
46,500,000.00
FRACTION ALLOCATION` UNIT COST
20/100 12,000,000.00 600,000.00
30/100 18,000,000.00 450,000.00
50/100 30,000,000.00 300,000.00
60,000,000.00

You might also like