Material Planning Dashboard

Emergency
0

Items requiring immediate attention.

Fair Attention
0

Items needing close monitoring.

Okay
0

Sufficiently stocked items.

Over Stocked
0

Items exceeding optimal level.

itemno	Description	uom	MRequiredPerSupplyPlan	Buffer & Specials 30%	TotalMaterialRequiredPerSupplyPlan	ConsolidatedStockBalance	MrpPerDay	TargetedCoverDays	LeadTime	CoverDaysWithoutGIT	OutstandingDaysToCoverWithoutGIT	CoverDaysWithGIT	OutstandingDays
RMCH001	Polyol	MT	1069318.08516863	320795.42555059	1390113.51071922	544937.780000000000	11584.2792559935	120.000000000000	135.000000000000	47.0411467090676	72.9588532909324	47.0411467090676	72.9588532909324
RMCH002	TDI250KG	MT	660707.847504434	198212.35425133	858920.201755764	224589.290000000000	7157.6683479647	120.000000000000	135.000000000000	31.3774373275988	88.6225626724012	31.3774373275988	88.6225626724012
RMCH013	SIDE PAPER 140cm 600kg/roll	KG	17067.0798648729	5120.12395946186	22187.2038243347	9782.940000000000	184.893365202789	120.000000000000	21.000000000000	52.9112550321649	67.0887449678351	52.9112550321649	67.0887449678351
RMLBLSPMD	MONDEO SPRING LABEL	PCS	1686	505.8	2191.8	850.000000000000	18.265	120.000000000000	14.000000000000	46.537092800438	73.462907199562	46.537092800438	73.462907199562
RMNLN014	Crown Fibre Pillow Nylon	PCS	51270	15381	66651	26274.000000000000	555.425	120.000000000000	14.000000000000	47.3043165143809	72.6956834856191	47.3043165143809	72.6956834856191
RMNLN024	Wellbeing Topper Carrier Bag	PCS	1350	405	1755	750.000000000000	14.625	120.000000000000	30.000000000000	51.2820512820513	68.7179487179487	51.2820512820513	68.7179487179487
RMNLN027	Fiesta Topper Carrier Bag	PCS	1535	460.5	1995.5	736.000000000000	16.6291666666667	120.000000000000	30.000000000000	44.2595840641443	75.7404159358557	44.2595840641443	75.7404159358557
RMSPR019	COIL WIRE 2.4mm	KG	32393.83	9718.149	42111.979	14263.160000000000	350.933158333333	120.000000000000	135.000000000000	40.6435233072281	79.3564766927719	40.6435233072281	79.3564766927719
RMTAP003	Taping Edge 1.5" Color m	MTR	1908757.125028	572627.1375084	2481384.2625364	1174158.190000000000	20678.2021878033	120.000000000000	5.000000000000	56.7824117075592	63.2175882924408	56.7824117075592	63.2175882924408
RMTXT-058	Elastic Loop	MTR	5770	1731	7501	2900.000000000000	62.5083333333333	120.000000000000	30.000000000000	46.3938141581122	73.6061858418878	46.3938141581122	73.6061858418878

itemno	Description	uom	MRequiredPerSupplyPlan	Buffer & Specials 30%	TotalMaterialRequiredPerSupplyPlan	ConsolidatedStockBalance	MrpPerDay	TargetedCoverDays	LeadTime	CoverDaysWithoutGIT	OutstandingDaysToCoverWithoutGIT	CoverDaysWithGIT	OutstandingDays
RMCH004	Amine 200KG	KG	1708.64468248289	512.593404744868	2221.23808722776	1565.260000000000	18.5103173935647	120.000000000000	135.000000000000	84.5614889642131	35.4385110357869	84.5614889642131	35.4385110357869
RMCH005	S. Octate 25KG	KG	2731.32898474587	819.398695423763	3550.72768016963	2401.250000000000	29.589397334747	120.000000000000	135.000000000000	81.1523794430312	38.8476205569688	81.1523794430312	38.8476205569688
RMCH006	Silicon 210KG	KG	13738.4666270782	4121.53998812347	17860.0066152017	12658.860000000000	148.833388460014	120.000000000000	135.000000000000	85.0538990678221	34.9461009321779	85.0538990678221	34.9461009321779
RMCH007	Foam Hardner	MT	15126.5503532544	4537.96510597633	19664.5154592307	11934.320000000000	163.870962160256	120.000000000000	30.000000000000	72.8275457876969	47.1724542123031	72.8275457876969	47.1724542123031
RMCH014	BASE PAPER 900kg/roll	KG	14671.896333932	4401.56890017961	19073.4652341116	17493.120000000000	158.945543617597	120.000000000000	21.000000000000	110.057316498827	9.94268350117284	110.057316498827	9.94268350117284
RMCH040	VISCO SYSTEM MDI	KG	4517.216997303	1355.1650991909	5872.3820964939	5050.000000000000	48.9365174707825	120.000000000000	30.000000000000	103.1949198881	16.8050801119001	103.1949198881	16.8050801119001
RMCH055	Butane Vrac (Liquified Gas)	KG	3750.83739641	1125.251218923	4876.088615333	4180.000000000000	40.6340717944417	120.000000000000	30.000000000000	102.869336382178	17.1306636178218	102.869336382178	17.1306636178218
RMCH058	Wrapping nylon – Unbranded	KG	154.525854228	46.3577562684	200.8836104964	105.260000000000	1.67403008747	120.000000000000	30.000000000000	62.8782008088528	57.1217991911472	62.8782008088528	57.1217991911472
RMGUM004	Spray Adhesive Glue	KG	3899.98377021	1169.995131063	5069.978901273	4173.930000000000	42.249824177275	120.000000000000	30.000000000000	98.7916537234974	21.2083462765026	98.7916537234974	21.2083462765026
RMLBLCF	COMFY LABEL	PCS	64046	19213.8	83259.8	80754.000000000000	693.831666666667	120.000000000000	14.000000000000	116.388461178144	3.6115388218564	116.388461178144	3.6115388218564
RMLBTNFB	TINY FIBRE LABEL	PCS	124505	37351.5	161856.5	88246.000000000000	1348.80416666667	120.000000000000	14.000000000000	65.4253613540389	54.5746386459611	65.4253613540389	54.5746386459611
RMSPR024	SPRING PACKAGING 75X48X10	PCS	229	68.7	297.7	280.000000000000	2.48083333333333	120.000000000000	14.000000000000	112.865300638226	7.1346993617736	112.865300638226	7.1346993617736
RMTXT-039	Inner Cover 80’’	SQM	2031.86187	609.558561	2641.420431	2030.000000000000	22.011836925	120.000000000000	21.000000000000	92.2231073634033	27.7768926365967	92.2231073634033	27.7768926365967
RMWBTPINST	Wellbeing Topper Insert	PCS	2885	865.5	3750.5	3000.000000000000	31.2541666666667	120.000000000000	30.000000000000	95.9872017064391	24.0127982935609	95.9872017064391	24.0127982935609

