Embed
Email

Operating Expense - Town of Morrisville

Document Sample

Shared by: gegeshandong
Categories
Tags
Stats
views:
0
posted:
12/28/2011
language:
pages:
17
Administration Description FY11 Plan FY12 Plan FY13 Plan FY14 Plan FY15 Plan FY11 Unfunded FY12 Unfunded FY13 unfunded FY14 Unfunded FY15 Unfunded

Acct # Totals Unused Rows Hidden $ 448,494.72 $ 459,922.87 $ 471,715.80 $ 483,623.82 $ 501,019.62 $ 13,847.58 $ 13,984.58 $ 13,887.80 $ 13,901.08 $ 13,934.43

10041204071710 Other Fringe Benefits $ 6,152 $ 6,152.00 $ 6,152.00 $ 6,152.00 $ 6,152.00 $ - $ - $ - $ - $ -

10041204202210 Supplies - Food $ 500 $ 507.50 $ 516.13 $ 526.45 $ 542.24 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00

10041204202610 Supplies $ 13,306 $ 13,505.09 $ 13,734.68 $ 14,009.37 $ 14,429.65 $ - $ - $ - $ - $ -

10041204202620 Dept Supplies - Admin $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -

10041204252501 Automotive - Fuel $ 356 $ 355.50 $ 360.83 $ 368.05 $ 379.09 $ - $ - $ - $ - $ -

10041204313110 Employee Travel and Training $ 6,564 $ 6,564.00 $ 6,564.00 $ 6,564.00 $ 6,564.00 $ 3,797.50 $ 3,807.50 $ 3,817.50 $ 3,817.50 $ 3,837.50

10041204313112 Training - Development $ - $ - $ - $ - $ - $ 2,925.00 $ 2,925.00 $ 2,925.00 $ 2,925.00 $ 2,925.00

10041204323221 All Communications $ 6,290 $ 6,289.68 $ 6,762.03 $ 7,461.75 $ 8,667.79 $ 622.08 $ 622.08 $ 628.30 $ 634.58 $ 640.93

10041204323225 Postage $ 17,588 $ 18,291.52 $ 18,840.27 $ 19,217.07 $ 19,409.24 $ - $ - $ - $ - $ -

10041204343449 Public Information $ 20,450 $ 20,859.00 $ 21,276.18 $ 21,701.70 $ 22,135.74 $ 1,950.00 $ 1,950.00 $ 1,950.00 $ 1,950.00 $ 1,950.00

10041204353552 Repair/Maint - Equipment $ 9,000 $ 9,000.00 $ 9,000.00 $ 9,000.00 $ 9,000.00 $ - $ - $ - $ - $ -

10041204434339 Equipment Rental $ 11,800 $ 11,800.00 $ 11,800.00 $ 11,800.00 $ 11,800.00 $ 4,200.00 $ 4,320.00 $ 4,200.00 $ 4,200.00 $ 4,200.00

10041204465610 Insurance - Workers Comp $ 186,057 $ 191,057.28 $ 196,057.28 $ 201,057.28 $ 206,057.28 $ - $ - $ - $ - $ -

10041204465620 Insurance and Bonds $ 166,000 $ 171,000.00 $ 176,000.00 $ 181,000.00 $ 191,000.00 $ - $ - $ - $ - $ -

10041204914710 Dues & Subscriptions $ 4,433 $ 4,541.30 $ 4,652.41 $ 4,766.15 $ 4,882.58 $ 253.00 $ 260.00 $ 267.00 $ 274.00 $ 281.00

10041204917410 Equipment-Expense $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -



4.89% 2.55% 2.56% 2.52% 3.60%

Control Variables from Budget

Account Number 100-4120-407.17-10 2009 2009 $ 5,903.49 Use this format for entering the









entries to the right)

Comments (Make

Account Title Other Fringe Benefits 2010 2010 $ 6,000.00 100 -4120 -401 .12 -10

Department Administration 2011 2011 $ 6,152.00 $ - 100 -4120 -407 .17 -10

Purpose of Account: 2012 2012 $ 6,152.00 $ -

Employer provided benefits to be considered as income to the employee. 2013 2013 $ 6,152.00 $ -

2014 2014 $ 6,152.00 $ -

2015 2015 $ 6,152.00 $ -

2011 2012 2013 2014 2015

Vendor Service/Product

Unit Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost

Total Estimated Budget [THIS LINE IS CALCULATED - MAKE NO ENTRIES] $ 6,152.00 $ 6,152.00 $ 6,152.00 $ 6,152.00 $ 6,152.00

John A. Whitson Vehicle Allowance Monthly $ 416.67 12 $ 5,000.00 $ 416.67 12 $ 5,000.00 $ 416.67 12 $ 5,000.00 $ 416.67 12 $ 5,000.00 $ 416.67 12 $ 5,000.00

Stacie Galloway Cell Phone Allowance Monthly $ 48.00 12 $ 576.00 $ 48.00 12 $ 576.00 $ 48.00 12 $ 576.00 $ 48.00 12 $ 576.00 $ 48.00 12 $ 576.00

Diana Davis Cell Phone Allowance Monthly $ 48.00 12 $ 576.00 $ 48.00 12 $ 576.00 $ 48.00 12 $ 576.00 $ 48.00 12 $ 576.00 $ 48.00 12 $ 576.00









Identified and Unfunded Identified and Unfunded

TOTALS $ - $ - $ - $ - $ -









2011 2012 2013 2014 2015

$ - $ - $ - $ - $ -

Account Number 100-4120-420.22-10 2009 2009 $ - Use this format for entering the









entries to the right)

