Dashboard · Meridian Climate Systems

Inventory risk

Raw material stock by age and risk. Who owns each band, and which items to act on first. Stock at 31 October 2026.

Rebuilt with made-up data. The real dashboard is internal.

Plant
Risk

All plants · All material groups

17.1% of raw material value is high risk.

4.9 M sits in High or Very high, against a 15% ceiling. 4 risk items have no owner yet.

Stock value
29.0 M
High risk
4.9 M
Risk items
59

High-risk share

17.1%

+2.1 pts above the 15.0% target

4.9 M of 29.0 M in High or Very high

Risk items with an owner

93.2%

−1.8 pts below the 95.0% target

55 of 59 items at Watch or above

Stock over a year old

22.9%

+7.9 pts above the 15.0% target

6.6 M received over 365 days ago

Months of stock

3.3 mo

+0.3 mo above the 3.0 mo target

29.0 M stock, 8.8 M used a month

Stock value by age

M · tap an age to filter

Stock value by age, All plants: 0 to 90 days 8.6 M, 91 to 180 days 9.8 M, 181 to 365 days 4.0 M, 1 to 2 years 5.2 M, Over 2 years 1.4 M.

Risk bands and owners

Tap a band to filter
68%15%12%
Stock value by risk band, All plants · All material groups: Low 19.6 M, owner Stores; Watch 4.4 M, owner Stores; High 3.5 M, owner Buying; Very high 1.4 M, owner Product.

No use and over-cover

Tap a row to filter

No use in 12 months

6.1%

1.8 M of 29.0 M

Over-cover

26.2%

7.6 M with over 6 months of stock

Months of stock

3.3 mo

8.8 M used a month

By material group

Value against last use

Items by stock value (M) and months since last use, All plants · All material groups: 180 items, 13 with no use in 12 months worth 1.8 M. The table below lists the items to act on.

Each dot is one item, value in M. Top right is money sitting still.

Act first: items at Watch or above

