Spreadsheet: 68227d1268762541-consolidating-columns-from-multiple-sheets-budget-example
Sheet: Parks

2010 Budget |  |  |  |  |  |  |  |  |  |  | PAGE: 30.1
 |  |  | [PHONE]-120000 | [PHONE]-120000 | [PHONE]-120000 | [PHONE]-120000 | [PHONE]-120000 | [PHONE]-120000 | [PHONE]-120000
[NAME] |  |  |  | [PHONE]-120000 |  | [PHONE]-120000 |  | [PHONE]-120000 |  | [PHONE]-120000
 |  |  | Sand | Repairs/Mtce |  |  |  |  | Litter
 |  |  | Sifting | Facilities | Equipment | Sundry | Horticulture | Irrigation | Control
Task | Function |  | 0401 | 0402 | 0403 | 0404 | 0405 | 0406 | 0407 |  | TOTAL
0408-01 | [NAME] Supervisor |  |  |  |  |  |  |  |  | 92263
0408-02 | Vehicle Expense - Spvr & Mgr(50%) |  |  |  |  |  |  |  |  | 11940
0408-03 | [NAME] Manager |  |  |  |  |  |  |  |  | 121130
0408-04 | [NAME] Staff (6) |  |  |  |  |  |  |  |  | 33150
99 | General |  | 69780 |  |  | 66052 | 8747
98 | General |  |  |  |  |  |  |  | 119589
01 | Furniture Repairs |  |  | 114449
02 | Hand Irrigation Equipment | * |  |  | 635
03 | Horticulture - Tree Equip |  |  |  | 1581
04 | Horticulture - Misc Equip |  |  |  | 6127
05 | Parks - Misc Equipment |  |  |  | 10926
06 | Weed Control Equipment |  |  |  | 9333
07 | [NAME] |  |  |  | 14199
08 | Hand Tools |  |  |  | 2068
09 | Spraying Equipment |  |  |  | 3132
10 | Water Equip Repair & Placement | * |  | 68131
11 | Pest Management | * |  |  |  | 13352
12 | Inventory Count |  |  |  |  | 2192
13 | Leases |  |  |  |  | 99000
14 | Depreciation |  |  |  | 8447
15 | Office Supplies |  |  |  |  | 1708
16 | Special Projects/Beautification |  |  |  |  | 64000
17 | Recoverable |  |  |  |  | 7154
18 | Electrical - Utilities |  |  |  |  | 8867
19 | Vandalism |  |  |  |  | 46192
20 | Standby Wages |  |  |  |  | 4128
21 | Electrical Repairs |  |  |  |  | 6660
22 | Sign Maintenance |  |  |  |  | 9576
23 | [NAME] |  |  |  |  | 4616
24 | Vandalism - Irrigation |  |  |  |  | 14606
25 | Equipment Training |  |  |  |  | 4306
26 | Telephone |  |  |  |  | 2821
27 | Seasonal services |  |  |  |  | 15356
30 | Spring/Fall Clean up | * |  |  |  |  | 64286
31 | Barrier Spraying |  |  |  |  |  | 22834
32 | Flowers and [NAME] |  |  |  |  |  | 45717
33 | Tree/Shrub Pesticide |  |  |  |  |  | 50873
34 | Tree Fertilizing |  |  |  |  |  | 50795
35 | Tree Planting/Management |  |  |  |  |  | 36231
36 | Tree/Shrub Removal/Pruning |  |  |  |  |  | 221675
37 | Turf Airating |  |  |  |  |  | 11104
38 | [NAME] and Trim |  |  |  |  |  | 7270
39 | [NAME] |  |  |  |  |  | 29526
40 | [NAME] |  |  |  |  |  | 5936
41 | [NAME] |  |  |  |  |  | 160175
42 | [NAME] |  |  |  |  |  | 28561
43 | [NAME] |  |  |  |  |  | 10413
44 | Weed Control |  |  |  |  |  | 83296
45 | Snow Removal |  |  |  |  |  | 55869
46 | [NAME] |  |  |  |  |  | 53190
47 | [NAME] |  |  |  |  |  | 17093
48 | Walkways |  |  |  |  |  | 41917
49 | Nursery |  |  |  |  |  | 3938
50 | Maintenance - Other |  |  |  |  |  | 10054
51 | Irrigation - Labour & Equip | * |  |  |  |  |  | 158672
52 | Supplies and Parts |  |  |  |  |  |  | 45342
53 | Annual Water Charge |  |  |  |  |  |  | 65822
54 | Riverside Park |  |  |  |  | 10772 |  | 412
55 | Channel Parkway |  |  |  |  | 12101
 |  |  | 69780 | 182580 | 56448 | 393459 | 1019500 | 270248 | 119589 | 258483 | 2370087
 | Actual |  | Sand | Repairs/Mtce |  |  |  |  | Litter
 | Feb 5 |  | Sifting | Facilities | Equipment | Sundry | Horticulture | Irrigation | Control