Comments (Make

Account Title Supplies - Food 2010 2010 $ 500.00 100 -4120 -401 .12 -10

Department Administration 2011 2011 $ 500.00 $ 100.00 100 -4120 -420 .22 -10

Purpose of Account: 2012 2012 $ 507.50 $ 100.00

Purchase of personal consumption supplies related to meeting support in 2013 2013 $ 516.13 $ 100.00

order to isolate these costs from other supplies to meet IRS Income 2014 2014 $ 526.45 $ 100.00

Taxing regulations. 2015 2015 $ 542.24 $ 100.00

2011 2012 2013 2014 2015

Vendor Service/Product

Unit Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost

Total Estimated Budget [THIS LINE IS CALCULATED - MAKE NO ENTRIES] $ 500.00 $ 507.50 $ 516.13 $ 526.45 $ 542.24

Various Snacks/Lunch for Vaious Meetings Each $ 25.00 20 $ 500.00 $ 25.38 20 $ 507.50 $ 25.81 20 $ 516.13 $ 26.32 20 $ 526.45 $ 27.11 20 $ 542.24









Identified and Unfunded Identified and Unfunded

TOTALS $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00

Various Snacks/Lunch for Vaious Meetings Each $ 25.00 4 $ 100.00 $ 25.00 4 $ 100.00 $ 25.00 4 $ 100.00 $ 25.00 4 $ 100.00 $ 25.00 4 $ 100.00









2011 2012 2013 2014 2015

$ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00

Account Number 100-4120-420.26-10 2009 2009 $ 10,389.91 Use this format for entering the









entries to the right)

Comments (Make

Account Title Supplies 2010 2010 $ 13,000.00 100 -4120 -401 .12 -10

Department Administration 2011 2011 $ 13,305.51 $ - 100 -4120 -420 .26 -10

Purpose of Account: 2012 2012 $ 13,505.09 $ -

Purchase of highly consumable items or items of small unit costs to be 2013 2013 $ 13,734.68 $ -

used by the department to properly conduct its business. 2014 2014 $ 14,009.37 $ -

2015 2015 $ 14,429.65 $ -

2011 2012 2013 2014 2015

Vendor Service/Product

Unit Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost

Total Estimated Budget [THIS LINE IS CALCULATED - MAKE NO ENTRIES] $ 13,305.51 $ 13,505.09 $ 13,734.68 $ 14,009.37 $ 14,429.65

Office Depot Copier/Printer Paper (8.5 x 11) Reem $ 3.50 1,950 $ 6,825.00 $ 3.55 1,950 $ 6,927.38 $ 3.61 1,950 $ 7,045.14 $ 3.69 1,950 $ 7,186.04 $ 3.80 1,950 $ 7,401.62

Writing Tablets (8.5 x 11) Pad $ 1.66 50 $ 83.00 $ 1.68 50 $ 84.25 $ 1.71 50 $ 85.68 $ 1.75 50 $ 87.39 $ 1.80 50 $ 90.01

Writing Tablets (5 x 8) Pad $ 1.00 30 $ 30.00 $ 1.02 30 $ 30.45 $ 1.03 30 $ 30.97 $ 1.05 30 $ 31.59 $ 1.08 30 $ 32.53

Interoffice Envelopes Each $ 0.3438 100 $ 34.38 $ 0.35 100 $ 34.90 $ 0.35 100 $ 35.49 $ 0.36 100 $ 36.20 $ 0.37 100 $ 37.28

Security Mailers (10 x 13) Each $ 0.3695 100 $ 36.95 $ 0.38 100 $ 37.50 $ 0.38 100 $ 38.14 $ 0.39 100 $ 38.90 $ 0.40 100 $ 40.07

Clasp Envelope (10 x 13) Each $ 0.1349 200 $ 26.98 $ 0.14 200 $ 27.38 $ 0.14 200 $ 27.85 $ 0.14 200 $ 28.41 $ 0.15 200 $ 29.26

Mailing Envelope (9 x 12) Each $ 0.0924 500 $ 46.20 $ 0.09 500 $ 46.89 $ 0.10 500 $ 47.69 $ 0.10 500 $ 48.64 $ 0.10 500 $ 50.10

Copier/Printer Paper (8.5 x 14) Reem $ 4.27 300 $ 1,281.00 $ 4.33 300 $ 1,300.22 $ 4.41 300 $ 1,322.32 $ 4.50 300 $ 1,348.77 $ 4.63 300 $ 1,389.23

Copier/Printer Paper (11 x 17) Reem $ 9.58 200 $ 1,916.00 $ 9.72 200 $ 1,944.74 $ 9.89 200 $ 1,977.80 $ 10.09 200 $ 2,017.36 $ 10.39 200 $ 2,077.88

Printer Ink Cartridge - Black Each $ 21.00 20 $ 420.00 $ 21.32 20 $ 426.30 $ 21.68 20 $ 433.55 $ 22.11 20 $ 442.22 $ 22.77 20 $ 455.48

Printer Ink Cartridge - Color Each $ 36.00 10 $ 360.00 $ 36.54 10 $ 365.40 $ 37.16 10 $ 371.61 $ 37.90 10 $ 379.04 $ 39.04 10 $ 390.42

Printer Toner Each $ 259.00 4 $ 1,036.00 $ 262.89 4 $ 1,051.54 $ 267.35 4 $ 1,069.42 $ 272.70 4 $ 1,090.80 $ 280.88 4 $ 1,123.53

Printer Drum Each $ 130.00 2 $ 260.00 $ 131.95 2 $ 263.90 $ 134.19 2 $ 268.39 $ 136.88 2 $ 273.75 $ 140.98 2 $ 281.97

Misc Desk Supplies $ 750.00 1 $ 750.00 $ 761.25 1 $ 761.25 $ 774.19 1 $ 774.19 $ 789.68 1 $ 789.68 $ 813.37 1 $ 813.37

$ - $ - $ - $ -

Pitney Bowes Mailing Machine Supplies $ 200.00 1 $ 200.00 $ 203.00 1 $ 203.00 $ 206.45 1 $ 206.45 $ 210.58 1 $ 210.58 $ 216.90 1 $ 216.90









Identified and Unfunded Identified and Unfunded

TOTALS $ - $ - $ - $ - $ -









2011 2012 2013 2014 2015

$ - $ - $ - $ - $ -

Account Number 100-4120-420.26-20 2009 2009 $ 5,410.13 Use this format for entering the









entries to the right)

