Spreadsheet: 329260d1404241043-obtaining-a-average-price-from-vlookup-formula-assembly-evaluation-before
Sheet: Makita

Kit # | SKU | Quantity | Initial Cost | eBay     Price | Amazon Price | Averge Price | Percent | Item Cost | StoneEdge Current
[NAME] | MAK-AMB-LXDT04CLW |  | 144 | 175 | 170 |  |  |  | X |  |  |  |  |  |  | Missing assemblies:
 | MAK-IMP-LXDT04-WH | 1 |  | 55 | 50 |  |  |  | X
 | MAK-FLS-LXLM01-WH | 1 |  | 25 | 50 |  |  |  | X
 | MAK-BAT-BL1815 | 2 |  | 90 | 138 |  |  |  | X
 | MAK-CHG-DC18RC | 1 |  | 50 | 77 |  |  |  | X
 | MAK-CAS-LXDT04CLW | 1 |  | 0 | 0 |  |  |  | X |  |  |  |  |  |  | 1434-2 - $113.30
LCT200W | MAK-AMB-LCT200W |  | 194 | 200 | 204 |  |  |  | X |  |  |  |  |  |  | 1834-2 - $127.70
 | MAK-DRL-LXFD01 | 1 |  | 45 | 50 |  |  |  | X
 | MAK-IMP-LXDT04-WH | 1 |  | 66 | 70 |  |  |  | X
 | MAK-CHG-DC18RA | 1 |  | 45 | 50 |  |  |  | X
 | MAK-BAT-BL1815 | 2 |  | 90 | 138 |  |  |  | X
 | MAK-TOT-LCT200W | 1 |  | 0 | 0
LXFD01TL | MAK-AMB-LXFD01TL |  | 127 | 165 | 165 |  |  |  | X
 | MAK-DRL-LXFD01TL | 1 |  | 45 | 55 |  |  |  | X
 | MAK-CHG-DC18RC | 1 |  | 50 | 77 |  |  |  | X
 | MAK-BAT-BL1815 | 1 |  | 90 | 138 |  |  |  | X
 | MAK-CAS-LXFD01 | 1 |  | 0 | 0 |  |  |  | X
LXT407 | MAK-AMB-LXT407-RC |  | 158 | 250 | 300 |  |  |  | X
 | MAK-RCS-BJR182-RC | 1 |  | 60 | 110 |  |  |  | X
 | MAK-IMP-LXDT04-TL-RC | 1 |  | 58 | 65 |  |  |  | X
 | MAK-HDR-LXPH01-TL-RC | 1 |  | 48 | 50 |  |  |  | X
 | MAK-FLS-BML185-TL-RC | 1 |  | 25 | 20 |  |  |  | X
 | MAK-BAT-BL1830-RC | 2 |  | 100 | 155 |  |  |  | X
 | - |  |  | 0 | 0
LXT211 | MAK-AMB-LXT211_LXPH01_TL_LXDT04_TL |  | 151 | 250 | 271 |  |  |  | X
 | MAK-HDR-LXPH01-TL | 1 |  | 60 | 98 |  |  |  | X
 | MAK-IMP-LXDT04-TL | 1 |  | 65 | 84 |  |  |  | X
 | MAK-BAT-BL1830 | 2 |  | 140 | 160 |  |  |  | X
 | MAK-CHG-DC18RA | 1 |  | 45 | 50 |  |  |  | X
 | Case | 1 |  | 0 | 0
LXFD01WSP1 | MAK-AMB-LXFD01WSP1 |  | 95 | 147 | 148 |  |  |  | X
 | MAK-DRL-LXFD01 | 1 |  | 45 | 50 |  |  |  | X
 | MAK-BAT-BL1815 | 1 |  | 98 | 138 |  |  |  | X
 | MAK-CHG-DC18RC | 1 |  | 50 | 77 |  |  |  | X
 | Case | 1 |  | 0 | 0
[NAME] | MAK-AMB-LCT309W |  | 205 | 224 | 203 |  |  |  | X
 | MAK-DRL-FD02 | 1 |  | 28 | 30 |  |  |  | X
 | MAK-IMP-WT01 | 1 |  | 78 | 78 |  |  |  | X
 | MAK-FLS-LM01W | 1 |  | 30 | 20 |  |  |  | X
 | MAK-BAT-BL1014 | 2 |  | 70 | 90 |  |  |  | X
 | MAK-CHG-DC10WB | 1 |  | 43 | 59 |  |  |  | X
 | Case square metal | 1 |  | 0 | 0
