Material Management
Dr Adewale Abimbola, FHEA, GMICE.
Aim
and Objectives
Aim: Material Management�Objectives: At the end of the lesson, the students should be able to:
Intro. Quiz
List the different types of material needed on a typical construction site.
Just in Time Deliveries (JIT)
Inventory Optimisation
Safety Stock
Z-score MS Excel formula = NORMSINV()
Worked Example 1:
A project manager records the daily use of A4 photocopier paper in a month (Table 1). She has determined that the lead time is 3 days and the service level is 95% (This means the safety stock levels will cover for 95% of all probable requests).
Determine the safety stock; the additional quantity held in inventory to mitigate the risk of a stockout.
Safety Stock
Day | Demand |
1 | 100 |
2 | 122 |
3 | 491 |
4 | 86 |
5 | 278 |
6 | 145 |
7 | 438 |
8 | 38 |
9 | 316 |
10 | 489 |
11 | 227 |
12 | 427 |
13 | 286 |
14 | 474 |
15 | 32 |
Day | Demand |
16 | 439 |
17 | 167 |
18 | 46 |
19 | 546 |
20 | 77 |
21 | 56 |
22 | 34 |
23 | 126 |
24 | 218 |
25 | 8 |
26 | 10 |
27 | 373 |
28 | 382 |
29 | 453 |
30 | 54 |
31 | 310 |
Safety Stock
Reorder Point
Worked Example 2:
A project manager records the daily use of A4 photocopier paper in a month (Table 1). She has determined that the lead time is 3 days and the service level is 95% (This means the safety stock levels will cover for 95% of all probable requests).
Determine the reorder point to avoid running out of stock.
Reorder Point
Day | Demand |
1 | 100 |
2 | 122 |
3 | 491 |
4 | 86 |
5 | 278 |
6 | 145 |
7 | 438 |
8 | 38 |
9 | 316 |
10 | 489 |
11 | 227 |
12 | 427 |
13 | 286 |
14 | 474 |
15 | 32 |
Day | Demand |
16 | 439 |
17 | 167 |
18 | 46 |
19 | 546 |
20 | 77 |
21 | 56 |
22 | 34 |
23 | 126 |
24 | 218 |
25 | 8 |
26 | 10 |
27 | 373 |
28 | 382 |
29 | 453 |
30 | 54 |
31 | 310 |
Reorder Point
Self-assessment Task 1
A site supervisor monitors the daily consumption of concrete blocks on a construction site over a month (Table 1). After establishing a lead time of 5 days and a service level of 92%, calculate the safety stock and reorder point.
Day | Demand |
1 | 1961 |
2 | 1939 |
3 | 1249 |
4 | 1999 |
5 | 1506 |
6 | 1467 |
7 | 1211 |
8 | 1372 |
9 | 1246 |
10 | 1413 |
11 | 1887 |
12 | 1378 |
13 | 1394 |
14 | 1461 |
15 | 1622 |
Day | Demand |
16 | 1756 |
17 | 1595 |
18 | 1736 |
19 | 1923 |
20 | 1678 |
21 | 1324 |
22 | 1970 |
23 | 1540 |
24 | 1388 |
25 | 1810 |
26 | 1257 |
27 | 1532 |
28 | 1741 |
29 | 1558 |
30 | 1758 |
31 | 1807 |
Self-assessment Task 2
A civil engineering firm is managing the construction of a major bridge project. The project requires careful management of specialised materials such as high-strength steel cables, pre-stressed concrete beams, and custom-designed expansion joints.
Given parameters:
• Lead time for steel cables: 12 weeks
• Service level: 98%
Calculate the safety stock and reorder point.
Week | Consumption (metres) |
1 | 110 |
2 | 150 |
3 | 200 |
4 | 112 |
5 | 92 |
6 | 130 |
7 | 117 |
8 | 105 |
9 | 87 |
10 | 96 |
11 | 84 |
12 | 101 |
13 | 82 |
14 | 96 |
15 | 123 |
16 | 131 |
Note: Use MS Excel to complete this task.
Group-assessment Task
References/Bibliography