Spreadsheet: 686595d1594705677-sum-product-bassed-on-a-month-criteria-test
Sheet: RAW Data

Part | Description | Type | Cost Per Part |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020
 |  |  |  | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
14280600 | 204*LHL KG  PRIMER GREY | 9999 BR204 KG DAIMLER |  | 20 | 20 | 20
66001197 | F01 LHL CA  DEEPSEA BLUE | BMW L6 DOOR SET
66001202 | F01 LHL CA  IMPERIAL BLU | BMW L6 DOOR SET
66001226 | F01 LHL CA  SOPHISTO GRE | BMW L6 DOOR SET
66001204 | F01 LHL CA  SPACE GREY | BMW L6 DOOR SET
66001241 | F01 LHN CA  ORION SILVER | BMW L6 DOOR SET
66001205 | F01 LHN CA  SOPHISTO GRE | BMW L6 DOOR SET
66001232 | F01 RHL CA  IMPERIAL BLU | BMW L6 DOOR SET
66001358 | F01 LHL CA  GLACIER SILV | BMW L6 DOOR SET
66001360 | F01 LHL CA  JATOBA MET. | BMW L6 DOOR SET
66001364 | F01 LHN CA  SPACE GREY | BMW L6 DOOR SET
66001373 | F01 LHN CA  TITAN SILVER | BMW L6 DOOR SET
66001198 | F01 RHL CA  SOPHISTO GRE | BMW L6 DOOR SET
66001199 | F01 RHN CA  GLACIER SILV | BMW L6 DOOR SET
66001201 | F01 RHN CA  IMPERIAL BLU | BMW L6 DOOR SET
66001224 | F01 RHN CA  SOPHISTO GRE | BMW L6 DOOR SET
66001203 | F01 RHN CA  SPACE GREY | BMW L6 DOOR SET
15093003 | BMW RAHMEN RHF | BMW SPARES E36 | 0
68970051 | 204=LHL     IRIDIUM SILV | BR204
68970031 | 204=LHL     OBSIDIAN BLK | BR204
14268320 | 204ALHL     DIAMANT SILV | BR204
67402893 | DAI*LH      PRIMER FOND | DAIMLER Cust. Huf D
15534230 | [NAME] 211 BRILLIANT SI | DAIMLER Cust. Huf D
15568610 | [NAME] 211 IRIDIUM SILV | DAIMLER Cust. Huf D
15534270 | [NAME] 211 OBSIDIAN BLK | DAIMLER Cust. Huf D
15602950 | [NAME] TAG PRIMER GREY | DAIMLER Cust. Huf D
60034962 | DAI*LHG     PRIMER GREY | DAIMLER Cust. Huf D
15533230 | DAI*LHG 211 BRILLIANT SI | DAIMLER Cust. Huf D
15533830 | DAI*LHG 211 CUBANITE SIL | DAIMLER Cust. Huf D
15573770 | DAI*LHG 211 FLINT GREY | DAIMLER Cust. Huf D
15573730 | DAI*LHG 211 IRIDIUM SILV | DAIMLER Cust. Huf D
15533270 | DAI*LHG 211 OBSIDIAN BLK | DAIMLER Cust. Huf D
15533470 | DAI*LHG 211 PRIMER GREY | DAIMLER Cust. Huf D
15533510 | DAI*LHG 211 TANSANITE BL | DAIMLER Cust. Huf D
15536130 | DAI*LHG 220 BLACK | DAIMLER Cust. Huf D
15536450 | DAI*LHG 220 BRILLIANT SI | DAIMLER Cust. Huf D
15536610 | DAI*LHG 220 OBSIDIAN BLK | DAIMLER Cust. Huf D
15535150 | DAI*LHG 220 PRIMER GREY | DAIMLER Cust. Huf D
14061811 | DAI*LHG 221 BLK MAGNETIT | DAIMLER Cust. Huf D
15681591 | DAI*LHG 221 CARNEOL RED | DAIMLER Cust. Huf D
15681431 | DAI*LHG 221 OBSIDIAN BLK | DAIMLER Cust. Huf D
67402894 | DAI*RH      PRIMER FOND | DAIMLER Cust. Huf D
60034963 | DAI*RHG     PRIMER GREY | DAIMLER Cust. Huf D
60034978 | DAI*RHG     PRIMER GREY | DAIMLER Cust. Huf D
15573750 | DAI*RHG 211 IRIDIUM SILV | DAIMLER Cust. Huf D
15533290 | DAI*RHG 211 OBSIDIAN BLK | DAIMLER Cust. Huf D
15533490 | DAI*RHG 211 PRIMER GREY | DAIMLER Cust. Huf D
15536630 | DAI*RHG 220 OBSIDIAN BLK | DAIMLER Cust. Huf D
15535170 | DAI*RHG 220 PRIMER GREY | DAIMLER Cust. Huf D
15681451 | DAI*RHG 221 OBSIDIAN BLK | DAIMLER Cust. Huf D
15685731 | DAI*RHG 221 PRIMER KG | DAIMLER Cust. Huf D
15322501 | DAI*RHG LUX PRIMER GREY | DAIMLER Cust. Huf D
15684530 | DAI*LH  221 OBSIDIAN BLK | DAIMLER Cust. Huf D
15536150 | DAI*RHG 220 BLACK | DAIMLER Cust. Huf D
15536470 | DAI*RHG 220 BRILLANT SIL | DAIMLER Cust. Huf D
32806300 | STRA205     BLACK | DAIMLER STAR
32806410 | STRA205     BRILLIANT BL | DAIMLER STAR
32806320 | STRA205     CAVANSIT BLU | DAIMLER STAR
32806400 | STRA205     DIAMOND W'TE | DAIMLER STAR
32806810 | STRA205     MB7831 GRAPH | DAIMLER STAR
32806310 | STRA205     OBSIDIAN BLK | DAIMLER STAR
32806350 | STRA205     POLAR WHITE | DAIMLER STAR
32806470 | STRA205     SELENIT GREY | DAIMLER STAR
32806500 | STRA292     BLACK | DAIMLER STAR
32806750 | STRAKIT 205 PRIMER GREY | DAIMLER STAR
15268501 | E46ALHG  -4 PRIMER BLACK | E46/4
15268100 | [NAME]  -4 PRIMER BLACK | E46/4
15268301 | E46PRHN  -4 PRIMER BLACK | E46/4
15718430 | E60ALHL CA  PRIMER.BLACK | E60 CA
14077640 | E89ALHL OVT ALPINE WHITE | E89
14077400 | E89ALHL     DEEP SEA BL | E89
14095460 | E89ALHL OCA ALPINE WHITE | [NAME]
14095520 | E89ALHL OCA BLK SAPPHIRE | [NAME]
14205210 | E89ALHL OCA ESTORILBLAU2 | [NAME]
14204680 | E89ALHL OCA MINERAL GREY | [NAME]
14204180 | E89ALHL OCA MINERALWHITE | [NAME]
14095290 | E89ARHN OCA ALPINE WHITE | [NAME]
14205220 | E89ARHL OCA ESTORILBLAU2 | [NAME]
29117000 | E90ALHG SSG PRIMER GREY | E90
67402235 | E8xALHG  CA MINERAL GREY | Huf D NON-CONDUCTIVE
67401554 | E8xALHG  CA TITAN SILVER | Huf D NON-CONDUCTIVE
14818201 | 405 LHL BRIGHT ATLAS | JLR CAP ATL
32806510 | STRA292     OBSIDIAN BLK | DAIMLER STAR
32806600 | STRA292     DIAMOND W'TE | DAIMLER STAR
15864971 | DAI*LHG 221 PALLADIUM SI | DAIMLER Cust. Huf D
14818501 | 405 N/L BRIGHT ATLAS | JLR CAP ATL
14818401 | 405 RHL BRIGHT ATLAS | JLR CAP ATL
14258501 | 405 LHL BRIGHT CHROME | JLR CAP BRI
14258701 | 405 RHL BRIGHT CHROME | JLR CAP BRI
13015101 | 405 LHL NARVIK BLACK | JLR CAP NAR
13015501 | 405 N/L NARVIK BLACK | JLR CAP NAR
13015201 | 405 LHL SHADOW ATLAS | JLR CAP SHA
13015701 | 405 N/L SHADOW ATLAS | JLR CAP SHA
13015401 | 405 RHL SHADOW ATLAS | JLR CAP SHA
14818301 | 405 COV BRIGHT ATLAS | JLR HANDLE COVER ATL
14538401 | 405 COV BRIGHT CHROME | JLR HANDLE COVER BRI
14469301 | 405 COV NARVIK BLACK | JLR HANDLE COVER NAR
14469401 | 405 COV SHADOW ATLAS | JLR HANDLE COVER SHA
15410902 | L30 FRT     BRUNEL | JLR L322 LOCKING CAP
15410903 | L30 FRT     OBERON | JLR L322 LOCKING CAP
15410604 | L30 RR      OBERON | JLR L322 NON-LOCK CAP
15447381 | L30PBWL     SANTORINI | [NAME]
15456212 | POR*GRP     BLACK LINE | PORSCHE Cust. Huf D
15484415 | VW *CAP LOC PRIMER GREY | VW Cust. Huf D
15484402 | VW *GRP VT  PRIMER SCH'E | VW Cust. Huf D
14040251 | AV ARHR     PRIMER GREY | W169 AVANTGARD CAP
14040172 | AV ARHG     PRIMER GREY | W169 AVANTGARD GRIP
14040162 | AV ALHG     PRIMER GREY | W169 AVANTGARD GRIP
32806670 | STRA292     SELENIT GREY | DAIMLER STAR
14095560 | E89ALHL OCA SPACE GREY | [NAME]
14040231 | EL ARHG     PRIMER GREY | W169 [NAME]
 |  |  |  | JUL
8235602 | VTB KEY HEAD HOUSING | VOLVO TRUCK & BUS | 0.47
68106001 | HUF MOULD+BLANK (DH KEY) | VOLVO TRUCK & BUS
8235710 | VTB KEY OVERMOULD | VOLVO TRUCK & BUS | 1.92
43023506 | BMW WINDOW ROLLER | BMW WINDOW LATCH
36204205 | COV     PLASTIC COVER | VOLVO TRUCK & BUS | 0.47
 |  |  |  |  |  |  |  |  |  |  |  |  |  | August
 |  |  | Target Sales |  | Forcast
 |  |  |  | 206000
 |  |  |  | 206000
 |  |  |  | 206000
 |  |  |  | 206000
 |  |  |  | 206000
 |  |  |  | 206000
 |  |  |  | 206000