Demographics Data Template - Download as Excel

Document Sample
Demographics Data Template - Download as Excel Powered By Docstoc
					                                                           KC Metro                                              Instructions
                                                Performance Measurement Project



This workbook contains seven Excel spreadsheets or templates:
         1 Asphalt Repair Service
         2 Street Sweeping Service
         3 Asphalt Repair Cost Template
         4 Street Sweeping Cost Template
         5 Demographic and one-time Data
         6 Asphalt Direct Labor Worksheet
         7 Street Sweeping Direct Labor Worksheet

These templates have been developed to compile cost and service data for Asphalt Repair and Street Sweeping
activities for all jurisdictions and other information including demographics and equipment use.

1. The Asphalt Repair and Street Sweeping Service templates should be compiled and forwarded to MARC
monthly. Record service information to the extent available. For example, cost and output data would be
available monthly whereas outcome data may not be available for several months or one or two years.

2. The Asphalt Repair and Street Sweeping Cost templates should be compiled and forwarded to MARC, initially
monthly. These templates will be used to record direct personal and expense costs only. Indirect costs such
as fringe benefits, overhead, supervisory time and other costs will be addressed at a later date.

3. The Demographic and one-time Data template should be completed and forwarded to MARC by June 30,
2000. We envision completing the Demographic and one-time Data template only once during this project.


Please enter the data on the templates where indicated, using dollars, numbers or narrative language as noted.
You can utilize Microsoft Word instead of these templates for the Demographic and one-time template where
applicable.




                                           8f7f9e02-2c05-453b-8dd1-a77c71d171bd.xls                                  Page 1
                                                                            KC Metro
                                                                 Performance Measurement Project


ASPHALT REPAIR FOR THE PERIOD ENDING:

Any asphalt repair that involves cutting the street and filling the area with hot asphalt.                                                       DATA
    Please report the information requested below in three categories:
        · Asphalt Repair -- defined as making a permanent repair by cutting the street and filling the area with hot asphalt.
        · Milled -- defined as making a permanent repair by milling down the surface and filling with hot asphalt.
        · Pothole repair -- defined as making a permanent repair by filling area with hot asphalt. This does not include "throw and go" filling with cold mix.

PERFORMANCE MEASURES: This section describes the performance information in terms of dollars and
numbers.

INPUT INDICATORS: measures the direct resources for a service. Support and supervisory staff not included.
Indirect personal and expense costs are not to be included at this time.
The costs of asphalt repair, expressed in dollars, MUST equal the costs on the asphalt repair cost template.

Employees
Direct Labor Hours (DLH) of Asphalt Crew, including Crew Leader (anyone who touches asphalt)

Materials Used
Tons of Asphalt
Tons of Rock
Cubic Yards of Concrete
Other (Please describe)

Costs: measures the direct costs of service (indirect costs not included at this time).                                                          $ or hrs
Total direct costs for asphalt crew (hours multiplied by hourly rate)
Total direct costs for asphalt repairs excluding total direct costs for asphalt crew (see cost template)
Number of equipment hours by type of equipment (total hours including use and stand-by hours)
Average cost per ton of asphalt used
Average cost per ton of rock used
Average cost per cubic yard of concrete used
Total contract costs for asphalt repair

OUTPUT INDICATORS: measures the amount of service provided.                                                                                         #
Number of asphalt repairs completed
Square feet of repairs made
Number of square feet milled
Total cost/ton of asphalt used
Total direct labor hours/ton of asphalt used

EFFICIENCY INDICATORS: measures unit costing or productivity.                                                                               To be computed
Average cost per asphalt repair
Number of asphalt repairs per DLH
Square yards of repair/DLH

EFFECTIVENESS INDICATORS: measures service quality.                                                                                              # or %
% of hazardous pavement conditions responded to within 24 hours
Number of asphalt repairs per 100 lane miles of streets
Number of square yards of repairs per 100 lane miles of streets

