[go: up one dir, main page]

0% found this document useful (0 votes)
15 views12 pages

7.2.price Optimization-Data Set

Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
15 views12 pages

7.2.price Optimization-Data Set

Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 12

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%

You might also like