USF Libraries
USF Digital Collections

Repair time standards for transit vehicles

MISSING IMAGE

Material Information

Title:
Repair time standards for transit vehicles transit database user's manual
Portion of title:
Transit database user's manual
Physical Description:
1 online resource (13 leaves) : ill. ;
Language:
English
Creator:
Centeno, Grisselle
University of South Florida -- Center for Urban Transportation Research
Publisher:
National Center for Transit Research, Center for Urban Transportation Research, University of South Florida
Place of Publication:
Tampa, Fla.
Publication Date:

Subjects

Subjects / Keywords:
Buses -- Maintenance and repair -- Databases -- Handbooks, manuals, etc -- Florida   ( lcsh )
Local transit -- Maintenance and repair -- Databases -- Handbooks, manuals, etc -- Florida   ( lcsh )
Genre:
government publication (state, provincial, terriorial, dependent)   ( marcgt )
handbook   ( marcgt )
non-fiction   ( marcgt )

Notes

Statement of Responsibility:
submitted by Grisselle Centeno.
General Note:
"September 24, 2002."

Record Information

Source Institution:
University of South Florida Library
Holding Location:
University of South Florida
Rights Management:
All applicable rights reserved by the source institution and holding location.
Resource Identifier:
aleph - 029120266
oclc - 752612980
usfldc doi - C01-00438
usfldc handle - c1.438
System ID:
SFS0032459:00001


This item is only available as the following downloads:


Full Text
xml version 1.0 encoding UTF-8 standalone no
record xmlns http:www.loc.govMARC21slim xmlns:xsi http:www.w3.org2001XMLSchema-instance xsi:schemaLocation http:www.loc.govstandardsmarcxmlschemaMARC21slim.xsd
leader nam 2200337Ia 4500
controlfield tag 001 029120266
005 20110915175134.0
006 m o d
007 cr bn|||||||||
008 110915s2002 flua of s000 0 eng d
datafield ind1 8 ind2 024
subfield code a C01-00438
035
(OCoLC)752612980
040
FHM
c FHM
d FHM
043
n-us-fl
090
HE5633.F6 (ONLINE)
1 100
Centeno, Grisselle.
0 245
Repair time standards for transit vehicles
h [electronic resource] :
b transit database user's manual /
submitted by Grisselle Centeno.
3 246
Transit database user's manual
260
[Tampa, Fla.] :
National Center for Transit Research, Center for Urban Transportation Research, University of South Florida,
[2002]
300
1 online resource (13 leaves) :
ill.
500
"September 24, 2002."
5 FTS
588
Description based on print version.
650
Buses
z Florida
x Maintenance and repair
Databases
v Handbooks, manuals, etc.
Local transit
Florida
Maintenance and repair
Databases
Handbooks, manuals, etc.
2 710
University of South Florida.
Center for Urban Transportation Research.
776
i Print version:
Centeno, Grisselle.
t Repair time standards for transit vehicles.
[Tampa, Fla.] : National Center for Transit Research, Center for Urban Transportation Research, University of South Florida, [2002]
w (OCoLC)53301849
773
Center for Urban Transportation Research Publications [USF].
4 856
u http://digital.lib.usf.edu/?c1.438
FTS
y USF ONLINE ACCESS
951
10
SFU01:001963447;
FTS



PAGE 1

REPAIR TIME STANDARDS F'DR TRANSIT VEHIC.LES TRANSIT DATABASE USER'S MANUAL SEPTEMBER 24, 2002 Submitted by: Grisselle Centeno, Ph. D. Industr ial and Management Systems Engineering Department University of South Florida FDOTProjectBC137-RPW032 CUTRAccount2117-473 LO

PAGE 2

TRANSIT DATABASE USER'S MANUAL 1

PAGE 3

