Incremental
Profit Margin Incremental
acquisition
band Volume Bands
Bands
25% + and 0.4% + and 6% + and
High
above above above
10% – 25%
Medium 0.1% – 0.4% 2% – 6%
Profit
Less than 10%
Low Less than 0.1% Less than 2%
Profit
Average number of
Market price of Current cost of Profit for each units of product sold to
the product the product unit a customer who makes
a purchase
Incremental_acqui
Avg_Price_per_ Average_Profit sition(per 10%
Products Cost_per_unit Average_units_sold
unit _per_unit decline in unit
price)
Product 1 95 92 3.0 0.6 0.323%
Product 2 37 27 10.0 0.8 0.106%
Product 3 34 26 8.0 0.6 0.328%
Product 4 32 30 2.0 0.7 0.000%
Product 5 62 45 17.0 1 0.079%
Product 6 86 78 8.0 0.9 0.000%
Product 7 105 77 28.0 1.9 0.000%
Product 8 84 67 17.0 0.9 0.282%
Product 9 69 53 16.0 1.8 0.484%
Product 10 108 94 14.0 1 0.000%
Product 11 84 75 9.0 0.6 0.111%
Product 12 105 99 6.0 3 0.000%
Product 13 32 29 3.0 0.2 0.351%
Product 14 49 45 4.0 0.3 0.030%
Product 15 68 53 15.0 2.1 0.000%
Product 16 20 16 4.0 2.3 0.213%
Product 17 105 88 17.0 2.3 0.132%
Product 18 56 54 2.0 3 0.335%
Product 19 98 72 26.0 0.2 0.111%
Product 20 17 16 1.0 0.2 0.277%
Product 21 47 39 8.0 0.5 0.445%
Product 22 97 89 8.0 2.5 0.260%
Product 23 35 31 4.0 0.3 0.030%
Product 24 108 96 12.0 2.4 0.000%
Product 25 47 43 4.0 2.9 0.000%
Product 26 55 54 1.0 0.1 0.000%
Product 27 91 69 22.0 1.5 0.147%
Product 28 63 60 3.0 1.9 0.316%
Product 29 41 39 2.0 1.2 0.000%
Product 30 33 32 1.0 2.4 0.200%
Product 31 75 68 7.0 1.6 0.000%
Product 32 105 84 21.0 1.2 0.497%
Product 33 20 18 2.0 1.1 0.341%
Product 34 22 19 3.0 2.3 0.020%
Product 35 47 33 14.0 0.8 0.000%
Product 36 50 38 12.0 2.7 0.000%
Product 37 51 36 15.0 0.6 0.000%
Product 38 42 34 8.0 1.2 0.000%
Product 39 39 29 10.0 0.3 0.000%
Product 40 20 19 1.0 2 0.000%
Product 41 108 85 23.0 1.2 0.193%
Product 42 14 13 1.0 1.6 0.018%
Product 43 110 104 6.0 1.2 0.299%
Product 44 42 30 12.0 2.8 0.361%
Product 45 46 43 3.0 3.1 0.000%
Product 46 105 101 4.0 0.8 0.207%
Product 47 47 47 0.0 3 0.134%
Product 48 98 79 19.0 0.6 0.000%
Product 49 87 63 24.0 0.6 0.000%
Product 50 46 43 3.0 0.7 0.000%
Product 51 73 56 17.0 0.7 0.062%
Product 52 81 57 24.0 0.3 0.000%
Product 53 103 81 22.0 1.8 0.000%
Product 54 37 32 5.0 2.2 0.000%
Product 55 53 37 16.0 0.2 0.000%
Product 56 36 36 0.0 3 0.058%
Product 57 110 90 20.0 1.1 0.080%
Product 58 56 43 13.0 0.2 0.135%
Product 59 11 10 1.0 2.6 0.000%
Product 60 64 61 3.0 2.3 0.000%
Product 61 22 19 3.0 1 0.057%
Product 62 14 12 2.0 2.2 0.000%
Product 63 101 91 10.0 1.8 0.000%
Product 64 101 99 2.0 0.8 0.000%
Product 65 62 58 4.0 2 0.000%
Product 66 95 87 8.0 0.7 0.000%
Product 67 47 34 13.0 2.1 0.000%
Product 68 98 73 25.0 1.9 0.259%
Product 69 78 58 20.0 1.3 0.367%
Product 70 45 40 5.0 2.2 0.353%
Product 71 94 75 19.0 2.2 0.000%
Product 72 86 83 3.0 1.5 0.309%
Product 73 53 41 12.0 2 0.000%
Product 74 23 20 3.0 2.2 0.000%
Product 75 90 75 15.0 0.4 0.206%
Product 76 44 32 12.0 2.4 0.000%
Product 77 60 52 8.0 1.9 0.432%
Product 78 71 59 12.0 1.2 0.096%
Product 79 42 33 9.0 1.4 0.365%
Product 80 78 70 8.0 1.7 0.440%
Product 81 57 50 7.0 2.4 0.000%
Product 82 18 15 3.0 0.2 0.156%
Product 83 78 56 22.0 1.3 0.301%
Product 84 52 47 5.0 2.8 0.215%
Product 85 21 16 5.0 2.2 0.146%
Product 86 55 43 12.0 1.1 0.475%
Product 87 24 24 0.0 2.8 0.335%
Product 88 89 84 5.0 0.3 0.000%
Product 89 82 74 8.0 1.7 0.285%
Product 90 110 84 26.0 2.3 0.166%
Product 91 51 42 9.0 3 0.025%
Product 92 86 74 12.0 1.1 0.366%
Product 93 66 63 3.0 0.9 0.000%
Product 94 75 68 7.0 1.3 0.000%
Product 95 35 32 3.0 1.8 0.499%
Product 96 86 73 13.0 0.2 0.000%
Product 97 87 62 25.0 0.2 0.468%
Product 98 56 50 6.0 2.5 0.192%
Product 99 68 66 2.0 1.2 0.072%
Product 100 66 53 13.0 2 0.401%
Product 101 46 39 7.0 0.1 0.334%
Product 102 107 84 23.0 0.7 0.000%
Product 103 110 105 5.0 0.2 0.000%
Product 104 57 47 10.0 1.3 0.265%
Product 105 73 69 4.0 0.6 0.000%
Product 106 34 28 6.0 2.9 0.000%
Product 107 104 78 26.0 2.5 0.000%
Product 108 96 84 12.0 1.9 0.000%
Product 109 14 14 0.0 2.7 0.235%
Product 110 64 48 16.0 1.1 0.015%
Product 111 99 96 3.0 2 0.435%
Product 112 66 65 1.0 2.4 0.575%
Product 113 69 63 6.0 2.2 0.113%
Product 114 63 53 10.0 0.5 0.033%
Product 115 55 47 8.0 2.1 0.226%
Product 116 65 61 4.0 1.6 0.251%
Product 117 20 18 2.0 0.3 0.192%
Product 118 110 86 24.0 1 0.000%
Product 119 23 19 4.0 1.1 0.159%
Product 120 65 55 10.0 0.4 0.107%
Product 121 35 32 3.0 2.7 0.058%
Product 122 96 83 13.0 0.2 0.288%
Product 123 77 54 23.0 2.1 0.000%
Product 124 102 90 12.0 2.2 0.389%
Product 125 27 26 1.0 1.4 0.166%
Product 126 94 77 17.0 1.2 0.282%
Product 127 17 13 4.0 1.4 0.039%
Product 128 31 29 2.0 1 0.212%
Product 129 55 55 0.0 1 0.032%
Product 130 42 42 0.0 1.5 0.000%
Product 131 56 48 8.0 2.6 0.236%
Product 132 34 24 10.0 2.2 0.196%
Product 133 77 65 12.0 2.2 0.000%
Product 134 87 72 15.0 2.8 0.299%
Product 135 44 43 1.0 1.7 0.000%
Product 136 32 23 9.0 0.1 0.188%
Product 137 33 23 10.0 2.1 0.000%
Product 138 72 51 21.0 2.6 0.040%
Product 139 58 46 12.0 1.2 0.000%
Product 140 40 38 2.0 1.1 0.285%
Product 141 79 66 13.0 0.8 0.135%
Product 142 109 83 26.0 1.2 0.000%
Product 143 37 30 7.0 2.9 0.253%
Product 144 52 51 1.0 1.4 0.053%
Product 145 83 83 0.0 3 0.000%
Product 146 35 32 3.0 0.4 0.000%
Product 147 102 76 26.0 1.9 0.095%
Product 148 80 72 8.0 2.9 0.134%
Product 149 73 65 8.0 0.5 0.495%
Product 150 29 27 2.0 1.5 0.000%
Product 151 52 43 9.0 0.6 0.002%
Product 152 87 67 20.0 2.1 0.173%
Product 153 89 68 21.0 1.2 0.233%
Product 154 43 42 1.0 0.4 0.171%
Product 155 56 51 5.0 2.4 0.342%
Product 156 25 20 5.0 2.8 0.000%
Product 157 85 69 16.0 1 0.132%
Product 158 49 43 6.0 0.7 0.316%
Product 159 46 40 6.0 1.3 0.000%
Product 160 89 62 27.0 1.5 0.046%
Product 161 69 65 4.0 2.5 0.523%
Product 162 98 89 9.0 0.3 0.183%
Product 163 71 54 17.0 1.3 0.215%
Product 164 59 54 5.0 1.6 0.105%
Product 165 39 28 11.0 0.4 0.000%
Product 166 76 67 9.0 2.5 0.000%
Product 167 20 19 1.0 0.5 0.000%
Product 168 37 31 6.0 3 0.131%
Product 169 88 74 14.0 2.6 0.000%
Product 170 14 12 2.0 1 0.615%
Product 171 14 12 2.0 0.6 0.000%
Product 172 25 23 2.0 1.3 0.000%
Product 173 50 39 11.0 2.3 0.000%
Product 174 31 25 6.0 1.9 0.123%
Product 175 80 67 13.0 1.8 0.167%
Product 176 86 75 11.0 0.6 0.000%
Product 177 47 39 8.0 1.9 0.059%
Product 178 80 72 8.0 1.7 0.019%
Product 179 81 74 7.0 1 0.000%
Product 180 98 81 17.0 1.9 0.049%
Product 181 98 85 13.0 1 0.294%
Product 182 35 34 1.0 0.6 0.000%
Product 183 104 99 5.0 2.2 0.469%
Product 184 48 46 2.0 2.3 0.472%
Product 185 41 34 7.0 1.9 0.392%
Product 186 79 56 23.0 2.6 0.000%
Product 187 20 15 5.0 0.7 0.329%
Product 188 22 17 5.0 0.2 0.000%
Product 189 89 87 2.0 0.1 0.000%
Product 190 75 72 3.0 0.8 0.000%
Product 191 49 43 6.0 0.6 0.000%
Product 192 30 21 9.0 1.4 0.000%
Product 193 45 39 6.0 1.3 0.329%
Product 194 62 52 10.0 0.1 0.119%
Product 195 27 19 8.0 0.2 0.066%
Product 196 26 20 6.0 2.5 0.080%
Product 197 59 58 1.0 1.4 0.271%
Product 198 49 47 2.0 0.6 0.000%
Product 199 39 34 5.0 1.7 0.000%
Product 200 98 97 1.0 0.4 0.195%
Product 201 62 55 7.0 2.8 0.415%
Product 202 39 36 3.0 0.7 0.000%
Product 203 43 36 7.0 2.3 0.007%
Product 204 103 75 28.0 2.7 0.329%
Product 205 22 21 1.0 1 0.257%
Product 206 14 12 2.0 1.5 0.055%
Product 207 70 56 14.0 1.1 0.000%
Product 208 25 21 4.0 2.1 0.000%
Product 209 34 29 5.0 1 0.063%
Product 210 65 45 20.0 0.5 0.259%
Product 211 31 26 5.0 2.2 0.139%
Product 212 51 47 4.0 1.9 0.400%
Product 213 102 86 16.0 0.7 0.000%
Product 214 45 34 11.0 0.8 0.018%
Product 215 92 68 24.0 2.2 0.000%
Product 216 82 74 8.0 2.4 0.000%
Product 217 28 27 1.0 2.2 0.220%
Product 218 99 80 19.0 2.2 0.385%
Product 219 105 75 30.0 1.3 0.134%
Product 220 71 67 4.0 3.1 0.000%
Product 221 104 99 5.0 1.7 0.000%
Product 222 32 29 3.0 1.4 0.242%
Product 223 58 43 15.0 1 0.000%
Product 224 45 39 6.0 2.4 0.357%
Product 225 15 14 1.0 1.8 0.090%
Product 226 18 17 1.0 2 0.298%
Product 227 33 28 5.0 0.5 0.508%
Product 228 22 19 3.0 1.7 0.197%
Product 229 57 53 4.0 2.8 0.000%
Product 230 49 46 3.0 0.7 0.172%
Product 231 10 9 1.0 2.6 0.000%
Product 232 48 45 3.0 1.3 0.173%
Product 233 98 69 29.0 0.3 0.134%
Product 234 74 68 6.0 1.1 0.000%
Product 235 83 68 15.0 1.6 0.000%
Product 236 54 42 12.0 2.6 0.442%
Product 237 37 37 0.0 1.4 0.000%
Product 238 14 14 0.0 2.3 0.000%
Product 239 52 50 2.0 2 0.000%
Product 240 107 87 20.0 1.1 0.000%
Product 241 89 79 10.0 2.4 0.024%
Product 242 65 63 2.0 0.7 0.000%
Product 243 69 55 14.0 2.9 0.183%
Product 244 85 67 18.0 1.8 0.000%
Product 245 100 75 25.0 1 0.076%
Product 246 23 21 2.0 1.5 0.290%
Product 247 59 57 2.0 0.5 0.000%
Product 248 16 15 1.0 1.6 0.095%
Product 249 84 71 13.0 0.8 0.264%
Product 250 38 28 10.0 2.1 0.540%
Increase_sale_vol
ume(per 10%
decline in unit
price)
8.91%
1.99%
3.78%
8.56%
2.64%
1.86%
5.53%
6.72%
2.96%
3.81%
9.75%
3.77%
6.37%
0.68%
0.04%
0.76%
7.63%
6.86%
3.07%
8.92%
0.22%
4.40%
6.30%
6.90%
9.51%
4.57%
2.54%
5.52%
5.93%
0.07%
1.36%
9.66%
1.06%
1.38%
5.24%
7.90%
9.16%
6.79%
6.46%
8.53%
8.52%
8.14%
3.36%
8.73%
1.48%
4.45%
4.32%
5.87%
1.63%
1.56%
5.13%
3.41%
3.76%
0.85%
2.21%
9.84%
1.61%
9.48%
4.76%
5.58%
2.59%
2.18%
9.73%
4.03%
8.18%
8.63%
3.03%
3.41%
3.24%
3.87%
8.10%
0.46%
8.00%
9.49%
7.09%
4.77%
8.44%
7.83%
9.21%
6.21%
4.18%
8.26%
0.21%
0.73%
0.87%
1.26%
7.25%
2.04%
7.86%
9.47%
5.79%
8.01%
0.92%
8.49%
5.46%
6.14%
7.95%
7.43%
6.29%
4.62%
9.21%
7.09%
0.07%
7.53%
0.68%
3.07%
0.08%
3.70%
6.67%
4.97%
9.06%
2.23%
9.89%
4.83%
2.05%
9.85%
2.14%
5.84%
9.56%
6.77%
6.66%
3.18%
5.49%
0.12%
4.94%
4.36%
7.55%
6.13%
2.62%
0.41%
6.29%
5.03%
2.25%
4.57%
8.27%
4.77%
2.54%
7.23%
1.17%
0.94%
9.48%
1.41%
4.24%
9.06%
4.05%
7.16%
4.77%
6.24%
7.90%
4.26%
1.65%
3.09%
0.63%
9.71%
3.86%
4.31%
3.73%
6.49%
5.29%
1.84%
1.51%
5.94%
5.70%
2.74%
9.75%
4.34%
0.11%
1.14%
6.35%
4.53%
3.28%
3.54%
8.09%
9.94%
9.64%
4.21%
3.92%
1.32%
9.89%
6.02%
8.59%
8.95%
4.96%
6.49%
9.78%
9.59%
1.44%
8.76%
9.04%
7.19%
7.10%
4.70%
4.33%
5.93%
5.18%
5.27%
3.73%
5.22%
7.67%
5.15%
6.40%
2.04%
8.11%
6.17%
7.85%
0.98%
1.92%
0.46%
0.62%
5.92%
4.26%
8.80%
6.38%
9.67%
5.71%
1.87%
7.94%
1.84%
5.00%
5.60%
5.19%
8.01%
7.12%
2.12%
1.15%
6.57%
0.63%
4.14%
8.55%
6.88%
4.98%
7.80%
7.32%
2.07%
0.77%
9.38%
4.10%
8.05%
5.28%
2.75%
1.03%
8.56%
8.14%
0.09%
1.55%
7.13%
5.91%
4.84%
0.47%
2.15%