Task | Function |  | 0401 | 0402 | 0403 | 0404 | 0405 | 0406 | 0407 |  | TOTAL
- | - | - | - | - | - | - | - | - | - | - | -
0408-01 | [NAME] Supervisor |  |  |  |  |  |  |  |  | 6941
0408-02 | Vehicle Expense - Spvr & Mgr(50%) |  |  |  |  |  |  |  |  | 1385
0408-03 | [NAME] Manager |  |  |  |  |  |  |  |  | 9554
0408-04 | [NAME] Staff (6) |  |  |  |  |  |  |  |  | 0
99 | General |  | 0 |  |  | 1921 | 0 |  | 0
98 | General |  |  |  |  |  |  |  | 5895
01 | Furniture Repairs |  |  | 9474
02 | Hand Irrigation Equipment |  |  |  | 0
03 | Horticulture - Tree Equip | * |  |  | 0
04 | Horticulture - Misc Equip |  |  |  | 0
05 | Parks - Misc Equipment |  |  |  | 428
06 | Weed Control Equipment |  |  |  | 0
07 | [NAME] |  |  |  | 0
08 | Hand Tools |  |  |  | 0
09 | Spraying Equipment |  |  |  | 0
10 | Water Equip Repair & Placement |  |  | 7
11 | Pest Management | * |  |  |  | 0
12 | Inventory Count | * |  |  |  | 554
13 | Leases |  |  |  |  | 99000
14 | Depreciation |  |  |  | 0
15 | Office Supplies |  |  |  |  | 0
16 | Special Projects/Beautification |  |  |  |  | 0
17 | Recoverable |  |  |  |  | 1255
18 | Electrical - Utilities |  |  |  |  | 0
19 | Vandalism |  |  |  |  | 3330
20 | Standby Wages |  |  |  |  | 424
21 | Electrical Repairs |  |  |  |  | 0
22 | Sign Maintenance |  |  |  |  | 1229
23 | [NAME] |  |  |  |  | 117
24 | Vandalism - Irrigation |  |  |  |  | 0
25 | Equipment Training |  |  |  |  | 212
26 | Telephone |  |  |  |  | 0
27 | Seasonal services |  |  |  |  | 0
30 | Spring/Fall Clean up | * |  |  |  |  | 955
31 | Barrier Spraying |  |  |  |  |  | 18
32 | Flowers and [NAME] |  |  |  |  |  | 7689
33 | Tree/Shrub Pesticide |  |  |  |  |  | 794
34 | Tree Fertilizing |  |  |  |  |  | 0
35 | Tree Planting/Management |  |  |  |  |  | 1093
36 | Tree/Shrub Removal/Pruning |  |  |  |  |  | 31866
37 | Turf Airating |  |  |  |  |  | 0
38 | [NAME] and Trim |  |  |  |  |  | 0
39 | [NAME] |  |  |  |  |  | 0
40 | [NAME] |  |  |  |  |  | 0
41 | [NAME] |  |  |  |  |  | 369
42 | [NAME] |  |  |  |  |  | 0
43 | [NAME] |  |  |  |  |  | 0
44 | Weed Control |  |  |  |  |  | 0
45 | Snow Removal |  |  |  |  |  | 13523
46 | [NAME] |  |  |  |  |  | 691
47 | [NAME] |  |  |  |  |  | 6821
48 | Walkways |  |  |  |  |  | 339
49 | Nursery |  |  |  |  |  | 0
50 | Maintenance - Other |  |  |  |  |  | 0
51 | Irrigation - Labour & Equip | * |  |  |  |  |  | 2907
52 | Supplies and Parts |  |  |  |  |  |  | 0
53 | Annual Water Charge |  |  |  |  |  |  | 0
54 | Riverside Park |  |  |  |  | 0 |  | 0
55 | Channel Parkway |  |  |  |  | 0
 |  |  | - | - | - | - | - | - | - | - | -
 |  |  | 0 | 9481 | 428 | 108042 | 64158 | 2907 | 5895 | 17880 | 208791
 |  |  | = | = | = | = | = | = | = | = | =
 | Variance - Over/(Under) |  | Sand | Repairs/Mtce |  |  |  |  | Litter
 | Feb 5 |  | Sifting | Facilities | Equipment | Sundry | Horticulture | Irrigation | Control