OUTCOME INDICATORS: measures service results.                                                                                                       %
Repair recidivism: % asphalt repairs requiring further repairs within two years
Pavement condition index within base repair area

EXPLANATORY INFORMATION
Describe unusual events which increased or decreased workload or expenditures such as unusual harsh winters
or heavy rains for the period reported.




                                                           8f7f9e02-2c05-453b-8dd1-a77c71d171bd.xls                                                         Page 2
                                                                              KC Metro                           Street Sweeping Service
                                                                   Performance Measurement Project



STREET SWEEPING FOR THE PERIOD ENDING:

Any activity associated with sweeping streets.                                                                             DATA

PERFORMANCE MEASURES: This section describes the performance information in terms of dollars and
numbers.


INPUT INDICATORS: measures the direct resources for a service. Support and supervisory staff not included.
Indirect personal and expense costs are not to be included at this time.
The costs of street sweeping, expressed in dollars, MUST equal the costs on the street sweeping cost template.

Employees
Direct Labor Hours (DLH) of street sweeping Crew, including Crew Leader

Costs: measures the direct costs of service (indirect costs not included at this time).                                   $ or Hrs
Total direct costs for street sweeping crew (hours multiplied by hourly rate)
Total direct costs for street sweeping expenses (see cost template)
Number of equipment hours by type of equipment

OUTPUT INDICATORS: measures the amount of service provided.                                                                   #
Number of cubic yards collected (Estimated)
Number of lane miles of streets swept or linear miles of curb swept per month - total streets
Number of lane miles of streets swept or linear miles of curb swept per month - collector streets
Number of lane miles of streets swept or linear miles of curb swept per month - arterial streets
Number of lane miles of streets swept or linear miles of curb swept per month - industrial streets
Number of lane miles of streets swept or linear miles of curb swept per month - residential streets

EFFICIENCY INDICATORS: measures unit costing or productivity.                                                         To be computed
Average cost per mile of street cleaned
Average number of miles of streets swept per DLH
Number of cubic yards collected per 100 lane miles of streets or 100 linear miles of curb

EFFECTIVENESS INDICATORS: measures service quality.                                                                        # or %
Percent of customers who rate street sweeping as good to excellent
Number of street sweeping complaints
% of residential streets rated as clean

OUTCOME INDICATORS: measures service results.                                                                                %
Percentage of street miles meeting cleaning schedule
% of routes completed on schedule

EXPLANATORY INFORMATION
Describe unusual events which increased or decreased workload or expenditures such as unusual harsh winters
or heavy rains for the period reported.




                                                              8f7f9e02-2c05-453b-8dd1-a77c71d171bd.xls                            Page 3
                                                         KC Metro                                  Asphalt Repair Costs
                                              Performance Measurement Project


Asphalt Repair Costs for the period ending:

This template reports the direct costs of asphalt repair. The costs reported on this
template MUST equal the costs reported on the Asphalt Repair Template.

Direct Labor                                                                                           $

Include in direct labor the direct salaries and overtime of the crew. Do not include
any other cost, such as fringe benefits. For salaries and wages, multiply the direct labor hours
reported on the asphalt repair template by the hourly rate to compute the direct salary and wage
amount. For overtime, report the actual overtime of asphalt repair crew. Use the direct labor
worksheet for asphalt repair that provides an automatic link to this spreadsheet.

Salaries and Wages of Crew                                                                                  -
Overtime of Crew                                                                                            -

Total Direct Labor                                                                                          -

Direct Expenses

Include in the direct expense category any other direct costs exclusive of salary and overtime
costs to the asphalt activity. Do not include fringe benefits. Examples follow. You may include
more detail by adding appropriate rows to the spreadsheet.


Asphalt
Concrete
Rock
Tools (Please describe)
Rentals (Please describe)
Tipping fees
Other (please describe)

Total Direct Expenses                                                                                       -

Total Direct Costs                                                                                          -




                                         8f7f9e02-2c05-453b-8dd1-a77c71d171bd.xls                               Page 4
                                                          KC Metro                                 Street Sweeping Costs
                                               Performance Measurement Project


