Scribd
Upload
8 views8 pages

Fruit Data Analysis and Metrics

The document contains various tables and calculations related to inventory management and analysis for a company. It includes data on typical industry inventory levels and costs, potential savings from reducing inventory levels, and calculations for expected time and variance of projects. The tables and calculations provide information on key inventory and project metrics for an organization to analyze their performance and identify areas for improvement.

Uploaded by

Varun Patel
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
8 views8 pages

Fruit Data Analysis and Metrics

The document contains various tables and calculations related to inventory management and analysis for a company. It includes data on typical industry inventory levels and costs, potential savings from reducing inventory levels, and calculations for expected time and variance of projects. The tables and calculations provide information on key inventory and project metrics for an organization to analyze their performance and identify areas for improvement.

Uploaded by

Varun Patel
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

Apple

Apple
Banana
Cherry
Sum

Banana
Cherry
1
0.33
5
3
1
7
0.20
0.14
1
4.2 1.47619
13

Apple
Banana
Cherry
Sum

Apple
0.238095
0.714286
0.047619
1

Banana
Cherry
Average
Consistency Measure
0.225806 0.384615 0.2828390248
1
0.677419 0.538462 0.6433888692
1.3188246097
0.096774 0.076923 0.073772106
0.766791244
1
1
3.0856158537
1.0285386179
Lambda max
CI=
CR=

0.0428079269
0.0738067705

A
A
B
C
D
E

B
0
4
2
2
1
9

C
1
0
2
1
1
5

D
3
3
0
1
1
8

E
1
1
1
0
1
4

1
1
1
1
0
4

6
9
6
5
4

0.111111
Initial Direct Relationship Matrix
0
0.444444
0.222222
0.222222
0.111111

0.111111
0
0.222222
0.111111
0.111111

0.333333
0.333333
0
0.111111
0.111111

0.111111
0.111111
0.111111
0
0.111111

0.111111
0.111111
0.111111
0.111111
0

1
-0.444444
-0.222222
-0.222222
-0.111111

-0.111111
1
-0.222222
-0.111111
-0.111111

I-D
-0.333333
-0.333333
1
-0.111111
-0.111111

-0.111111
-0.111111
-0.111111
1
-0.111111

-0.111111
-0.111111
-0.111111
-0.111111
1

0.415673
0.940375
0.626065
0.532027
0.39046

0.373083
0.385009
0.457411
0.31891
0.281601

D*(I-D)^-1
0.664395
0.863714
0.431005
0.444634
0.378194

0.306644
0.398637
0.31431
0.174446
0.243782

0.306644
0.398637
0.31431
0.274446
0.143782

2.06644

I(Identity Matrix)
1
0
0
0
0

1.4156729131
0.9403747871
0.6260647359
0.5320272572
0.3904599659

Threshold Value
0.4151277683

0
1
0
0
0

0
0
1
0
0

0
0
0
1
0

Inverse of I-D
0.373083 0.664395
1.385009 0.863714
0.457411 1.431005
0.31891 0.444634
0.281601 0.378194

0.306644
0.398637
0.31431
1.174446
0.243782

0.306644
0.398637
0.31431
0.274446
1.143782

0
0
0
0
1

Working Capital
Typical Industry

Average Inventory Investment for 6 to 8 inventory


turnarounds

Revenue Realization
Average Unrealized
Revenue 2 to 5%

US $125-168 million

US $20-50 million

Typical
High Carrying Obsolescene
Inefficiences and High Inventory Cost Cost
Errors
20-30%
2-5%
5-15%
Upto 40% more revenue
What can be saved?
US $ 5-15 million

Slow
Fulfillment
1-2%
Upto 20% more revenue
US $ 4-10 million

venue Realization
verage Unrealized
Revenue 2 to 5%

US $20-50 million
Lost Sales

2-3%
o 20% more revenue
US $ 4-10 million

To

Tm
4
1
3
4
0.5
3
1
5
2
2.5
3

Tp
6
4.5
3
5
1
4
1.5
6
5
2.75
5

Expected Time
8
5
3
6
1.5
5
5
7
8
4.5
7

Variance
6 0.444444
4 0.444444
3
0
5 0.111111
1 0.027778
4 0.111111
2 0.444444
6 0.111111
5
1
3 0.111111
5 0.444444

0.761148

You might also like