Resource Commulati
[Link]. Material Label Initials cost/unit demand Total Cost % Ranking
Name ve Demand
1 Steel Kg S 60 6862 411720 411720 42.65% A
2 Cement bags C 350 800 280000 691720 29.00% A
3 Sand brass S 9,000.00 14 126000 817720 13.05% A
4 Aggregate brass A 2,000.00 21.07 42140 859860 4.37% A
5 Tiles sq f T 55 425 23375 883235 2.42% A
6 fan number f 1700 8 13600 896835 1.41% B
7 Electric wire bundle e 670 20 13400 910235 1.39% B
8 Bricks brass B 6,516.00 2 13032 923267 1.35% B
9 Admixture number A 3,070.00 3 9210 932477 0.95% B
10 WC pan number W 4500 2 9000 941477 0.93% C
11 Murum brass M 1100 7 7700 949177 0.80% C
12 shower number s 2500 2 5000 954177 0.52% C
13 taps number t 400 12 4800 958977 0.50% C
14 bulb number b 400 10 4000 962977 0.41% C
15 Sink(16x22) number S 1500 1 1500 964477 0.16% C
16 Excavation brass E 450 2 900 965377 0.09% C
965377
Material Ordering Holding
[Link]. Resource Name Initials cost/unit demand(D) Total Cost
Label cost(S) Cost(H)
1 Steel Kg S 60 6862 411720 8234.4 9
2 Cement bags C 350 800 280000 5600 52.5
3 Sand brass S 9,000.00 14 126000 2520 250
4 Aggregate brass A 2,000.00 21.07 42140 842.8 300
5 Tiles sq f T 55 425 23375 467.5 8.25
6 fan number f 1700 8 13600 272 255
7 Electric wire bundle e 670 20 13400 268 100.5
8 Bricks brass B 6,516.00 2 13032 260.64 250
9 Admixture number A 3,070.00 3 9210 184.2 250
10 WC pan number W 4500 2 9000 180 250
11 Murum brass M 1100 7 7700 154 165
12 shower number s 2500 2 5000 100 250
13 taps number t 400 12 4800 96 60
14 bulb number b 400 10 4000 80 60
15 Sink(16x22) number S 1500 1 1500 30 225
16 Excavation brass E 450 2 900 18 67.5
965377
2*D*S (2*D*S)/H EOQ feasible EOQ total cost [Link] orders C order of quantities
113008906 12556545 3543.522 3600 216000 1.9061111111 2
8960000 170666.67 413.1182 420 147000 1.9047619048 2
70560 282.24 16.8 17 153000 0.8235294118 1
35515.592 118.38531 10.8805 10 20000 2.107 2
397375 48166.667 219.4691 220 12100 1.9318181818 2
4352 17.066667 4.131182 4 6800 2 2
10720 106.66667 10.32796 10 6700 2 2
1042.56 4.17024 2.042117 2 13032 1 1
1105.2 4.4208 2.10257 2 6140 1.5 1
720 2.88 1.697056 2 9000 1 1
2156 13.066667 3.614784 4 4400 1.75 2
400 1.6 1.264911 2 5000 1 1
2304 38.4 6.196773 6 2400 2 2
1600 26.666667 5.163978 5 2000 2 2
60 0.2666667 0.516398 1 1500 1 1
72 1.0666667 1.032796 1 450 2 2
time betwn order
Resource Material Ordering Holding
[Link]. Initials cost/unit demand(D) Total Cost feasible EOQ
Name Label cost(S) Cost(H)
1 Steel Kg S 60 6862 411720 8234.4 9 3600
2 Cement bags C 350 800 280000 5600 52.5 420
3 Sand brass S 9,000.00 14 126000 2520 250 17
4 Aggregate brass A 2,000.00 21.07 42140 842.8 300
10
5 Tiles sq f T 55 425 23375 467.5 8.25 220
6 fan number f 1700 8 13600 272 255 4
Electric
7 bundle e 670 20 13400 268 100.5
wire 10
8 Bricks brass B 6,516.00 2 13032 260.64 250 2
Admixtur
9 number A 3,070.00 3 9210 184.2 250
e 2
10 WC pan number W 4500 2 9000 180 250 2
11 Murum brass M 1100 7 7700 154 165 4
12 shower number s 2500 2 5000 100 250 2
13 taps number t 400 12 4800 96 60 6
14 bulb number b 400 10 4000 80 60 5
Sink(16x2
15 number S 1500 1 1500 30 225
2) 1
Excavatio
16 brass E 450 2 900 18 67.5
n 1
No of Corrected Date Date used Date used justificati
orders total cost ordered from to on
2 432000
2 294000
1 153000
2 40000
2 24200
2 13600
2 13400
1 13032
1 6140
1 9000
2 8800
1 5000
2 4800
2 4000
1 1500
2 900