dpw works automated system to improve route performance andefficiency and efficiency district of...
TRANSCRIPT
DPW WorksDPW WorksAutomated System to Improve Route Performance Automated System to Improve Route Performance
andand EfficiencyEfficiency
District of ColumbiaDistrict of ColumbiaSolid Waste Management AdministrationSolid Waste Management Administration
2
DPW WorksDPW Works
Operations of SWMAOperations of SWMA
• Residential Collection Residential Collection – Curbside collection - 109,000 customers Curbside collection - 109,000 customers
• Supercan & 2X/wk pickupSupercan & 2X/wk pickup
– Bulk & heavy trash Bulk & heavy trash • scheduled & unscheduledscheduled & unscheduled
• Street & Alley CleaningStreet & Alley Cleaning– Mechanical sweepingMechanical sweeping– Alley cleaning Alley cleaning – Nuisance abatement Nuisance abatement (e.g. illegal dumping)(e.g. illegal dumping)
– Special eventsSpecial events– Leaf & snow removalLeaf & snow removal
3
DPW WorksDPW WorksDistrict of ColumbiaDistrict of Columbia
Before Before DPW WorksDPW Works system system
• Accountability difficult to measureAccountability difficult to measure– Little supporting documentationLittle supporting documentation– Manual reports – limited valueManual reports – limited value
• Excessive paper workExcessive paper work– Slow process in completion & distribution of reports/forms Slow process in completion & distribution of reports/forms
• Minimal information available to evaluate route size & Minimal information available to evaluate route size & performanceperformance
• Vehicle status & breakdown information maintained by Vehicle status & breakdown information maintained by Fleet ServicesFleet Services
• Costs for various services: highly inaccurateCosts for various services: highly inaccurate• OT efforts & costs not well tracked OT efforts & costs not well tracked
4
DPW WorksDPW WorksDistrict of Columbia District of Columbia
Results of Results of DPW WorksDPW Works system system
• Documentation to support management reports, Documentation to support management reports, budgets & operational changesbudgets & operational changes– On-line access to current & historical information On-line access to current & historical information – Planning: Route size, Staffing levels, Vehicle utilizationPlanning: Route size, Staffing levels, Vehicle utilization
• Reduced work in compilation & distribution of paper Reduced work in compilation & distribution of paper documentsdocuments– Payroll processing streamlined through on-line access to time Payroll processing streamlined through on-line access to time
& attendance and overtime& attendance and overtime
• Basis for accurate costing & reimbursement of servicesBasis for accurate costing & reimbursement of services• Encouraging Business Unit supervisors to be Encouraging Business Unit supervisors to be
accountable for employees, equipment & routesaccountable for employees, equipment & routes• Building employee technology & management skillsBuilding employee technology & management skills
5
DPW WorksDPW WorksImplementationImplementation
• Automated daily assignment & Automated daily assignment & tracking of personnel, vehicles, tracking of personnel, vehicles, and routesand routes
• Key operational data captured, Key operational data captured, at source, to allow efficient at source, to allow efficient tracking of service performance tracking of service performance and costsand costs
• Performance reporting by Performance reporting by Business Unit, Activity/Service, Business Unit, Activity/Service, District, and Route/CrewDistrict, and Route/Crew
• On-line access to daily and On-line access to daily and summary information across summary information across the organization & various the organization & various locationslocations
DPW Works was implemented in 2001 for Residential Collection and 2002 for Street & Alley Cleaning. Key features include:
EquipmentPersonnel
Routes
Business Unit
6
DPW WorksDPW WorksSystem TechnologySystem Technology
• ““Custom developed” system for D.C. SWMACustom developed” system for D.C. SWMA• Client-Server system using Microsoft SQL Server Client-Server system using Microsoft SQL Server
relational databaserelational database• Operates on local and wide area networksOperates on local and wide area networks
• Currently, approximately 50 users in D.C. Currently, approximately 50 users in D.C.
– Operating within 10 Business Units (at 9 locations throughout Operating within 10 Business Units (at 9 locations throughout city)city)
• Features include:– Scaleable architecture to accommodate a large number of users across
WAN/LAN
– Installation on a central or local server with run-time versions installed on individual client machines (no per user licensing fee)
– System upgrades/modifications are automatically updated on client machines & remote access capability (via secure Internet connection)
7
DPW WorksDPW Works
Daily ProcessingDaily Processing
System workflow follows the normal daily processing System workflow follows the normal daily processing for solid waste collection operations.for solid waste collection operations.
Business Unit
Business Unit ActivityActivity
RouteRoute
Task or Work Order
Task or Work Order
Employee Attendance
Employee Attendance
EquipmentAvailability
EquipmentAvailability
PerformanceAccomplishments•Routes completed•Cost/route or ton•Vehicle utilization•Personnel overtime•Tons or loads / run•Service orders completed
PerformanceAccomplishments•Routes completed•Cost/route or ton•Vehicle utilization•Personnel overtime•Tons or loads / run•Service orders completed
WorkSchedules
WorkSchedules
8
DPW WorksDPW Works System FunctionalitySystem FunctionalityMain MenuMain Menu
User permissions, Lookup table settings, and Application variables.
Full range of features to manage attendance & daily operations.
Independent input of personnel, vehicle, and route information.
Large selection of reports can be created and printed for cost and performance measurements.
9
DPW WorksDPW Works System FunctionalitySystem FunctionalityDefault ConfigurationsDefault Configurations
• Routes are grouped by any Routes are grouped by any Work Setup such as day of Work Setup such as day of week, service area, or week, service area, or special activity. special activity.
• Multiple setups can be Multiple setups can be created to select any group created to select any group of routes for day. of routes for day.
• Default setup can then be Default setup can then be modified as needed to modified as needed to reflect day’s work & staff/ reflect day’s work & staff/ vehicle assignments.vehicle assignments.
10
DPW WorksDPW Works System FunctionalitySystem FunctionalityDaily AssignmentsDaily Assignments
• Daily Assignment Tracking Screen (DATS) is the supervisor’s Daily Assignment Tracking Screen (DATS) is the supervisor’s primary screen with all daily work for the Business Unitprimary screen with all daily work for the Business Unit
• Access provided to other screens to manage daily operations Access provided to other screens to manage daily operations such as employee, vehicle & route statuses, crew assignments, such as employee, vehicle & route statuses, crew assignments, route operations, and overtimeroute operations, and overtime
11
DPW WorksDPW Works System FunctionalitySystem FunctionalityTime & AttendanceTime & Attendance
• Daily Time & Attendance Screen serves as the time & Daily Time & Attendance Screen serves as the time & attendance form for a Business Unit attendance form for a Business Unit
• Employee status, work hours, and overtime hours provide key Employee status, work hours, and overtime hours provide key inputs for personnel & labor cost reporting.inputs for personnel & labor cost reporting.
12
DPW WorksDPW Works System FunctionalitySystem FunctionalityVehicle StatusVehicle Status
• Update vehicle status, Update vehicle status, breakdowns and repair breakdowns and repair needsneeds
• Access vehicle Access vehicle specifications and specifications and operational historyoperational history
• Capability to borrow or Capability to borrow or transfer vehicles among transfer vehicles among Business UnitsBusiness Units
13
DPW WorksDPW Works System FunctionalitySystem FunctionalityDaily OperationsDaily Operations
• The Daily Operations Tracking Screen (DOTS) monitors The Daily Operations Tracking Screen (DOTS) monitors individual route information for performance and costing individual route information for performance and costing evaluations.evaluations.
• DOTS worksheets are completed by the driver and input at end DOTS worksheets are completed by the driver and input at end of day.of day.
14
DPW WorksDPW Works
ReportingReporting
• A comprehensive selection A comprehensive selection of daily and summary of daily and summary reports reports
• Four categories of reports Four categories of reports - employee, vehicle, route, - employee, vehicle, route, and cost.and cost.
• Query fields include:Query fields include:– Dates (& ranges)Dates (& ranges)
– Business unitBusiness unit
– ActivityActivity
– District / wardDistrict / ward
15
DPW WorksDPW WorksReport DataReport Data
(FY2002)(FY2002)
0
1,000
2,000
3,000
4,000
5,000
6,000
7,000
8,000
10 11 12 1 2 3 4 5 6 7 8 9
To
ns / m
o.
So. Capitol Brentw ood Bulk
Tonnage Collected per MonthResidential Collection
Month
Service Requests - Bulk ServiceResidential Collection
0
2,000
4,000
6,000
8,000
10,000
12,000
10 11 12 1 2 3 4 5 6 7 8 9Months
Service Requests-Sched. Service Requests-Unsched.
16
DPW WorksDPW WorksReport DataReport Data
(FY2002)(FY2002)
% OT Hours to Total HoursResidential Collection
0%
2%
4%
6%
8%
10%
12%
14%
16%
10 11 12 1 2 3 4 5 6 7 8 9 TotalMonths
So. Capitol Brentw ood Bulk
% Vehicles DownResidential Collection
0%
2%
4%
6%
8%
10%
12%
14%
16%
18%
10 11 12 1 2 3 4 5 6 7 8 9 TotalMonths
So.Capitol Brentw ood Bulk
17
DPW WorksDPW WorksReport DataReport Data
(FY2002)(FY2002)
OT Hours by Day of WeekResidential Collection
0%
10%
20%
30%
40%
50%
60%
Mon Tue Wed Thu Fri Sat Sun
So. Capitol Brentw ood Bulk
% Overtime Hours for Yard
OT Hours by Day of WeekResidential Collection
0
1,000
2,000
3,000
4,000
5,000
6,000
7,000
8,000
9,000
Mon Tue Wed Thu Fri Sat Sun
So. Capitol Brentw ood Bulk
Total Overtime Hours for FY2002
18
DPW WorksDPW Works
Contact InformationContact Information
Tom Henderson, Administrator, SWMATom Henderson, Administrator, SWMA
• 202-645-5141202-645-5141
• [email protected]@dc.gov
Tony Duckett, Division Manager, SWMATony Duckett, Division Manager, SWMA
• 202-645-4303202-645-4303
• [email protected]@dc.gov
Mel Paret, Principal, Public Works SolutionsMel Paret, Principal, Public Works Solutions
• 703-516-9220703-516-9220
• [email protected]@dpwsolutions.com