Spreadsheet: 153483d1335937916-lock-a-cell-reference-to-a-different-worksheet-from-where-the-cell-is-located-copy-calculator-copy
Sheet: R&F Dec 11 - Feb 12

Period ending: |  | 2012-06-30 00:00:00
Period Pricing Covers: |  | 2011-12-01 00:00:00 | to | 2012-02-29 00:00:00 |  |  |  |  |  |  | Special Event Pricing |  |  |  |  |  |  |  |  |  |  |  |  | Landfill Pricing - Recyclables |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Transfer Station Pricing - Garbage
Where | Equals | % of factor nominated as being proportion applicable to that particular segment (F) | [NAME] 240Ltr MGB | [NAME] (Commercial) - 240Ltr MGB | Recyclables - 240Ltr MGB | Organics - 240Ltr MGB | Clean Up Service - Per Premise | Temporary Service - Mixed Solid Waste - Delivery | Temporary Service - Mixed Solid Waste - 240Ltr MGB | [NAME] | ???? - Temporary Service - Mixed Solid Waste - Delivery | ???? - Temporary Service - Mixed Solid Waste - Delivery | ???? - Temporary Service - Mixed Solid Waste - Delivery | ???? - Temporary Service - Mixed Solid Waste - Delivery | ???? - Temporary Service - Mixed Solid Waste - Delivery | ???? - Temporary Service - Mixed Solid Waste - Delivery | ???? - Temporary Service - Mixed Solid Waste - Delivery | ???? - Temporary Service - Mixed Solid Waste - Delivery | ???? - Temporary Service - Mixed Solid Waste - Delivery | ???? - Temporary Service - Mixed Solid Waste - Delivery | ???? - Temporary Service - Mixed Solid Waste - Delivery | Temporary Service - Recyclables Per Service | Temporary Service - Collection of Waste Per Service | [NAME] (15 & 20 Cubic Metre) - Per Month | ???? - Collection Fee Per Bin/Service | ???? - On Call Collection Fee Per Bin/Service | ???? - Collection Fee Per Bin/Service | ???? - On Call Collection Fee Per Bin/Service | ???? - Collection Fee Per Bin/Service | ???? - On Call Collection Fee Per Bin/Service | ???? - Collection Fee Per Bin/Service | ???? - On Call Collection Fee Per Bin/Service | ???? - Collection Fee Per Bin/Service | ???? - On Call Collection Fee Per Bin/Service | ???? - Collection Fee Per Bin/Service | ???? - On Call Collection Fee Per Bin/Service | ???? - Collection Fee Per Bin/Service | ???? - On Call Collection Fee Per Bin/Service | ???? - Collection Fee Per Bin/Service | ???? - On Call Collection Fee Per Bin/Service | ???? - Collection Fee Per Bin/Service | ???? - On Call Collection Fee Per Bin/Service | Alternative MRF - Per Kilometre Rate | [NAME] (15 & 20 Cubic Metre) - Per Month | ???? - Collection Fee Per Bin/Service | ???? - On Call Collection Fee Per Bin/Service | ???? - Collection Fee Per Bin/Service | ???? - On Call Collection Fee Per Bin/Service | ???? - Collection Fee Per Bin/Service | ???? - On Call Collection Fee Per Bin/Service | Alternative MRF - Per Kilometre Rate | Special Event Recyclables Processing - Per 240Ltr MGB | Landfill Processing of Recyclables - Per Tonne
R | Rise and Fall Amount - Wages | 0.157 | 0.0108 | 0.0108 | 0.024 | 0.0074 | 0.0281 | 0.3135 | 0.0125 | 0.0278 | 0 | 0.6271 | 1.8813 | 1.2542 | 0.6271 | 0.6271 | 0.6271 | 0.9406 | 0.9406 | 1.8813 | 0.9406 | 0.0263 | 0.0263 | 1.6304 | 2.5084 | 5.0167 | 3.449 | 6.898 | 2.5084 | 5.0167 | 2.5084 | 2.5084 | 3.449 | 6.898 | 3.1355 | 6.2709 | 2.5084 | 5.0167 | 2.5084 | 5.0167 | 3.1355 | 6.2709 | 0.0499 | 1.6304 | 2.8219 | 5.6438 | 2.4143 | 4.8286 | 2.8219 | 5.6438 | 0.0499 | 0.0041 | 0.6271
R | Rise and Fall Amount - Fuels & Oils | 0.081 | 0.0014 | 0.0014 | 0.003 | 0.0009 | 0.0035 | 0.0392 | 0.0016 | 0.0035 | 0 | 0.0784 | 0.2352 | 0.1568 | 0.0784 | 0.0784 | 0.0784 | 0.1176 | 0.1176 | 0.2352 | 0.1176 | 0.0033 | 0.0033 | 0.2039 | 0.3136 | 0.6273 | 0.4312 | 0.8625 | 0.3136 | 0.6273 | 0.3136 | 0.3136 | 0.4312 | 0.8625 | 0.392 | 0.7841 | 0.3136 | 0.6273 | 0.3136 | 0.6273 | 0.392 | 0.7841 | 0.0062 | 0.2039 | 0.3528 | 0.7057 | 0.3019 | 0.6037 | 0.3528 | 0.7057 | 0.0062 | 0.0005 | 0.0784
R | Rise and Fall Amount - Management Costs, Profit Return & Other Materials | 0.739 | 0.0674 | 0.0674 | 0.1498 | 0.0463 | 0.175 | 1.9538 | 0.0777 | 0.1733 | 0 | 3.9075 | 11.7225 | 7.815 | 3.9075 | 3.9075 | 3.9075 | 5.8613 | 5.8613 | 11.7225 | 5.8613 | 0.1637 | 0.1637 | 10.1595 | 15.6301 | 31.2601 | 21.4913 | 42.9827 | 15.6301 | 31.2601 | 15.6301 | 15.6301 | 21.4913 | 42.9827 | 19.5376 | 39.0751 | 15.6301 | 31.2601 | 15.6301 | 31.2601 | 19.5376 | 39.0751 | 0.311 | 10.1595 | 17.5838 | 35.1676 | 15.0439 | 30.0879 | 17.5838 | 35.1676 | 0.311 | 0.0254 | 3.9075
R | Rise and Fall Amount - Superannuation | 0.004 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
R | Rise and Fall Amount - Workers Compensation | 0.007 | -0.0006 | -0.0006 | -0.0012 | -0.0004 | -0.0015 | -0.0162 | -0.0006 | -0.0014 | 0 | -0.0324 | -0.0971 | -0.0648 | -0.0324 | -0.0324 | -0.0324 | -0.0486 | -0.0486 | -0.0971 | -0.0486 | -0.0014 | -0.0014 | -0.0842 | -0.1295 | -0.259 | -0.1781 | -0.3562 | -0.1295 | -0.259 | -0.1295 | -0.1295 | -0.1781 | -0.3562 | -0.1619 | -0.3238 | -0.1295 | -0.259 | -0.1295 | -0.259 | -0.1619 | -0.3238 | -0.0026 | -0.0842 | -0.1457 | -0.2914 | -0.1247 | -0.2493 | -0.1457 | -0.2914 | -0.0026 | -0.0002 | -0.0324
R | Rise and Fall Amount - Payroll Tax | 0.012 | -0.0009 | -0.0009 | -0.0021 | -0.0007 | -0.0025 | -0.0275 | -0.0011 | -0.0024 | 0 | -0.055 | -0.165 | -0.11 | -0.055 | -0.055 | -0.055 | -0.0825 | -0.0825 | -0.165 | -0.0825 | -0.0023 | -0.0023 | -0.143 | -0.22 | -0.44 | -0.3025 | -0.605 | -0.22 | -0.44 | -0.22 | -0.22 | -0.3025 | -0.605 | -0.275 | -0.55 | -0.22 | -0.44 | -0.22 | -0.44 | -0.275 | -0.55 | -0.0044 | -0.143 | -0.2475 | -0.495 | -0.2118 | -0.4235 | -0.2475 | -0.495 | -0.0044 | -0.0004 | -0.055
 | Total Rise and Fall Adjustment |  | 0.0781 | 0.0781 | 0.1735 | 0.05350000000000001 | 0.2026 | 2.2628 | 0.0901 | 0.2008 | 0 | 4.525600000000001 | 13.5769 | 9.051200000000001 | 4.525600000000001 | 4.525600000000001 | 4.525600000000001 | 6.7884 | 6.7884 | 13.5769 | 6.7884 | 0.1896 | 0.1896 | 11.7666 | 18.1026 | 36.2051 | 24.8909 | 49.782 | 18.1026 | 36.2051 | 18.1026 | 18.1026 | 24.8909 | 49.782 | 22.6282 | 45.2563 | 18.1026 | 36.2051 | 18.1026 | 36.2051 | 22.6282 | 45.2563 | 0.3601 | 11.7666 | 20.3653 | 40.7307 | 17.4236 | 34.84740000000001 | 20.3653 | 40.7307 | 0.3601 | 0.0294 | 4.525600000000001
