The processing of work related costs throughout MET/TEAM is calculated when the Work Order is returned. The table below explains the hierarchy used for the calculations, the formulas, and several examples.
|
Funding Calculation Hierarchy |
|||||
|
1. Kind of Job Number |
|||||
|
2. Customer Hourly Rate * Work
Order Labor (if charged) |
|||||
|
3. Service Facility Hourly Rate *
Work Order Labor (if charged) |
|||||
|
Job Number = Standard Hours Formula |
if(JN="Standard
Hours",(SP*AQ),0) + (if(OHR<>0, if(WLHC="Y", OHR*WLH,0),if(WLHC="Y",
SHR*WLH,0)))+ if(ISOB="Y",ISO,0) + (WOPQ*WOPP) |
||||
|
Job Number = Level of Effort Formula |
if(JN="Level of
Effort",0,(SP*AQ)) + (if(OHR<>0, if(WLHC="Y",
OHR*WLH,0),if(WLHC="Y", SHR*WLH,0))) + if(ISOB="Y",ISO,0)
+(WOPQ*WOPP) |
||||
|
Funding Attributes |
Job Number = Standard Hours. No
associated std. price, hourly rates, or labor. |
Job Number = Standard Hours. Std.
price exists, no hourly rate or labor. ISO fee exists not used. |
Job Number = Standard Hours. Std.
price exists, no hourly rate or labor. ISO fee exists and used. |
Job Number = Standard Hours. Std.
price exists, Customer hourly rate exists but no labor added to Work Order.
ISO fee exists not used. |
Job Number = Standard Hours. Std.
price exists, Customer hourly rate exists but no labor added to Work Order.
ISO fee exists and used. |
|
Kind of Job Number (JN) |
Standard Hours |
Standard Hours |
Standard Hours |
Standard Hours |
Standard Hours |
|
Type Procedure Standard Hours (SH) |
5 |
5 |
5 |
5 |
5 |
|
Type Procedure Standard Hours Type |
Average |
Average |
Average |
Average |
Average |
|
Type Procedure Std. Price (SP) |
0 |
100 |
100 |
100 |
100 |
|
Asset Characteristics Quantity (AQ) |
1 |
2 |
1 |
1 |
3 |
|
ISO Cert Fee (ISO) |
0 |
225 |
225 |
225 |
225 |
|
Customer Hourly Rate (OHR) |
0 |
0 |
0 |
50 |
50 |
|
Service Facility Hourly Rate (SHR) |
0 |
0 |
0 |
0 |
0 |
|
Work Order ISOCert Checked (ISOB) |
N |
N |
Y |
N |
Y |
|
Work Order Labor Hours (WLH) |
0 |
0 |
0 |
0 |
0 |
|
Charge Work Order Labor (WLHC) |
N/A |
N/A |
N/A |
N/A |
N/A |
|
Work Order Parts Qty (WOPQ) |
0 |
0 |
0 |
0 |
0 |
|
Work Order Parts Price (WOPP) |
0 |
0 |
0 |
0 |
0 |
|
Returning Cost (RC) |
$
- |
$
200 |
$
325 |
$
100 |
$ 525 |
|
Comments |
Job Number = Standard Hours. Std.
price exists, Customer hourly rate exists, labor added to Work Order but not
charged. ISO fee exists not used. |
Job Number = Standard Hours. Std.
price exists, Customer hourly rate exist labor added to Work Order but not
charged. ISO fee exists and used. |
Job Number = Standard Hours. Std.
price exists, Customer hourly rate exist labor added to Work Order and
charged. ISO fee exists not used. |
Job Number = Standard Hours. Std.
price exists, Customer hourly rate exist labor added to Work Order and
charged. ISO fee exists and used. |
Job Number = Standard Hours. Std.
price exists, Customer hourly rate exists, labor added to Work Order and
charged. Parts added to Work Order. ISO fee exists not used. |
|
Kind of Job Number (JN) |
Standard Hours |
Standard Hours |
Standard Hours |
Standard Hours |
Standard Hours |
|
Type Procedure Standard Hours (SH) |
5 |
5 |
5 |
5 |
5 |
|
Type Procedure Standard Hours Type |
Average |
Average |
Average |
Average |
Average |
|
Type Procedure Std. Price (SP) |
100 |
100 |
100 |
100 |
100 |
|
Asset Characteristics Quantity (AQ) |
1 |
3 |
1 |
2 |
1 |
|
ISO Cert Fee (ISO) |
225 |
225 |
225 |
225 |
225 |
|
Customer Hourly Rate (OHR) |
50 |
50 |
50 |
50 |
50 |
|
Service Facility Hourly Rate (SHR) |
0 |
0 |
0 |
0 |
0 |
|
Work Order ISOCert Checked (ISOB) |
N |
Y |
N |
Y |
N |
|
Work Order Labor Hours (WLH) |
2.5 |
2.5 |
2.5 |
2.5 |
2.5 |
|
Charge Work Order Labor (WLHC) |
N |
N |
Y |
Y |
Y |
|
Work Order Parts Qty (WOPQ) |
0 |
0 |
0 |
0 |
4 |
|
Work Order Parts Price (WOPP) |
0 |
0 |
0 |
0 |
3.25 |
|
Returning Cost (RC) |
$
100 |
$
525 |
$
225 |
$
550 |
$
238 |
|
Comments |
Job Number = Standard Hours. Std.
price exists, Customer hourly rate exist labor added to Work Order and
charged. Service Facility hourly rate added but no labor entered at that
rate. Parts removed from Work Order. ISO fee exists not used. |
Job Number = Standard Hours. Std.
price exists, Customer hourly rate removed. Previous labor on Work Order at Customer's
previous hourly rate; charged. Service Facility hourly rate added but no
labor entered at that rate. ISO fee exists Not used. |
Job Number = Standard Hours. Std.
price exists, Customer hourly rate removed. Previous labor on Work Order
removed. Service Facility hourly rate exists but no labor entered at that
rate. ISO fee exists not used. |
Job Number = Standard Hours. Std.
price exists, Customer hourly rate doesn't exist. Service Facility hourly
rate exists and labor entered and charged at Service Facility rate. ISO fee
exists not used. |
Job Number = Standard Hours. Std.
price exists, Customer hourly rate doesn't exist. Service Facility hourly
rate exists and labor entered and charged at Service Facility rate. Part
added to Work Order. ISO fee exists not used. |
|
Kind of Job Number (JN) |
Standard Hours |
Standard Hours |
Standard Hours |
Standard Hours |
Standard Hours |
|
Type Procedure Standard Hours (SH) |
5 |
5 |
5 |
5 |
5 |
|
Type Procedure Standard Hours Type |
Average |
Average |
Average |
Average |
Average |
|
Type Procedure Std. Price (SP) |
100 |
100 |
100 |
100 |
100 |
|
Asset Characteristics Quantity (AQ) |
2 |
1 |
3 |
1 |
1 |
|
ISO Cert Fee (ISO) |
225 |
225 |
225 |
225 |
225 |
|
Customer Hourly Rate (OHR) |
50 |
0 |
0 |
0 |
0 |
|
Service Facility Hourly Rate (SHR) |
75 |
75 |
75 |
75 |
75 |
|
Work Order ISOCert Checked (ISOB) |
N |
N |
N |
N |
N |
|
Work Order Labor Hours (WLH) |
2.5 |
2.5 |
0 |
3 |
3 |
|
Charge Work Order Labor (WLHC) |
Y |
Y |
N/A |
Y |
Y |
|
Work Order Parts Qty (WOPQ) |
0 |
0 |
0 |
0 |
8 |
|
Work Order Parts Price (WOPP) |
0 |
0 |
0 |
0 |
3.25 |
|
Returning Cost (RC) |
$
325 |
$
225 |
$
300 |
$
325 |
$ 351 |
|
Comments |
Job Number = Level of Effort. Standard
Hours and Std. Price exists have no effect. ISO fee exists not used. |
Job Number = Level of Effort. Standard
Hours and Std. Price exists have no effect. Customer hourly rate exists,
labor is added to the Work Order and charged. Service Facility hourly rate
added but no labor entered at that rate. ISO fee exists not used. |
Job Number = Level of Effort. Standard
Hours and Std. Price exists have no effect. Customer hourly rate does not
exist. Service Facility hourly rate exists and labor entered on Work Order at
that rate. ISO fee exists not used. |
Job Number = Level of Effort. Standard
Hours and Std. Price exists have no effect. Customer hourly rate exists.
Service Facility hourly rate exists. Labor entered on Work Order uses Customer
hourly rate. Parts added to Work Order and charged. ISO fee exists not used. |
Job Number = Level of Effort. Standard
Hours and Std. Price exists have no effect. Customer hourly rate exists.
Service Facility hourly rate exists. Labor entered on Work Order uses Customer
hourly rate. Parts added to Work Order and charged. ISO fee exists and used. |
|
Kind of Job Number (JN) |
Level of Effort |
Level of Effort |
Level of Effort |
Level of Effort |
Level of Effort |
|
Type Procedure Standard Hours (SH) |
5 |
6 |
5 |
5 |
5 |
|
Type Procedure Standard Hours Type |
Average |
Average |
Average |
Average |
Average |
|
Type Procedure Std. Price (SP) |
100 |
100 |
100 |
100 |
100 |
|
Asset Characteristics Quantity (AQ) |
2 |
1 |
3 |
1 |
1 |
|
ISO Cert Fee (ISO) |
225 |
225 |
225 |
225 |
225 |
|
Customer Hourly Rate (OHR) |
0 |
50 |
0 |
50 |
50 |
|
Service Facility Hourly Rate (SHR) |
0 |
75 |
75 |
75 |
75 |
|
Work Order ISOCert Checked (ISOB) |
N |
N |
N |
N |
Y |
|
Work Order Labor Hours (WLH) |
0 |
1 |
1 |
1 |
1 |
|
Charge Work Order Labor (WLHC) |
N/A |
Y |
Y |
Y |
Y |
|
Work Order Parts Qty (WOPQ) |
0 |
0 |
0 |
8 |
8 |
|
Work Order Parts Price (WOPP) |
0 |
0 |
0 |
3.25 |
3.25 |
|
Returning Cost (RC) |
$
- |
$
50 |
$
75 |
$
76 |
$
301 |
Related Topics