Comments (Make

Account Title Supplies - Admin 2010 2010 $ - 100 -4120 -401 .12 -10

Department Administration 2011 2011 $ - $ - 100 -4120 -420 .26 -20

Purpose of Account: 2012 2012 $ - $ -

Purchase of highly consumable items or items of small unit costs to be 2013 2013 $ - $ -

used by the department to properly conduct its business [used by 2014 2014 $ - $ -

departments that also purchase supplies for other entities]. 2015 2015 $ - $ -

2011 2012 2013 2014 2015

Vendor Service/Product

Unit Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost

Total Estimated Budget [THIS LINE IS CALCULATED - MAKE NO ENTRIES] $ - $ - $ - $ - $ -









Identified and Unfunded Identified and Unfunded

TOTALS $ - $ - $ - $ - $ -









2011 2012 2013 2014 2015

$ - $ - $ - $ - $ -

Account Number 100-4120-425.25-01 2009 2009 $ 300.95 Use this format for entering the









entries to the right)

Comments (Make

Account Title Automotive - Fuel 2010 2010 $ 420.00 100 -4120 -401 .12 -10

Department Administration 2011 inflation flat 2011 $ 355.50 $ - 100 -4120 -425 .25 -01

Purpose of Account: 2012 inflation flat 2012 $ 355.50 $ -

Purchase of fuel for town equipment and vehicles. 2013 increase 1.5% inflation 2013 $ 360.83 $ -

2014 increase 2% inflation 2014 $ 368.05 $ -

2015 increase 3% inflation 2015 $ 379.09 $ -

2011 2012 2013 2014 2015

Vendor Service/Product

Unit Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost

Total Estimated Budget [THIS LINE IS CALCULATED - MAKE NO ENTRIES] $ 355.50 $ 355.50 $ 360.83 $ 368.05 $ 379.09

Town of Cary Unleaded Gasoline Gallons $ 2.370 150 $ 355.50 $ 2.370 150 $ 355.50 $ 2.406 150 $ 360.83 $ 2.454 150 $ 368.05 $ 2.527 150 $ 379.09

MPG/vehicle 20 20 20 20 20

Miles/vehicle 3,000 3,000 3,000 3,000 3,000

vehicles 1 1 1 1 1









Identified and Unfunded Identified and Unfunded

TOTALS $ - $ - $ - $ - $ -









2011 2012 2013 2014 2015

$ - $ - $ - $ - $ -

Account Number 100-4120-431.31-10 2009 2009 $ 1,908.86 Use this format for entering the









entries to the right)

