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