Cedar A.K.A. Sandras

Instructions

Status

1.- To be Assigned
2.- Work in Progress
3.- Completed
4.- Invoice & Payroll 5.- Paid

Substatus

0.- TMS ACCEPTED 1.- ON MY WAY TO FACILITY 2.- ARRIVED TO FACILITY 3.- LOADING 4.- ON MY WAY TO LOCATION 5.- ARRIVED TO LOCATION 6.- UNLOADING 7.- FINISHED

Invoice_rate -> desde el csvOWNER OPERATOR
Load_rate = company rate -> desde el csv
driver_rate -> se tiene que calcular

HR Positions

FIELD CREW SUPERVISOR
FIELD CREW MANAGER
FIELD CREW OPERATOR
OPERATIONS
MECHANICS
OFFICE

Types of drivers

DRIVER
HELPER TRUCK
OWNER OPERATOR

Tabla de comparacion (Millas -> Company Rate -> Driver Rate -> Driver rate percent)

miles	company rate	driver rate
0-50	446.01	111.50
51-60	453.57	113.39
61-70	468.70	117.18
71-80	483.83	130.63
81-90	502-75	135.74
91-100	514.09	138.80
101-111	525.45	141.89
111-120	559.49	151.06
121-130	578.40	156.17
131-140	597.31	161.27
141-150	623.80	168.43
151-160	642.71	183.17
161-170	661.62	188.56
171-180	680.53	193.95
181-190	699.45	202.58
191-200	710.79	211.20
201-210	741.06	219.83
211-220	771.32	228.45
221-230	801.58	237.70
231-240	831.84	254.32
241-250	862.10	262.95
251-260	892.36	271.57
261-270	922.63	280.20
271-280	952.89	288.82
281-290	983.15
291-300	1013.4

Locations status

ON GOING FINISHED

Divert status

1.- PENDING ASSIGN TICKET 2.- TICKET ASSIGNED 3.- COMPLETED