Comments (Make

Account Title Employee Travel and Training 2010 2010 $ 5,000.00 100 -4120 -401 .12 -10

Department Administration 2011 2011 $ 6,564.00 $ 3,797.50 100 -4120 -431 .31 -10

Purpose of Account: 2012 2012 $ 6,564.00 $ 3,807.50

Costs associated with attending schools, seminars, workshops, and other 2013 2013 $ 6,564.00 $ 3,817.50

training related to achieving and/or maintaining certifications and 2014 2014 $ 6,564.00 $ 3,817.50

representing the town in regional coordinations. 2015 2015 $ 6,564.00 $ 3,837.50

2011 2012 2013 2014 2015

Vendor Service/Product

Unit Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost

Total Estimated Budget [THIS LINE IS CALCULATED - MAKE NO ENTRIES] $ 6,564.00 $ 6,564.00 $ 6,564.00 $ 6,564.00 $ 6,564.00

NCMC Association Town Clerk's Annual Conference Fee $ 530.00 1 $ 530.00 $ 530.00 1 $ 530.00 $ 530.00 1 $ 530.00 $ 530.00 1 $ 530.00 $ 530.00 1 $ 530.00

Lodging $ 85.00 2 $ 170.00 $ 85.00 2 $ 170.00 $ 85.00 2 $ 170.00 $ 85.00 2 $ 170.00 $ 85.00 2 $ 170.00

Per Diem $ 54.00 2 $ 108.00 $ 54.00 2 $ 108.00 $ 54.00 2 $ 108.00 $ 54.00 2 $ 108.00 $ 54.00 2 $ 108.00

Mileage $ 0.55 300 $ 165.00 $ 0.55 300 $ 165.00 $ 0.55 300 $ 165.00 $ 0.55 300 $ 165.00 $ 0.55 300 $ 165.00

NCCCMA Manager's Conference/Seminar Fee $ 500.00 2 $ 1,000.00 $ 500.00 2 $ 1,000.00 $ 500.00 2 $ 1,000.00 $ 500.00 2 $ 1,000.00 $ 500.00 2 $ 1,000.00

Lodging $ 85.00 2 $ 170.00 $ 85.00 2 $ 170.00 $ 85.00 2 $ 170.00 $ 85.00 2 $ 170.00 $ 85.00 2 $ 170.00

Per Diem $ 54.00 4 $ 216.00 $ 54.00 4 $ 216.00 $ 54.00 4 $ 216.00 $ 54.00 4 $ 216.00 $ 54.00 4 $ 216.00

Mileage $ 0.55 300 $ 165.00 $ 0.55 300 $ 165.00 $ 0.55 300 $ 165.00 $ 0.55 300 $ 165.00 $ 0.55 300 $ 165.00

NCLM Annual Conference Fee $ 500.00 1 $ 500.00 $ 500.00 1 $ 500.00 $ 500.00 1 $ 500.00 $ 500.00 1 $ 500.00 $ 500.00 1 $ 500.00

Lodging $ 85.00 2 $ 170.00 $ 85.00 2 $ 170.00 $ 85.00 2 $ 170.00 $ 85.00 2 $ 170.00 $ 85.00 2 $ 170.00

Per Diem $ 54.00 3 $ 162.00 $ 54.00 3 $ 162.00 $ 54.00 3 $ 162.00 $ 54.00 3 $ 162.00 $ 54.00 3 $ 162.00

Mileage $ 0.55 300 $ 165.00 $ 0.55 300 $ 165.00 $ 0.55 300 $ 165.00 $ 0.55 300 $ 165.00 $ 0.55 300 $ 165.00

C3M PIO Training/Conference/Seminar Fee $ 500.00 1 $ 500.00 $ 500.00 1 $ 500.00 $ 500.00 1 $ 500.00 $ 500.00 1 $ 500.00 $ 500.00 1 $ 500.00

Lodging $ 85.00 2 $ 170.00 $ 85.00 2 $ 170.00 $ 85.00 2 $ 170.00 $ 85.00 2 $ 170.00 $ 85.00 2 $ 170.00

Per Diem $ 54.00 2 $ 108.00 $ 54.00 2 $ 108.00 $ 54.00 2 $ 108.00 $ 54.00 2 $ 108.00 $ 54.00 2 $ 108.00

Mileage $ 0.55 100 $ 55.00 $ 0.55 100 $ 55.00 $ 0.55 100 $ 55.00 $ 0.55 100 $ 55.00 $ 0.55 100 $ 55.00

Airfare $ 350.00 1 $ 350.00 $ 350.00 1 $ 350.00 $ 350.00 1 $ 350.00 $ 350.00 1 $ 350.00 $ 350.00 1 $ 350.00

Various Office Training Fee $ 175.00 10 $ 1,750.00 $ 175.00 10 $ 1,750.00 $ 175.00 10 $ 1,750.00 $ 175.00 10 $ 1,750.00 $ 175.00 10 $ 1,750.00

Employees Local Mileage Miles $ 0.55 200 $ 110.00 $ 0.55 200 $ 110.00 $ 0.55 200 $ 110.00 $ 0.55 200 $ 110.00 $ 0.55 200 $ 110.00









Identified and Unfunded Identified and Unfunded

TOTALS $ 3,797.50 $ 3,807.50 $ 3,817.50 $ 3,817.50 $ 3,837.50

ICMA Annual Conference Fee $ 600.00 1 $ 600.00 $ 600.00 1 $ 600.00 $ 600.00 1 $ 600.00 $ 600.00 1 $ 600.00 $ 600.00 1 $ 600.00

Lodging $ 110.00 4 $ 440.00 $ 110.00 4 $ 440.00 $ 110.00 4 $ 440.00 $ 110.00 4 $ 440.00 $ 110.00 4 $ 440.00

Per Diem $ 54.00 4 $ 216.00 $ 54.00 4 $ 216.00 $ 54.00 4 $ 216.00 $ 54.00 4 $ 216.00 $ 54.00 4 $ 216.00

Mileage $ 0.55 $ - $ 0.55 $ - $ 0.55 $ - $ 0.55 $ - $ 0.55 $ -

Airfare $ 300.00 1 $ 300.00 $ 310.00 1 $ 310.00 $ 320.00 1 $ 320.00 $ 320.00 1 $ 320.00 $ 340.00 1 $ 340.00

NCLM Annual Conference Fee $ 500.00 2 $ 1,000.00 $ 500.00 2 $ 1,000.00 $ 500.00 2 $ 1,000.00 $ 500.00 2 $ 1,000.00 $ 500.00 2 $ 1,000.00

Lodging $ 85.00 4 $ 340.00 $ 85.00 4 $ 340.00 $ 85.00 4 $ 340.00 $ 85.00 4 $ 340.00 $ 85.00 4 $ 340.00

Per Diem $ 54.00 6 $ 324.00 $ 54.00 6 $ 324.00 $ 54.00 6 $ 324.00 $ 54.00 6 $ 324.00 $ 54.00 6 $ 324.00

Mileage $ 0.55 300 $ 165.00 $ 0.55 300 $ 165.00 $ 0.55 300 $ 165.00 $ 0.55 300 $ 165.00 $ 0.55 300 $ 165.00

Employees Counterpart/Peer Visits Employees 5 5 5 5 5

Mileage $ 0.55 150 $ 412.50 $ 0.55 150 $ 412.50 $ 0.55 150 $ 412.50 $ 0.55 150 $ 412.50 $ 0.55 150 $ 412.50









2011 2012 2013 2014 2015

####### $ 3,807.50 ####### ####### $ 3,837.50

Account Number 100-4120-431.31-12 2009 2009 $ 1,047.00 Use this format for entering the









entries to the right)

