ROT

O
 SUPPLY CHAIN PROCESS

PLANNING SOURCING MAKE DELIVER

-Demand
Plan. RETURN
-S&OP. -SOUCE. -MFG. -LOGISTICS.
-MPS. -PURCHASE. -SCHEDULE. -WEARHOUSE
-MRP.
 SUPPLY CHAIN PROCESS
PLANNING
1-Demand Plan

year naiive moving average weighted moving average mathematical model

sales(demand)In thousands

y = 8.1273x - 16170

2013 190 2 3 4 0.2 190.2549

2014 199 190 0.3 198.3822

2015 194 199 194.5 0.5 206.5095

2016 220 194 196.5 194.3333 194.7 214.6368

2017 227 220 207 204.3333 200.75 208 222.7641

2018 234 227 223.5 213.6667 210 218.3 230.8914

2019 238 234 230.5 227 218.75 229.1 239.0187

2020 248 238 236 233 229.75 234.6 247.146

2021 255 248 243 240 236.75 242.2 255.2733

2022 260 255 251.5 247 243.75 249.5 263.4006

2023 270 260 257.5 254.3333 250.25 256.1 271.5279

2024 ?? 270 265 261.6667 258.25 264 279.6552

 PLANNING
Performance

performance (error)
naiive weighted moving average mathematical model
moving average %

% 2 % % 0.2549 0.13%

9 4.52% 0.6178 0.31%

5 2.58% 0.50 0.26% 12.5095 6.45%

26 11.82% 23.50 10.68% 25.3 11.50% 5.3632 2.44%

7 3.08% 20.00 8.81% 19 8.37% 4.2359 1.87%

7 2.99% 10.50 4.49% 15.7 6.71% 3.1086 1.33%

4 1.68% 7.50 3.15% 8.9 3.74% 1.0187 0.43%

10 4.03% 12.00 4.84% 13.4 5.40% 0.854 0.34%

7 2.75% 12.00 4.71% 12.8 5.02% 0.2733 0.11%

5 1.92% 8.50 3.27% 10.5 4.04% 3.4006 1.31%

10 3.70% 12.50 4.63% 13.9 5.15% 1.5279 0.57%

3.91% 4.98% 6.24% 1.51%

The best method to use is mathematical

 SUPPLY CHAIN PROCESS
PLANNING
2-Sales and operating process

Family SKU 2020 2021 2022 2023 average sales %

Black 48,000 50,000 50,000 52,000 50000 19%
pen Red 60,000 65,000 65,000 67,000 64250 25%
Blue 140,000 140,000 145,500 151,000 144125 56%
SUM 248,000 255,000 260,500 270,000 258375

Pen M1 M2 M3 M4
Black 300

Demand (Sales Plan) 4,300 4,350 4,450 4,500

MPS lost size Red 400

Black 832 842 861 871

Blue 500
Demand (Sales Plan) 5,500 5,600 5,650 5,750

Red 1,368 1,393 1,405 1,430

Demand (Sales Plan) 12,000 12,125 12,200 12,350

Blue 6,694 6,763 6,805 6,889

 Plan(BLACK) W1 W2 W3 W4 W5 W6 W7 W8 W9 W10 W11 W12 W13 W14 W15 W16 W17

Demand 174 174 174 174 174 220 220 220 225 225 225 225 228 228 228 228
220

1500 Inventory 1,326 1,152 978 804 630 190 770 550 325 100 675 450 222 794 567 339
410

MPS 800 800 800

Plan(RED) W1 W2 W3 W4 W5 W6 W7 W8 W9 W10 W11 W12 W13 W14 W15 W16 W17

Demand 317 274 274 274 274 348 348 348 407 351 351 351 414 357 357 357
403

2000 Inventory 1,683 1,409 1,135 861 587 836 488 140 733 382 680 266 909 552 195
184 31

MPS 1,000 1,000 1,000 1,000

Plan(BLUE) W1 W2 W3 W4 W5 W6 W7 W8 W9 W10 W11 W12 W13 W14 W15 W16 W17

Demand 1,223 1,339 1,339 1,339 1,339 1,545 1,691 1,691 1,555 1,701 1,701 1,701 1,574 1,722 1,722 1,722
1,691