itemno

Description

uom

MRequiredPerSupplyPlan

Buffer & Specials 30%

TotalMaterialRequiredPerSupplyPlan

ConsolidatedStockBalance

MrpPerDay

TargetedCoverDays

LeadTime

CoverDaysWithoutGIT

OutstandingDaysToCoverWithoutGIT

GIT

CoverDaysWithGIT

OutstandingDays

RMCH004

Amine 200KG

1708.64468248289

512.593404744868

2221.23808722776

1565.260000000000

18.5103173935647

120.000000000000

135.000000000000

84.5614889642131

35.4385110357869

0.000000000000

84.5614889642131

35.4385110357869

RMCH005

S. Octate 25KG

2731.32898474587

819.398695423763

3550.72768016963

2401.250000000000

29.589397334747

120.000000000000

135.000000000000

81.1523794430312

38.8476205569688

0.000000000000

81.1523794430312

38.8476205569688

RMCH006

Silicon 210KG

13738.4666270782

4121.53998812347

17860.0066152017

12658.860000000000

148.833388460014

120.000000000000

135.000000000000

85.0538990678221

34.9461009321779

0.000000000000

85.0538990678221

34.9461009321779

RMCH007

Foam Hardner

15126.5503532544

4537.96510597633

19664.5154592307

11934.320000000000

163.870962160256

120.000000000000

30.000000000000

72.8275457876969

47.1724542123031

0.000000000000

72.8275457876969

47.1724542123031

RMCH014

BASE PAPER 900kg/roll

14671.896333932

4401.56890017961

19073.4652341116

17493.120000000000

158.945543617597

120.000000000000

21.000000000000

110.057316498827

9.94268350117284

0.000000000000

110.057316498827

9.94268350117284

RMCH040

VISCO SYSTEM MDI

4517.216997303

1355.1650991909

5872.3820964939

5050.000000000000

48.9365174707825

120.000000000000

30.000000000000

103.1949198881

16.8050801119001

0.000000000000

103.1949198881

16.8050801119001

RMCH055

Butane Vrac (Liquified Gas)

3750.83739641

1125.251218923

4876.088615333

4180.000000000000

40.6340717944417

120.000000000000

30.000000000000

102.869336382178

17.1306636178218

0.000000000000

102.869336382178

17.1306636178218

RMCH058

Wrapping nylon – Unbranded

154.525854228

46.3577562684

200.8836104964

105.260000000000

1.67403008747

120.000000000000

30.000000000000

62.8782008088528

57.1217991911472

0.000000000000

62.8782008088528

57.1217991911472

RMGUM004

Spray Adhesive Glue

3899.98377021

1169.995131063

5069.978901273

4173.930000000000

42.249824177275

120.000000000000

30.000000000000

98.7916537234974

21.2083462765026

0.000000000000

98.7916537234974

21.2083462765026

RMLBLCF

COMFY LABEL

PCS

64046

19213.8

83259.8

80754.000000000000

693.831666666667

120.000000000000

14.000000000000

116.388461178144

3.6115388218564

0.000000000000

116.388461178144

3.6115388218564

RMLBTNFB

TINY FIBRE LABEL

PCS

124505

37351.5

161856.5

88246.000000000000

1348.80416666667

120.000000000000

14.000000000000

65.4253613540389

54.5746386459611

0.000000000000

65.4253613540389

54.5746386459611

RMSPR024

SPRING PACKAGING 75X48X10

PCS

229

68.7

297.7

280.000000000000

2.48083333333333

120.000000000000

14.000000000000

112.865300638226

7.1346993617736

0.000000000000

112.865300638226

7.1346993617736

RMTXT-039

Inner Cover 80’’

SQM

2031.86187

609.558561

2641.420431

2030.000000000000

22.011836925

120.000000000000

21.000000000000

92.2231073634033

27.7768926365967

0.000000000000

92.2231073634033

27.7768926365967

RMWBTPINST

Wellbeing Topper Insert

PCS

2885

865.5

3750.5

3000.000000000000

31.2541666666667

120.000000000000

30.000000000000

95.9872017064391

24.0127982935609

0.000000000000

95.9872017064391

24.0127982935609