Comments (Make

Account Title Training - Development 2010 2010 $ - 100 -4120 -401 .12 -10

Department Administration 2011 2011 $ - $ 2,925.00 100 -4120 -431 .31 -12

Purpose of Account: 2012 2012 $ - $ 2,925.00

Costs of training designed to develop employee skills and professionalism. 2013 2013 $ - $ 2,925.00

2014 2014 $ - $ 2,925.00

2015 2015 $ - $ 2,925.00

2011 2012 2013 2014 2015

Vendor Service/Product

Unit Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost

Total Estimated Budget [THIS LINE IS CALCULATED - MAKE NO ENTRIES] $ - $ - $ - $ - $ -









Identified and Unfunded Identified and Unfunded

TOTALS $ 2,925.00 $ 2,925.00 $ 2,925.00 $ 2,925.00 $ 2,925.00

Professional Services Vendor Senior Management Training Employee $ 40.00 15 $ 600.00 $ 40.00 15 $ 600.00 $ 40.00 15 $ 600.00 $ 40.00 15 $ 600.00 $ 40.00 15 $ 600.00

Professional Services Vendor Senior Management Training Employee $ 40.00 15 $ 600.00 $ 40.00 15 $ 600.00 $ 40.00 15 $ 600.00 $ 40.00 15 $ 600.00 $ 40.00 15 $ 600.00

Professional Services Vendor Senior Management Training Employee $ 40.00 15 $ 600.00 $ 40.00 15 $ 600.00 $ 40.00 15 $ 600.00 $ 40.00 15 $ 600.00 $ 40.00 15 $ 600.00

Professional Services Vendor Team Building Employee $ 75.00 15 $ 1,125.00 $ 75.00 15 $ 1,125.00 $ 75.00 15 $ 1,125.00 $ 75.00 15 $ 1,125.00 $ 75.00 15 $ 1,125.00









2011 2012 2013 2014 2015

####### $ 2,925.00 ####### ####### $ 2,925.00

Account Number 100-4120-432.32-21 2009 2009 $ 5,532.36 Use this format for entering the









entries to the right)

Comments (Make

Account Title All Communications 2010 2010 $ 6,120.00 100 -4120 -401 .12 -10

Department Administration 2011 2011 $ 6,289.68 $ 622.08 100 -4120 -432 .32 -21

Purpose of Account: 2012 2012 $ 6,289.68 $ 622.08

Costs associated with providing communications equipment and services 2013 2013 $ 6,762.03 $ 628.30

such as basic and long-distance telephone, fax, cell, and aircards. 2014 2014 $ 7,461.75 $ 634.58

2015 2015 $ 8,667.79 $ 640.93

2011 2012 2013 2014 2015

Vendor Service/Product

Unit Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost

Total Estimated Budget [THIS LINE IS CALCULATED - MAKE NO ENTRIES] $ 6,289.68 $ 6,289.68 $ 6,762.03 $ 7,461.75 $ 8,667.79

AT&T Mobility PIO Air Card Cards 1 1 1 1 1

Rate $ 51.84 $ 51.84 $ 52.62 $ 53.67 $ 55.28

Months 12 $ 622.08 12 $ 622.08 12 $ 631.41 12 $ 644.04 12 $ 663.36



Nextel Cell Phones Phones 1 1 1 1 1

Rate $ 165.00 $ 165.00 $ 167.48 $ 170.82 $ 175.95

Months 12 $ 1,980.00 12 $ 1,980.00 12 $ 2,009.70 12 $ 2,049.89 12 $ 2,111.39



NC IT Long Distance Service - Desk Phone Monthly $ 7.30 12 $ 87.60 $ 7.30 12 $ 87.60 $ 7.41 12 $ 88.91 $ 7.56 12 $ 90.69 $ 7.78 12 $ 93.41



AT&T Voice and Data Lines Monthly $ 300.00 12 $ 3,600.00 $ 300.00 12 $ 3,600.00 $ 336.00 12 $ 4,032.00 $ 389.76 12 $ 4,677.12 $ 483.30 12 $ 5,799.63

8 lines









Identified and Unfunded Identified and Unfunded

TOTALS $ 622.08 $ 622.08 $ 628.30 $ 634.58 $ 640.93

AT&T Mobility Air Card Cards 1 1 1 1 1

Rate $ 51.84 $ 51.84 $ 52.36 $ 52.88 $ 53.41

Months 12 $ 622.08 12 $ 622.08 12 $ 628.30 12 $ 634.58 12 $ 640.93









2011 2012 2013 2014 2015

$ 622.08 $ 622.08 $ 628.30 $ 634.58 $ 640.93

Account Number 100-4120-432.32-25 2009 2009 $ 11,568.59 Use this format for entering the









entries to the right)