T | Tendered amount in contract |  | 0.863 | 0.863 | 1.917 | 0.593 | 2.239 | 25 | 0.994 | 2.218 | 0 | 50 | 150 | 100 | 50 | 50 | 50 | 75 | 75 | 150 | 75 | 2.095 | 2.095 | 130 | 200 | 400 | 275 | 550 | 200 | 400 | 200 | 200 | 275 | 550 | 250 | 500 | 200 | 400 | 200 | 400 | 250 | 500 | 3.98 | 130 | 225 | 450 | 192.5 | 385 | 225 | 450 | 3.98 | 0.325 | 50
 | New Contract Price |  | 0.9411 | 0.9411 | 2.0905 | 0.6465 | 2.4416 | 27.2628 | 1.0841 | 2.4188 | 0 | 54.5256 | 163.5769 | 109.0512 | 54.5256 | 54.5256 | 54.5256 | 81.7884 | 81.7884 | 163.5769 | 81.7884 | 2.2846 | 2.2846 | 141.7666 | 218.1026 | 436.2051 | 299.8909 | 599.782 | 218.1026 | 436.2051 | 218.1026 | 218.1026 | 299.8909 | 599.782 | 272.6282 | 545.2563 | 218.1026 | 436.2051 | 218.1026 | 436.2051 | 272.6282 | 545.2563 | 4.3401 | 141.7666 | 245.3653 | 490.7307 | 209.9236 | 419.8474 | 245.3653 | 490.7307 | 4.3401 | 0.3544 | 54.5256
 |  |  | 0.8742 | 0.8742 | 1.9422 | 0.6008 | 2.2683 | 25.3275 | 1.0071 | 2.2472 | 0 | 50.6551 | 151.9654 | 101.3102 | 50.6551 | 50.6551 | 50.6551 | 75.9826 | 75.9826 | 151.9654 | 75.9826 | 2.1225 | 2.1225 | 131.7033 | 202.6205 | 405.2409 | 278.6031 | 557.2062 | 202.6205 | 405.2409 | 202.6205 | 202.6205 | 278.6031 | 557.2062 | 253.2755 | 506.5511 | 202.6205 | 405.2409 | 202.6205 | 405.2409 | 253.2755 | 506.5511 | 4.032 | 131.7033 | 227.9481 | 455.896 | 195.0222 | 390.0445 | 227.9481 | 455.896 | 4.032 | 0.3292 | 50.6551
 |  |  | -0.06690000000000007 | -0.06690000000000007 | -0.1482999999999999 | -0.04569999999999996 | -0.1732999999999998 | -1.935299999999998 | -0.07700000000000018 | -0.1716000000000002 | 0 | -3.8705 | -11.61150000000001 | -7.741 | -3.8705 | -3.8705 | -3.8705 | -5.805799999999991 | -5.805799999999991 | -11.61150000000001 | -5.805799999999991 | -0.1621000000000001 | -0.1621000000000001 | -10.0633 | -15.4821 | -30.96420000000001 | -21.2878 | -42.57580000000007 | -15.4821 | -30.96420000000001 | -15.4821 | -15.4821 | -21.2878 | -42.57580000000007 | -19.3527 | -38.70519999999999 | -15.4821 | -30.96420000000001 | -15.4821 | -30.96420000000001 | -19.3527 | -38.70519999999999 | -0.3080999999999996 | -10.0633 | -17.41719999999998 | -34.8347 | -14.9014 | -29.80289999999997 | -17.41719999999998 | -34.8347 | -0.3080999999999996 | -0.0252 | -3.8705 | -701.3116
 |  |  | 0.09049826187717266 | 0.09049826187717266 | 0.09050599895670318 | 0.09021922428330524 | 0.09048682447521215 | 0.090512 | 0.09064386317907444 | 0.09053201082055905 | #N/A | 0.09051200000000001 | 0.09051266666666669 | 0.09051200000000001 | 0.09051200000000001 | 0.09051200000000001 | 0.09051200000000001 | 0.09051200000000001 | 0.09051200000000001 | 0.09051266666666669 | 0.09051200000000001 | 0.09050119331742243 | 0.09050119331742243 | 0.0905123076923077 | 0.09051300000000001 | 0.09051275 | 0.09051236363636363 | 0.09051272727272727 | 0.09051300000000001 | 0.09051275 | 0.09051300000000001 | 0.09051300000000001 | 0.09051236363636363 | 0.09051272727272727 | 0.09051280000000002 | 0.09051260000000001 | 0.09051300000000001 | 0.09051275 | 0.09051300000000001 | 0.09051275 | 0.09051280000000002 | 0.09051260000000001 | 0.09047738693467336 | 0.0905123076923077 | 0.09051244444444444 | 0.09051266666666666 | 0.0905122077922078 | 0.09051272727272729 | 0.09051244444444444 | 0.09051266666666666 | 0.09047738693467336 | 0.09046153846153845 | 0.09051200000000001