TABLE OF CONTENT 1.0 WELCOME!! . . .... . . . .. .. ... ... .... . . .. . .. . . ... . . .... . . .... ... .. . ... .. ... 3 2 0 IN'T'RODUCTION ... . .... .. ......... ......... . .. . .. . ... ...... . . .... . . . . ......... . . 3 3.0 .SYSTEM REQUIREMENTS . .... . .... .... .... . ... ..... .... ....................... 3 4 0 BACK-UPS ... ......... .... .... ... ..... .... . .... .... ... . . .... . . . ...... . ........ .... . 3 5 0 ICONS .... .. ... .. .. .. .. ... ... .. ... .. ..... .. ... .. ... .. .. .. .. .. ........... .. ... .. .. ........... .. .. .. 4 6.0 MENUS ......................... .. . . .. . . .. . .. . .. . . .. . . ...... . . .. ... . . . .. . . .... . 4 6.1 Sub-Menus . .. .. .... . .... . .... .................... . ................. .. . . . .... . .... . s 6.1 1 Forms Sub-Menu .. . .. . .... . .. . .. . . .. . . . ..... . . ... .. . . . .. . . . .. . . S 6 .1.2 Reports Sub-Menu ...... . .......................... .. .. . . . . .. . . . . .. . . .. . 6 7.0 7.1 7 2 7.3 8.0 9.0 10.0 REPORTS .... . .... ..... .... .. ..... ...... ..... ...... . ........ ... ...... ... 7 Work Flow Report .... .... . .. . .... .... .... . .... . . . . . .. .... ... . .... ....... ... . .. 7 Work Log Report ................. .... ........ .... .... . ..... . . ........ . . . .... . . .... . 8 Performance L evel Rei)Ort . . ..... ... . ...... .... . . .... ..... ...... . ....... .... . . . 9 RELATIONSHIP BETWEEN DATA ... .... ...... .... . . . .... ... . ...... . ... ........... 10 HOW TO'S FOR TRANSIT DATABASE .................................................... ll TRANSIT DATABASE DICTIONARY .......... .... . ............................. ......... 12 2

PAGE 4

1.0 WELCOMEII Welcome to the Transit Database. The following Is a Users' Manual created to help a layman learn to understand and operate the database with ease, and generate customized Reports for viewing. 2.0 INTRODUCTION This database provides lnfonnation on the time standards for the repair of the braking systems of the transit vehicles. The database would also give the work e lements required to do the repair jobs on the transit vehicles along with the standard time required to do the job. The database is intended to help the managers to evaluate the relative productivity or the combined productivity of all employees. In addition, it allows managers to schedul e spedlic tasks to e mployees and to obtain an estimate of ending time of those tasks according to the standards preViously detennined. Other functions provided by database are explained further I n other sections. 3.0 SYSTEM REQUIREMENTS To use the Transit database, minimum system requirements are listed below: Intel Pentium processor, AMD Duron or equivalent (500 MHz system speed) 64MB RAM At least 50 MB of free hard d isk space ( 8 GB HOD p referred) Microsoft Office 2000, Professional edition. Microsoft Windows 2000 operating system CD ROM (16x preferred) 4.0 BACK-UPS It i s recommended that a back-up of the database be made very week I n order to have the latest and current information stored in case of machine failure. Back-ups must be stored on a separate machine preferably, on FTP Programs (Remote disk space) or on CD If a CD Burner is available. 3

PAGE 5

5.0 ICONS The following are the various loons used within the database, and their function is explained briefly. REPORT BUTTON FORM BUTTON 'BACK' NAVIGATION BUTTON 'EXIT MENU' BUTTON 6.0 MENUS The Main Menu Is provided with two buttons: one for Data Entry (Forms) and another to view/customize Reports There Is an Exlt button at the bottom to dose this page. 4

PAGE 6