itemno	Description	uom	MRequiredPerSupplyPlan	Buffer & Specials 30%	TotalMaterialRequiredPerSupplyPlan	ConsolidatedStockBalance	MrpPerDay	TargetedCoverDays	LeadTime	CoverDaysWithoutGIT	OutstandingDaysToCoverWithoutGIT	CoverDaysWithGIT	OutstandingDays
RMBIO001	BIOCRYSTAL MIXTURE 0,1-0,4mm	KG	20.58	6.174	26.754	464.500000000000	0.22295	120.000000000000	30.000000000000	2083.42677730433	-1963.42677730433	2083.42677730433	-1963.42677730433
RMBIOZIPLOCK	Bio Pillow zip-lock nylon	PCS	980	294	1274	8510.000000000000	10.6166666666667	120.000000000000	30.000000000000	801.569858712716	-681.569858712716	801.569858712716	-681.569858712716
RMBLKINST	BULK PILLOW INSERT	PCS	6452	1935.6	8387.6	33599.000000000000	69.8966666666667	120.000000000000	7.000000000000	480.695312127426	-360.695312127426	480.695312127426	-360.695312127426
RMCH016	RS NYLON 56CM 26kg/roll	KG	7982.59327054634	2394.7779811639	10377.3712517102	15513.210000000000	86.478093764252	120.000000000000	21.000000000000	179.388898676358	-59.3888986763581	179.388898676358	-59.3888986763581
RMCH024	DOP 200KG	MT	2022.62656118093	606.787968354279	2629.41452953521	3600.000000000000	21.9117877461267	120.000000000000	21.000000000000	164.295129256916	-44.2951292569159	164.295129256916	-44.2951292569159
RMCH028	GLYCERIN 250KG	MT	957.58008203	287.274024609	1244.854106639	8185.000000000000	10.3737842219917	120.000000000000	30.000000000000	789.008121322632	-669.008121322632	789.008121322632	-669.008121322632
RMCH039	VISCO SYSTEM POLYOL ACE-550	KG	10265.312350698	3079.5937052094	13344.9060559074	16660.000000000000	111.207550465895	120.000000000000	30.000000000000	149.809971806809	-29.8099718068088	149.809971806809	-29.8099718068088
RMCH051	Wrapping NYLON 80-85 gsm	KG	11233.30491344	3369.991474032	14603.296387472	158809.000000000000	121.694136562267	120.000000000000	30.000000000000	1304.98481263099	-1184.98481263099	1304.98481263099	-1184.98481263099
RMCH052	Conventional polyol	KG	3352.577244	1005.7731732	4358.3504172	5300.000000000000	36.31958681	120.000000000000	30.000000000000	145.926770250061	-25.9267702500605	145.926770250061	-25.9267702500605
RMCH056	Poudre Talc Industrial	KG	37.8490151	11.35470453	49.20371963	1275.000000000000	0.410030996916667	120.000000000000	30.000000000000	3109.52101082038	-2989.52101082038	3109.52101082038	-2989.52101082038
RMCRHND	PILLOW TOP ROYAL CARRIER HANDLE	PCS	1108	332.4	1440.4	17000.000000000000	12.0033333333333	120.000000000000	135.000000000000	1416.27325742849	-1296.27325742849	1416.27325742849	-1296.27325742849
RMLBFLPR	FLORA PREMIER LABEL	PCS	3189	956.7	4145.7	9936.000000000000	34.5475	120.000000000000	14.000000000000	287.60402344598	-167.60402344598	287.60402344598	-167.60402344598
RMLBLKK	KOKO LABEL	PCS	14977	4493.1	19470.1	72130.000000000000	162.250833333333	120.000000000000	14.000000000000	444.55857956559	-324.55857956559	444.55857956559	-324.55857956559
RMLBLLG	LEGEND PLUS LABEL (LDPE)	PCS	2004	601.2	2605.2	3114.000000000000	21.71	120.000000000000	15.000000000000	143.436204514049	-23.4362045140489	143.436204514049	-23.4362045140489
RMLBLSFL	SUPER FLORA LABEL	PCS	4603	1380.9	5983.9	82064.000000000000	49.8658333333333	120.000000000000	14.000000000000	1645.69595080132	-1525.69595080132	1645.69595080132	-1525.69595080132
RMLBPTR	PILLOW TOP ROYAL LABEL	PCS	277	83.1	360.1	50350.000000000000	3.00083333333333	120.000000000000	30.000000000000	16778.672590947	-16658.672590947	16778.672590947	-16658.672590947
RMLBPTR2	PILLOW TOP ROYAL INFO LABEL	PCS	277	83.1	360.1	2400.000000000000	3.00083333333333	120.000000000000	21.000000000000	799.777839489031	-679.777839489031	799.777839489031	-679.777839489031
RMLBWB	WELL BEING LABEL	PCS	11754	3526.2	15280.2	56255.000000000000	127.335	120.000000000000	14.000000000000	441.78741115954	-321.78741115954	441.78741115954	-321.78741115954
RMNLN015	Classic Foam Pillow Nylon	PCS	13640	4092	17732	21774.000000000000	147.766666666667	120.000000000000	30.000000000000	147.353936386194	-27.3539363861944	147.353936386194	-27.3539363861944
RMNLN016	Comfy Pillow Nylon	PCS	7320	2196	9516	37654.000000000000	79.3	120.000000000000	30.000000000000	474.829760403531	-354.829760403531	474.829760403531	-354.829760403531
RMNLN017	PILLOW BULK PACK NYLON	PCS	6452	1935.6	8387.6	11025.000000000000	69.8966666666667	120.000000000000	14.000000000000	157.732843721684	-37.7328437216844	157.732843721684	-37.7328437216844
RMNLN023	Koko Pillow Nylon	PCS	41970	12591	54561	84418.000000000000	454.675	120.000000000000	30.000000000000	185.666684994776	-65.6666849947765	185.666684994776	-65.6666849947765
RMNLN054	Bio Pillow Nylon	PCS	980	294	1274	23378.000000000000	10.6166666666667	120.000000000000	30.000000000000	2202.00941915228	-2082.00941915228	2202.00941915228	-2082.00941915228
RMNLN055	Cozy pillow Nylon	PCS	3600	1080	4680	9046.000000000000	39	120.000000000000	30.000000000000	231.948717948718	-111.948717948718	231.948717948718	-111.948717948718
RMNLN056	Cutie Pillow Nylon	PCS	2840	852	3692	10577.000000000000	30.7666666666667	120.000000000000	30.000000000000	343.781148429036	-223.781148429036	343.781148429036	-223.781148429036
RMSPR008	SPRING SUPPORT	PCS	14948	4484.4	19432.4	60500.000000000000	161.936666666667	120.000000000000	135.000000000000	373.602848850374	-253.602848850374	373.602848850374	-253.602848850374
RMSPR009	HALTCO CLIPS	PCS	387620	116286	503906	550000.000000000000	4199.21666666667	120.000000000000	45.000000000000	130.976809166789	-10.9768091667891	130.976809166789	-10.9768091667891
RMSPR010	FLEX-C-RING CLIP	PCS	204371.74873	61311.524619	265683.273349	2054000.000000000000	2214.02727790833	120.000000000000	45.000000000000	927.721180535988	-807.721180535988	927.721180535988	-807.721180535988
RMSPR022	HELLICO WIRE 1.3mm	KG	3810.08	1143.024	4953.104	9891.800000000000	41.2758666666667	120.000000000000	135.000000000000	239.650934040553	-119.650934040553	239.650934040553	-119.650934040553
RMSPR023	Air Vent	PCS	15704	4711.2	20415.2	81000.000000000000	170.126666666667	120.000000000000	45.000000000000	476.115835260002	-356.115835260002	476.115835260002	-356.115835260002
RMSPR025	SPRING PACKAGING 75X54X10	PCS	393	117.9	510.9	1130.000000000000	4.2575	120.000000000000	14.000000000000	265.413975337639	-145.413975337639	265.413975337639	-145.413975337639
RMSPR026	SPRING PACKAGING 75X72X10	PCS	1090	327	1417	4970.000000000000	11.8083333333333	120.000000000000	14.000000000000	420.889202540579	-300.889202540579	420.889202540579	-300.889202540579
RMSPR027	SPRING PACKAGING 75X84X10	PCS	251	75.3	326.3	2110.000000000000	2.71916666666667	120.000000000000	14.000000000000	775.973030953111	-655.973030953111	775.973030953111	-655.973030953111
RMSPR028	SPRING MATTRESS CORNER PROTECTOR	PCS	6744	2023.2	8767.2	10256.000000000000	73.06	120.000000000000	21.000000000000	140.377771694498	-20.3777716944977	140.377771694498	-20.3777716944977
RMSPR051	LOW MELT FIBER DENIER 4, LENGTH 51 MM	MT	960.609948797355	288.182984639207	1248.79293343656	10995.000000000000	10.406607778638	120.000000000000	30.000000000000	1056.54025152844	-936.540251528437	1056.54025152844	-936.540251528437
RMTAP004	ZIP	PCS	2885	865.5	3750.5	27532.000000000000	31.2541666666667	120.000000000000	15.000000000000	880.906545793894	-760.906545793894	880.906545793894	-760.906545793894
RMTAP007	MONDEO SPRING TAPING EDGE	MTR	57445.31	17233.593	74678.903	215000.000000000000	622.324191666667	120.000000000000	135.000000000000	345.479097356318	-225.479097356318	345.479097356318	-225.479097356318
RMTAP008	MONDEO BORDER TAPE	MTR	14901.71	4470.513	19372.223	81000.000000000000	161.435191666667	120.000000000000	135.000000000000	501.749334601403	-381.749334601403	501.749334601403	-381.749334601403
RMTAP009	FLORA PREMIER TAPING EDGE	MTR	48457.924144	14537.3772432	62995.3013872	306370.000000000000	524.960844893333	120.000000000000	4.000000000000	583.605430729317	-463.605430729317	583.605430729317	-463.605430729317
RMTAP010	WELL BEING TAPING EDGE	MTR	184112.52903	55233.758709	239346.287739	525034.000000000000	1994.552397825	120.000000000000	4.000000000000	263.233997047425	-143.233997047425	263.233997047425	-143.233997047425
RMTAP011	PILLOW TOP ROYAL TAPING EDGE	MTR	14763.12671	4428.938013	19192.064723	81000.000000000000	159.933872691667	120.000000000000	135.000000000000	506.459317446519	-386.459317446519	506.459317446519	-386.459317446519
RMTXT-002	Flora Textile 80" (m)NEW	SQM	4362.4	1308.72	5671.12	11165.000000000000	47.2593333333333	120.000000000000	15.000000000000	236.249629702775	-116.249629702775	236.249629702775	-116.249629702775
RMTXT-011	Screen Material Textile 80" m	SQM	227596.573762554	68278.9721287661	295875.54589132	680775.190000000000	2465.62954909433	120.000000000000	14.000000000000	276.106031520453	-156.106031520453	276.106031520453	-156.106031520453
RMTXT-015	Koko Mattress Textile 80"	SQM	106148.13680885	31844.441042655	137992.577851505	567698.670000000000	1149.93814876254	120.000000000000	135.000000000000	493.677569190052	-373.677569190052	493.677569190052	-373.677569190052
RMTXT-019	Comfy Textile 80"	SQM	374488.37628169	112346.512884507	486834.889166197	662177.800000000000	4056.95740971831	120.000000000000	135.000000000000	163.220298643948	-43.220298643948	163.220298643948	-43.220298643948
RMTXT-041	Classic Foam Pillow Textile	SQM	11048.4	3314.52	14362.92	148266.790000000000	119.691	120.000000000000	30.000000000000	1238.74635519797	-1118.74635519797	1238.74635519797	-1118.74635519797
RMTXT-042	Comfy Pillow Textile	SQM	36559.16	10967.748	47526.908	554991.250000000000	396.057566666667	120.000000000000	30.000000000000	1401.28934960381	-1281.28934960381	1401.28934960381	-1281.28934960381
RMTXT-043	FLORA DESIGN 2 TEXTILE	SQM	426476.624027522	127942.987208257	554419.611235779	1519546.960000000000	4620.16342696482	120.000000000000	135.000000000000	328.894634144631	-208.894634144631	328.894634144631	-208.894634144631
RMTXT-044	COTTON FIBRE TEXTILE 80"	SQM	72023.21347	21606.964041	93630.177511	435774.700000000000	780.251479258333	120.000000000000	135.000000000000	558.505445467691	-438.505445467691	558.505445467691	-438.505445467691
RMTXT-045	PAMA TEXTILE	SQM	26072.9020755	7821.87062265	33894.77269815	36707.430000000000	282.45643915125	120.000000000000	135.000000000000	129.957844509765	-9.95784450976481	129.957844509765	-9.95784450976481
RMTXT-046	DAMASK BORDER (REGAL)	SQM	7004.4198945	2101.32596835	9105.74586285	47450.160000000000	75.88121552375	120.000000000000	135.000000000000	625.32155913012	-505.32155913012	625.32155913012	-505.32155913012
RMTXT-047	DAMASK REGINA	SQM	78610.224	23583.0672	102193.2912	283892.580000000000	851.61076	120.000000000000	135.000000000000	333.359550318505	-213.359550318505	333.359550318505	-213.359550318505
RMTXT-048	FLORA PREMIER TEXTILE	SQM	31126.5043570315	9337.95130710945	40464.455664141	239154.980000000000	337.203797201175	120.000000000000	135.000000000000	709.229795112067	-589.229795112067	709.229795112067	-589.229795112067
RMTXT-049	Pillow Top Royal Panel Textile	SQM	1223.1133425	366.93400275	1590.04734525	13026.540000000000	13.25039454375	120.000000000000	135.000000000000	983.105820508901	-863.105820508901	983.105820508901	-863.105820508901
RMTXT-050	Pillow Top Royal Border Textile	SQM	1216.7472555	365.02417665	1581.77143215	8574.570000000000	13.18142860125	120.000000000000	135.000000000000	650.503845932668	-530.503845932668	650.503845932668	-530.503845932668
RMTXT-052	Mondeo Spring Damask	SQM	18280.6995	5484.20985	23764.90935	188534.830000000000	198.04091125	120.000000000000	21.000000000000	951.999406637754	-831.999406637754	951.999406637754	-831.999406637754
RMTXT-055	KOKO TEXTILE (AREWA)	SQM	51547.60156	15464.280468	67011.882028	530794.660000000000	558.432350233333	120.000000000000	135.000000000000	950.508436300681	-830.508436300681	950.508436300681	-830.508436300681
RMTXT-059	Legend Plus textile (LDPE)	SQM	17164.48	5149.344	22313.824	116303.850000000000	185.948533333333	120.000000000000	30.000000000000	625.462583195063	-505.462583195063	625.462583195063	-505.462583195063