Street Sweeping Costs for the period ending:

This template reports the direct costs of street sweeping costs. The costs reported on this
template MUST equal the costs reported on the Street Sweeping Template.

Direct Labor                                                                                             $

Include in direct labor the direct salaries and overtime of the crew. Do not include
any other cost, such as fringe benefits. For salaries and wages, multiply the direct labor hours
reported on the asphalt repair template by the hourly rate to compute the direct salary and wage
amount. For overtime, report the actual overtime of asphalt repair crew. Use the direct labor
worksheet for street sweeping that provides an automatic link to this spreadsheet.

Salaries and Wages of Crew                                                                                   -
Overtime of Crew                                                                                             -

Total Direct Labor                                                                                           -

Direct Expenses

Include in the direct expense category any other direct costs exclusive of salary and overtime
costs to the street sweeping activity. Do not include fringe benefits. Examples follow. You may
include more detail by adding appropriate rows to the spreadsheet.

Fuel
Vehicle Parts (Please describe)
In-house Mechanics
Tools (Please describe)
Brushes
Rentals (Please describe)
Other (Please describe)

Total Direct Expenses                                                                                        -

Total Direct Costs                                                                                           -




                                         8f7f9e02-2c05-453b-8dd1-a77c71d171bd.xls                                Page 5
                                                                  KC Metro                                   Demorgraphic and One Time Data
                                                       Performance Measurement Project


DEMOGRAPHICS

This section describes the data relating to the demographics of the jurisdiction. This sheet will be                          # or $
completed once and submitted to MARC by June 30, 2000. Please express your answers in terms
of numbers, dollars or a narrative, where applicable.

Employment (Day) Population
Residential (Night) Population
Land Area (square miles)
Persons per Square Mile
Median Family Income (1999 population estimate)

Number of lane miles of streets maintained
Number of linear miles of curbs
Number of residential building permits (1999 totals)
Number of commercial building permits (1999 totals)
Dollars of building permits (1999 totals)

Explanatory Information: In this section, please describe in narrative form any other information                           Narrative
you feel the reader should know, such as topography. Use this sheet or a Microsoft Word
document.

Describe topography (hilly, flat, gently rolling)




                                                                   Page 6                           8f7f9e02-2c05-453b-8dd1-a77c71d171bd.xls
                                                                       KC Metro                                        Demorgraphic and One Time Data
                                                            Performance Measurement Project


STREET SWEEPING OTHER INFORMATION: This section presents explanatory information in terms of a narrative.                             Narrative
Please describe the following on a separate document using Microsoft Word.

1. Describe how street sweeping is delivered with in-house and contractor services.
Describe the number and composition of street sweeping crews including the crew chief.
Do not include supervisory or support personnel.
Include temporary positions. The crew composition should equal the direct labor hours as reported on the cost templates
and above.

2. Describe the number and type of vehicles used for street sweeping. Be specific.
 For each piece of equipment, complete the equipment information section below.

3. Generally describe the service level and delivery of this activity. Include the number of lane miles of streets that are
maintained for street sweeping purposes.

4. Describe any other service delivery issue you feel is important.

STREET SWEEPING EQUIPMENT INFORMATION (By each piece of equipment) (only include equipment fully
dedicated to street sweeping)                                                                                                      #, $ or narrative
(Please copy and paste for each piece of equipment)
Description
Activity
Acquisition Date
Estimated Original Cost
Estimated Salvage Value
Useful Life (number of years or number of hours)
General Condition
Number of Equipment Hours Consumed per Year


ASPHALT REPAIR OTHER INFORMATION: This section presents explanatory information in terms of a narrative.
Please describe the following on a separate document using Microsoft Word.

1. Describe how asphalt repair is delivered with in-house and contractor services.
Describe the number and composition of asphalt repair crews.
Include anyone who touches asphalt repair including the crew leader. Do not include supervisory or support personnel.
Include temporary positions. The crew composition should equal the direct labor hours as reported on the cost templates
and above.