10000 Inventory 8,777 7,438 6,099 4,760 3,421 1,876 185 194 203 348 347 346 345 472 450 428 406

MPS 1,700 1,700 1,700 1,700 1,700 1,700 1,700 1,700 1,700
1,700
 FRONT COVER

INK
BODY

BACK COVER
 SUPPLY CHAIN PROCESS
PLANNING
Bill of material & MRP

BOM # Part number Part name Qty UOM LT

1 A2154 FRONT COVER 1 PC 3 W
explotion 2 A2155 BACK COVER 1 PC 2 W
3 A2156 INK 150 ML 1 W
4 A2157 BODY 1 PC 3 W

BLACK Plan W1 W2 W3 W4 W5 W6 W7 W8 W9 W10 W11 W12 W13 W14 W15 W16 W17
MPS 800 800 800
FRONT COVER 0 0 0 0 0 0 0 800 0 0 0 800 0 0 800 0 0
BACK COVER 0 0 0 0 0 0 0 800 0 0 0 800 0 0 800 0 0
INK 0 0 0 0 0 0 0 120 0 0 0 120 0 0 120 0 0
BODY 0 0 0 0 0 0 0 800 0 0 0 800 0 0 800 0 0
RED Plan W1 W2 W3 W4 W5 W6 W7 W8 W9 W10 W11 W12 W13 W14 W15 W16 W17
MPS 1000 1000 1000 1000
FRONT COVER 0 0 0 0 0 0 1000 0 0 1000 0 0 1000 0 1000 0 0
BACK COVER 0 0 0 0 0 0 1000 0 0 1000 0 0 1000 0 1000 0 0
INK 0 0 0 0 0 0 150 0 0 150 0 0 150 0 150 0 0
BODY 0 0 0 0 0 0 1000 0 0 1000 0 0 1000 0 1000 0 0
BLUE Plan W1 W2 W3 W4 W5 W6 W7 W8 W9 W10 W11 W12 W13 W14 W15 W16 W17
MPS 1700 1700 1700 1700 1700 1700 1700 1700 1700 1700
FRONT COVER 0 0 0 0 0 0 0 1700 1700 1700 1700 1700 1700 1700 1700 1700 1700
BACK COVER 0 0 0 0 0 0 0 1700 1700 1700 1700 1700 1700 1700 1700 1700 1700
INK 0 0 0 0 0 0 0 255 255 255 255 255 255 255 255 255 255
BODY 0 0 0 0 0 0 0 1700 1700 1700 1700 1700 1700 1700 1700 1700 1700
 SUPPLY CHAIN PROCESS
Material Plan FRONT COVER 200
W1 W2 W3 W4 W5 W6 W7 W8 W9 W10 W11 W12 W13 W14 W15 W16
grossing Gross Requirement 0 0 0 0 0 0 1000 2500 1700 2700 1700 2500 2700 1700 3500 1700
300 Inventory 300 300 300 300 800 800 0 0 0 0 0 0 0 0 0 0
Order Rec / Pipeline 500 200 500

netting Net Requirements

Planned Order Receipt
0 0 0 0 0 200
200
2500
2600
1500
1600
2700
2800
1700
1800
2500
2600
2200
2200
1700
1800
3500
3600
1700
1800
Planned order Release 0 0 0 200 2600 1600 2800 1800 2600 2200 1800 3600 1800 0 0 0

offsetting Material Plan BACK COVER

W1 W2
200
W3 W4 W5 W6 W7 W8 W9 W10 W11 W12 W13 W14 W15 W16
Gross Requirement 0 0 0 0 0 0 1000 2500 1700 2700 1700 2500 2700 1700 3500 1700
450 Inventory 450 450 450 450 1150 1150 150 0 0 0 0 0 0 0 0 0
Order Rec / Pipeline 700 700 300
Net Requirements 0 0 0 0 0 0 2350 1700 2000 1700 2500 2400 1700 3500 1700
Planned Order Receipt 2400 1800 2000 1800 2600 2400 1800 3600 1800
Planned order Release 0 0 0 0 0 2400 1800 2000 1800 2600 2400 1800 3600 1800 0 0