itemno

Description

uom

MRequiredPerSupplyPlan

Buffer & Specials 30%

TotalMaterialRequiredPerSupplyPlan

ConsolidatedStockBalance

MrpPerDay

TargetedCoverDays

LeadTime

CoverDaysWithoutGIT

OutstandingDaysToCoverWithoutGIT

GIT

CoverDaysWithGIT

OutstandingDays

RMBIO001

BIOCRYSTAL MIXTURE 0,1-0,4mm

20.58

6.174

26.754

464.500000000000

0.22295

120.000000000000

30.000000000000

2083.42677730433

-1963.42677730433

0.000000000000

2083.42677730433

-1963.42677730433

RMBIOZIPLOCK

Bio Pillow zip-lock nylon

PCS

980

294

1274

8510.000000000000

10.6166666666667

120.000000000000

30.000000000000

801.569858712716

-681.569858712716

0.000000000000

801.569858712716

-681.569858712716

RMBLKINST

BULK PILLOW INSERT

PCS

6452

1935.6

8387.6

33599.000000000000

69.8966666666667

120.000000000000

7.000000000000

480.695312127426

-360.695312127426

0.000000000000

480.695312127426

-360.695312127426

RMCH016

RS NYLON 56CM 26kg/roll

7982.59327054634

2394.7779811639