A | The amount specified in Australian Fair Pay Commission Pay Scale Transport Industry - WASTE COLLECTION & RECYCLING (State) Award AN120614-Clause 2, as revised and published from time to time. | [NAME] | 22.44 | OK | NB: Transport Industry Award replaced by Waste Management Award 2010 - transitional arrangements apply
B | The amount specified in Australian Fair Pay Commission Pay Scale Transport Industry - WASTE COLLECTION & RECYCLING (State) Award AN120614-Clause 2, as at the Closing Date. | [NAME] | 20.78
C | The index number allocated by the Australian Bureau of Statistics in the Consumer Price Index Catalogue No. 6401.0, Table 7, Transportation - Automotive Fuel as revised and published from time to time by the aforesaid Bureau. |  | 242.2 | OK
D | The index number allocated by the Australian Bureau of Statistics in the Consumer Price Index Catalogue No. 6401.0, Table 7, Transportation = Automotive Fuel existing as at the Closing Date. |  | 237.6
H | The index number allocated by the Australian Bureau of Statistics as the Consumer Price Index: All [NAME] existing as revised and published from time to time by the aforesaid Bureau. |  | 178.8 | OK
J | The index number allocated by the Australian Bureau of Statistics as the Consumer Price Index: All [NAME] existing as at the Closing Date and shall take effect from the first day of the quarter following the quarter in which the variation occurred. |  | 161.7
K | Change in contributions under the Federal Superannuation Guarantee Legislation. Superannuation - as revised and published from time to time by the Australian Tax Office |  | 0.09 | OK
L | Change in contributions under the Federal Superannuation Guarantee Legislation. Superannuation - as revised and published as at the Closing Date and shall take effect from the first day of the quarter in which the variation occurred. |  | 0.09
M | Changes in gazetted rates by the WorkCover Authority of NSW. Workers Compensation Industry Rate - as revised and published from time to time by the WorkCover Authority of NSW. |  | 0.0513 | OK
N | Changes in gazetted rates by the WorkCover Authority of NSW. Workers Compensation Industry Rate - as revised and published as at the Closing Date and shall take effect from the first day of the quarter following the quarter in which the variation occurred. |  | 0.05653
O | Changes in Payroll Tax legislation. Payroll Tax Legislation - as revised and published from time to time by the Office of State Revenue. |  | 0.0545 | OK
P | Changes in Payroll Tax legislation. Payroll Tax Legislation - as revised and published as at the Closing Date and shall take effect from the first day of the quarter following the quarter in which the variation occurred. |  | 0.06
 | Calculation | Wages | R = T (A - B) F
 |  |  | B
 |  | Fuel | R = T (C - D) F
 |  |  | D
 |  | Management & Profit | R = T (H - J) F
 |  |  | J
 |  | Superannuation | R = T (K - L) F
 |  |  | L
 |  | Workers comp | R = T (M - N) F
 |  |  | N
 |  | Payroll Tax | R = T (O - P) F
 |  |  | P
 |  | Fixed
 |  | Variable