2. Describe the number and type of vehicles used for asphalt repair. Be specific.
 For each piece of equipment, complete the equipment information section below.

3. Generally describe the service level and delivery of this activity.

4. Describe any other service delivery issue you feel is important.

ASPHALT REPAIR EQUIPMENT INFORMATION (By each piece of equipment) (only include equipment fully dedicated
to street sweeping)
(Please copy and paste for each piece of equipment)
Description
Activity
Acquisition Date
Estimated Original Cost
Estimated Salvage Value
Useful Life (number of years or number of hours)
General Condition
Number of Equipment Hours Consumed per Year




                                                                         Page 7                             8f7f9e02-2c05-453b-8dd1-a77c71d171bd.xls
                                                  KC Metro                        Asphalt Direct Labor Worksheet
                                       Performance Measurement Project

DIRECT LABOR WORKSHEET - ASPHALT REPAIR - FOR THE PERIOD ENDING:

The purpose of this worksheet is to facilitate your compilation of direct labor costs. Remember
we are recording the direct salaries and overtime of the crew. Do not include any other cost, such
as fringe benefits. For salaries and wages, multiply the direct labor hours reported on the
asphalt repair template by the hourly rate to compute the direct salary and wage amount.
For overtime, report the actual overtime of asphalt repair crew.

                                                                          Salary and         Total
NAME OF INDIVIDUAL                                        S/W Hours       Wage Hourly      Salary and
Direct Salaries and Wages                                 This Period        Rate           Wages
                                                                                                   -
                                                                                                   -
                                                                                                   -
                                                                                                   -
                                                                                                   -
                                                                                                   -
                                                                                                   -
                                                                                                   -
                                                                                                   -
                                                                                                   -
                                                                                                   -
Total Direct Salaries and Wages                                                                    -


Overtime                                                   OT Hours            OT             Total
                                                          This Period         Rate             OT
                                                                                                      -
                                                                                                      -
                                                                                                      -
                                                                                                      -
                                                                                                      -
                                                                                                      -
                                                                                                      -
                                                                                                      -
                                                                                                      -
                                                                                                      -
                                                                                                      -
Total Overtime                                                                                        -




                                  8f7f9e02-2c05-453b-8dd1-a77c71d171bd.xls                                Page 8
                                                        KC Metro                             Sweeping Direct Labor Worksht
                                             Performance Measurement Project

DIRECT LABOR WORKSHEET - STREET SWEEPING - FOR THE PERIOD ENDING:

The purpose of this worksheet is to facilitate your compilation of direct labor costs. Remember
we are recording the direct salaries and overtime of the crew. Do not include any other cost, such
as fringe benefits. For salaries and wages, multiply the direct labor hours reported on the
street sweeping template by the hourly rate to compute the direct salary and wage amount.
For overtime, report the actual overtime of asphalt repair crew.

                                                                        Salary and         Total
NAME OF INDIVIDUAL                                      S/W Hours       Wage Hourly      Salary and
Direct Salaries and Wages                               This Period        Rate           Wages
                                                                                                 -
                                                                                                 -
                                                                                                 -
                                                                                                 -
                                                                                                 -
                                                                                                 -
                                                                                                 -
                                                                                                 -
                                                                                                 -
                                                                                                 -
                                                                                                 -
Total Direct Salaries and Wages                                                                  -


Overtime                                                 OT Hours            OT             Total
                                                        This Period         Rate             OT
                                                                                                     -
                                                                                                     -
                                                                                                     -
                                                                                                     -
                                                                                                     -
                                                                                                     -
                                                                                                     -
                                                                                                     -
                                                                                                     -
                                                                                                     -
                                                                                                     -
Total Overtime                                                                                       -




                                       8f7f9e02-2c05-453b-8dd1-a77c71d171bd.xls                                     Page 9

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:46
posted:1/18/2011
language:English
pages:9
Description: Demographics Data Template document sample