10377.3712517102

15513.210000000000

86.478093764252

120.000000000000

21.000000000000

179.388898676358

-59.3888986763581

0.000000000000

179.388898676358

-59.3888986763581

RMCH024

DOP 200KG

2022.62656118093

606.787968354279

2629.41452953521

3600.000000000000

21.9117877461267

120.000000000000

21.000000000000

164.295129256916

-44.2951292569159

0.000000000000

164.295129256916

-44.2951292569159

RMCH028

GLYCERIN 250KG

957.58008203

287.274024609

1244.854106639

8185.000000000000

10.3737842219917

120.000000000000

30.000000000000

789.008121322632

-669.008121322632

0.000000000000

789.008121322632

-669.008121322632

RMCH039

VISCO SYSTEM POLYOL ACE-550

10265.312350698

3079.5937052094

13344.9060559074

16660.000000000000

111.207550465895

120.000000000000

30.000000000000

149.809971806809

-29.8099718068088

0.000000000000

149.809971806809

-29.8099718068088

RMCH051

Wrapping NYLON 80-85 gsm

11233.30491344

3369.991474032

14603.296387472

158809.000000000000

121.694136562267

120.000000000000

30.000000000000

1304.98481263099

-1184.98481263099

0.000000000000

1304.98481263099

-1184.98481263099

RMCH052

Conventional polyol

3352.577244

1005.7731732

4358.3504172

5300.000000000000

36.31958681

120.000000000000

30.000000000000

145.926770250061

-25.9267702500605

0.000000000000

145.926770250061

-25.9267702500605

RMCH056

Poudre Talc Industrial

37.8490151

11.35470453

49.20371963

1275.000000000000

0.410030996916667

120.000000000000

30.000000000000

3109.52101082038

-2989.52101082038

0.000000000000

3109.52101082038

-2989.52101082038

RMCRHND

PILLOW TOP ROYAL CARRIER HANDLE

PCS

1108

332.4

1440.4

17000.000000000000

12.0033333333333

120.000000000000

135.000000000000

1416.27325742849

-1296.27325742849

0.000000000000

1416.27325742849

-1296.27325742849

RMLBFLPR

FLORA PREMIER LABEL

PCS

3189

956.7

4145.7

9936.000000000000

34.5475

120.000000000000

14.000000000000

287.60402344598

-167.60402344598

0.000000000000

287.60402344598

-167.60402344598

RMLBLKK

KOKO LABEL

PCS

14977

4493.1

19470.1

72130.000000000000

162.250833333333

120.000000000000

14.000000000000

444.55857956559

-324.55857956559

0.000000000000

444.55857956559

-324.55857956559

RMLBLLG

LEGEND PLUS LABEL (LDPE)

PCS

2004

601.2

2605.2

3114.000000000000

21.71

120.000000000000

15.000000000000

143.436204514049

-23.4362045140489

0.000000000000

143.436204514049

-23.4362045140489

RMLBLSFL

SUPER FLORA LABEL

PCS

4603

1380.9

5983.9

82064.000000000000

49.8658333333333

120.000000000000

14.000000000000

1645.69595080132

-1525.69595080132

0.000000000000

1645.69595080132

-1525.69595080132

RMLBPTR

PILLOW TOP ROYAL LABEL

PCS

277

83.1

360.1

50350.000000000000

3.00083333333333

120.000000000000

30.000000000000

16778.672590947

-16658.672590947

0.000000000000

16778.672590947

-16658.672590947

RMLBPTR2

PILLOW TOP ROYAL INFO LABEL

PCS

277

83.1

360.1

2400.000000000000

3.00083333333333

120.000000000000

21.000000000000

799.777839489031

-679.777839489031

0.000000000000

799.777839489031

