Spreadsheet: 023ce056-7d2c-4144-836c-311d9da8fade
Sheet: 2011-12 Pricing table

Weighted Avg Price | Rate Increase | Inflation | Increas + Inflation | Cost Increase | New Price (pre-round) | New Price | Final Price After Round Down | Price Differential
0 | 0.02 | 0.0114
0.01 | 0.02 | 0.0114
0.02 | 0.02 | 0.0114
0.03 | 0.02 | 0.0114
0.04 | 0.02 | 0.0114
0.05 | 0.02 | 0.0114
0.06 | 0.02 | 0.0114
0.07 | 0.02 | 0.0114
0.08 | 0.02 | 0.0114
0.09 | 0.02 | 0.0114
0.1 | 0.02 | 0.0114
0.11 | 0.02 | 0.0114
0.12 | 0.02 | 0.0114
0.13 | 0.02 | 0.0114
0.14 | 0.02 | 0.0114
0.15 | 0.02 | 0.0114
0.16 | 0.02 | 0.0114
0.17 | 0.02 | 0.0114
0.18 | 0.02 | 0.0114
0.19 | 0.02 | 0.0114
0.2 | 0.02 | 0.0114
0.21 | 0.02 | 0.0114
0.22 | 0.02 | 0.0114
0.23 | 0.02 | 0.0114
0.24 | 0.02 | 0.0114
0.25 | 0.02 | 0.0114
0.26 | 0.02 | 0.0114
0.27 | 0.02 | 0.0114
0.28 | 0.02 | 0.0114
0.29 | 0.02 | 0.0114
0.3 | 0.02 | 0.0114
0.31 | 0.02 | 0.0114
0.32 | 0.02 | 0.0114
0.33 | 0.02 | 0.0114
0.34 | 0.02 | 0.0114
0.35 | 0.02 | 0.0114
0.36 | 0.02 | 0.0114
0.37 | 0.02 | 0.0114
0.38 | 0.02 | 0.0114
0.39 | 0.02 | 0.0114
0.4 | 0.02 | 0.0114
0.41 | 0.02 | 0.0114
0.42 | 0.02 | 0.0114
0.43 | 0.02 | 0.0114
0.44 | 0.02 | 0.0114
0.45 | 0.02 | 0.0114
0.46 | 0.02 | 0.0114
0.47 | 0.02 | 0.0114
0.48 | 0.02 | 0.0114
0.49 | 0.02 | 0.0114
0.5 | 0.02 | 0.0114
0.5 | 0.02 | 0.0114
0.51 | 0.02 | 0.0114
0.52 | 0.02 | 0.0114
0.53 | 0.02 | 0.0114
0.54 | 0.02 | 0.0114
0.55 | 0.02 | 0.0114
0.56 | 0.02 | 0.0114
0.57 | 0.02 | 0.0114
0.58 | 0.02 | 0.0114
0.59 | 0.02 | 0.0114
0.6 | 0.02 | 0.0114
0.61 | 0.02 | 0.0114
0.62 | 0.02 | 0.0114
0.63 | 0.02 | 0.0114
0.64 | 0.02 | 0.0114
0.65 | 0.02 | 0.0114
0.66 | 0.02 | 0.0114
0.67 | 0.02 | 0.0114
0.68 | 0.02 | 0.0114
0.69 | 0.02 | 0.0114
0.7 | 0.02 | 0.0114
0.71 | 0.02 | 0.0114
0.72 | 0.02 | 0.0114
0.73 | 0.02 | 0.0114
0.74 | 0.02 | 0.0114
0.75 | 0.02 | 0.0114
0.76 | 0.02 | 0.0114
0.77 | 0.02 | 0.0114
0.78 | 0.02 | 0.0114
0.79 | 0.02 | 0.0114
0.8 | 0.02 | 0.0114
0.81 | 0.02 | 0.0114
0.82 | 0.02 | 0.0114
0.83 | 0.02 | 0.0114
0.84 | 0.02 | 0.0114
0.85 | 0.02 | 0.0114
0.86 | 0.02 | 0.0114
0.87 | 0.02 | 0.0114
0.88 | 0.02 | 0.0114
0.89 | 0.02 | 0.0114
0.9 | 0.02 | 0.0114
0.91 | 0.02 | 0.0114
0.92 | 0.02 | 0.0114
0.93 | 0.02 | 0.0114
0.94 | 0.02 | 0.0114
0.95 | 0.02 | 0.0114
0.96 | 0.02 | 0.0114
0.97 | 0.02 | 0.0114
0.98 | 0.02 | 0.0114
0.99 | 0.02 | 0.0114
1 | 0.02 | 0.0114
1.01 | 0.02 | 0.0114
1.02 | 0.02 | 0.0114
1.03 | 0.02 | 0.0114
1.04 | 0.02 | 0.0114
1.05 | 0.02 | 0.0114
1.06 | 0.02 | 0.0114
1.07 | 0.02 | 0.0114
1.08 | 0.02 | 0.0114
1.09 | 0.02 | 0.0114
1.1 | 0.02 | 0.0114
1.11 | 0.02 | 0.0114
1.12 | 0.02 | 0.0114
1.13 | 0.02 | 0.0114
1.14 | 0.02 | 0.0114
1.15 | 0.02 | 0.0114
1.16 | 0.02 | 0.0114
1.17 | 0.02 | 0.0114
1.18 | 0.02 | 0.0114
1.19 | 0.02 | 0.0114
1.2 | 0.02 | 0.0114
1.21 | 0.02 | 0.0114
1.22 | 0.02 | 0.0114
1.23 | 0.02 | 0.0114
1.24 | 0.02 | 0.0114
1.25 | 0.02 | 0.0114
1.26 | 0.02 | 0.0114
1.27 | 0.02 | 0.0114
1.28 | 0.02 | 0.0114
1.29 | 0.02 | 0.0114
1.3 | 0.02 | 0.0114
1.31 | 0.02 | 0.0114
1.32 | 0.02 | 0.0114
1.33 | 0.02 | 0.0114
1.34 | 0.02 | 0.0114
1.35 | 0.02 | 0.0114
1.36 | 0.02 | 0.0114
1.37 | 0.02 | 0.0114
1.38 | 0.02 | 0.0114
1.39 | 0.02 | 0.0114
1.4 | 0.02 | 0.0114
1.41 | 0.02 | 0.0114
1.42 | 0.02 | 0.0114
1.43 | 0.02 | 0.0114
1.44 | 0.02 | 0.0114
1.45 | 0.02 | 0.0114
1.46 | 0.02 | 0.0114
1.47 | 0.02 | 0.0114
1.48 | 0.02 | 0.0114
1.49 | 0.02 | 0.0114
1.5 | 0.02 | 0.0114
1.51 | 0.02 | 0.0114
1.52 | 0.02 | 0.0114
1.53 | 0.02 | 0.0114
1.54 | 0.02 | 0.0114
1.55 | 0.02 | 0.0114
1.56 | 0.02 | 0.0114
1.57 | 0.02 | 0.0114
1.58 | 0.02 | 0.0114
1.59 | 0.02 | 0.0114
1.6 | 0.02 | 0.0114
1.61 | 0.02 | 0.0114
1.62 | 0.02 | 0.0114
1.63 | 0.02 | 0.0114
1.64 | 0.02 | 0.0114
1.65 | 0.02 | 0.0114
1.66 | 0.02 | 0.0114
1.67 | 0.02 | 0.0114
1.68 | 0.02 | 0.0114
1.69 | 0.02 | 0.0114
1.7 | 0.02 | 0.0114
1.71 | 0.02 | 0.0114
1.72 | 0.02 | 0.0114
1.73 | 0.02 | 0.0114
1.74 | 0.02 | 0.0114
1.75 | 0.02 | 0.0114
1.76 | 0.02 | 0.0114
1.77 | 0.02 | 0.0114
1.78 | 0.02 | 0.0114
1.79 | 0.02 | 0.0114
1.8 | 0.02 | 0.0114
1.81 | 0.02 | 0.0114
1.82 | 0.02 | 0.0114
1.83 | 0.02 | 0.0114
1.84 | 0.02 | 0.0114
1.85 | 0.02 | 0.0114
1.86 | 0.02 | 0.0114
1.87 | 0.02 | 0.0114
1.88 | 0.02 | 0.0114
1.89 | 0.02 | 0.0114
1.9 | 0.02 | 0.0114
1.91 | 0.02 | 0.0114
1.92 | 0.02 | 0.0114
1.93 | 0.02 | 0.0114
1.94 | 0.02 | 0.0114
1.95 | 0.02 | 0.0114
1.96 | 0.02 | 0.0114
1.97 | 0.02 | 0.0114
1.98 | 0.02 | 0.0114
1.99 | 0.02 | 0.0114
2 | 0.02 | 0.0114
2.01 | 0.02 | 0.0114
2.02 | 0.02 | 0.0114
2.03 | 0.02 | 0.0114
2.04 | 0.02 | 0.0114
2.05 | 0.02 | 0.0114
2.06 | 0.02 | 0.0114
2.07 | 0.02 | 0.0114
2.08 | 0.02 | 0.0114
2.09 | 0.02 | 0.0114
2.1 | 0.02 | 0.0114
2.11 | 0.02 | 0.0114
2.12 | 0.02 | 0.0114
2.13 | 0.02 | 0.0114
2.14 | 0.02 | 0.0114
2.15 | 0.02 | 0.0114
2.16 | 0.02 | 0.0114
2.17 | 0.02 | 0.0114
2.18 | 0.02 | 0.0114
2.19 | 0.02 | 0.0114
2.2 | 0.02 | 0.0114
2.21 | 0.02 | 0.0114
2.22 | 0.02 | 0.0114
2.23 | 0.02 | 0.0114
2.24 | 0.02 | 0.0114
2.25 | 0.02 | 0.0114
2.26 | 0.02 | 0.0114
2.27 | 0.02 | 0.0114
2.28 | 0.02 | 0.0114
2.29 | 0.02 | 0.0114
2.3 | 0.02 | 0.0114
2.31 | 0.02 | 0.0114
2.32 | 0.02 | 0.0114
2.33 | 0.02 | 0.0114
2.34 | 0.02 | 0.0114
2.35 | 0.02 | 0.0114
2.36 | 0.02 | 0.0114
2.37 | 0.02 | 0.0114
2.38 | 0.02 | 0.0114
2.39 | 0.02 | 0.0114 |  |  | 2.46
2.4 | 0.02 | 0.0114 |  |  | 2.46 |  |  |  | hardcoded to not exceed required lunch price of $2.46
2.41 | 0.02 | 0.0114 |  |  | 2.46 |  |  |  | hardcoded to not exceed required lunch price of $2.46
2.42 | 0.02 | 0.0114 |  |  | 2.46 |  |  |  | hardcoded to not exceed required lunch price of $2.46
2.43 | 0.02 | 0.0114 |  |  | 2.46 |  | 2.46 |  | hardcoded to not exceed required lunch price of $2.46
2.44 | 0.02 | 0.0114 |  |  | 2.46 |  | 2.46 |  | hardcoded to not exceed required lunch price of $2.46
2.45 | 0.02 | 0.0114 |  |  | 2.46 |  | 2.46 |  | hardcoded to not exceed required lunch price of $2.46
2.46 | 0.02 | 0.0114 |  |  | 2.46 |  | 2.46 |  | hardcoded to not exceed required lunch price of $2.46
2.47 | 0.02 | 0.0114
2.48 | 0.02 | 0.0114
2.49 | 0.02 | 0.0114
2.5 | 0.02 | 0.0114
2.51 | 0.02 | 0.0114
2.52 | 0.02 | 0.0114
2.53 | 0.02 | 0.0114
2.54 | 0.02 | 0.0114
2.55 | 0.02 | 0.0114
2.56 | 0.02 | 0.0114
2.57 | 0.02 | 0.0114
2.58 | 0.02 | 0.0114
2.59 | 0.02 | 0.0114
2.6 | 0.02 | 0.0114
2.61 | 0.02 | 0.0114
2.62 | 0.02 | 0.0114
2.63 | 0.02 | 0.0114
2.64000000000001 | 0.02 | 0.0114
2.65 | 0.02 | 0.0114
2.66000000000001 | 0.02 | 0.0114
2.67 | 0.02 | 0.0114
2.68000000000001 | 0.02 | 0.0114
2.69000000000001 | 0.02 | 0.0114
2.70000000000001 | 0.02 | 0.0114
2.71000000000001 | 0.02 | 0.0114
2.72000000000001 | 0.02 | 0.0114
2.73000000000001 | 0.02 | 0.0114
2.74000000000001 | 0.02 | 0.0114
2.75000000000001 | 0.02 | 0.0114
2.76000000000001 | 0.02 | 0.0114
2.77000000000001 | 0.02 | 0.0114
2.78000000000001 | 0.02 | 0.0114
2.79000000000001 | 0.02 | 0.0114
2.80000000000001 | 0.02 | 0.0114
2.81000000000001 | 0.02 | 0.0114
2.82000000000001 | 0.02 | 0.0114
2.83000000000001 | 0.02 | 0.0114
2.84000000000001 | 0.02 | 0.0114
2.85000000000001 | 0.02 | 0.0114
2.86000000000001 | 0.02 | 0.0114
2.87000000000001 | 0.02 | 0.0114
2.88000000000001 | 0.02 | 0.0114
2.89000000000001 | 0.02 | 0.0114
2.90000000000001 | 0.02 | 0.0114
2.91000000000001 | 0.02 | 0.0114
2.92000000000001 | 0.02 | 0.0114
2.93000000000001 | 0.02 | 0.0114
2.94000000000001 | 0.02 | 0.0114
2.95000000000001 | 0.02 | 0.0114
2.96000000000001 | 0.02 | 0.0114
2.97000000000001 | 0.02 | 0.0114
2.98000000000001 | 0.02 | 0.0114
2.99000000000001 | 0.02 | 0.0114
3.00000000000001 | 0.02 | 0.0114
3.01000000000001 | 0.02 | 0.0114
3.02000000000001 | 0.02 | 0.0114
3.03000000000001 | 0.02 | 0.0114
3.04000000000001 | 0.02 | 0.0114
3.05000000000001 | 0.02 | 0.0114
3.06000000000001 | 0.02 | 0.0114
3.07000000000001 | 0.02 | 0.0114
3.08000000000002 | 0.02 | 0.0114
3.09000000000001 | 0.02 | 0.0114
3.10000000000001 | 0.02 | 0.0114
3.11000000000001 | 0.02 | 0.0114
3.12000000000002 | 0.02 | 0.0114
3.13000000000002 | 0.02 | 0.0114
3.14000000000002 | 0.02 | 0.0114
3.15000000000002 | 0.02 | 0.0114
3.16000000000002 | 0.02 | 0.0114
3.17000000000002 | 0.02 | 0.0114
3.18000000000002 | 0.02 | 0.0114
3.19000000000002 | 0.02 | 0.0114
3.20000000000002 | 0.02 | 0.0114
3.21000000000002 | 0.02 | 0.0114
3.22000000000002 | 0.02 | 0.0114
3.23000000000002 | 0.02 | 0.0114
3.24000000000002 | 0.02 | 0.0114
3.25000000000002 | 0.02 | 0.0114
3.26000000000002 | 0.02 | 0.0114
3.27000000000002 | 0.02 | 0.0114
3.28000000000002 | 0.02 | 0.0114
3.29000000000002 | 0.02 | 0.0114
3.30000000000002 | 0.02 | 0.0114
3.31000000000002 | 0.02 | 0.0114
3.32000000000002 | 0.02 | 0.0114
3.33000000000002 | 0.02 | 0.0114
3.34000000000002 | 0.02 | 0.0114
3.35000000000002 | 0.02 | 0.0114
3.36000000000002 | 0.02 | 0.0114
3.37000000000002 | 0.02 | 0.0114
3.38000000000002 | 0.02 | 0.0114
3.39000000000002 | 0.02 | 0.0114
3.40000000000002 | 0.02 | 0.0114
3.41000000000002 | 0.02 | 0.0114
3.42000000000002 | 0.02 | 0.0114
3.43000000000002 | 0.02 | 0.0114
3.44000000000002 | 0.02 | 0.0114
3.45000000000002 | 0.02 | 0.0114
3.46000000000002 | 0.02 | 0.0114
3.47000000000002 | 0.02 | 0.0114
3.48000000000002 | 0.02 | 0.0114
3.49000000000002 | 0.02 | 0.0114
3.50000000000002 | 0.02 | 0.0114
3.51000000000002 | 0.02 | 0.0114
3.52000000000002 | 0.02 | 0.0114
3.53000000000003 | 0.02 | 0.0114
3.54000000000003 | 0.02 | 0.0114
3.55000000000003 | 0.02 | 0.0114
3.56000000000003 | 0.02 | 0.0114
3.57000000000003 | 0.02 | 0.0114
3.58000000000003 | 0.02 | 0.0114
3.59000000000003 | 0.02 | 0.0114
3.60000000000003 | 0.02 | 0.0114
3.61000000000003 | 0.02 | 0.0114
3.62000000000003 | 0.02 | 0.0114
3.63000000000003 | 0.02 | 0.0114
3.64000000000003 | 0.02 | 0.0114
3.65000000000003 | 0.02 | 0.0114
3.66000000000003 | 0.02 | 0.0114
3.67000000000003 | 0.02 | 0.0114
3.68000000000003 | 0.02 | 0.0114
3.69000000000003 | 0.02 | 0.0114
3.70000000000003 | 0.02 | 0.0114
3.71000000000003 | 0.02 | 0.0114
3.72000000000003 | 0.02 | 0.0114
3.73000000000003 | 0.02 | 0.0114
3.74000000000003 | 0.02 | 0.0114
3.75000000000003 | 0.02 | 0.0114
3.76000000000003 | 0.02 | 0.0114
3.77000000000003 | 0.02 | 0.0114
3.78000000000003 | 0.02 | 0.0114
3.79000000000003 | 0.02 | 0.0114
3.80000000000003 | 0.02 | 0.0114
3.81000000000003 | 0.02 | 0.0114
3.82000000000003 | 0.02 | 0.0114
3.83000000000003 | 0.02 | 0.0114
3.84000000000003 | 0.02 | 0.0114
3.85000000000003 | 0.02 | 0.0114
3.86000000000003 | 0.02 | 0.0114
3.87000000000003 | 0.02 | 0.0114
3.88000000000003 | 0.02 | 0.0114
3.89000000000003 | 0.02 | 0.0114
3.90000000000003 | 0.02 | 0.0114
3.91000000000003 | 0.02 | 0.0114
3.92000000000003 | 0.02 | 0.0114
3.93000000000003 | 0.02 | 0.0114
3.94000000000003 | 0.02 | 0.0114
3.95000000000003 | 0.02 | 0.0114
3.96000000000004 | 0.02 | 0.0114
3.97000000000004 | 0.02 | 0.0114
3.98000000000004 | 0.02 | 0.0114
3.99000000000004 | 0.02 | 0.0114
4.00000000000004 | 0.02 | 0.0114
4.01000000000004 | 0.02 | 0.0114
4.02000000000004 | 0.02 | 0.0114
4.03000000000004 | 0.02 | 0.0114
4.04000000000004 | 0.02 | 0.0114
4.05000000000004 | 0.02 | 0.0114
4.06000000000004 | 0.02 | 0.0114
4.07000000000004 | 0.02 | 0.0114
4.08000000000004 | 0.02 | 0.0114
4.09000000000004 | 0.02 | 0.0114
4.10000000000004 | 0.02 | 0.0114
4.11000000000004 | 0.02 | 0.0114
4.12000000000004 | 0.02 | 0.0114
4.13000000000004 | 0.02 | 0.0114
4.14000000000004 | 0.02 | 0.0114
4.15000000000004 | 0.02 | 0.0114
4.16000000000004 | 0.02 | 0.0114
4.17000000000004 | 0.02 | 0.0114
4.18000000000004 | 0.02 | 0.0114
4.19000000000004 | 0.02 | 0.0114
4.20000000000004 | 0.02 | 0.0114
4.21000000000004 | 0.02 | 0.0114
4.22000000000004 | 0.02 | 0.0114
4.23000000000004 | 0.02 | 0.0114
4.24000000000004 | 0.02 | 0.0114
4.25000000000004 | 0.02 | 0.0114
4.26000000000004 | 0.02 | 0.0114
4.27000000000004 | 0.02 | 0.0114
4.28000000000004 | 0.02 | 0.0114
4.29000000000004 | 0.02 | 0.0114
4.30000000000004 | 0.02 | 0.0114
4.31000000000004 | 0.02 | 0.0114
4.32000000000004 | 0.02 | 0.0114
4.33000000000004 | 0.02 | 0.0114
4.34000000000004 | 0.02 | 0.0114
4.35000000000004 | 0.02 | 0.0114
4.36000000000004 | 0.02 | 0.0114
4.37000000000004 | 0.02 | 0.0114
4.38000000000004 | 0.02 | 0.0114
4.39000000000005 | 0.02 | 0.0114
4.40000000000005 | 0.02 | 0.0114
4.41000000000005 | 0.02 | 0.0114
4.42000000000005 | 0.02 | 0.0114
4.43000000000005 | 0.02 | 0.0114
4.44000000000005 | 0.02 | 0.0114
4.45000000000005 | 0.02 | 0.0114
4.46000000000005 | 0.02 | 0.0114
4.47000000000005 | 0.02 | 0.0114
4.48000000000005 | 0.02 | 0.0114
4.49000000000005 | 0.02 | 0.0114
4.50000000000005 | 0.02 | 0.0114
4.51000000000005 | 0.02 | 0.0114
4.52000000000005 | 0.02 | 0.0114
4.53000000000005 | 0.02 | 0.0114
4.54000000000005 | 0.02 | 0.0114
4.55000000000005 | 0.02 | 0.0114
4.56000000000005 | 0.02 | 0.0114
4.57000000000005 | 0.02 | 0.0114
4.58000000000005 | 0.02 | 0.0114
4.59000000000005 | 0.02 | 0.0114
4.60000000000005 | 0.02 | 0.0114
4.61000000000005 | 0.02 | 0.0114
4.62000000000005 | 0.02 | 0.0114
4.63000000000005 | 0.02 | 0.0114
4.64000000000005 | 0.02 | 0.0114
4.65000000000005 | 0.02 | 0.0114
4.66000000000005 | 0.02 | 0.0114
4.67000000000005 | 0.02 | 0.0114
4.68000000000005 | 0.02 | 0.0114
4.69000000000005 | 0.02 | 0.0114
4.70000000000005 | 0.02 | 0.0114
4.71000000000005 | 0.02 | 0.0114
4.72000000000005 | 0.02 | 0.0114
4.73000000000005 | 0.02 | 0.0114
4.74000000000005 | 0.02 | 0.0114
4.75000000000005 | 0.02 | 0.0114
4.76000000000005 | 0.02 | 0.0114
4.77000000000005 | 0.02 | 0.0114
4.78000000000005 | 0.02 | 0.0114
4.79000000000005 | 0.02 | 0.0114
4.80000000000005 | 0.02 | 0.0114
4.81000000000005 | 0.02 | 0.0114
4.82000000000005 | 0.02 | 0.0114
4.83000000000006 | 0.02 | 0.0114
4.84000000000006 | 0.02 | 0.0114
4.85000000000006 | 0.02 | 0.0114
4.86000000000006 | 0.02 | 0.0114
4.87000000000006 | 0.02 | 0.0114
4.88000000000006 | 0.02 | 0.0114
4.89000000000006 | 0.02 | 0.0114
4.90000000000006 | 0.02 | 0.0114
4.91000000000006 | 0.02 | 0.0114
4.92000000000006 | 0.02 | 0.0114
4.93000000000006 | 0.02 | 0.0114
4.94000000000006 | 0.02 | 0.0114
4.95000000000006 | 0.02 | 0.0114
4.96000000000006 | 0.02 | 0.0114
4.97000000000006 | 0.02 | 0.0114
4.98000000000006 | 0.02 | 0.0114
4.99000000000006 | 0.02 | 0.0114
5.00000000000006 | 0.02 | 0.0114