Comments (Make

Account Title Postage 2010 2010 $ 19,000.00 100 -4120 -401 .12 -10

Department Administration 2011 2011 $ 17,588.00 $ - 100 -4120 -432 .32 -25

Purpose of Account: 2012 2012 $ 18,291.52 $ -

Postage charges for metered, bulk or registered mail via USPS, UPS, 2013 2013 $ 18,840.27 $ -

Federal Express, and post office box rental. 2014 2014 $ 19,217.07 $ -

2015 2015 $ 19,409.24 $ -

2011 2012 2013 2014 2015

Vendor Service/Product

Unit Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost

Total Estimated Budget [THIS LINE IS CALCULATED - MAKE NO ENTRIES] $ 17,588.00 $ 18,291.52 $ 18,840.27 $ 19,217.07 $ 19,409.24

USPS Reserve Account Quarterly $ 60.00 4 $ 240.00 $ 62.40 4 $ 249.60 $ 64.27 4 $ 257.09 $ 65.56 4 $ 262.23 $ 66.21 4 $ 264.85

PO Box Rental Annual $ 98.00 1 $ 98.00 $ 101.92 1 $ 101.92 $ 104.98 1 $ 104.98 $ 107.08 1 $ 107.08 $ 108.15 1 $ 108.15

Morrisville Connection Mailing Monthly $ 1,450.00 11 $ 15,950.00 $ 1,508.00 11 $ 16,588.00 $ 1,553.24 11 $ 17,085.64 $ 1,584.30 11 $ 17,427.35 $ 1,600.15 11 $ 17,601.63

Postcard Mailing Mailing $ 1,300.00 1 $ 1,300.00 $ 1,352.00 1 $ 1,352.00 $ 1,392.56 1 $ 1,392.56 $ 1,420.41 1 $ 1,420.41 $ 1,434.62 1 $ 1,434.62









Identified and Unfunded Identified and Unfunded

TOTALS $ - $ - $ - $ - $ -









2011 2012 2013 2014 2015

$ - $ - $ - $ - $ -

Account Number 100-4120-434.34-49 2009 This year included cost for a bi-annual citizen survey. With use of new Qualtric Survey Group, routine survey cost should be reduced 2009 $ 34,814.02 Use this format for entering the









entries to the right)

Comments (Make

Account Title Public Information 2010 2010 $ 22,250.00 100 -4120 -401 .12 -10

Department Administration 2011 2011 $ 20,450.00 $ 1,950.00 100 -4120 -434 .34 -49

Purpose of Account: 2012 2012 $ 20,859.00 $ 1,950.00

Expenses incurred disseminating information to the general public. 2013 2013 $ 21,276.18 $ 1,950.00

Includes publishing the Morrisville Connection . 2014 2014 $ 21,701.70 $ 1,950.00

2015 2015 $ 22,135.74 $ 1,950.00

2011 2012 2013 2014 2015

Vendor Service/Product

Unit Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost

Total Estimated Budget [THIS LINE IS CALCULATED - MAKE NO ENTRIES] $ 20,450.00 $ 20,859.00 $ 21,276.18 $ 21,701.70 $ 22,135.74

Triangle Communications Morrisville Connection Printing per Edition $ 1,800.00 11 $ 19,800.00 $ 1,836.00 11 $ 20,196.00 $ 1,872.72 11 $ 20,599.92 $ 1,910.17 11 $ 21,011.92 $ 1,948.38 11 $ 21,432.16

Special Notice per Event $ 650.00 1 $ 650.00 $ 663.00 1 $ 663.00 $ 676.26 1 $ 676.26 $ 689.79 1 $ 689.79 $ 703.58 1 $ 703.58









Identified and Unfunded Identified and Unfunded

TOTALS $ 1,950.00 $ 1,950.00 $ 1,950.00 $ 1,950.00 $ 1,950.00

Triangle Communications Special Notice Event $ 650.00 3 $ 1,950.00 $ 650.00 3 $ 1,950.00 $ 650.00 3 $ 1,950.00 $ 650.00 3 $ 1,950.00 $ 650.00 3 $ 1,950.00









2011 2012 2013 2014 2015

####### $ 1,950.00 $ 1,950.00 ####### $ 1,950.00

Account Number 100-4120-435.35-52 2009 2009 $ 6,791.22 Use this format for entering the









entries to the right)

Comments (Make

Account Title Repair/Maint - Equipment 2010 2010 $ 9,000.00 100 -4120 -401 .12 -10

Department Administration 2011 2011 $ 9,000.00 $ - 100 -4120 -435 .35 -52

Purpose of Account: 2012 2012 $ 9,000.00 $ -

Costs associated with the repair and maintenance of non-automotive 2013 2013 $ 9,000.00 $ -

equipment. 2014 2014 $ 9,000.00 $ -

2015 2015 $ 9,000.00 $ -

2011 2012 2013 2014 2015

Vendor Service/Product

Unit Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost

Total Estimated Budget [THIS LINE IS CALCULATED - MAKE NO ENTRIES] $ 9,000.00 $ 9,000.00 $ 9,000.00 $ 9,000.00 $ 9,000.00

Pitney Bowes Mailing Machine Maintenance Quarterly $ 1,800.00 4 $ 7,200.00 $ 1,800.00 4 $ 7,200.00 $ 1,800.00 4 $ 7,200.00 $ 1,800.00 4 $ 7,200.00 $ 1,800.00 4 $ 7,200.00



OCE Imagistics Copier Maintenance/Repair Event $ 1,800.00 1 $ 1,800.00 $ 1,800.00 1 $ 1,800.00 $ 1,800.00 1 $ 1,800.00 $ 1,800.00 1 $ 1,800.00 $ 1,800.00 1 $ 1,800.00









Identified and Unfunded Identified and Unfunded

TOTALS $ - $ - $ - $ - $ -









2011 2012 2013 2014 2015

$ - $ - $ - $ - $ -

Account Number 100-4120-443.43-39 2009 2009 $ 12,553.89 Use this format for entering the









entries to the right)

