Commitments Calculations Matrix

Following is a matrix of the labor, expense, item, and document summary level commitments.

 

Type

Control VI Hours/Qty VI Overage Hours Cost Bill
Labor

N

Limit

 
PO Hours - TS Hours - VI  Labor Line Hours
LIMIT TO ZERO
PO Labor line Amount – VI Labor line amounts – [TS hours * effective cost rate (rounded)]

IF bill rate found

     IF committed cost >0

    THEN greater of [committed hours * bill rate] or

    committed cost

    ELSE lesser of [committed hours * bill rate] or  

   committed cost

ELSE committed cost

Labor

N

 

Don't Limit

 

PO Hours - TS Hours - VI  Labor Line Hours

LIMIT TO ZERO

PO Labor line Amount – VI Labor line amounts – [TS hours * effective cost rate (rounded)]

LIMIT TO ZERO

IF bill rate found

     IF committed cost >0

    THEN greater of [committed hours * bill rate] or

    committed cost

    ELSE lesser of [committed hours * bill rate] or

    committed cost

ELSE committed cost

LIMIT TO ZERO

Labor

N

 

Funding Cap Adj

 

PO Hours - TS Hours - VI  Labor Line Hours

LIMIT TO ZERO

PO Labor line Amount – VI Labor line amounts – [TS hours * effective cost rate (rounded)]

LIMIT TO ZERO

IF bill rate found

     IF committed cost >0

    THEN greater of [committed hours * bill rate] or

    committed cost

    ELSE lesser of [committed hours * bill rate] or   

   committed cost

ELSE committed cost

LIMIT TO ZERO

Labor

Y

 

Limit

 
PO Hours - TS Hours - VI  Labor Line Hours

IF cost rate specified

THEN

[committed hours * PO Labor line cost rate (rounded)]

ELSE

PO Labor line Amount – VI Labor line amounts – [TS hours * effective cost rate (rounded)]

IF bill rate found

THEN [committed hours * bill rate]

ELSE committed cost

Labor

Y

Don't Limit

PO Hours - TS Hours - VI  Labor Line Hours

IF cost rate specified

THEN

[committed hours * PO Labor line cost rate (rounded)]

DON'T LIMIT

ELSE

PO Labor line Amount – VI Labor line amounts – [TS hours * effective cost rate (rounded)]

LIMIT TO ZERO

IF bill rate found

THEN [committed hours * bill rate]

ELSE committed cost

Labor

Y

Funding Cap Adj

PO Hours - TS Hours - VI  Labor Line Hours

IF cost rate specified

THEN

[committed hours * PO Labor line cost rate (rounded)]

DON'T LIMIT

ELSE

PO Labor line Amount – VI Labor line amounts – [TS hours * effective cost rate (rounded)]

LIMIT TO ZERO

IF bill rate found

THEN [committed hours * bill rate]

ELSE committed cost

Expense

NA

Limit

NA PO Expense line Amount – VI Expense line amounts – Expense Report line amounts

IF markup found

THEN Committed Cost * (1 + [Expected Markup %]/100)

ELSE Committed Cost

Expense

NA

Don't Limit

NA

PO Expense line Amount – VI Expense line amounts – Expense Report line amounts

LIMIT TO ZERO

IF markup found

THEN Committed Cost * (1 + [Expected Markup %]/100)

ELSE Committed Cost

LIMIT TO ZERO

Expense

NA

Funding Cap Adj

NA

PO Expense line Amount – VI Expense line amounts – Expense Report line amounts

LIMIT TO ZERO

IF markup found

THEN Committed Cost * (1 + [Expected Markup %]/100)

ELSE Committed Cost

LIMIT TO ZERO

Item

N

Limit

NA PO Item line Amount – VI Item line amounts

IF Bill By set to Markup

THEN Committed Cost * (1 + [Expected Markup %]/100)

IF Bill By set to Bill Rate

THEN

     IF committed cost >0

    THEN greater of [committed qty * bill rate] or

    committed cost

    ELSE lesser of [committed qty * bill rate] or committed

    cost

ELSE Committed Cost

Item

N

Don't Limit

NA

PO Item line Amount – VI Item line amounts

LIMIT TO ZERO

IF Bill By set to Markup

THEN Committed Cost * (1 + [Expected Markup %]/100)

IF Bill By set to Bill Rate

THEN

     IF committed cost >0

    THEN greater of [committed qty * bill rate] or

    committed cost

    ELSE lesser of [committed qty * bill rate] or committed

    cost

ELSE Committed Cost

LIMIT TO ZERO

Item

N

Funding Cap Adj

NA

PO Item line Amount – VI Item line amounts

LIMIT TO ZERO

IF Bill By set to Markup

THEN Committed Cost * (1 + [Expected Markup %]/100)

IF Bill By set to Bill Rate

THEN

     IF committed cost >0

    THEN greater of [committed qty * bill rate] or

    committed cost

    ELSE lesser of [committed qty * bill rate] or committed

    cost

ELSE Committed Cost

LIMIT TO ZERO

Item

Y

Limit

NA

IF cost rate specified

THEN

[committed quantity * PO Item line cost rate (rounded)]

ELSE

PO Item line Amount – VI Item line amounts

IF Bill By set to Markup

THEN Committed Cost * (1 + [Expected Markup %]/100)

IF Bill By set to Bill Rate

THEN [committed qty * bill rate]

ELSE Committed Cost

Item

Y

Don't Limit

NA

IF cost rate specified

THEN

[committed quantity * PO Item line cost rate (rounded)]

DON'T LIMIT

ELSE

PO Item line Amount – VI Item line amounts

LIMIT TO ZERO

IF Bill By set to Markup

THEN Committed Cost * (1 + [Expected Markup %]/100)

IF Bill By set to Bill Rate

DON'T LIMIT

THEN [committed qty * bill rate]

ELSE Committed Cost

LIMIT TO ZERO

Item

Y

Funding Cap Adj

NA

IF cost rate specified

THEN

[committed quantity * PO Item line cost rate (rounded)]

DON'T LIMIT

ELSE

PO Item line Amount – VI Item line amounts

LIMIT TO ZERO

IF Bill By set to Markup

THEN Committed Cost * (1 + [Expected Markup %]/100)

IF Bill By set to Bill Rate

DON'T LIMIT

THEN [committed qty * bill rate]

ELSE Committed Cost

LIMIT TO ZERO

Document Summary

NA

Limit

NA PO Amount – VI Labor, Expense and Item line amounts – [TS hours * effective cost rate (rounded)] - Expense Report line amounts

Committed Cost

Document Summary

NA

Don't Limit

NA

PO Amount – VI Labor, Expense and Item line amounts – [TS hours * effective cost rate (rounded)] - Expense Report line amounts

LIMIT TO ZERO

Committed Cost

Document Summary

NA

Funding Cap Adj

NA

PO Amount – VI Labor, Expense and Item line amounts – [TS hours * effective cost rate (rounded)] - Expense Report line amounts

LIMIT TO ZERO

Committed Cost

 

Acronyms:

NA - Not Applicable

PO - Purchase Order

TS - Timesheet

VI - Vendor Invoice