see description and attachment

profilepapchu
cat_contract_assessment_worksheet.xlsm

Sheet1

Contract Assessment Worksheet
Contractor Name: Caterpillar Start Date: 12/1/15
Contract No.: End Date:
Contracted Service(s) Provided: Option Periods:
Form Completed By: SCM320 Class Date: 11/4/15
Risk Factors Weight Comments
1. Contract Size 9 FALSE FALSE TRUE
2. Performance Period 7 TRUE FALSE FALSE
3. Contract Type 9 TRUE TRUE FALSE
4. Complexity of Contract Requirements 7 FALSE FALSE FALSE
5. Contract Award 7 FALSE TRUE FALSE
6. Contractor 7 FALSE FALSE TRUE
7. Contract Subject 9 FALSE FALSE TRUE
8. Subcontractors 5 TRUE FALSE FALSE
9. Contracting Officer and/or Contracting Organization 5 FALSE TRUE FALSE
10. Contract Modifications 7 FALSE TRUE FALSE
11. Age of Program or Service 3 TRUE FALSE FALSE
12. Access to Personally Identifiable, Proprietary and/or Classified Information 5 FALSE TRUE FALSE
80
Contract Risk = Medium

Evaluate

Sheet2

0 0 5 5 9 45
1 0 0 1 7 7
1 0 1 9 9
0 0 0 0 7 0
0 3 0 3 7 21
0 0 5 5 7 35
0 0 5 5 9 45
1 0 0 1 5 5
0 3 0 3 5 15
0 3 0 3 7 21
1 0 0 1 3 3
0 3 0 3 5 15
4 9 15 28 80 221
2.7625
1 Low
2 Medium
3.5 High

Sheet3

3
5
7
9

Large

Large

5 - 10 Years

5 - 10 Years

More than 10 years

More than 10 years

Fixed Price

Fixed Price

Cost Reimbursable

Cost Reimbursable

High Complexity

High Complexity

Low Complexity

Low Complexity

Full and open competition with

a large # of bidders or

simplified acquisition

procedures

Full and open competition with

a large # of bidders or

simplified acquisition

procedures

Competitive acquisition with

limited # of bidders

Competitive acquisition with

limited # of bidders

Sole source

Sole source

Known issues with contractor,

such as defaults; suspensions

or debarments; past

performance issues; significant

audit findings on previous

contracts; or past or ongoing

investigations or lawsuits

Known issues with contractor,

such as defaults; suspensions

or debarments; past

performance issues; significant

audit findings on previous

contracts; or past or ongoing

investigations or lawsuits

Agency has experience with

contractor, only minor issues,

or new contractor

Agency has experience with

contractor, only minor issues,

or new contractor

Agency has significant

experience with contractor and

no signficant issues

Agency has significant

experience with contractor and

no signficant issues

Not mission critical or not

highly visible, sensitive, or

potentially controversial

Not mission critical or not

highly visible, sensitive, or

potentially controversial

Contract is moderately visible,

sensitive, or controversial

Contract is moderately visible,

sensitive, or controversial

Contract is mission critical or is

highly visible, sensitive, or

potentially controversial

Contract is mission critical or is

highly visible, sensitive, or

potentially controversial

Percent of work subcontracted

is less than 25%

Percent of work subcontracted

is less than 25%

Percent of work

subcontracted is between

25% and 50%.

Percent of work

subcontracted is between

25% and 50%.

Percent of work subcontracted

is more than 50%

Percent of work subcontracted

is more than 50%

Previous audits or program

reviews noted no signficant

deficiencies with the CO and/or

organization

Previous audits or program

reviews noted no signficant

deficiencies with the CO and/or

organization

Less than 5 years

Less than 5 years

Previous audits or program

reviews noted moderate

deficiencies with the CO

and/or organization

Previous audits or program

reviews noted moderate

deficiencies with the CO

and/or organization

Previous audits or program

reviews noted signficant

deficiencies with the CO

and/or organization

Previous audits or program

reviews noted signficant

deficiencies with the CO

and/or organization

No modifications or

modifications had little impact

on cost and/or period of

performance

No modifications or

modifications had little impact

on cost and/or period of

performance

Modifications moderately

increased cost and/or period

of performance

Modifications moderately

increased cost and/or period

of performance

Modifications significantly

increased cost and/or period of

performance

Modifications significantly

increased cost and/or period of

performance

Existing with no changes within

past year

Existing with no changes within

past year

Existing with minimal changes

within past year

Existing with minimal changes

within past year

New or existing with significant

changes

New or existing with significant

changes

Moderate Complexity

Moderate Complexity

No requirement to access

No requirement to access

Small

Small

Limited requirement to access

Limited requirement to access

Requirement to access

Requirement to access

Medium

Medium