Production Scheduling-Supply Chain Management Report 2022

Production Scheduling- Supply Chain Management
Introduction
Ultralights (company or firm) is a medium sized firm employing 900 persons and 125
managerial and administrative personnel. The firm is engaged in the business of automotive
electrical components. The company has been planning their inventory through Material
Requirement Planning (MRP) strategy. The company is under the able guidance of Mr.
Johnny Bennet. Recently, the company has faced some issues or to be correct in a spirit to
further innovate and improvise the inventory management strategy, there is a further planning
to modernise the current MRP system of inventory planning based on vies obtained from
different personnel in the organisation,
The report has been prepared with an objective to schedule the inventory for producing the
required product so as to make the inventory available as per the demand of the organisation
which starts from week for two products namely:
(a) Headlamp (HL200E);
(b) Sidelamp (SL 100E)
Further, there is also demand for one spare part namely Side Lens(SL 111P)
Analysis
Demand
The company has forecasted demand for its product starting from week 3, the demand pattern
projected has been presented as under:
Sl No Item Description Quantity Week
1 Head lamp (HL 200E) 120 4
90 5
75 6
2 Side Lamp ( SL 100E) 100 3
80 5
110 6
3 Side Lens (SL 111P) 40 3
35 6
Production charting
Further, each component manufacturing requires a varied of sub products which needs to be
procured timely so as to manage the operations of the company. The current manufacturing
passage or mapping of each product requirement is presented as under:
Sl
No
Item Description and Part
Number
HL
200E
SL
100E
HL
211A
SL
112A
SL
122A
SL
123A
1 SL 111P 1
2 SL 113P 1
3 SL 112A 1
4 SL 121F 1

Sl
No
Item Description and Part
Number
HL
200E
SL
100E
HL
211A
SL
112A
SL
122A
SL
123A
5 SL 122A\ 1
6 SL 123A 1
7 SL 131F 1
8 SL 133F 1
9 SL 132P 1
10 SL 134P 1
11 HL 211A 1
12 HL 212P 1
13 HL 222P 1
14 HL 223F 1
15 C 310P 1 1
16 C 206P 4 2 2
Material Procurement Pattern
The company has material procurement planning wherein fixed lead time and safety stock
has been maintained so as to ensure smooth flow of inventory along the pipeline without
creating any hassles or blockage in the supply chain. For ensuring the said pattern, company
management has prepared the following status of the current availability of raw materials for
meeting the demands starting from week 3.
Sl
No
Item Description and
Part Number
Lead Time
(weeks)
Safety Stock
(units)
Lot
Sizing
On
Hand
Scheduled
Receipts
1 SL 111P 2 0
FOQ=3
50 15
2 SL 113P 1 20
FOQ=1
00 20
3 SL 112A 3 0 L4L 20 80 (Week 2)
4 SL 121F 2 0 L4L 0 80 (Week 2)
5 SL 122A 2 0 L4L 0 80 (Week 2)
6 SL 123A 2 0
FOQ=2
00 0
7 SL 131F 2 0
POQ
(P=2) 0 110 (Week 1)
8 SL 133F 2 0
FOQ=2
50
9 SL 132P 1 25
FOQ=1
00 35 100 (Week 1)
10 SL 134P 1 0
FOQ=4
00 100
11 HL 211A 3 0 L4L 0
12 HL 212P 2 15
FOQ=3
50 15
13 HL 222P 3 10
POQ
(P=4) 10 285 (Week 1)
14 HL 223F 1 0
POQ
(P=4) 0 120 (Week 1)
15 C 310P 1 20 FOQ=1 40 180 (Week 1)

Sl
No
Item Description and
Part Number
Lead Time
(weeks)
Safety Stock
(units)
Lot
Sizing
On
Hand
Scheduled
Receipts
80
16 C 206P 1 30
FOQ=2
500 270
Material Requirement for the period
Further based on demand of the organisation, one needs to plan the inventory required over
the 6 week period based on data and facts available. Further, one needs to eliminate the
inventory whose product is available. Based on above the inventory requirement of the
organisation is presented as under:
Sl
No
Item Description and
Part Number
HL
200E
SL
100
E
HL
211A
SL
112
A
SL
122
A
SL
123
A
Ext
ra
tot
al
1 SL 111P 0 290 0 0 0 0 75
36
5
2 SL 113P 0 290 0 0 0 0 0
29
0
3 SL 112A 0 290 0 0 0 0 0
29
0
4 SL 121F 0 0 0 290 0 0 0
29
0
5 SL 122A 0 0 0 290 0 0 0
29
0
6 SL 123A 0 0 0 290 0 0 0
29
0
7 SL 131F 0 0 0 0 290 0 0
29
0
8 SL 133F 0 0 0 0 0 290 0
29
0
9 SL 132P 0 0 0 0 290 0 0
29
0
10 SL 134P 0 0 0 0 0 290 0
29
0
11 HL 211A 285 0 0 0 0 0 0
28
5
12 HL 212P 285 0 0 0 0 0 0
28
5
13 HL 222P 0 0 285 0 0 0 0
28
5
14 HL 223F 0 0 285 0 0 0 0
28
5
15 C 310P 0 0 285 290 0 0 0
57
5
16 C 206P 1140 580 570 0 0 0 0
22
90
However, some of the items are available in the fold of the company, hence the said materials
are required to be eliminated to optimise the inventory process.