6.1 Sub-Menus Every submenu has clearly marked buttons for accessing various Forms or Reports. For Example, within the Reports Menu, we have a Work Flow Report, for viewing the flow of various processes In a Brake Job. 6 1.1 Forms SubMenu Forms are meant for data entry, updating, editing and deleting records of transactions, clients order In Informati on, etc It is through these forms that the database will be populated. Keeping in mind user convenience, the menus are created in such a way that the user can move from one related form to another with in a single click. For example, for entering employee data for a new employee, the Employee Deta ils Form needs to be updated. So when the user fills out the Employee Form, the next for in the sequence can be accessed by one click as shown In the screen shot below. To access the forms simply select the required form from the Forms Menu. As shown below, there are several b uttons to access various forms. These Forms are used to enter/update data in the tables of the data base. The formats and parameters for entering data in forms are shown in the Data Dictionary at the end of the manual. a :..IIlLi! frnployee Job lnfo :-. . : i : Add/Edit o Pro.cets O.toU Add/Ecltt Elemen.tll Updte Elemenu ln a f'f'Oceu Adel/fdlt S'(ftem D&tell t Md/Edtt Employee Info 5

PAGE 7

6.1.2 Reports SubMenu Reports provide specific business information in a printable format. Some of the reports can be generated based on criteria like tlme period. Every report created for the Transit Database has a specific business function like Employee Performance tracking or Work Flow. Details of all the Reports are given below. As shown next the Reports sub-menu has three buttons to access the respective Reports. The Work Order Report takes user inputs for Report start and end dates. WORK LOGS WOFUC FLOW CHARTS PERFORMANCE LEYELS ' : 6

PAGE 8

7.0 REPORTS Reports provide specific busineSs information !n a printab l e format. Some of the reports can be generated based on criteria like time period. Every report c reated for the Transit Database has a spedfic business function lik e Employee Performance tracking or Work F low. Details o f ail the Reports are given below. 7.1 Work Flow Report As shown below, this report shows at a glance the processes Involved in a brake job, their Standard Times and a b rief description of the p rocesses. This can be handed to a worker along with the Flow Chart provided with the database to use as a guideline. The Management can a lso a dd/edit processes through the Forms, and ail changes will automatically b e reflected In the Reports. IIIJIIIIIIIIIIIIIJIIIIIIIII.IIIIIIIIIIIJIUIIIIIIIIII U III.IIIliiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii U IIIIIIIIIIUI Work Flow IIII IIIU I UI11111.11IIIIUIIIIIIIIIIIIIIIIII IIIIIIIIII II.III1111111111111111111111111IIIIII IIIIIIIIIIU I UIIIIU I111 System ttame brakes Grand Total Proc::es:s Nome Sus Arrangement Remova Tires itd T ime tAinutes Description 5 R a ise bus and batk up btakes 8 RHS a n d LHS wfleel s Axle Removs\ 1 0 Orum Disassem bl y 1 5 Mount Shoe B rake 2 1 Moun t Hub And Drum 18 Mount Axl e 1 5 Sus adjust ment 1 4 Tire Mounting 24 130 R e m oving a.11le$ on e ither side wi1h assembly Dissambling the drums Mounting the s hoe btake MotJnting the hub an1S drum on either s ide Mountina the axle assembly b ack on either si d e Receding the brakes Mounting w h eels o.n tlot h sidot b .. c k 7

PAGE 9

7.2 Wor k Log Report For this report the user needs to. enter start and end dates for which the Report is generated. This Report shows which job was performed by which employee and on what date. It also provides comparison between Operator and Standard t imes. Report i s shown below. This Report keeps a track of worker performance and can be used for performance evaluation, ident ifying train ing needs and assessing sclentlflc grounds for promotion of employees .... ............... -............ . ................ .. ..... .. .. _, .................. .. ................... ......................... Work log ..... ........ ............. ,.. .... . ..... ......... ..... _, ........... ........ ...................... _,_ .................. .. First Name Last Name Job Type Std Tlme Opera tor Time Date Rar .. b rakes 300 32 812912002 brakes 300 333 7131/2002 brakes 300 340 713112002 brakes 300 265 7/31/2002 brakes 300 753 9/112002 Vil< Elhide 300 410 6/1212002 btlkas 300 285 6/1212002 bi'Skee 300 340 811212002 300 2AS 811212002 brakss 300 30 91151all 2 8

PAGE 10

7.3 Performance Level Report This is a graphical Report and shows at a glance the number of jobs worked on, the average Performance level for the jobs. This allows Management to find out the preparedness of the facility to do brake jobs. See picture below. Performance Level brakes S)lstem 9

