Spreadsheet: 65623d1266336666-index-and-match-formulas-sample
Sheet: Variable Cost

 | Variable Cost
 | 060987 | 1000 | 2000 | 3000 | 4000 | 5000 | 7500 | 10000 | 15000 | 20000 | 25000 | 30000 | 35000 | 40000 | 45000 | 50000 | 60000 | 70000 | 80000 | 90000 | 100000 | 125000 | 150000 | 175000 | 200000 | 225000 | 250000 | 275000
 | 4 color | 1648.18 | 1660.82 | 1743.04 | 1777.51 | 1868.62 | 2065.59 | 2258.86 | 2615.34 | 2953.73 | 3320.11 | 3659.18 | 4023.91 | 4356.09 | 4732.26 | 5106.98 | 5776.9 | 6514.76 | 7143.77 | 7867.83 | 8505.44 | 10289.37 | 12078.18 | 13863.44 | 15650.94 | 17437.77 | 19222.22 | See Estimating
 | 5 color | 1741.98 | 1755.7 | 1837.92 | 1872.39 | 1963.5 | 2159.4 | 2353.73 | 2710.23 | 3048.63 | 3414.99 | 3754.07 | 4118.79 | 4450.98 | 4826.14 | 5201.87 | 5871.78 | 6609.66 | 7238.66 | 7962.71 | 8600.34 | 10384.25 | 12173.06 | 13958.34 | 15745.83 | 17532.65 | 19317.1 | See Estimating
 | 6 color | 1836.87 | 1850.59 | 1932.82 | 1967.28 | 2058.38 | 2254.29 | 2448.61 | 2805.11 | 3143.51 | 3509.89 | 3848.96 | 4213.68 | 4545.86 | 4921.02 | 5296.76 | 5966.68 | 6704.54 | 7333.54 | 8057.61 | 8695.22 | 10479.15 | 12267.94 | 14053.22 | 15840.72 | 17627.55 | 19411.99 | See Estimating
 | 060955 | 1000 | 2000 | 3000 | 4000 | 5000 | 7500 | 10000 | 15000 | 20000 | 25000 | 30000 | 35000 | 40000 | 45000 | 50000 | 60000 | 70000 | 80000 | 90000 | 100000 | 125000 | 150000 | 175000 | 200000 | 225000 | 250000 | 275000
 | 5 color | 1722 | 1812.04 | 1776.9 | 1837.32 | 1889.35 | 1993.57 | 2130.74 | 2363.15 | 2608.59 | 2833.7 | 3061.07 | 3285.18 | 3511.15 | 3767.79 | 4021.81 | 4459.99 | 4957.11 | 5332.31 | 5814.31 | 6296.99 | 7444.15 | 8622.74 | 9782.57 | 10877.58 | 12052.9 | 13226.92 | See Estimating
 | 6 color | 1823.05 | 1913.1 | 1877.95 | 1938.38 | 1990.42 | 2094.63 | 2231.8 | 2464.21 | 2709.63 | 2934.76 | 3161.05 | 3386.23 | 3612.21 | 3868.85 | 4122.86 | 4559.97 | 5058.16 | 5915.38 | 5915.38 | 6396.97 | 7545.2 | 8723.8 | 9882.55 | 10978.63 | 12152.88 | 13326.9 | See Estimating
 | 060900 | 1000 | 2000 | 3000 | 4000 | 5000 | 7500 | 10000 | 15000 | 20000 | 25000 | 30000 | 35000 | 40000 | 45000 | 50000 | 60000 | 70000 | 80000 | 90000 | 100000 | 125000 | 150000 | 175000 | 200000 | 225000 | 250000 | 275000
 | 5 color | 1782.85 | 1794.2 | 1883.86 | 1919.59 | 2016.87 | 2226.26 | 2434.34 | 2816.88 | 3182.33 | 3575.99 | 3941.04 | 4334.09 | 4691.07 | 5093.48 | 5495.35 | 6217.31 | 7010.65 | 7691.62 | 8467.89 | 9155.93 | 11074.46 | 12994.73 | 14913.6 | 16834.64 | 18755.04 | 20674.13 | See Estimating
 | 6 color | 1881.51 | 1892.86 | 1982.5 | 2018.24 | 3031.75 | 3277.7 | 3519.83 | 3967.2 | 4384.46 | 4853.53 | 5271.37 | 5736.36 | 6134.08 | 6603.72 | 7075.81 | 7892.42 | 8817.29 | 9604.52 | 10509.46 | 11278.06 | 13502.98 | 15731.24 | 17956.57 | 20184.6 | 22411.98 | 24636.25 | See Estimating
 | 060996 | 1000 | 2000 | 3000 | 4000 | 5000 | 7500 | 10000 | 15000 | 20000 | 25000 | 30000 | 35000 | 40000 | 45000 | 50000 | 60000 | 70000 | 80000 | 90000 | 100000 | 125000 | 150000 | 175000 | 200000 | 225000 | 250000 | 275000
 | 5 color | 1687.9 | 1704.05 | 1777.31 | 1811.51 | 1894.99 | 2077.62 | 2254.05 | 2581.75 | 2891.41 | 3226.56 | 3536.89 | 3870.44 | 4175.12 | 4519.18 | 4864.87 | 5476.09 | 6152.85 | 6725.49 | 7388.5 | 7973.63 | 9610 | 11249.14 | 12885.83 | 14524.71 | 12432.86 | 13611.98 | See Estimating
 | 6 color | 1776.65 | 1792.79 | 1866.05 | 1900.24 | 1983.72 | 2166.37 | 2342.8 | 2670.48 | 2981.23 | 3316.39 | 3626.71 | 3960.27 | 4264.94 | 4609 | 4953.6 | 5564.83 | 6242.67 | 6814.23 | 7477.25 | 8063.46 | 9699.82 | 11337.89 | 12974.57 | 14614.52 | 16251.69 | 17888.59 | See Estimating
 | 061151 | 1000 | 2000 | 3000 | 4000 | 5000 | 7500 | 10000 | 15000 | 20000 | 25000 | 30000 | 35000 | 40000 | 45000 | 50000 | 60000 | 70000 | 80000 | 90000 | 100000 | 125000 | 150000 | 175000 | 200000 | 225000 | 250000 | 275000
 | 5 color | 1588.73 | 1652.66 | 1635.08 | 1680.62 | 1716.64 | 1805.85 | 1908.68 | 2087.85 | 2272.59 | 2441.97 | 2614.94 | 2780.73 | 2957.28 | 3154.75 | 3351.68 | 3681.02 | 4064.17 | 4334.2 | 4701.34 | 5070.2 | 5942.41 | 6837.78 | 7724.33 | 8560.76 | 9456.65 | 10353.34 | See Estimating
 | 6 color | 1672.51 | 1736.44 | 1718.86 | 1765.47 | 1801.49 | 1889.63 | 1993.53 | 2172.71 | 2357.43 | 2526.82 | 2698.71 | 2864.5 | 3042.13 | 3239.59 | 3435.46 | 3764.81 | 4147.95 | 4417.98 | 4786.19 | 5153.98 | 6026.19 | 6921.56 | 7808.1 | 8645.62 | 9541.5 | 10438.2 | See Estimating
 | 060995 .016 | 1000 | 2000 | 3000 | 4000 | 5000 | 7500 | 10000 | 15000 | 20000 | 25000 | 30000 | 35000 | 40000 | 45000 | 50000 | 60000 | 70000 | 80000 | 90000 | 100000 | 125000 | 150000 | 175000 | 200000 | 225000 | 250000 | 275000
 | 5 color | 1656.06 | 1752.85 | 1808.9 | 1912.89 | 2006.52 | 2229.43 | 2443.44 | 2832.18 | 3265.67 | 3655.5 | 4036.08 | 4452.73 | 4881.07 | 5267.44 | 5692.93 | 6478.17 | 7318 | 8006.39 | 8827.84 | 9647.68 | 11701.89 | 13754.37 | 15808.57 | 17863.45 | 19916.55 | 21969.1 | See Estimating
 | 6 color | 1747.32 | 1844.09 | 1900.15 | 2005.23 | 2097.78 | 2321.76 | 2535.76 | 2923.44 | 3358 | 3749.74 | 4127.35 | 4545.07 | 4973.39 | 5358.7 | 5784.19 | 6570.51 | 7410.35 | 8097.64 | 8920.18 | 9739.99 | 12104.77 | 13846.71 | 15900.91 | 17954.71 | 20008.88 | 22061.42 | See Estimating
 | 060995 .020 | 1000 | 2000 | 3000 | 4000 | 5000 | 7500 | 10000 | 15000 | 20000 | 25000 | 30000 | 35000 | 40000 | 45000 | 50000 | 60000 | 70000 | 80000 | 90000 | 100000 | 125000 | 150000 | 175000 | 200000 | 225000 | 250000 | 275000
 | 5 color | 1703.49 | 1814.28 | 1875.7 | 1990.49 | 2095.95 | 2343.63 | 2583.48 | 3018.55 | 3505.86 | 3944.17 | 4373.21 | 4842.62 | 5321.57 | 5756.42 | 6232.53 | 7116.84 | 8058.97 | 8839.97 | 9761.6 | 10682.65 | 12986.73 | 15291.22 | 17595.27 | 19901.07 | 22206.19 | 24508.58 | See Estimating
 | 6 color | 1800.14 | 1911.99 | 1973.42 | 2088.22 | 2192.6 | 2440.28 | 2681.19 | 3116.28 | 3603.58 | 4041.88 | 4470.95 | 4940.35 | 5419.29 | 5854.15 | 6329.18 | 7214.57 | 8156.71 | 8937.69 | 9859.33 | 10779.28 | 13084.45 | 15387.87 | 17693.01 | 19998.8 | 22302.83 | 24606.3 | See Estimating
 | 070913 | 1000 | 2000 | 3000 | 4000 | 5000 | 7500 | 10000 | 15000 | 20000 | 25000 | 30000 | 35000 | 40000 | 45000 | 50000 | 60000 | 70000 | 80000 | 90000 | 100000 | 125000 | 150000 | 175000 | 200000 | 225000 | 250000 | 275000
 | 5 color | 1779.75 | 1894.16 | 1853.63 | 1920.39 | 2004.25 | 2131.06 | 2299.79 | 2591.52 | 2893.21 | 3176.6 | 3441.33 | 3745.61 | 4065.51 | 4345.55 | 4660.81 | 5207.81 | 5824.95 | 6373.25 | 6928.95 | 7530.99 | 8990.06 | 10387.25 | 11869.6 | 13349.94 | 14827.9 | 16310.25 | See Estimating
 | 6 color | 1885.76 | 2000.18 | 1958.58 | 2026.41 | 2110.28 | 2238.07 | 2405.83 | 2696.47 | 2998.16 | 3281.54 | 3546.28 | 3851.62 | 4171.52 | 4450.5 | 4765.75 | 5312.76 | 5930.97 | 6478.21 | 7034.97 | 7637.01 | 9096.09 | 10493.28 | 11974.55 | 13455.97 | 14933.93 | 16415.21 | See Estimating
 | 081275 | 1000 | 2000 | 3000 | 4000 | 5000 | 7500 | 10000 | 15000 | 20000 | 25000 | 30000 | 35000 | 40000 | 45000 | 50000 | 60000 | 70000 | 80000 | 90000 | 100000 | 125000 | 150000 | 175000 | 200000 | 225000 | 250000 | 275000
 | 5 color | 1702.41 | 1714.46 | 1789.15 | 1819.93 | 1903.33 | 2083.95 | 2260.38 | 2582.49 | 2887.83 | 3221.25 | 3527.35 | 3859.01 | 4158.37 | 4499.96 | 4839.92 | 5445.86 | 6114.13 | 6677.73 | 7333.16 | 7908.01 | 9526.89 | 11146.88 | 12763.5 | 14384.15 | 16003.04 | 17621.38 | See Estimating
 | 6 color | 1794.76 | 1806.81 | 1881.49 | 1911.19 | 1995.69 | 2176.3 | 2352.72 | 2674.84 | 2980.18 | 3313.61 | 3619.69 | 3951.37 | 4250.73 | 4592.33 | 4931.19 | 5537.14 | 6206.47 | 6770.09 | 7425.52 | 8000.35 | 9619.24 | 11238.14 | 12854.77 | 14476.51 | 16095.39 | 17712.65 | See Estimating
 | 080757 | 1000 | 2000 | 3000 | 4000 | 5000 | 7500 | 10000 | 15000 | 20000 | 25000 | 30000 | 35000 | 40000 | 45000 | 50000 | 60000 | 70000 | 80000 | 90000 | 100000 | 125000 | 150000 | 175000 | 200000 | 225000 | 250000 | 275000
 | 5 color | 1636.08 | 1720.29 | 1837.52 | 1933.57 | 2046.47 | 2312.39 | 2548.16 | 3047.27 | 3523.31 | 4022.3 | 4485.63 | 4983.59 | 5460.04 | 5967.35 | 6405.12 | 7376.49 | 8372.95 | 9301.61 | 10289.78 | 11276.89 | 13745.48 | 16214.08 | 18682.67 | 21152.43 | 23622.7 | 26091.3 | See Estimating
 | 6 color | 1721.05 | 1805.26 | 1922.48 | 2019.62 | 2131.43 | 2397.36 | 2634.2 | 3132.25 | 3609.36 | 4108.34 | 4570.6 | 5068.56 | 5545 | 6053.4 | 6491.17 | 7462.54 | 8459.01 | 9387.66 | 10374.76 | 11361.85 | 13830.44 | 16299.06 | 18768.73 | 21237.4 | 23707.66 | 26177.35 | See Estimating
 | 090060 | 1000 | 2000 | 3000 | 4000 | 5000 | 7500 | 10000 | 15000 | 20000 | 25000 | 30000 | 35000 | 40000 | 45000 | 50000 | 60000 | 70000 | 80000 | 90000 | 100000 | 125000 | 150000 | 175000 | 200000 | 225000 | 250000 | 275000
 | 5 color | 1598.85 | 1665.23 | 1646.38 | 1694.22 | 1731.5 | 1820.89 | 1927.29 | 2110.29 | 2299.99 | 2473.21 | 2651.08 | 2820.74 | 3002.13 | 3204.54 | 3405.34 | 3743.41 | 4134.29 | 4413 | 4789.99 | 5167.64 | 6061.19 | 6979.01 | 7886.84 | 8743.35 | 9662.74 | 10579.69 | See Estimating
 | 6 color | 1684.97 | 1751.33 | 1732.49 | 1779.26 | 1816.54 | 1907 | 2012.32 | 2196.4 | 2386.1 | 2559.33 | 2736.12 | 2906.86 | 3088.25 | 3290.65 | 3491.45 | 3829.52 | 4220.41 | 4499.1 | 4876.11 | 5253.76 | 6146.22 | 7065.14 | 7972.94 | 8829.46 | 9474.78 | 10665.82 | See Estimating