-679.777839489031

RMLBWB

WELL BEING LABEL

PCS

11754

3526.2

15280.2

56255.000000000000

127.335

120.000000000000

14.000000000000

441.78741115954

-321.78741115954

0.000000000000

441.78741115954

-321.78741115954

RMNLN015

Classic Foam Pillow Nylon

PCS

13640

4092

17732

21774.000000000000

147.766666666667

120.000000000000

30.000000000000

147.353936386194

-27.3539363861944

0.000000000000

147.353936386194

-27.3539363861944

RMNLN016

Comfy Pillow Nylon

PCS

7320

2196

9516

37654.000000000000

79.3

120.000000000000

30.000000000000

474.829760403531

-354.829760403531

0.000000000000

474.829760403531

-354.829760403531

RMNLN017

PILLOW BULK PACK NYLON

PCS

6452

1935.6

8387.6

11025.000000000000

69.8966666666667

120.000000000000

14.000000000000

157.732843721684

-37.7328437216844

0.000000000000

157.732843721684

-37.7328437216844

RMNLN023

Koko Pillow Nylon

PCS

41970

12591

54561

84418.000000000000

454.675

120.000000000000

30.000000000000

185.666684994776

-65.6666849947765

0.000000000000

185.666684994776

-65.6666849947765

RMNLN054

Bio Pillow Nylon

PCS

980

294

1274

23378.000000000000

10.6166666666667

120.000000000000

30.000000000000

2202.00941915228

-2082.00941915228

0.000000000000

2202.00941915228

-2082.00941915228

RMNLN055

Cozy pillow Nylon

PCS

3600

1080

4680

9046.000000000000

120.000000000000

30.000000000000

231.948717948718

-111.948717948718

0.000000000000

231.948717948718

-111.948717948718

RMNLN056

Cutie Pillow Nylon

PCS

2840

852

3692

10577.000000000000

30.7666666666667

120.000000000000

30.000000000000

343.781148429036

-223.781148429036

0.000000000000

343.781148429036

-223.781148429036

RMSPR008

SPRING SUPPORT

PCS

14948

4484.4

19432.4

60500.000000000000

161.936666666667

120.000000000000

135.000000000000

373.602848850374

-253.602848850374

0.000000000000

373.602848850374

-253.602848850374

RMSPR009

HALTCO CLIPS

PCS

387620

116286

503906

550000.000000000000

4199.21666666667

120.000000000000

45.000000000000

130.976809166789

-10.9768091667891

0.000000000000

130.976809166789

-10.9768091667891

RMSPR010

FLEX-C-RING CLIP

PCS

204371.74873

61311.524619

265683.273349

2054000.000000000000

2214.02727790833

120.000000000000

45.000000000000

927.721180535988

-807.721180535988

0.000000000000

927.721180535988

-807.721180535988

RMSPR022

HELLICO WIRE 1.3mm

3810.08

1143.024

4953.104

9891.800000000000

41.2758666666667

120.000000000000

135.000000000000

239.650934040553

-119.650934040553

0.000000000000

239.650934040553

-119.650934040553

RMSPR023

Air Vent

PCS

15704

4711.2

20415.2

81000.000000000000

170.126666666667

120.000000000000

45.000000000000

476.115835260002

-356.115835260002

0.000000000000

476.115835260002

-356.115835260002

RMSPR025

SPRING PACKAGING 75X54X10

PCS

393

117.9

510.9

1130.000000000000

4.2575

120.000000000000

14.000000000000

265.413975337639

-145.413975337639

0.000000000000

265.413975337639

-145.413975337639

RMSPR026

SPRING PACKAGING 75X72X10

PCS

1090

327

1417

4970.000000000000

11.8083333333333

120.000000000000

14.000000000000

420.889202540579

-300.889202540579

0.000000000000

420.889202540579

-300.889202540579

RMSPR027

SPRING PACKAGING 75X84X10

PCS

251

75.3

326.3

2110.000000000000

2.71916666666667

120.000000000000

14.000000000000

775.973030953111

-655.973030953111

0.000000000000

775.973030953111

-655.973030953111

RMSPR028

SPRING MATTRESS CORNER PROTECTOR

PCS

6744

2023.2

8767.2

10256.000000000000

73.06

120.000000000000

21.000000000000

140.377771694498

-20.3777716944977

0.000000000000

140.377771694498

-20.3777716944977

RMSPR051

LOW MELT FIBER DENIER 4, LENGTH 51 MM

960.609948797355

288.182984639207

1248.79293343656

10995.000000000000

10.406607778638

120.000000000000

30.000000000000

1056.54025152844

-936.540251528437

0.000000000000

1056.54025152844

-936.540251528437

RMTAP004

ZIP

PCS

2885

865.5

3750.5

27532.000000000000

31.2541666666667

120.000000000000

15.000000000000

880.906545793894

-760.906545793894

0.000000000000

880.906545793894

-760.906545793894

RMTAP007

MONDEO SPRING TAPING EDGE

MTR

57445.31

17233.593

74678.903

215000.000000000000

622.324191666667

120.000000000000

135.000000000000

345.479097356318

-225.479097356318

0.000000000000

345.479097356318

-225.479097356318

RMTAP008

MONDEO BORDER TAPE

MTR

14901.71

4470.513

19372.223

81000.000000000000

161.435191666667

120.000000000000

135.000000000000

501.749334601403

-381.749334601403

0.000000000000

501.749334601403

-381.749334601403

RMTAP009

FLORA PREMIER TAPING EDGE

MTR

48457.924144

14537.3772432

62995.3013872

306370.000000000000

524.960844893333

120.000000000000

4.000000000000

583.605430729317

-463.605430729317

0.000000000000

583.605430729317

-463.605430729317

RMTAP010

WELL BEING TAPING EDGE

MTR

184112.52903

55233.758709

239346.287739

525034.000000000000

1994.552397825

120.000000000000

4.000000000000

263.233997047425

-143.233997047425

0.000000000000

263.233997047425

-143.233997047425

RMTAP011

PILLOW TOP ROYAL TAPING EDGE

MTR

14763.12671

4428.938013

19192.064723

81000.000000000000

159.933872691667

120.000000000000

135.000000000000

506.459317446519

-386.459317446519

0.000000000000

