| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
1 | $50 | $110 | $100 | |||||
2 | Percentage | Multiple of Units Sold | Original Price | New Price | Cost | Old COGS | New COGS | This sheet allows you to enter in the original price and cost of a bottle of wine (in yellow) and calculate the following things: |
3 | 100% | 1.000 | $50 | $50 | $100 | 200.00% | 200.00% | 1) Multiples of Units Sold - For every bottle of wine sold @ original price, this is the number of bottles to sell to get the same contribution margin |
4 | 99% | 0.990 | $50 | $50 | $100 | 200.00% | 202.02% | 2) New Price - Automatically calculated from percentage of original price |
5 | 98% | 0.980 | $50 | $49 | $100 | 200.00% | 204.08% | 3) New COGS - Automatically calculated from the percentage of original price |
6 | 97% | 0.971 | $50 | $49 | $100 | 200.00% | 206.19% | |
7 | 96% | 0.962 | $50 | $48 | $100 | 200.00% | 208.33% | |
8 | 95% | 0.952 | $50 | $48 | $100 | 200.00% | 210.53% | |
9 | 94% | 0.943 | $50 | $47 | $100 | 200.00% | 212.77% | |
10 | 93% | 0.935 | $50 | $47 | $100 | 200.00% | 215.05% | |
11 | 92% | 0.926 | $50 | $46 | $100 | 200.00% | 217.39% | |
12 | 91% | 0.917 | $50 | $46 | $100 | 200.00% | 219.78% | |
13 | 90% | 0.909 | $50 | $45 | $100 | 200.00% | 222.22% | |
14 | 89% | 0.901 | $50 | $45 | $100 | 200.00% | 224.72% | |
15 | 88% | 0.893 | $50 | $44 | $100 | 200.00% | 227.27% | |
16 | 87% | 0.885 | $50 | $44 | $100 | 200.00% | 229.89% | |
17 | 86% | 0.877 | $50 | $43 | $100 | 200.00% | 232.56% | |
18 | 85% | 0.870 | $50 | $43 | $100 | 200.00% | 235.29% | |
19 | 84% | 0.862 | $50 | $42 | $100 | 200.00% | 238.10% | |
20 | 83% | 0.855 | $50 | $42 | $100 | 200.00% | 240.96% | |
21 | 82% | 0.847 | $50 | $41 | $100 | 200.00% | 243.90% | |
22 | 81% | 0.840 | $50 | $41 | $100 | 200.00% | 246.91% | |
23 | 80% | 0.833 | $50 | $40 | $100 | 200.00% | 250.00% | |
24 | 79% | 0.826 | $50 | $40 | $100 | 200.00% | 253.16% | |
25 | 78% | 0.820 | $50 | $39 | $100 | 200.00% | 256.41% | |
26 | 77% | 0.813 | $50 | $39 | $100 | 200.00% | 259.74% | |
27 | 76% | 0.806 | $50 | $38 | $100 | 200.00% | 263.16% | |
28 | 75% | 0.800 | $50 | $38 | $100 | 200.00% | 266.67% | |
29 | 74% | 0.794 | $50 | $37 | $100 | 200.00% | 270.27% | |
30 | 73% | 0.787 | $50 | $37 | $100 | 200.00% | 273.97% | |
31 | 72% | 0.781 | $50 | $36 | $100 | 200.00% | 277.78% | |
32 | 71% | 0.775 | $50 | $36 | $100 | 200.00% | 281.69% | |
33 | 70% | 0.769 | $50 | $35 | $100 | 200.00% | 285.71% | |
34 | 69% | 0.763 | $50 | $35 | $100 | 200.00% | 289.86% | |
35 | 68% | 0.758 | $50 | $34 | $100 | 200.00% | 294.12% | |
36 | 67% | 0.752 | $50 | $34 | $100 | 200.00% | 298.51% | |
37 | 66% | 0.746 | $50 | $33 | $100 | 200.00% | 303.03% | |
38 | 65% | 0.741 | $50 | $33 | $100 | 200.00% | 307.69% | |
39 | 64% | 0.735 | $50 | $32 | $100 | 200.00% | 312.50% | |
40 | 63% | 0.730 | $50 | $32 | $100 | 200.00% | 317.46% | |
41 | 62% | 0.725 | $50 | $31 | $100 | 200.00% | 322.58% | |
42 | 61% | 0.719 | $50 | $31 | $100 | 200.00% | 327.87% | |
43 | 60% | 0.714 | $50 | $30 | $100 | 200.00% | 333.33% | |
44 | 59% | 0.709 | $50 | $30 | $100 | 200.00% | 338.98% | |
45 | 58% | 0.704 | $50 | $29 | $100 | 200.00% | 344.83% | |
46 | 57% | 0.699 | $50 | $29 | $100 | 200.00% | 350.88% | |
47 | 56% | 0.694 | $50 | $28 | $100 | 200.00% | 357.14% | |
48 | 55% | 0.690 | $50 | $28 | $100 | 200.00% | 363.64% | |
49 | 54% | 0.685 | $50 | $27 | $100 | 200.00% | 370.37% | |
50 | 53% | 0.680 | $50 | $27 | $100 | 200.00% | 377.36% | |
51 | 52% | 0.676 | $50 | $26 | $100 | 200.00% | 384.62% | |
52 | 51% | 0.671 | $50 | $26 | $100 | 200.00% | 392.16% | |
53 | 50% | 0.667 | $50 | $25 | $100 | 200.00% | 400.00% | |
54 | ||||||||
55 | ||||||||
56 | ||||||||
57 | ||||||||
58 | ||||||||
59 | ||||||||
60 | ||||||||
61 | ||||||||
62 | ||||||||
63 | ||||||||
64 | ||||||||
65 | ||||||||
66 | ||||||||
67 | ||||||||
68 | ||||||||
69 | ||||||||
70 | ||||||||
71 | ||||||||
72 | ||||||||
73 | ||||||||
74 | ||||||||
75 | ||||||||
76 | ||||||||
77 | ||||||||
78 | ||||||||
79 | ||||||||
80 | ||||||||
81 | ||||||||
82 | ||||||||
83 | ||||||||
84 | ||||||||
85 | ||||||||
86 | ||||||||
87 | ||||||||
88 | ||||||||
89 | ||||||||
90 | ||||||||
91 | ||||||||
92 | ||||||||
93 | ||||||||
94 | ||||||||
95 | ||||||||
96 | ||||||||
97 | ||||||||
98 | ||||||||
99 | ||||||||
100 |