FD01W | MAK-AMB-FD01W |  | 98 | 130 | 113 |  |  |  | X
 | MAK-DRL-FD01 | 1 |  | 50 | 60 |  |  |  | X
 | MAK-BAT-BL1014 | 2 |  | 70 | 90 |  |  |  | X
 | MAK-CHG-DC10WB | 1 |  | 43 | 59 |  |  |  | X
 | MAK-DRL-FD02 | 1 |  | 28 | 30 |  |  |  | X
 | MAK-CHG-DC10WB | 1 |  | 43 | 59 |  |  |  | X
 | Case square metal | 1 |  | 0 | 0
[NAME] | MAK-AMB-DCBL1830X2 |  | 95 | 290 | 290 |  |  |  | X
 | MAK-BAT-BL1830 | 2 |  | 125 | 145 |  |  |  | X
 | MAK-CHG-DC18RC | 1 |  | 50 | 77 |  |  |  | X
MAK-AMB-RJ01W | MAK-AMB-RJ01W |  | 119 | 145 | 140 |  |  |  | X
 | MAK-RCS-RJ01W | 1 |  | 87 | 118 |  |  |  | X
 | MAK-BAT-BL1014 | 2 |  | 70 | 90 |  |  |  | X
 | MAK-CHG-DC10WB | 1 |  | 43 | 59 |  |  |  | X
 | - | 1 |  | 0 | 0
LXFD01-RC | MAK-AMB-LXFD01-RC |  | 85 | 143 | 156 |  |  |  | X
 | MAK-CHG-DC18RA-RC | 1 |  | 45 | 50 |  |  |  | X
 | MAK-DRL-LXFD01-RC | 1 |  | 45 | 47 |  |  |  | X
 | - | 2 |  | 90 | 95 |  |  |  | X
 | - | 1 |  | 0 | 0
LXT211_LXPH01_LXDT04-RC | MAK-AMB-LXT211_LXPH01_LXDT04-RC |  | 151 | 250 | 270 |  |  |  | X
 | MAK-HDR-LXPH01-TL-RC | 1 |  | 55 | 85 |  |  |  | X
 | MAK-IMP-LXDT04-TL-RC | 1 |  | 54 | 76 |  |  |  | X
 | MAK-BAT-BL1830-RC | 2 |  | 100 | 110 |  |  |  | X
 | MAK-CHG-DC18RA-RC | 1 |  | 45 | 50 |  |  |  | X
 | - | 1 |  | 0 | 0
LXT211_BTD141_BHP452-RC | MAK-AMB-LXT211_BTD141_BHP452-RC |  | 151 | 262.5 | 270 |  |  |  | X
 | MAK-IMP-BTD141-TL-RC | 1 |  | 60 | 75 |  |  |  | X
 | MAK-DRL-BHP452-TL-RC | 1 |  | 46 | 62 |  |  |  | X
 | MAK-BAT-BL1830-RC | 2 |  | 85 | 95 |  |  |  | X
 | MAK-CHG-DC18RA-RC | 1 |  | 45 | 50 |  |  |  | X
 | - | 1 |  | 0 | 0
LCT200W-B-RC | MAK-AMB-LCT200W_B-RC |  | 124 |  |  |  |  |  | X
 | MAK-DRL-LXFD01-RC | 1 |  | 55 | 98 |  |  |  | X
 | MAK-IMP-LXDT04-TL-RC | 1 |  | 54 | 84 |  |  |  | X
 | MAK-CHG-DC18RA-RC | 1 |  | 45 | 50 |  |  |  | X
 | MAK-BAT-BL1815-RC | 2 |  | 90 | 100 |  |  |  | X
 | MAK-TOT-LCT200W-US | 1 |  | 0 | 0 |  |  |  | X
LCT209W | MAK-AMB-LCT209W |  | 176 | 130 | 120 |  |  |  | X
 | MAK-DRL-FD02 | 1 |  | 28 | 30 |  |  |  | X
 | MAK-IMP-DT01W | 1 |  | 45 | 30 |  |  |  | X
 | MAK-BAT-BL1014 | 2 |  | 70 | 90 |  |  |  | X
 | MAK-CHG-DC10WB | 1 |  | 43 | 59 |  |  |  | X
 | - | 1 |  | 0 | 0