59 items, 9.4 M. 4 with no owner. Largest first.
Raw material items at Watch risk or above, with their owner and next action
Next action
Inverter compressor 8 TRMCS-RM-17888 · Plant EastHigh0.60 M540 daysLast used 7 months agoCompressorsBuyingCancel open buys
Screw compressor 90 TRMCS-RM-19587 · Plant NorthHigh0.59 M653 daysLast used 9 months agoCompressorsBuyingOffer to the service team
Inverter compressor 8 TRMCS-RM-18131 · Plant NorthWatch0.56 M460 daysLast used 9 months agoCompressorsStoresUse on open orders first
EC fan 630 mmMCS-RM-11666 · Plant EastHigh0.54 M537 daysLast used 7 months agoMotors and fansBuyingReturn to supplier
Screw compressor 90 TRMCS-RM-12032 · Plant NorthWatch0.49 M466 daysLast used 1 month agoCompressorsStoresUse on open orders first
Screw compressor 90 TRMCS-RM-17319 · Plant NorthWatch0.47 M144 daysUsed this monthCompressorsStoresHold new buys
Fan motor 11 kWMCS-RM-13903 · Plant NorthVery high0.43 M878 daysNo use for 14 monthsMotors and fansProductWrite down
EC fan 630 mmMCS-RM-13902 · Plant SouthWatch0.41 M377 daysLast used 3 months agoMotors and fansStoresUse on open orders first
Copper tube 12.7 mmMCS-RM-10577 · Plant NorthVery high0.40 M1,126 daysNo use for 21 monthsCopper and coilsProductRework into a current model
Variable speed drive 7.5 kWMCS-RM-17001 · Plant EastHigh0.40 M254 daysLast used 3 months agoControlsBuyingOffer to the service team
Copper coil 6 rowMCS-RM-16597 · Plant EastWatch0.39 M328 daysLast used 1 month agoCopper and coilsStoresHold new buys
Pressure sensor 30 barMCS-RM-10080 · Plant NorthWatch0.37 M463 daysLast used 1 month agoControlsStoresUse on open orders first
Scroll compressor 15 TRMCS-RM-18928 · Plant SouthWatch0.32 M228 daysUsed this monthCompressorsNo owner yetAssign an owner
Screw compressor 60 TRMCS-RM-17708 · Plant EastWatch0.28 M312 daysLast used 2 months agoCompressorsNo owner yetAssign an owner
Screw compressor 60 TRMCS-RM-15173 · Plant SouthHigh0.25 M403 daysLast used 6 months agoCompressorsNo owner yetAssign an owner
Stainless drain panMCS-RM-12873 · Plant EastWatch0.25 M373 daysLast used 3 months agoSheet metalStoresUse on open orders first
Refrigerant charge kitMCS-RM-17730 · Plant NorthVery high0.22 M1,018 daysNo use for 33 monthsRefrigerantProductRework into a current model
Copper tube 9.5 mmMCS-RM-10582 · Plant EastHigh0.22 M529 daysLast used 8 months agoCopper and coilsBuyingReturn to supplier
Inverter compressor 8 TRMCS-RM-12594 · Plant EastHigh0.18 M703 daysNo use for 16 monthsCompressorsBuyingReturn to supplier
Ball valve DN50MCS-RM-13159 · Plant SouthVery high0.16 M1,049 daysNo use for 33 monthsValves and fittingsProductRework into a current model
Ball valve DN50MCS-RM-17695 · Plant NorthHigh0.14 M671 daysNo use for 12 monthsValves and fittingsNo owner yetAssign an owner
EC fan 630 mmMCS-RM-19259 · Plant NorthHigh0.13 M674 daysLast used 8 months agoMotors and fansBuyingCancel open buys
EC fan 630 mmMCS-RM-15191 · Plant SouthWatch0.12 M315 daysLast used 2 months agoMotors and fansStoresHold new buys
Galvanised sheet 0.9 mmMCS-RM-18669 · Plant NorthHigh0.12 M432 daysLast used 3 months agoSheet metalBuyingReturn to supplier
Expansion valve kitMCS-RM-14863 · Plant SouthWatch0.11 M232 daysLast used 3 months agoValves and fittingsStoresUse on open orders first
Copper tube 22.2 mmMCS-RM-18595 · Plant SouthWatch0.11 M15 daysUsed this monthCopper and coilsStoresUse on open orders first
Refrigerant charge kitMCS-RM-18604 · Plant SouthHigh0.10 M570 daysLast used 3 months agoRefrigerantBuyingOffer to the service team
Aluminium fin stock 0.11 mmMCS-RM-11514 · Plant SouthWatch0.09 M189 daysLast used 1 month agoSheet metalStoresUse on open orders first
Scroll compressor 10 TRMCS-RM-10172 · Plant NorthVery high0.09 M1,148 daysNo use for 33 monthsCompressorsProductRework into a current model
Stainless drain panMCS-RM-12061 · Plant NorthWatch0.07 M323 daysLast used 2 months agoSheet metalStoresHold new buys
Panel filter G4MCS-RM-19968 · Plant SouthWatch0.07 M336 daysLast used 3 months agoFiltersStoresHold new buys
Control board v3MCS-RM-11371 · Plant SouthHigh0.06 M694 daysLast used 11 months agoControlsBuyingOffer to the service team
Refrigerant charge kitMCS-RM-13468 · Plant NorthWatch0.05 M151 daysUsed this monthRefrigerantStoresUse on open orders first
Damper actuatorMCS-RM-10488 · Plant NorthWatch0.05 M320 daysLast used 2 months agoControlsStoresUse on open orders first
Damper actuatorMCS-RM-15494 · Plant SouthHigh0.04 M650 daysLast used 10 months agoControlsBuyingOffer to the service team
Fan motor 5.5 kWMCS-RM-14690 · Plant NorthVery high0.04 M988 daysNo use for 27 monthsMotors and fansProductSell at a discount
Scroll compressor 10 TRMCS-RM-10323 · Plant NorthWatch0.04 M131 daysLast used 1 month agoCompressorsStoresUse on open orders first
Service valve 16 mmMCS-RM-11614 · Plant SouthWatch0.03 M142 daysUsed this monthValves and fittingsStoresHold new buys
Copper elbow 15.9 mmMCS-RM-12666 · Plant SouthVery high0.03 M1,149 daysNo use for 19 monthsCopper and coilsProductRework into a current model
Pressure sensor 30 barMCS-RM-13285 · Plant EastHigh0.03 M608 daysNo use for 19 monthsControlsBuyingCancel open buys
Panel filter G4MCS-RM-10803 · Plant NorthHigh0.03 M308 daysLast used 11 months agoFiltersBuyingOffer to the service team
Panel filter G4MCS-RM-14038 · Plant EastWatch0.03 M285 daysLast used 3 months agoFiltersStoresUse on open orders first
Refrigerant R32 cylinderMCS-RM-16450 · Plant NorthWatch0.03 M137 daysUsed this monthRefrigerantStoresHold new buys
Fan motor 11 kWMCS-RM-14365 · Plant NorthHigh0.03 M653 daysLast used 8 months agoMotors and fansBuyingOffer to the service team
Fan motor 11 kWMCS-RM-17279 · Plant SouthHigh0.02 M429 daysLast used 8 months agoMotors and fansBuyingOffer to the service team
Foam panel 50 mmMCS-RM-14382 · Plant SouthHigh0.02 M660 daysLast used 7 months agoInsulationBuyingCancel open buys
Inverter compressor 8 TRMCS-RM-11404 · Plant NorthHigh0.02 M616 daysLast used 9 months agoCompressorsBuyingCancel open buys
Variable speed drive 7.5 kWMCS-RM-10928 · Plant NorthVery high0.02 M984 daysNo use for 31 monthsControlsProductSell at a discount
Variable speed drive 7.5 kWMCS-RM-16465 · Plant NorthHigh0.02 M423 daysUsed this monthControlsBuyingReturn to supplier
Insulation roll 25 mmMCS-RM-18934 · Plant SouthVery high0.02 M878 daysNo use for 22 monthsInsulationProductSell at a discount
Scroll compressor 25 TRMCS-RM-15825 · Plant SouthWatch0.02 M395 daysUsed this monthCompressorsStoresUse on open orders first
Centrifugal fan 315 mmMCS-RM-16348 · Plant NorthWatch0.02 M299 daysLast used 2 months agoMotors and fansStoresUse on open orders first
Screw compressor 60 TRMCS-RM-14735 · Plant NorthWatch0.02 M245 daysLast used 3 months agoCompressorsStoresHold new buys
Fan motor 11 kWMCS-RM-11947 · Plant SouthWatch0.01 M272 daysUsed this monthMotors and fansStoresUse on open orders first
Copper tube 9.5 mmMCS-RM-13104 · Plant NorthWatch0.01 M182 daysUsed this monthCopper and coilsStoresHold new buys
Insulation roll 25 mmMCS-RM-13617 · Plant SouthWatch0.01 M136 daysUsed this monthInsulationStoresHold new buys
Control board v3MCS-RM-13977 · Plant NorthVery high0.01 M1,089 daysNo use for 23 monthsControlsProductSell at a discount
Copper coil 4 rowMCS-RM-17021 · Plant EastWatch0.01 M448 daysLast used 3 months agoCopper and coilsStoresHold new buys
Centrifugal fan 315 mmMCS-RM-12813 · Plant SouthHigh0.01 M676 daysLast used 8 months agoMotors and fansBuyingReturn to supplier