Task | Function |  | 0401 | 0402 | 0403 | 0404 | 0405 | 0406 | 0407 |  | TOTAL
- | - | - | - | - | - | - | - | - | - | - | -
0408-01 | [NAME] Supervisor |  |  |  |  |  |  |  |  | -85322
0408-02 | Vehicle Expense - Spvr & Mgr(50%) |  |  |  |  |  |  |  |  | -10555
0408-03 | [NAME] Manager |  |  |  |  |  |  |  |  | -111576
0408-04 | [NAME] Staff (6) |  |  |  |  |  |  |  |  | -33150
99 | General |  | -69780 |  |  | -64131 | -8747 |  | 0
98 | General |  |  |  |  |  |  |  | -113694
01 | Furniture Repairs |  |  | -104975
02 | Hand Irrigation Equipment |  |  |  | -635
03 | Horticulture - Tree Equip | * |  |  | -1581
04 | Horticulture - Misc Equip |  |  |  | -6127
05 | Parks - Misc Equipment |  |  |  | -10498
06 | Weed Control Equipment |  |  |  | -9333
07 | [NAME] |  |  |  | -14199
08 | Hand Tools |  |  |  | -2068
09 | Spraying Equipment |  |  |  | -3132
10 | Water Equip Repair & Placement |  |  | -68124
11 | Pest Management | * |  |  |  | -13352
12 | Inventory Count | * |  |  |  | -1638
13 | Leases |  |  |  |  | 0
14 | Depreciation |  |  |  |  | -8447
15 | Office Supplies |  |  |  |  | -1708
16 | Special Projects/Beautification |  |  |  |  | -64000
17 | Recoverable |  |  |  |  | -5899
18 | Electrical - Utilities |  |  |  |  | -8867
19 | Vandalism |  |  |  |  | -42862
20 | Standby Wages |  |  |  |  | -3704
21 | Electrical Repairs |  |  |  |  | -6660
22 | Sign Maintenance |  |  |  |  | -8347
23 | [NAME] |  |  |  |  | -4499
24 | Vandalism - Irrigation |  |  |  |  | -14606
25 | Equipment Training |  |  |  |  | -4094
26 | Telephone |  |  |  |  | -2821
27 | Seasonal services |  |  |  |  | -15356
30 | Spring/Fall Clean up | * |  |  |  |  | -63331
31 | Barrier Spraying |  |  |  |  |  | -22816
32 | Flowers and [NAME] |  |  |  |  |  | -38028
33 | Tree/Shrub Pesticide |  |  |  |  |  | -50079
34 | Tree Fertilizing |  |  |  |  |  | -50795
35 | Tree Planting/Management |  |  |  |  |  | -35138
36 | Tree/Shrub Removal/Pruning |  |  |  |  |  | -189809
37 | Turf Airating |  |  |  |  |  | -11104
38 | [NAME] and Trim |  |  |  |  |  | -7270
39 | [NAME] |  |  |  |  |  | -29526
40 | [NAME] |  |  |  |  |  | -5936
41 | [NAME] |  |  |  |  |  | -159806
42 | [NAME] |  |  |  |  |  | -28561
43 | [NAME] |  |  |  |  |  | -10413
44 | Weed Control |  |  |  |  |  | -83296
45 | Snow Removal |  |  |  |  |  | -42346
46 | [NAME] |  |  |  |  |  | -52499
47 | [NAME] |  |  |  |  |  | -10272
48 | Walkways |  |  |  |  |  | -41578
49 | Nursery |  |  |  |  |  | -3938
50 | Maintenance - Other |  |  |  |  |  | -10054
51 | Irrigation - Labour & Equip | * |  |  |  |  |  | -155765
52 | Supplies and Parts |  |  |  |  |  |  | -45342
53 | Annual Water Charge |  |  |  |  |  |  | -65822
54 | Riverside Park |  |  |  |  | -10772 |  | -412
55 | Channel Parkway |  |  |  |  | -12101
 |  |  | - | - | - | - | - | - | - | - | -
 |  |  | -69780 | -173099 | -47573 | -293864 | -955342 | -267341 | -113694 | -240603 | -2161296
 |  |  | = | = | = | = | = | = | = | = | =