Comments (Make

Account Title Equipment Rental 2010 2010 $ 12,000.00 100 -4120 -401 .12 -10

Department Administration 2011 2011 $ 11,800.00 $ 4,200.00 100 -4120 -443 .43 -39

Purpose of Account: 2012 2012 $ 11,800.00 $ 4,320.00

Costs associated with leasing/renting vehicles, trucks, construction and 2013 2013 $ 11,800.00 $ 4,200.00

office equipment. 2014 2014 $ 11,800.00 $ 4,200.00

2015 2015 $ 11,800.00 $ 4,200.00

2011 2012 2013 2014 2015

Vendor Service/Product

Unit Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost

Total Estimated Budget [THIS LINE IS CALCULATED - MAKE NO ENTRIES] $ 11,800.00 $ 11,800.00 $ 11,800.00 $ 11,800.00 $ 11,800.00

Xerox Corporation Copier Machine Rental Monthly $ 650.00 12 $ 7,800.00 $ 650.00 12 $ 7,800.00 $ 650.00 12 $ 7,800.00 $ 650.00 12 $ 7,800.00 $ 650.00 12 $ 7,800.00

Print Charges Quarterly $ 1,000.00 4 $ 4,000.00 $ 1,000.00 4 $ 4,000.00 $ 1,000.00 4 $ 4,000.00 $ 1,000.00 4 $ 4,000.00 $ 1,000.00 4 $ 4,000.00









Identified and Unfunded Identified and Unfunded

TOTALS $ 4,200.00 $ 4,320.00 $ 4,200.00 $ 4,200.00 $ 4,200.00

Xerox Corporation Higher Function Copier incremental Monthly $ 350.00 12 $ 4,200.00 $ 360.00 12 $ 4,320.00 $ 350.00 12 $ 4,200.00 $ 350.00 12 $ 4,200.00 $ 350.00 12 $ 4,200.00









2011 2012 2013 2014 2015

####### $ 4,320.00 $ 4,200.00 ####### $ 4,200.00

Account Number 100-4120-446.56-10 2009 2009 $ 187,556.28 Use this format for entering the









entries to the right)

Comments (Make

Account Title Insurance - Workers Comp 2010 2010 $ 191,888.00 100 -4120 -401 .12 -10

Department Administration 2011 2011 $ 186,057.28 $ - 100 -4120 -446 .56 -10

Purpose of Account: 2012 2012 $ 191,057.28 $ -

Costs of insurance providing medical care of employees with on-the-job 2013 2013 $ 196,057.28 $ -

injuries 2014 2014 $ 201,057.28 $ -

2015 2015 $ 206,057.28 $ -

2011 2012 2013 2014 2015

Vendor Service/Product

Unit Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost

Total Estimated Budget [THIS LINE IS CALCULATED - MAKE NO ENTRIES] $ 186,057.28 $ 191,057.28 $ 196,057.28 $ 201,057.28 $ 206,057.28

Godwin, Mercedes Monthly Payment in Settlement Monthly $ 921.44 12 $ 11,057.28 $ 921.44 12 $ 11,057.28 $ 921.44 12 $ 11,057.28 $ 921.44 12 $ 11,057.28 $ 921.44 12 $ 11,057.28

Trisure Insurance Annual Policy Policy $ 175,000.00 1 $ 175,000.00 $ 180,000.00 1 $ 180,000.00 $ 185,000.00 1 $ 185,000.00 $ 190,000.00 1 $ 190,000.00 $ 195,000.00 1 $ 195,000.00









Identified and Unfunded Identified and Unfunded

TOTALS $ - $ - $ - $ - $ -









2011 2012 2013 2014 2015

$ - $ - $ - $ - $ -

Account Number 100-4120-446.56-20 2009 2009 $ 126,153.00 Use this format for entering the









entries to the right)

Comments (Make

Account Title Insurance and Bonds 2010 2010 $ 137,922.00 100 -4120 -401 .12 -10

Department Administration 2011 increases related to updating of equipment schedule (equipment over $5000 in value) and computer/media inventory 2011 $ 166,000.00 $ - 100 -4120 -446 .56 -20

Purpose of Account: 2012 2012 $ 171,000.00 $ -

Costs of providing liability and property insurance on employees, buildings, 2013 2013 $ 176,000.00 $ -

vehicles, equipment and etc… 2014 2014 $ 181,000.00 $ -

2015 2015 $ 191,000.00 $ -

2011 2012 2013 2014 2015

Vendor Service/Product

Unit Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost

Total Estimated Budget [THIS LINE IS CALCULATED - MAKE NO ENTRIES] $ 166,000.00 $ 171,000.00 $ 176,000.00 $ 181,000.00 $ 191,000.00

Trisure Insurance Liability Insurance Policy $ 146,000.00 1 $ 146,000.00 $ 151,000.00 1 $ 151,000.00 $ 156,000.00 1 $ 156,000.00 $ 161,000.00 1 $ 161,000.00 $ 171,000.00 1 $ 171,000.00

Trisure Insurance Deductable Payments Incidents $ 10,000.00 2 $ 20,000.00 $ 10,000.00 2 $ 20,000.00 $ 10,000.00 2 $ 20,000.00 $ 10,000.00 2 $ 20,000.00 $ 10,000.00 2 $ 20,000.00









Identified and Unfunded Identified and Unfunded

TOTALS $ - $ - $ - $ - $ -









2011 2012 2013 2014 2015

$ - $ - $ - $ - $ -

Account Number 100-4120-491.47-10 2009 2009 $ 2,023.90 Use this format for entering the









entries to the right)