506.459317446519

-386.459317446519

RMTXT-002

Flora Textile 80" (m)NEW

SQM

4362.4

1308.72

5671.12

11165.000000000000

47.2593333333333

120.000000000000

15.000000000000

236.249629702775

-116.249629702775

0.000000000000

236.249629702775

-116.249629702775

RMTXT-011

Screen Material Textile 80" m

SQM

227596.573762554

68278.9721287661

295875.54589132

680775.190000000000

2465.62954909433

120.000000000000

14.000000000000

276.106031520453

-156.106031520453

0.000000000000

276.106031520453

-156.106031520453

RMTXT-015

Koko Mattress Textile 80"

SQM

106148.13680885

31844.441042655

137992.577851505

567698.670000000000

1149.93814876254

120.000000000000

135.000000000000

493.677569190052

-373.677569190052

0.000000000000

493.677569190052

-373.677569190052

RMTXT-019

Comfy Textile 80"

SQM

374488.37628169

112346.512884507

486834.889166197

662177.800000000000

4056.95740971831

120.000000000000

135.000000000000

163.220298643948

-43.220298643948

0.000000000000

163.220298643948

-43.220298643948

RMTXT-041

Classic Foam Pillow Textile

SQM

11048.4

3314.52

14362.92

148266.790000000000

119.691

120.000000000000

30.000000000000

1238.74635519797

-1118.74635519797

0.000000000000

1238.74635519797

-1118.74635519797

RMTXT-042

Comfy Pillow Textile

SQM

36559.16

10967.748

47526.908

554991.250000000000

396.057566666667

120.000000000000

30.000000000000

1401.28934960381

-1281.28934960381

0.000000000000

1401.28934960381

-1281.28934960381

RMTXT-043

FLORA DESIGN 2 TEXTILE

SQM

426476.624027522

127942.987208257

554419.611235779

1519546.960000000000

4620.16342696482

120.000000000000

135.000000000000

328.894634144631

-208.894634144631

0.000000000000

328.894634144631

-208.894634144631

RMTXT-044

COTTON FIBRE TEXTILE 80"

SQM

72023.21347

21606.964041

93630.177511

435774.700000000000

780.251479258333

120.000000000000

135.000000000000

558.505445467691

-438.505445467691

0.000000000000

558.505445467691

-438.505445467691

RMTXT-045

PAMA TEXTILE

SQM

26072.9020755

7821.87062265

33894.77269815

36707.430000000000

282.45643915125

120.000000000000

135.000000000000

129.957844509765

-9.95784450976481

0.000000000000

129.957844509765

-9.95784450976481

RMTXT-046

DAMASK BORDER (REGAL)

SQM

7004.4198945

2101.32596835

9105.74586285

47450.160000000000

75.88121552375

120.000000000000

135.000000000000

625.32155913012

-505.32155913012

0.000000000000

625.32155913012

-505.32155913012

RMTXT-047

DAMASK REGINA

SQM

78610.224

23583.0672

102193.2912

283892.580000000000

851.61076

120.000000000000

135.000000000000

333.359550318505

-213.359550318505

0.000000000000

333.359550318505

-213.359550318505

RMTXT-048

FLORA PREMIER TEXTILE

SQM

31126.5043570315

9337.95130710945

40464.455664141

239154.980000000000

337.203797201175

120.000000000000

135.000000000000

709.229795112067

-589.229795112067

0.000000000000

709.229795112067

-589.229795112067

RMTXT-049

Pillow Top Royal Panel Textile

SQM

1223.1133425

366.93400275

1590.04734525

13026.540000000000

13.25039454375

120.000000000000

135.000000000000

983.105820508901

-863.105820508901

0.000000000000

983.105820508901

-863.105820508901

RMTXT-050

Pillow Top Royal Border Textile

SQM

1216.7472555

365.02417665

1581.77143215

8574.570000000000

13.18142860125

120.000000000000

135.000000000000

650.503845932668

-530.503845932668

0.000000000000

650.503845932668

-530.503845932668

RMTXT-052

Mondeo Spring Damask

SQM

18280.6995

5484.20985

23764.90935

188534.830000000000

198.04091125

120.000000000000

21.000000000000

951.999406637754

-831.999406637754

0.000000000000

951.999406637754

-831.999406637754

RMTXT-055

KOKO TEXTILE (AREWA)

SQM

51547.60156

15464.280468

67011.882028

530794.660000000000

558.432350233333

120.000000000000

135.000000000000

950.508436300681

-830.508436300681

0.000000000000

950.508436300681

-830.508436300681

RMTXT-059

Legend Plus textile (LDPE)

SQM

17164.48

5149.344

22313.824

116303.850000000000

185.948533333333

120.000000000000

30.000000000000

625.462583195063

-505.462583195063

0.000000000000

625.462583195063

-505.462583195063

