M4 shows the Maximum Stock Level. In N15:N20 calculate how many part codes are over-stocked for each supplier, remember that the value in M4 can change.

please help, what is the excel formula in N15:N20?

N15 4 x fx A B G H M N Inventory Inventory Management Reordeni Reorder In Stock On Backord 31 Min Slock Level Max Slock Level Reorder At Raorder Due 20 40 22 17 0 40 17 14 Price Bracket Re-order Amount 0 25 50 20 100 15 200 10 On Backorder Over-Stocked Category Accessories and luring Groupe When Wheets Contact Points Groot Access and tuning Whecta Wheels Accessories and tuning Contact Points Frameset Framese Frames Frameset Contact Paints Framese Contact Points Framese Groupant Groupset Groupat Groups Contact Paints Accessorturing Contact Points Contact Points 0 30 22 41 1 16 17 4 9 22 Supplier Cyce Warehouse Nashbar Performance Bikes Plus Backcountry LBS 24 18 Supplier Cycle Warchose Cycle Warehouse Dydie Waren Dycle Warehouse Cycle Whouse Nashbar Cycle Warehouse Performance Performance Dycle Warehouse Cycle Warehouse Bikes Pus Bikes Pus Bikes Pus Cycle Warehouse Dycle Warehouse Cycle Warehouse Nashbar Nashbar Nashbar Nasher Nachbar Nashbar Dycle Warehouse Nashbar Bhes Pus Cycle Warehouse Dycle Warehouse Cycle Warehouse Backcountry Nashbar Nashar Nashbar Nachbar Nasher Backcountry Cycle Warehouse LBS Cycle Warehouse Bikes Plus Cycle Warehouse 12 18 13 0 15 3 Part CodProdud Description 4 AC1945 Aloy CR Bots 5 GR1751 CNC brakes 200g Brakes 6 WH2778 CNC V16 Super Gp Wheels 7 WH1250 CNC V18 Ultra Wheels 8 CO2901 Qustom Bar Plus De 9 OR1215 Dura Ace Chen 10 AC1500 Fairing M5 Bots 11 WHERE Forte LOR Tyres 12 WH1573 Forte Light Tubes 13 AG2054 Generic FD Master Adaptor 14 CO1469 Generic Foam Tape Tape 15 FR1934 Headset 16 FR1235 J&L Fork 17 FR230 J&L Plug 18 FR1080 J&L Top Cap & Screw 19 CO 1649 KCNC Scandum Seatpost 20 FR1081 Mr. Pode Sest Camp 21 CO1098 Nashbar Carton Bar 22 FR1323 Nasher Carbon Frame 23 GR218 Nashbar Cassette 24 GR1988 Nashar FD 25 GR1432 Nashbar Lovers 26 GR1770 Nashbar RD 27 C022957 RockBros CMOS 28 AC1914 RockBros S60 Pecals 29 CO2143 Spacers 30 Co 1688 Specialised cam Tape Tape 31 WH2342 Thanum OR Skewers 32 AC2733 Titanium Stem Bolts 33 GR1406 Llegra BB 34 GR1550 Utegra Cates 35 GR1838 Libegru Castle 36 GR2000 Utegra Cranks 37 GR1172 Llegra FD 38 GR2589 Utegra Lovers 39 GR1322 Llegra RD 40 Co26 Uno 7050 Stem 41 WH2373 Velaska Rim tape 42 WH1100 XR-270/Biex When 43 AC1919 Bikes Pls Deluxe Pedal 44 AC2174 Rockor Aloe ditet Pedals 45 C01104 Rockolder Carbon Bar 46 co 1650 Diamond Seatpost 47 CO 2200 BBC 5000 Sien 48 CO2361 Diamond Um Saddle 49 FR1092 Finn Cop & Scrow 50 FR1036 RockBros Seat Clamp 51 FR1240 Frille Fork 52 FR1324 RockBros Carbon Frame 53 FR17 FR4G37 Gig Handel 54 GR1171 Firma FD 55 GR1218 56 GR1325 Firma RD 57 GR1407 Firma RR 58 GR14 Rockor Leven 59 GR1554 Firma Condes 60 GR1753 Firma Brakes 61 GR1773 Rackgro RD 62 GR1040 Firma Cassette 63 GR1987 Rockgrp FD 64 GR2013 Firma Cars 65 GRAM Firma Lovers 66 GR2030 Rockor p Cassette 67 WH1200 Litrazen 5 Whal 68 WH15 Firma immer Tubes 69 WHO Litra Heck Tyres ! Price/UniWeight $2.21 0.3 356 10 $132.84 7781 $269.45 $0.71 22 $27.72 217.6 $0.45 0.6 S123 228.9 $17.73 381 $2.54 22.5 9014 06 $24.84 60.6 $160.16 314 $11.55 6 $319 76 $78.32 $ 180.1 315.55 8.5 S55.77 189 $103. 20 857 $34.06 1973 $27.24 23 $105.73 1988 $45.07 202.6 $20.45 $ 210.6 $21.50 131.6 $26.32 2.4 $0.16 0.5 $4.42 26.8 $8.96 6.7 $16.52 $ 51 $24.61 49.1 S49.05 176 $1244 6949 $25.35 91.7 393.92 216.8 $42.23 204.8 $14.00 $ 130.9 54.70 2 $114.06 595 $24.75 131.6 324.99 110.3 $67.37 189 306 15 180.1 $18.73 130.9 316.50 210.6 $4.01 7.8 $13.97 9.5 $167.20 $ 344 $131.42 857 $12.74 60.6 $29.20 91.2 $25.29 217.6 $41.50 2040 $16.CR 51 $130.68 199.8 $7.90 40.1 $58.01 S44.31 2008 $49.06 178 $35.80 $150.0 694.9 $84.04 216.8 $44.75 1972 $150.80 986 $86.41 $ $33.20 228.9 44 22 18 37 1 43 19 2 11 18 11 44 Accores and tuning Groupant Groupset Graupat Groupe Braupadi Groupe Groupant Contact Points Whecta Wheels Accessories and lure Accessories and tuning Contact Paints Contact Paints Contact Paints Contact Points Frames Frameset Frameset Frameset Frames Groupset Groupont Groupset Groupant Groupset Groupont Groupset Brauna Groupset Groupon Groupset Groupant Groupset 43 6 20 17 34 14 16 25 36 37 1 20 31 13 31 20 4 Magneto Chan Cytle Warehouse Dyce Warehouse Cycle Warehouse Dyce Wardhese Cycle Warehouse Bike Pus Nachbar Bikes Plus Nashbar Nashar Backcountry Backcountry Nasher Nachbar Cycle Warehouse Nashbar Nashbar Nashbar Nashbar Nasihar Nashbar Dyce Warehe Performance LBS 21 49 19 12 B 6 40 Wheels Wheat 18 28