Material Plan INK 200

PLANNING Gross Requirement
W1
0
W2
0
W3
0
W4
0
W5
0
W6
0
W7
150
W8
375
W9
255
W10
405
W11
255
W12
375
W13
405
W14
255
W15
525
W16
255
350 Inventory 350 350 350 350 350 1250 1100 725 770 365 110 635 230 0 0 0
Order Rec / Pipeline 900 300 900
Net Requirements 0 0 0 0 0 0 0 0 0 0 0 0 25 525 255
Planned Order Receipt 200 600 400

Bill of material Planned order Release 0 0 0 0 0 0 0 0 0 0 0 0 200 600 400 0

& MRP Material Plan BODY

W1 W2
200
W3 W4 W5 W6 W7 W8 W9 W10 W11 W12 W13 W14 W15 W16
Gross Requirement 0 0 0 0 0 0 1000 2500 1700 2700 1700 2500 2700 1700 3500 1700
400 Inventory 400 400 400 400 400 1400 400 0 0 0 0 0 0 0 0 0
Order Rec / Pipeline 1000 1000 400
Net Requirements 0 0 0 0 0 0 2100 700 2700 1700 2500 2300 1700 3500 1700
Planned Order Receipt 2200 800 2800 1800 2600 2400 1800 3600 1800
Planned order Release 0 0 0 0 2200 800 2800 1800 2600 2400 1800 3600 1800 0 0 0
 ‫‪SUPPLY CHAIN PROCESS‬‬
‫‪sourcing‬‬

‫‪MRP‬‬ ‫‪Requester‬‬ ‫‪purchasing‬‬ ‫‪Sourcing‬‬

‫)‪(specification‬‬
‫‪materials‬‬ ‫‪quantity‬‬ ‫‪price‬‬ ‫تورد شركه رافال للبالستيك الكميات المشار اليها باالسعار المعروضه في تاريخ ‪21/11/2023‬‬
‫‪front cover‬‬ ‫‪200‬‬ ‫‪0.5‬‬ ‫‪.‬بحالتها السليمة‬
‫‪.‬يتحمل البائع جميع تكاليف الشحن والعماله‬
‫‪back cover‬‬ ‫‪2400‬‬ ‫‪0.25‬‬
‫‪.‬يدفع المبلغ كامال عند االستالم‪-‬‬
‫‪ink‬‬ ‫‪30‬‬ ‫‪0.25‬‬
‫مصاريف النقل والشحن على البائع‪-‬‬
‫‪body‬‬ ‫‪2200‬‬ ‫‪0.5‬‬
‫‪Legal‬‬ ‫تامين الشحنه كامال حتى الوصول على البائع‪-‬‬
‫اذا تم تاخير الشحنه عن المهله المتفق عليها (‪ 15‬يوم) يتم دفع غرامه ‪ %10‬من البائع‪-‬‬
‫‪Finance‬‬ ‫الدفع عن طريق البنك‪-‬‬
‫‪.‬تتحمل احدي الشركتين شرط جزائي ‪ %20‬من قيمة البضاعه في حالة االخالل بأي بند من بنود العقد‪-‬‬

‫‪ /..............‬الطرف االول‬
‫‪/..............‬الطرف الثانى‬
 SUPPLY CHAIN PROCESS
Deliver & wearhouse

Inv. cost

Unit cost Acquistion cost carrying cost stock out

Material cost=1.5 Cap. Cost=14%

Labor cost= 0.5 per unit Ordering cost =500 Risk cost=16%
Packiging cost= 0.25 Unit cost =2.5 Tax=10%
Transportation = 0.25 per
unit
 SUPPLY CHAIN PROCESS
Deliver & wearhouse

Inv. cost

stock out

demand
2013 190
Reorder point = LEAD TIME * DDLT
2014 199 =3*( + 54 = 88
2015 194
EOQ = UNIT 2016 220
2017 227
2018 234
2019 238
SAFETY STOCK = SD*[Link] 2020 248
2021 255
=27.37285 *1.96 =54 2022 260
2023 270

Orders 1000
stock out 25