PAGE 11

8.0 RELATIONSHIP BETWEEN DATA All the tables within the database are connected to one another in some way, such that data can be viewed using the Reports in any manner. The relationships are shown below In the Entity-Relationship diagram. Explanation of each table is covered in the data dictionary. 10

PAGE 12

9.0 HOW TO'S FOR TRANSIT DATABASE 1. How to enter a new Element in a Process? Two forms need to be entered, the Element Details form, which adds a new element into the database and the ElementsinProcess form, which corresponds this element to a particular Process/es. 2. How to evaluate employee performance? Use the 'Work Log' report by entering the period for which performance measurement is needed. Then check the employees Performance Rating, and compare improvement/progress. 3. How to add Processes to a system? Use the Process details form to create a new Process and match it to a system via th e SystemiD. IMPORTANT: When adding new process times, give additional 15% allowance to the times for fatigue, standing, etc. by multiplying the time by 1.15. 4. How to generate a Work Order? Use the Work Flow report to enlist Standard Times and processes i n the system to be worked on, and use the 'Proposed Row Chart' to check detailed method. S. How to measure System time? After the set up is complete and the work order is given, start the time measurement. Stop the clock for foreign elements, and restart after it Is resolved. Stop the clock when work order is returned. 6. How to delete Inco rrect entries? Go to the concerned form, scroll to the incorrect enby using scroll bars at the bottom, and when the desired record appears, delete ently or delete entire record. 11

PAGE 13

10.0 TRANSIT DATABASE DICTIONARY System: This refers to the various jobs like brakes, air conditioning, etc within the fadllty. Prooess: A system Is made up of several 'Processes' as shown In the Process table. Each Process is unique and corresponds to some System via the System 10. Element: This is sma llest defined work element. Many elements together make a Process or entire System, e.g., Remove Nuts from wheel. The database contains over 200 Elements corresponding to Brake Jobs. The following tables summarizes and describes each of the entity sets of the database. For each entity sets and related attributes. the data type along with the description for each attribute is provided. 12

PAGE 14

DATA DICTIONARY TABLE NAME ATIRIBUTE OATATVPE OESCRIPnON *rocessiO (PK)* AUto Number Automatically generated number rooess!O Number Roc:ords tM 10 ass:Qned to ead1process elementiO Number Records number olven t o each element employee fmOIOYOO fnformation emiliO>ee!O (PK)'B41 Aut:oNumber Automatkallv aenerated number nrstNamc Text Records emplovee name lastName Text Records emplOyee last name -.ssStreet T ext Records employee address -.sscav Text Records emolovee c itv addr'essstat:a Text Records emolovee state addressZio Text Records emolovee zlo code Text Records emokM:!e phone number SkJIICode Humber Records emolovee skUI code manaoeriO Text Records manaoers IO nt Text Records the name of the deoartment comoarwName Text Records the name of the raclllt v Gives the processes petfonned by the empiO'JI!eSVStem emoiO'II!es empl .,......ocessll> (PI<) AutoNumber Automa enerated number IS\'Stemlo Number Record Svstems 10 staltTime Dale/Time Records ume that the svstcm was starta d encmone Dale/limo Records timo that t:ha system was coml)let< Date Oab!rome Records the date of_ operation ooeratlonnme Number Records the total time fOf the ooeratSon effid81CY Number Records the effidencv ( 1 00 nonnan crooess ustoraa rocessm { P Kl* AUtoNumbet !0 Number Records the svstems 10 rocessName Text Records the orccess name stomme Number Records the -standard timo descript;on Text Records dOSCriDtiOI'I Of the I)I'OC(!:SSOS tho ranoe of pcrc::eotag'l) tsmeand skill skill Tratker code ocr ooeraoor sldOCOde A o.N umber Records the Skill coda for tho ranacstart Numller Ptooef"!Md scal e r or oerfoiYllanre evaruation ranaefnd Number Predetaned scale ror oerformanre evaluatio n lsvstem Qves the svstems lnfo:matlon II> (PI