itemno	Description	uom	MRequiredPerSupplyPlan	Buffer & Specials 30%	TotalMaterialRequiredPerSupplyPlan	ConsolidatedStockBalance	MrpPerDay	TargetedCoverDays	LeadTime	CoverDaysWithoutGIT	OutstandingDaysToCoverWithoutGIT	CoverDaysWithGIT	OutstandingDays
CRUMB	CRUMB	KG	111536.058676527	33460.8176029581	144996.876279485	10572.720000000000	1208.30730232904	120.000000000000	30.000000000000	8.7500257423098	111.24997425769	8.7500257423098	111.24997425769
FCRUMB	FIBRE CRUMB	KG	75630	22689	98319	11152.910000000000	819.325	120.000000000000	4.000000000000	13.612315015409	106.387684984591	13.612315015409	106.387684984591
RMCH003	MC 260KG	MT	63340.7097721606	19002.2129316482	82342.9227038088	15229.330000000000	686.19102253174	120.000000000000	135.000000000000	22.1940093937845	97.8059906062155	22.1940093937845	97.8059906062155
RMCH011	Calcium Carbonate CaCO3 50KG	KG	250666.36871194	75199.9106135819	325866.279325521	42888.350000000000	2715.55232771268	120.000000000000	7.000000000000	15.7936010152767	104.206398984723	15.7936010152767	104.206398984723
RMCH012G	PIGMENTS	KG	6478.37312942495	1943.51193882748	8421.88506825243	2090.540000000000	70.1823755687703	120.000000000000	135.000000000000	29.7872504750359	90.2127495249641	29.7872504750359	90.2127495249641
RMCH021	Wraping NYLON 240 CM 104KG	KG	114366.07034354	34309.821103062	148675.891446602	0.000000000000	1238.96576205502	120.000000000000	21.000000000000	0	120	0	120
RMCH026	VORAMER ISO CYANITE 230KG	MT	30263.1085219706	9078.93255659117	39342.0410785617	6990.000000000000	327.850342321348	120.000000000000	135.000000000000	21.3207036799389	98.6792963200611	21.3207036799389	98.6792963200611
RMCH053	LDPE RESIN	MT	33102.74860646	9930.824581938	43033.573188398	25.000000000000	358.613109903317	120.000000000000	30.000000000000	0.0697130119050586	119.930286988095	0.0697130119050586	119.930286988095
RMFB001	DRY SOLID FIBRE CONTENT	KG	18251.5890271497	5475.47670814492	23727.0657352947	4864.000000000000	197.725547794122	120.000000000000	30.000000000000	24.5997548332224	95.4002451667776	24.5997548332224	95.4002451667776
RMGUM005	Simalfa 3031 white adhesive gum	KG	1558.1011	467.43033	2025.53143	0.000000000000	16.8794285833333	120.000000000000	135.000000000000	0	120	0	120
RMLBLZP	Zippy Label	PCS	9794	2938.2	12732.2	879.000000000000	106.101666666667	120.000000000000	14.000000000000	8.28450699800506	111.715493001995	8.28450699800506	111.715493001995
RMSPR001	FIBRE FELT	MTR	14574.41912	4372.325736	18946.744856	0.000000000000	157.889540466667	120.000000000000	21.000000000000	0	120	0	120
RMSPR034	FRAME WIRE 3.7MM	KG	1906.67	572.001	2478.671	0.000000000000	20.6555916666667	120.000000000000	135.000000000000	0	120	0	120

itemno

Description

uom

MRequiredPerSupplyPlan

Buffer & Specials 30%

TotalMaterialRequiredPerSupplyPlan

ConsolidatedStockBalance

MrpPerDay

TargetedCoverDays

LeadTime

CoverDaysWithoutGIT

OutstandingDaysToCoverWithoutGIT

GIT

CoverDaysWithGIT

OutstandingDays

CRUMB

111536.058676527

33460.8176029581

144996.876279485

10572.720000000000

1208.30730232904

120.000000000000

30.000000000000

8.7500257423098

111.24997425769

0.000000000000

8.7500257423098

111.24997425769

FCRUMB

FIBRE CRUMB

75630

22689

98319

11152.910000000000

819.325

120.000000000000

4.000000000000

13.612315015409

106.387684984591

0.000000000000

13.612315015409

106.387684984591

RMCH003

MC 260KG

63340.7097721606

19002.2129316482

82342.9227038088

15229.330000000000

686.19102253174

120.000000000000

135.000000000000

22.1940093937845

97.8059906062155

0.000000000000

22.1940093937845

97.8059906062155

RMCH011

Calcium Carbonate CaCO3 50KG

250666.36871194

75199.9106135819

325866.279325521

42888.350000000000

2715.55232771268

120.000000000000

7.000000000000

15.7936010152767

104.206398984723

0.000000000000

15.7936010152767

104.206398984723

RMCH012G

PIGMENTS

6478.37312942495

1943.51193882748

8421.88506825243

2090.540000000000

70.1823755687703

120.000000000000

135.000000000000

29.7872504750359

90.2127495249641

0.000000000000

29.7872504750359

90.2127495249641

RMCH021

Wraping NYLON 240 CM 104KG

114366.07034354

34309.821103062

148675.891446602

0.000000000000

1238.96576205502

120.000000000000

21.000000000000

120

0.000000000000

120

RMCH026

VORAMER ISO CYANITE 230KG

30263.1085219706

9078.93255659117

39342.0410785617

6990.000000000000

327.850342321348

120.000000000000

135.000000000000

21.3207036799389

98.6792963200611

0.000000000000

21.3207036799389

98.6792963200611

RMCH053

LDPE RESIN

33102.74860646

9930.824581938

43033.573188398

25.000000000000

358.613109903317

120.000000000000

30.000000000000

0.0697130119050586

119.930286988095

0.000000000000

0.0697130119050586

119.930286988095

RMFB001

DRY SOLID FIBRE CONTENT

18251.5890271497

5475.47670814492

23727.0657352947

4864.000000000000

197.725547794122

120.000000000000

30.000000000000

24.5997548332224

95.4002451667776

0.000000000000

24.5997548332224

95.4002451667776

RMGUM005

Simalfa 3031 white adhesive gum

1558.1011

467.43033

2025.53143

0.000000000000

16.8794285833333

120.000000000000

135.000000000000

120

0.000000000000

120

RMLBLZP

Zippy Label

PCS

9794

2938.2

12732.2

879.000000000000

106.101666666667

120.000000000000

14.000000000000

8.28450699800506

111.715493001995

0.000000000000

8.28450699800506

111.715493001995

RMSPR001

FIBRE FELT

MTR

14574.41912

4372.325736

18946.744856

0.000000000000

157.889540466667

120.000000000000

21.000000000000

120

0.000000000000

120

RMSPR034

FRAME WIRE 3.7MM

1906.67

572.001

2478.671

0.000000000000

20.6555916666667

120.000000000000

135.000000000000

120

0.000000000000

120

LAGOS PLANT	BENIN PLANT	KADUNA PLANT	Central_Plant	BN_TXTCUT	BN_TXTWIP	IKTXT	KD_TXTCUT
KD_TXTWIP	TXTCUT	TXTWIP	BN_TAPEEDG	KD_TAPEEDG	PILLOWSECT	BN_PILLOWSG	KD_PILLOWS
_x2060_ANPLWPROD	ANUSHARM	TAPE_EDGE	BLKPROD	BN_BLKPROD	KD_BLKPROD

📊 Material Planning Report Generation

Emergency 0

Fair Attention 0

Okay 0

Over Stocked 0

Filter Options

Report Table

Emergency
0

Fair Attention
0

Okay
0

Over Stocked
0