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