LXDT01 | MAK-AMB-LXDT01 |  | 329 | 195 | 210 | 235
 | MAK-IMP-LXDT01 | 1 |  | 110 | 146
 | MAK-CHG-DC18RA | 1 |  | 49 | 57
 | MAK-BAT-BL1830 | 2 |  | 125 | 145
 | - | 1 |  | 0 | 0
LXT437 | MAK-AMB-LXT437 |  | 270 | 280 | 314
 | MAK-FLS_LXLM01 | 1 |  | 25 | 50
 | MAK-HDR-LXPH01Z | 1 |  | 65 | 98
 | MAK-IMP-LXDT04Z | 1 |  | 58 | 84
 | MAK-CHG-DC18RC | 1 |  | 50 | 77
 | MAK-BAT-BL1830 | 2 |  | 125 | 145
 | MAK-CRS-BSS611 | 1 |  | 70 | 158
 | - | 1 |  | 0 | 0
[NAME] | MAK-AMB-LXFD01CW |  | 139 | 140 | 145
 | MAK-DRL-LXFD01 | 1 |  | 45 | 50
 | MAK-CHG-DC18RC | 1 |  | 50 | 77
 | MAK-BAT-BL1815 | 2 |  | 50 | 77
 | MAK-CAS-LXFD01 | 1 |  | 0 | 0
LCT300W | MAK-AMB-LCT300W |  | 184 | 160 | 216
 | MAK-CHG-DC18RA | 1 |  | 49 | 57
 | MAK-BAT-BL1815 | 2 |  | 90 | 138
 | MAK-DRL-LXFD01 | 1 |  | 45 | 50
 | MAK-IMP-LXDT04WH | 1 |  | 98 | 138
 | MAK-FLS-BML185 | 1 |  | 25 | 20
 | MAK-TOT-LCT300W | 1 |  | 0 | 0
FD02W | MAK-AMB-FD02W |  | 100 | 115 | 118
 | MAK-BAT-BL1014 | 2 |  | 70 | 90
 | MAK-CHG-DC10WB | 1 |  | 43 | 59
 | MAK-DRL-FD02 | 1 |  | 28 | 30
 | MAK-CAS-FDO2W | 1 |  | 0 | 0
[NAME] | MAK-AMB-LXFD01CLW |  | 133 | 145 | 145
 | MAK-DRL-LXFD01 | 1 |  | 45 | 50
 | MAK-FLS-LXLM01-WH | 1 |  | 25 | 50
 | MAK-BAT-BL1815 | 2 |  | 70 | 90
 | MAK-CHG-DC18RC | 1 |  | 50 | 77
 | CASE | 1 |  | 0 | 0
WT01W | MAK-AMB-WT01W |  | 119 | 145 | 136
 | MAK-IMP-WT01 | 1 |  | 70 | 80
 | MAK-BAT-BL1014 | 2 |  | 70 | 90
 | MAK-CHG-DC10WB | 1 |  | 43 | 59
 | CASE 824842-6 | 1 |  | 0 | 0
DT01W | MAK-AMB-DT01W |  | 98 | 127 | 108
 | MAK-IMP-DT01 | 1 |  | 35 | 35
 | MAK-BAT-BL1014 | 1 |  | 70 | 90
 | MAK-CHG-DC10WB | 1 |  | 43 | 59
 | MAK-HOL-TD090D | 1 |  | 10 | 9
XPH01CW | MAK-AMB-XPH01CW |  | 181 | 185 | 220
 | MAK-HDR-LXPH01-WH | 1 |  | 65 | 98
 | MAK-BAT-BL1815 | 2 |  | 70 | 90
 | MAK-CHG-DC18RA | 1 |  | 49 | 57
 | Case | 1 |  | 0 | 0
LXT224 | MAK-AMB-LXT224 |  | 243 | 280 | 280 |  |  |  |  | Not in stone edge
 | MAK-HDR-LXPH03 | 1 |  | 85 | 104
 | MAK-RCS-BJR182 | 1 |  | 60 | 110
 | MAK-BAT-BL1830 | 1 |  | 125 | 145
 | MAK-CHG-DC18RC | 1 |  | 50 | 77
 | Case | 1 |  | 0 | 0
- |  |  | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0