Comments (Make

Account Title Dues & Subscriptions 2010 Annual software rights/membership dues to Qualtrics Survey group began within this year. 2010 $ 4,500.00 100 -4120 -401 .12 -10

Department Administration 2011 2011 $ 4,432.75 $ 253.00 100 -4120 -491 .47 -10

Purpose of Account: 2012 2012 $ 4,541.30 $ 260.00

Costs associated with memberships in professional organizations and 2013 2013 $ 4,652.41 $ 267.00

subscriptions to professional journals and technical publications required 2014 2014 $ 4,766.15 $ 274.00

to maintain certifications and professionalism. 2015 2015 $ 4,882.58 $ 281.00

2011 2012 2013 2014 2015

Vendor Service/Product

Unit Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost

Total Estimated Budget [THIS LINE IS CALCULATED - MAKE NO ENTRIES] $ 4,432.75 $ 4,541.30 $ 4,652.41 $ 4,766.15 $ 4,882.58

ICMA Membership based on salary salary $ 0.0080 120,000 $ 960.00 $ 0.0082 122,000 $ 995.52 $ 0.0083 124,000 $ 1,032.08 $ 0.0085 126,000 $ 1,069.70 $ 0.0087 128,000 $ 1,108.41

NCCCMA Membership based on salary salary $ 0.00175 113,000 $ 197.75 $ 0.00179 115,000 $ 205.28 $ 0.00182 117,000 $ 213.02 $ 0.00186 119,000 $ 221.00 $ 0.00189 121,000 $ 229.21

NC3C Membership annual $ 50.00 1 $ 50.00 $ 51.00 1 $ 51.00 $ 52.02 1 $ 52.02 $ 53.06 1 $ 53.06 $ 54.12 1 $ 54.12

IIMC Membership annual $ 140.00 1 $ 140.00 $ 142.80 1 $ 142.80 $ 145.66 1 $ 145.66 $ 148.57 1 $ 148.57 $ 151.54 1 $ 151.54

3CMA Membership annual $ 350.00 1 $ 350.00 $ 357.00 1 $ 357.00 $ 364.14 1 $ 364.14 $ 371.42 1 $ 371.42 $ 378.85 1 $ 378.85

NCMAC Alumni Membership annual $ 50.00 3 $ 150.00 $ 51.00 3 $ 153.00 $ 52.02 3 $ 156.06 $ 53.06 3 $ 159.18 $ 54.12 3 $ 162.36

Qualtics Labs Software Rights/Membership rate locked annual $ 2,500.00 1 $ 2,500.00 $ 2,550.00 1 $ 2,550.00 $ 2,601.00 1 $ 2,601.00 $ 2,653.02 1 $ 2,653.02 $ 2,706.08 1 $ 2,706.08

NCAMC Membership annual $ 50.00 1 $ 50.00 $ 51.00 1 $ 51.00 $ 52.02 1 $ 52.02 $ 53.06 1 $ 53.06 $ 54.12 1 $ 54.12

Sam's Club Membership annual $ 35.00 1 $ 35.00 $ 35.70 1 $ 35.70 $ 36.41 1 $ 36.41 $ 37.14 1 $ 37.14 $ 37.89 1 $ 37.89









Identified and Unfunded Identified and Unfunded

TOTALS $ 253.00 $ 260.00 $ 267.00 $ 274.00 $ 281.00

News and Observer Newspaper Subscription $ 165.00 1 $ 165.00 $ 170.00 1 $ 170.00 $ 175.00 1 $ 175.00 $ 180.00 1 $ 180.00 $ 185.00 1 $ 185.00

Triangle Business Journal Newspaper Subscription $ 88.00 1 $ 88.00 $ 90.00 1 $ 90.00 $ 92.00 1 $ 92.00 $ 94.00 1 $ 94.00 $ 96.00 1 $ 96.00









2011 2012 2013 2014 2015

$ 253.00 $ 260.00 $ 267.00 $ 274.00 $ 281.00

Account Number 100-4120-491.74-10 2009 2009 $ 604.73 Use this format for entering the









entries to the right)

Comments (Make

Account Title Equipment-Expense 2010 2010 $ - 100 -4120 -401 .12 -10

Department Administration 2011 2011 $ - $ - 100 -4120 -491 .74 -10

Purpose of Account: 2012 2012 $ - $ -

Expenditures for the equipment, new and replacement, having unit costs 2013 2013 $ - $ -

of less than $5,000. 2014 2014 $ - $ -

2015 2015 $ - $ -

2011 2012 2013 2014 2015

Vendor Service/Product

Unit Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost Rate Quantity Cost

Total Estimated Budget [THIS LINE IS CALCULATED - MAKE NO ENTRIES] $ - $ - $ - $ - $ -









Identified and Unfunded Identified and Unfunded

TOTALS $ - $ - $ - $ - $ -









2011 2012 2013 2014 2015

$ - $ - $ - $ - $ -



Related docs
Other docs by gegeshandong
A_E_KY-4PSE30WUSeries-Rev1012A
Views: 0  |  Downloads: 0
688_xls
Views: 0  |  Downloads: 0
2-1 辫措康
Views: 0  |  Downloads: 0
VINPR Lit Order Form New Jan 09
Views: 0  |  Downloads: 0
WRECKED - Torino Film Festival
Views: 0  |  Downloads: 0
project2btestcases
Views: 0  |  Downloads: 0
Fund Account transfer form9.2011
Views: 0  |  Downloads: 0
By registering with docstoc.com you agree to our
privacy policy

You are almost ready to download!

You are almost ready to download!