Services Pre PNM Assignment

mckn277
template_guide_new.docm
Home>Government homework help>Services Pre PNM Assignment

PROC 5870 Services Pre PNM Exercise Due Week 8 TEMPLATE GUIDE

General comments:

This template was developed to assist you in working through the exercise addressing the concepts and cost elements associated with the Services Pre-PNM assignment. You will find the proposed and objective portions of the total cost element table completed for you as well as entries in the tables addressing the individual cost elements. Make sure you look at each one carefully to see what is missing and need to complete the optimistic and pessimistic positions . To save some effort, in the total cost area under III you only need to plug in the dollars you would propose for the pessimistic – you can explain the rationale in the supporting narrative for each of the cost elements, you do not have to present the buildup in the table. (This also allows the table to fit on the page!). Remember there are four positions presented in this pre-PNM: the contractor’s proposed, the objective/target where we think we will end up, the optimistic if everything goes our way and the pessimistic worst case scenario.

You may answer the “questions for thought and comment” outside of the PNM document if you wish, or because of the manner in which Mr. Bitner (course developer) presents the in the case, you are welcome to address the questions where they appear in the pre-PNM discussion. All the questions I require you to address are listed in this template in the pertinent areas so if you just work from this template you will cover everything you need to complete. All three assignments are included in this template –Assignment 1 is the pre PNM and questions, Assignments 2 and 3 following the PNM. Throughout the template I have added some extra reminders and/or notes to help you. In exercise 3 for example you are provided the formulas and a table to use for calculating the final CPIF based on an underrun (undertarget cost).

Remember from your first PNM there are cases when the target (most likely objective) and pessimistic positions could be the same; likewise, sometimes the proposed and objective are the same, or your optimistic is the same as the objective. To save time on this case, assume any allowed questioned or unsupported areas of the contractor proposal could be supported and/or defended by the contractor at the prices proposed for a pessimistic position. Remember however, if there had been unallowed costs these should not be part of any of your negotiating positions and would never be permitted.

In the fee area you are not asked to present a weighted guideline analysis but know that in practice you would actually include that calculation to support your fee position. Likewise you are not asked to work through a capital cost of money. For both you may just accept what is provided as sufficient.

Be sure to remove my comments as you write your narrative.

This project is worth 150 or the total 1,000 course points – you see noted in this template the point value for each area.

===============================================================================

SUBJECT: PRELIMINARY PRICE NEGOTIATION MEMORANDUM (PRE-PNM)

I. OVERVIEW (6 POINTS)

Enter narrative following the format of the PNM – remember key things about the acquisition and write it so that someone who doesn’t know anything about the action has a good understanding of what you plan to do and why. Look at the score sheet from your first PNM to help you hit the highlights.

II. COST ANALYSIS SUMMARY (2 POINTS)

A. The contractor’s proposal price is $____________ The government objective is __________ with an optimistic of $___________ and pessimistic of $___________ (as stated below). __________ The objective determinations were based on ____________________________. See Section IV to see how these objectives were determined.

III. TOTAL COSTS: (5 POINTS)

A.

1999, 2000 and 2001 Totals:

IV. PARTICULARS AND FACT FINDING

Comment: look at the summary table in developing the particulars and use them as presented. Frequently in negotiations we find there is nothing wrong with the positions but the numbers are different due to rounding – I have created a bit of that in this exercise. Just use the numbers provided.

For the database analyst II I want you to use some creative writing to come up with the objective I have provided of 4,160 hours reflected in the summary table above. The point here is to understand that even when DCAA and the technical personnel provide input ultimately the Contracting Officer has to document and then negotiation to what they believe is best. Reflect on concepts you have learned in this course and come up with a plausible reason for this position.

A. LABOR: (8 POINTS)

i. ON-SITE:

1. Hours: The contractor proposed 8,320 hours per year for their analyst (application systems, programmer and database), 34,944 hours for computer support/operations and 17,472 for systems administration.

a. Questioned and or Unsupported Hours -.

i. Optimistic –

ii. Objective/Target (Most Likely to Negotiate) –

iii. Pessimistic -

2. Labor Rates:

PROPOSED

Questioned and or Unsupported Rates: .

OPTIMISTIC

a. Optimistic:

OJECTIVE/TARGET (MOST LIKELY)

b. Objective/Target (Most Likely to Negotiate

PESSIMISTIC

c. Pessimistic:

3. Costs: Per the hours and labor rates given above, below please find the total costs for all years.

Thoughts and Comments (3 POINTS FOR EACH QUESTION 9 POINTS)

1. In doing market research to assess the labor market and wage/salary trends for computer/information technology support, you noticed that support is increasingly being provided on a remote basis (vice on-site), thanks to improving technology. Being on-site to provide support is not as important as it used to be. How could you use that information?

2. What sources could you go to conduct this market research on the labor market?

3. (There are several sources of wage rate escalation factors. A widely-accepted source is Data Resources, Inc. (DRI). DRI rates are privately produced escalation factors based in part on BLS indices for material and labor, such as the Consumer Price Index and the PPI. DRI incorporates economic and social variables into their economic forecast models. DCAA recommended use of DRI escalation. The contractor proposes using DRI plus .5% due to the tight labor market. What would you do to resolve the DCAA recommendation and the proposed addition of .5% escalation?

ii. ON-CALL SUPPORT: (5 POINTS)

1. Hours: The contractor proposed the following hours per year based upon 1 person at each site.

a. Questioned and or Unsupported:

i. Optimistic –

.

ii. Objective/Target (Most Likely to Negotiate)

iii. Pessimistic –.

2. Labor Rates:

Position

PROPOSED

1999 Rate

2000 Rate

2001 Rate

Applics Sys Anal II

$ 38.10

$ 40.27

$ 42.53

Progr Analyst II

$ 39.77

$ 42.04

$ 44.39

Database Anal/Prog II

$ 25.13

$ 26.56

$ 28.05

a. Questioned and or Unsupported Rates:

.

b. Optimistic :

c. Objective/Target (Most Likely to Negotiate )

d. Pessimistic :

3. Costs: Per the hours and labor rates given above, below please find the total costs.

Position

PROPOSED

1999 Total

2000 Total

2001 Total

Applics Sys Anal II

$ 27,432.00

$ 33,826.80

$ 40,828.80

Progr Analyst II

$ 33,406.80

$ 40,358.40

$ 47,941.20

Database Anal/Prog II

$ 18,093.60

$ 22,310.40

$ 26,928.00

Yearly Totals

$ 78,932.40

$ 96,495.60

$ 115,698.00

3 Year Totals

 

 

$ 291,126.00

Thoughts and Comments: (3 POINTS EACH 21 POINTS TOTAL)

1. What quantitative analysis methods could you suggest to better assess whether there will be an increasing occurrence of failures?

2. What is the turnover rate for support personnel? If it is high, is learning starting all over again with new personnel? Why the high turnover? Is the contractor paying competitive wages/salaries? If there is high turnover and you negotiate "hard" to minimize the number of personnel, how could this impact performance risk?

3. In what ways could we DCAA support for our analysis of turnover? What specific request would you make to them? What is an example of a request that would be too general?

4. Why does introducing incentives on cost performance make sense in this situation?

5. What are the possibilities if we stated the requirement only in terms of the 2% downtime goal? Would the contractor have more freedom in how support was accomplished?

6. Would performance incentives be more or less motivating if requirements were restated this way? How could award fee be used? FPIF?

7. Discuss the possibility of endangering performance by overemphasizing cost control through incentives.

B. FRINGE: Make sure you comment on what DCAA said! (3 POINTS)

Thoughts and Comments: (3 POINTS EACH 21 POINTS TOTAL)

1. What costs are typically included in fringe?

2. What is one reason that fringe would specifically be identified in the proposal, as opposed to just being included as part of the overhead?

3. Where could you find out what the Dept of Labor minimum wages and fringe are for in your area?

4. Discuss why contracting officer involvement in fringe issues differs significantly based on whether contract administration has been delegated to DCMC or not.

5. Where could you go to get information on fringe costs? Allowability policy? Calculating an indirect cost? DCAA guidance?

6. What are the implications of whether this contract is CAS covered or not?

7. If the company experienced a significant decline in its business base and workforce, how might this impact its cost of fringe benefits per labor hour?

C. OVERHEAD: .For the overhead calculation both on site and on call labor dollars are added together from the total cost summary sheet and reflects both on-site and on call labor. (3 POINTS)

1999 Proposed Total

2000 Proposed Total

2001 Proposed Total

Proposed Total Costs

TOTAL LABOR COST

$ 2,337,503

$ 2,387,308

$ 2,520,996

$ 7,166,873

OVERHEAD

35%

50%

50%

 

OVERHEAD TOTALS

$ 790,499

$ 1,193,654

$ 1,260,498

$ 3,244,651

Thoughts and Comments: (3 POINTS EACH 9 POINTS TOTAL)

1. What costs are typically included in overhead?

2. Discuss common indirect cost rate misunderstanding; i.e., assessing a rate as too high or too low without understanding the composition and costs included in its pool and base.

3. If a company is doing business predominantly with Government and its Government business is declining, what would likely happen to its overhead rate?

D. MATERIAL AND PARTS: (5 POINTS)

Presented in Proposal

Material Proposed

1999

Rate

1999

2000 Rate

2000

2001 Rate

2001

Totall

Scheduled

$200,000.

0.941

$225,816.00

0.930

$204,514.00

$630,330.00

Unscheduled

1.261

$151,320

1.261

$190,815

1.284

$245,082

$587,217

Minor enhancements

1.358

$40,740

1.358

$55,325

1.383

$76,525

$172,590

Miscellaneous

1.067

$8,536

1.067

$9,108

1.087

$9,898

$27,542

TOTAL MATERIAL

 

$400,596

 

$481,063

 

$536,020

$1417,679

Material Growth Factors:

Be sure to explain what the escalations are based upon also note what was presented in the proposal and what was cited in the DCAA report as proposed growth factors… what do you think happened here as they are not the same – comment in your PNM.

The following summarizes the proposed and recommended growth factors for materials supporting unscheduled maintenance, minor system enhancements, and miscellaneous use:

Material Growth Factors - Proposed

1999

2000

2001

Unscheduled

1.30

1.30

1.30

Minor Enhancements

1.40

1.40

1.40

Miscellaneous

1.10

1.10

1.10

Material Growth Factors - Govt Objective

1999

2000

2001

Unscheduled

1.00

1.05

1.10

Minor Enhancements

1.00

1.00

0.25

Miscellaneous

1.05

1.05

1.05

Material

1999 Optimistic Rate

1999 Optimistic $

2000 Optimistic . Rate

2000 Optimistic $

2001 Optimistic Rate

2001 Optimistic $

Optimistic Total $

Scheduled

Unscheduled

1.00

1.05

1.10

Minor enhancements

1.00

1.00

0.25

Miscellaneous

1.05

1.05

1.05

TOTAL MATERIAL

i. Optimistic:

Material

1999 Target/Objective Most Likely to Negotiate Rate

1999 Target/Objective Most Likely to Negotiate

$

2000 Target/Objective Most Likely to Negotiate Rate

2000 Target/Objective Most Likely to Negotiate $

2001 Target/Objective Most Likely to Negotiate Rate

2001 Target/Objective Most Likely to Negotiate $

Target/Objective Most Likely to Negotiate Total $

Scheduled

$ 200,000

$225,816

$ 204,514

Unscheduled

$ 116,400

$118,553

$ 128,844

Minor enhancements

$ 29,100

$28,227

$ 6,972

Miscellaneous

$ 8,148

$8,299

$ 8,609

TOTAL MATERIAL

$ 353,648

$380,895

$ 348,939

ii. Objective/Target (Most Likely to Negotiate):

Locate the rates to complete the table above from the cost summary at the beginning of the PNM!

Material

1999 Pessimistic Rate

1999 Pessimistic $

2000 Pessimistic Rate

2000 Pessimistic $

2001 Pessimistic

Rate

2001 Pessimistic

$

Pessimistic Total $

Scheduled

Unscheduled

Minor enhancements

Miscellaneous

TOTAL MATERIAL

iii. Pessimistic:

E. GENERAL AND ADMINISTRATIVE (G & A) COSTS: (2 POINTS)

You may enter a table here or just discuss the proposed, objective, optimistic and pessimistic rates.

Thoughts and Comments: (3 POINTS)

1. What costs are typically included in G&A?

F. TARGET FEE: The proposed fee given by McGhee is 11% (pessimistic outcome). We will offer 9% (optimistic and most likely to negotiate target) based on the calculated weighted guidelines. (5 POINTS)

Thoughts and Comments: (3 POINTS EACH 12 POINTS TOTAL)

1. Why is it very likely that a service oriented company would not propose Facilities Capital Cost of Money?

2. Discuss how the Weighted Guidelines could be used to develop a minimum and maximum fee; and how with share ratios pessimistic and optimistic costs could be calculated.

3. Discuss how the minimum and maximum fee could be calculated given share ratios and optimistic/pessimistic costs.

4. Discuss how the dollar amount of potential share (over or under) must be enough to provide effective incentive.

G. CPIF SHARE RATIOS: (2 POINTS)

.

i. Optimistic

ii. Objective/Target (Most Likely to Negotiate):

iii. Pessimistic:

Thoughts and Comments: (3 POINTS EACH 12 POINTS TOTAL)

1. It may be worthwhile to review the difference between the proposed 90/10 and 70/30 ratios. Why does it make sense that the

contractor would propose 90/10 given its anticipation of future breakdowns?

2. Prompt clarifying discussion on why the most likely causes of over target costs are a significant factor in determining the over target share.

3. Ask what yourself questions you would raise as the contracting rep on an IPT doing an acquisition strategy planning session.

4. Discuss where you would go for guidance/policy on incentive contracts.

H. OPTIMISTIC/PESSIMISTIC COST: Please see the optimistic/pessimistic costs given above. (2 POINTS)

i. Optimistic

ii. Objective/Target (Most Likely to Negotiate):

.

iii. Pessimistic:

Thoughts and Comments: (3 POINTS)

1. Ask what type of contract the CPIF effectively becomes once incurred costs hit pessimistic cost.

ATTACHMENTS: (2 POINTS)

What kind of attachments would you think would be provided?

Anything else you would need to “put on” the PNM (assume it doesn’t have all the instructor Q&A and is a real pre PNM—there is something special that you need to make sure you place on the document. Check your score sheet for the first PNM if you are in doubt!

ASSIGNMENT 2: (5 POINTS)

Y2K Testing and BRAC! Three months after contract award, DoD mandates Y2K testing of all computer systems be accomplished within the next four months. In addition, both computer center operations are to be combined at Fogleman AFB and the combination completed by Jan 2001! The contracting officer notifies McGhee Systems in writing to start support of the Y2K testing immediately. The contracting officer sends a separate letter notifying McGhee Systems to submit a combined proposal for both the added Y2K effort and for combining and continuing computer center support. McGhee Systems submits the equitable adjustment proposal. Your technical folks have alerted you that since contract award the contractor has reduced its staff….and that it has not impacted performance a bit! You look at the contractor's proposal. Regarding the combination of computer centers, they are proposing simply adding the staffs because the work will double when combined. They are also proposing that since we just negotiated a fair and reasonable price, we can just use the recent proposal (skill mix and quantities and rates) as a basis for negotiation. Identify and discuss two primary issues that you will pursue in your analysis.

Two primary issues I will pursue in my analysis of the request for equitable adjustment will include:

1.

.

2.

ASSIGNMENT 3: The contract is complete. Final CPIF Price. Using your CPIF Target Cost/Fee and incentive elements from Assignment 1 (assume the equitable adjustment never occurred), what is the final CPIF price if McGhee Systems experienced final incurred cost of $700,000 under target cost. Remember there are minimum and maximum fees (5 POINTS)

27 of 27

1999 Costs

On-Site Support Proposed Hrs./Yr. Esc. 1999 Rate 1999 Proposed Total Proposed Totals Optimistic Hrs/Yr. Esc. 1999 Rate 1999 Optimistic Total OPTIMISTIC TOTALS OBJ Esc. 1999 Rate 1999 Obj Total OBJECTIVE Target TOTALS Pessimistic
Application Systems Analyst II 8,320 1.056 $ 25.40 $ 211,339 8,320 1.056 $ 25.40 $ 211,339 $
Programmer Analyst II 8,320 1.056 $ 26.51 $ 220,586 8,320 1.056 $ 26.51 $ 220,586 $
Database Analyst II 8,320 1.056 $ 16.75 $ 139,396 4,160 1.056 $ 16.75 $ 69,698 $
Computer Support/Operations II 34,944 1.056 $ 29.51 $ 1,031,273 34,944 1.056 $ 29.51 $ 1,031,273 $
Systems Administration 17,472 1.056 $ 37.54 $ 655,975 17,472 1.056 $ 37.54 $ 655,975 $
On-Call Support $
Application Systems Analyst II 720 $ 38.10 $ 27,433 360 $ 38.10 $ 13,717 $
Programmer Analyst II 840 $ 39.77 $ 33,406 240 $ 39.77 $ 9,545 $
Database Analyst II 720 $ 25.13 $ 18,095 240 $ 25.13 $ 6,032 $
Total Labor 79,656 $ 2,337,503 74,056 $ 2,218,164 $
Fringe $ 1.47 $ 113,743 $ 1.47 $ 107,628 $
Overhead 35% $ 790,499 35% $ 766,105 $
$
Material Growth Factors $
Scheduled $200,000 $ 200,000 $
Unscheduled 1.261 $151,320 0.970 $ 116,400 $
Minor Enhancements 1.358 $40,740 0.970 $ 29,100 $
Misc 1.067 $8,536 1.019 $ 8,148 $
Total Material $400,596 $ 353,648 $
Total Support Cost $ 3,642,341 $ 3,445,545 $
$
G&A 15% $ 546,351 15% $ 516,832 $
$
Target Cost $ 4,188,692 $ 3,962,376 $
Target Fee 11% $ 460,756 9% $ 356,614 $
Target Price $ 4,649,448 $ 4,318,990 $
Minimum Fee 90/10 $ 418,869 80/20 $ 237,743 $
Maximum Fee 70/30 $ 661,813 80/20 $ 183,410 $
Optimistic Cost 84% $ 3,518,501 84% $ 483,410 $
Pessimistic Cost 110% $ 4,607,561 115% $ 3,328,396 $
Contractor Share Ratio Over 10% 20% %
Contractor Share Ratio Under 30% 20% %

On-Site Support

Proposed

Hrs./Yr.

2000

Rate

2000

Proposed

Total

Proposed

Totals

Optimistic

Hrs/Yr.

2000

Rate

2000

Optimistic

Total

Optimisti

c Totals

OJB

2000

Rate

2000

Objectiv

e/Target

Target

Objective

Totals

2000

Pessimisti

c

Application Systems Analyst

II

8,3201.057 $26.85 223,386$ 8,3201.057 $ 26.85 $ 223,386 $

Programmer Analyst II

8,3201.057 $28.02 233,159$ 8,3201.057 $ 28.02 $ 223,159 $

Database Analyst II

8,3201.057 $ 17.71 147,342$ 4,1601.057 $ 17.71 $ 73,671 $

Computer

Support/Operations II

34,9441.057 $ 31.19 1,090,055$ 34,9441.057 $ 31.19 $ 1,090,055 $

Systems Administration

17,4721.057 $39.68 693,366$ 17,4721.057 $ 39.68 $ 693,289 $

On-Call Support

$

Application Systems Analyst

II

840 $40.27 33,830$ 360 $ 40.27 $ 14,497 $

Programmer Analyst II

960 $42.04 40,354$ 240 $ 42.04 $ 10,089 $

Database Analyst II

840 $26.56 22,314$ 240 $ 26.56 $ 6,375 $

Total Labor

80,0162,483,806$ 74,0562,344,599$

$

Fringe

$ 1.47

113,743$

$ 1.47

107,628$

$

Overhead

50%

1,193,654$

47%

1,087,409$

$

$

Material Growth Factors

$

Scheduled0.94$225,8160.941225,816$

$

Unscheduled1.261$190,8151.019118,553$

$

Minor Enhancements1.358$55,3250.97028,227$

$

Misc1.067$9,1081.0198,299$

$

Total Material481,064$ 380,895$

$

Total Support Cost4,272,267$ 3,920,531$

$

$

G&A25%1,068,067$ 23%901,722$

$

$

Target Cost5,340,333$ 4,822,253$

$

Target Fee11%587,437$ 9%434,003$

$

Target Price5,927,770$ 5,256,256$

$

Minimum Fee 90/10534,033$ 80/20289,335$

$

Maximum Fee 70/30843,773$ 80/20588,315$

$

Optimistic Cost84%4,485,880$ 84%4,050,693$

$

Pessimistic Cost 110%5,874,367$ 115%5,545,591$

$

Contractor Share Ratio Over10%20%%

Contractor Share Ratio Under30%20%%

2000 Costs

On-Site Support Proposed Hrs./Yr. Esc. 2000 Rate 2000 Proposed Total Proposed Totals Optimistic Hrs/Yr. Esc. 2000 Rate 2000 Optimistic Total Optimistic Totals OJB Esc. 2000 Rate 2000 Objective/Target Target Objective Totals 2000 Pessimistic
Application Systems Analyst II 8,320 1.057 $ 26.85 $ 223,386 8,320 1.057 $ 26.85 $ 223,386 $
Programmer Analyst II 8,320 1.057 $ 28.02 $ 233,159 8,320 1.057 $ 28.02 $ 223,159 $
Database Analyst II 8,320 1.057 $ 17.71 $ 147,342 4,160 1.057 $ 17.71 $ 73,671 $
Computer Support/Operations II 34,944 1.057 $ 31.19 $ 1,090,055 34,944 1.057 $ 31.19 $ 1,090,055 $
Systems Administration 17,472 1.057 $ 39.68 $ 693,366 17,472 1.057 $ 39.68 $ 693,289 $
On-Call Support $
Application Systems Analyst II 840 $ 40.27 $ 33,830 360 $ 40.27 $ 14,497 $
Programmer Analyst II 960 $ 42.04 $ 40,354 240 $ 42.04 $ 10,089 $
Database Analyst II 840 $ 26.56 $ 22,314 240 $ 26.56 $ 6,375 $
Total Labor 80,016 $ 2,483,806 74,056 $ 2,344,599 $
Fringe $ 1.47 $ 113,743 $ 1.47 $ 107,628 $
Overhead 50% $ 1,193,654 47% $ 1,087,409 $
$
Material Growth Factors $
Scheduled 0.941 $225,816 0.941 $ 225,816 $
Unscheduled 1.261 $190,815 1.019 $ 118,553 $
Minor Enhancements 1.358 $55,325 0.970 $ 28,227 $
Misc 1.067 $9,108 1.019 $ 8,299 $
Total Material $ 481,064 $ 380,895 $
Total Support Cost $ 4,272,267 $ 3,920,531 $
$
G&A 25% $ 1,068,067 23% $ 901,722 $
$
Target Cost $ 5,340,333 $ 4,822,253 $
Target Fee 11% $ 587,437 9% $ 434,003 $
Target Price $ 5,927,770 $ 5,256,256 $
Minimum Fee 90/10 $ 534,033 80/20 $ 289,335 $
Maximum Fee 70/30 $ 843,773 80/20 $ 588,315 $
Optimistic Cost 84% $ 4,485,880 84% $ 4,050,693 $
Pessimistic Cost 110% $ 5,874,367 115% $ 5,545,591 $
Contractor Share Ratio Over 10% 20% %
Contractor Share Ratio Under 30% 20% %

On-Site Support

Proposed

Hrs./Yr.

2001

Rate

2001

Proposed

Total

Proposed

Totals

Optimistic

Hrs/Yr.

2001

Rate

2001

Optimistic

Total

Optimistic

Totals

Obj

2001

Rate

2001 Obj

Total

Objective

Target Totals

Pessimistic

Application Systems Analyst II

8,3201.056 $ 28.35 235,895$ 8,320$ 1.056 $ 28.35 $ 235,895 $

Programmer Analyst II

8,3201.056 $ 29.59 246,216$ 8,320$ 1.056 $ 29.59 $ 246,216 $

Database Analyst II

8,3201.056 $ 18.70 155,593$ 4,160$ 1.056 $ 18.70 $ 77,796 $

Computer Support/Operations

II

34,9441.056 $ 32.94 1,151,098$ 34,944$ 1.056 $ 32.94 $ 1,551,098 $

Systems Administration

17,4721.056 $ 41.91 732,194$ 17,472$ 1.056 $ 41.91 $ 732,194 $

On-Call Support

$

Application Systems Analyst II

960 $ 42.53 40,828$ 480 $ 42.53 $ 20,414 $

Programmer Analyst II

1,080 $ 44.39 47,941$ 360 $ 44.39 $ 18,980 $

Database Analyst II

960 $ 28.05 26,930$ 360 $ 28.05 $ 10,099 $

Total Labor

80,3762,636,695$ 74,4162,489,693$

$

Fringe

$ 1.47

113,743$

$ 1.47

107,628$

$

Overhead

50%

1,260,498$

47%

1,148,304$

$

$

Material Growth Factors

$

Scheduled0.93$204,5140.93204,514$

$

Unscheduled1.284$245,0821.087128,844$

$

Minor Enhancements1.383$76,5250.2476,972$

$

Misc1.087$9,8981.0378,609$

$

Total Material536,020$ 348,939$

$

Total Support Cost4,546,956$ 4,094,564$

$

$

G&A25%1,136,739$ 23%941,750$

$

$

Target Cost5,683,695$ 5,036,313$

$

Target Fee11%625,207$ 9%453,268$

$

Target Price6,308,902$ 5,489,582$

$

Minimum Fee 90/10568,370$ 80/20302,179$

$

Maximum Fee 70/30898,024$ 8020614,430$

$

Optimistic Cost84%4,774,304$ 84%4,230,503$

$

Pessimistic Cost 110%6,252,065$ 115%5,791,760$

$

Contractor Share Ratio Over10%20%

%

Contractor Share Ratio Under30%20%

%

On-Site Labor Hours

Position Proposed Hrs./Yr. Proprosed Elements Optimistic Hrs/Yr. Variance Comments Most Likely to Negotiate Hrs/Yr. Variance Comments Pessimestic Hrs/Yr. Variance
Applications Systems Analyst II 8,320 2080hrs/yr. x 2 persons x 2 sites 6,240 25% Take away one person and have one person float between the 2 sites. 8,320 0% Accept as proposed, but use as an incentive to lower the costs 8,320 0%
Programmer Analyst II 8,320 2080hrs/yr. x 2 persons x 2 sites 6,240 25% Take away one person and have one person float between the 2 sites. 8,320 0% Accept as proposed, but use as an incentive to lower the costs 8,320 0%
Database Analysis II 8,320 2080hrs/yr. x 2 persons x 2 sites 6,240 25% Take away one person and have one person float between the 2 sites. 6,240 25% Take away one person and have one person float between the 2 sites. 8,320 0%
Computer Support/Operations II 34,944 ((2080hrs/yr. + (16hrs x 52wks)) x 2 persons x 2 sites x 3 shifts 34,944 0% Accept as proposed, but use as an incentive to lower the costs 34,944 0% Accept as proposed, but use as an incentive to lower the costs 34,944 0%
Systems Administration 17,472 ((2080hrs/yr. + (16hrs x 52wks)) x 2 persons x 2 sites x 3 shifts 17,472 0% Accept as proposed, but use as an incentive to lower the costs 17,472 0% Accept as proposed, but use as an incentive to lower the costs 17,472 0%
Total Hours per year 77,376 71,136 8% 75,296 3% 77,376 0%

On-Site Labor Costs

Position 1998 Rate Proposed Esc. 1999 Rate Proposed Esc. 2000 Rate Proposed Esc. 2001 Rate Optimistic Esc. 1999 Rate Optimistic Esc. 2000 Rate Optimistic Esc. 2001 Rate Proposed Hrs./Yr. Optimistic Hrs/Yr. 1999 Proposed Total 2000 Proposed Total 2001 Proposed Total Proposed Total Costs 1999 Optimistic Total 2000 Optimistic Total 2001 Optimistic Total Check Optimistic Total Target Objective Hrs/Yr. 1999 Most Likely Total 2000 Most Likely Total 2001 Most Likely Total Check Most Likely to Negotiate Total Pessimestic Hrs/Yr. 1999 Pessimesitc Total 2000 Pessimesitc Total 2001 Pessimesitc Total Check Total Pessimestic Total Costs Pessimistic Total
Applications Systems Analyst II $ 24.05 1.056 $ 25.40 1.057 $ 26.85 1.056 $ 28.35 1.051 $ 25.28 1.052 $ 26.59 1.051 $ 27.95 8,320 6,240 $ 211,339.00 $ 223,386.00 $ 235,895.00 $ 670,620.00 $ 157,725.67 $ 165,927.41 $ 174,389.70 $ 498,042.78 $ 498,042.78 8,320 $ 211,328.00 $ 223,392.00 $ 235,872.00 $ 670,592.00 $ 670,592.00 8,320 $ 211,328.00 $ 223,392.00 $ 235,872.00 $ 670,592.00 $ 670,592.00 $ 670,592.00
Programmer Analyst II $ 25.11 1.056 $ 26.51 1.057 $ 28.02 1.056 $ 29.59 1.051 $ 26.39 1.052 $ 27.76 1.051 $ 29.18 8,320 6,240 $ 220,586.00 $ 233,159.00 $ 246,216.00 $ 699,961.00 $ 164,677.41 $ 173,240.63 $ 182,075.90 $ 519,993.94 $ 519,993.94 8,320 $ 220,563.20 $ 233,126.40 $ 246,188.80 $ 699,878.40 $ 699,878.40 8,320 $ 220,563.20 $ 233,126.40 $ 246,188.80 $ 699,878.40 $ 699,878.40 $ 699,878.40
Database Analysis II $ 15.87 1.056 $ 16.75 1.057 $ 17.71 1.056 $ 18.70 1.051 $ 16.68 1.052 $ 17.55 1.051 $ 18.44 8,320 6,240 $ 139,396.00 $ 147,342.00 $ 155,593.00 $ 442,331.00 $ 104,079.27 $ 109,491.39 $ 115,075.45 $ 328,646.11 $ 328,646.11 6,240 $ 104,520.00 $ 110,510.40 $ 116,688.00 $ 331,718.40 $ 331,718.40 8,320 $ 139,360.00 $ 147,347.20 $ 155,584.00 $ 442,291.20 $ 442,291.20 $ 442,291.20
Computer Support/Operations II $ 27.95 1.056 $ 29.51 1.057 $ 31.19 1.056 $ 32.94 1.051 $ 29.38 1.052 $ 30.90 1.051 $ 32.48 34,944 34,944 $ 1,031,273.00 $ 1,090,055.00 $ 1,151,098.00 $ 3,272,426.00 $ 1,026,495.72 $ 1,079,873.50 $ 1,134,947.05 $ 3,241,316.28 $ 3,241,316.28 34,944 $ 1,031,197.44 $ 1,089,903.36 $ 1,151,055.36 $ 3,272,156.16 $ 3,272,156.16 34,944 $ 1,031,197.44 $ 1,089,903.36 $ 1,151,055.36 $ 3,272,156.16 $ 3,272,156.16 $ 3,272,156.16
Systems Administration $ 35.55 1.056 $ 37.54 1.057 $ 39.68 1.056 $ 41.91 1.051 $ 37.36 1.052 $ 39.31 1.051 $ 41.31 17,472 17,472 $ 655,975.00 $ 693,366.00 $ 732,194.00 $ 2,081,535.00 $ 652,807.21 $ 686,753.18 $ 721,777.60 $ 2,061,337.99 $ 2,061,337.99 17,472 $ 655,898.88 $ 693,288.96 $ 732,251.52 $ 2,081,439.36 $ 2,081,439.36 17,472 $ 655,898.88 $ 693,288.96 $ 732,251.52 $ 2,081,439.36 $ 2,081,439.36 $ 2,081,439.36
TOTAL $ 2,258,569.00 $ 2,387,308.00 $ 2,520,996.00 $ 7,166,873.00 $ 2,105,785.28 $ 2,215,286.12 $ 2,328,265.71 $ 6,649,337.11 $ 6,649,337.11 7% $ 2,223,507.52 $ 2,350,221.12 $ 2,482,055.68 $ 7,055,784.32 $ 7,055,784.32 2% $ 2,258,347.52 $ 2,387,057.92 $ 2,520,951.68 $ 7,166,357.12 $ 7,166,357.12 $ 7,166,357.12
OVERHEAD 35% 50% 50% 35% 47% 47% 35% 47% 47% 35% 50% 50%
OVERHEAD TOTALS $ 790,499.15 $ 1,193,654.00 $ 1,260,498.00 $ 3,244,651.15 $ 737,024.85 $ 1,041,184.47 $ 1,094,284.88 $ 2,872,494.21 $ 778,227.63 $ 1,104,603.93 $ 1,166,566.17 $ 3,049,397.73 $ 790,421.63 $ 1,193,528.96 $ 1,260,475.84 $ 3,244,426.43

2001 Costs

On-Site Support Proposed Hrs./Yr. Esc. 2001 Rate 2001 Proposed Total Proposed Totals Optimistic Hrs/Yr. Esc. 2001 Rate 2001 Optimistic Total Optimistic Totals Obj Esc. 2001 Rate 2001 Obj Total Objective Target Totals Pessimistic
Application Systems Analyst II 8,320 1.056 $ 28.35 $ 235,895 $ 8,320 1.056 $ 28.35 $ 235,895 $
Programmer Analyst II 8,320 1.056 $ 29.59 $ 246,216 $ 8,320 1.056 $ 29.59 $ 246,216 $
Database Analyst II 8,320 1.056 $ 18.70 $ 155,593 $ 4,160 1.056 $ 18.70 $ 77,796 $
Computer Support/Operations II 34,944 1.056 $ 32.94 $ 1,151,098 $ 34,944 1.056 $ 32.94 $ 1,551,098 $
Systems Administration 17,472 1.056 $ 41.91 $ 732,194 $ 17,472 1.056 $ 41.91 $ 732,194 $
On-Call Support $
Application Systems Analyst II 960 $ 42.53 $ 40,828 480 $ 42.53 $ 20,414 $
Programmer Analyst II 1,080 $ 44.39 $ 47,941 360 $ 44.39 $ 18,980 $
Database Analyst II 960 $ 28.05 $ 26,930 360 $ 28.05 $ 10,099 $
Total Labor 80,376 $ 2,636,695 74,416 $ 2,489,693 $
Fringe $ 1.47 $ 113,743 $ 1.47 $ 107,628 $
Overhead 50% $ 1,260,498 47% $ 1,148,304 $
$
Material Growth Factors $
Scheduled 0.93 $204,514 0.93 $ 204,514 $
Unscheduled 1.284 $245,082 1.087 $ 128,844 $
Minor Enhancements 1.383 $76,525 0.247 $ 6,972 $
Misc 1.087 $9,898 1.037 $ 8,609 $
Total Material $ 536,020 $ 348,939 $
Total Support Cost $ 4,546,956 $ 4,094,564 $
$
G&A 25% $ 1,136,739 23% $ 941,750 $
$
Target Cost $ 5,683,695 $ 5,036,313 $
Target Fee 11% $ 625,207 9% $ 453,268 $
Target Price $ 6,308,902 $ 5,489,582 $
Minimum Fee 90/10 $ 568,370 80/20 $ 302,179 $
Maximum Fee 70/30 $ 898,024 8020 $ 614,430 $
Optimistic Cost 84% $ 4,774,304 84% $ 4,230,503 $
Pessimistic Cost 110% $ 6,252,065 115% $ 5,791,760 $
Contractor Share Ratio Over 10% 20% %
Contractor Share Ratio Under 30% 20% %

Proposed

Hrs./Yr.

Proprosed Elements

Optimistic

Hrs/Yr.

Proposed Elements

Objective

Hrs/Yr.

Proposed Elements

Pessimestic

Hrs/Yr.

Proposed Elements

8,320

2080hrs/yr. x 2 persons

x 2 sites

8,320

2080hrs/yr. x 2 persons

x 2 sites

8,320

2080hrs/yr. x 2 persons

x 2 sites

34,944

((2080hrs/yr. + (16hrs x

52wks)) x 2 persons x 2

sites x 3 shifts

17,472

((2080hrs/yr. + (16hrs x

52wks)) x 2 persons x 2

sites x 3 shifts

77,376

On-Site Labor Hours

Position Proposed Hrs./Yr. Proprosed Elements Optimistic Hrs/Yr. Proposed Elements Objective Hrs/Yr. Proposed Elements Pessimestic Hrs/Yr. Proposed Elements
Applications Systems Analyst II 8,320 2080hrs/yr. x 2 persons x 2 sites
Programmer Analyst II 8,320 2080hrs/yr. x 2 persons x 2 sites
Database Analysis II 8,320 2080hrs/yr. x 2 persons x 2 sites
Computer Support/Operations II 34,944 ((2080hrs/yr. + (16hrs x 52wks)) x 2 persons x 2 sites x 3 shifts
Systems Administration 17,472 ((2080hrs/yr. + (16hrs x 52wks)) x 2 persons x 2 sites x 3 shifts
Total Hours per year 77,376

On-Site Labor Costs

Position 1999 Rate 2000 Rate 2001 Rate Proposed Hrs./Yr. Proposed Costs Optimistic Hrs/Yr. Optimistic Target Objective Hrs/Yr. Objective Pessimestic Hrs/Yr. Pessimistic
Applications Systems Analyst II $ 25.40 $ 26.85 $ 28.35 8,320 $ 670,592.00 6,240 8,320 8,320
Programmer Analyst II $ 26.51 $ 28.02 $ 29.59 8,320 $ 699,878.40 6,240 8,320 8,320
Database Analysis II $ 16.75 $ 17.71 $ 18.70 8,320 $ 442,291.20 6,240 6,240 8,320
Computer Support/Operations II $ 29.51 $ 31.19 $ 32.94 34,944 $ 3,272,156.16 34,944 34,944 34,944
Systems Administration $ 37.54 $ 39.68 $ 41.91 17,472 $ 2,081,439.36 17,472 17,472 17,472
TOTAL / VARIANCE $ 7,166,357.12

Sheet3

Position1998 Rate

Proposed

Esc.

1999 Rate

Proposed

Esc.

2000 Rate

Proposed

Esc.

2001 Rate

Applications Systems Analyst II $ 24.05 1.056 $ 25.40 1.057 $ 26.85 1.056 $ 28.35

Programmer Analyst II $ 25.11 1.056 $ 26.51 1.057 $ 28.02 1.056 $ 29.59

Database Analysis II $ 15.87 1.056 $ 16.75 1.057 $ 17.71 1.056 $ 18.70

Computer Support/Operations II $ 27.95 1.056 $ 29.51 1.057 $ 31.19 1.056 $ 32.94

Systems Administration $ 35.55 1.056 $ 37.54 1.057 $ 39.68 1.056 $ 41.91

On-Site Labor Costs

Position 1998 Rate Proposed Esc. 1999 Rate Proposed Esc. 2000 Rate Proposed Esc. 2001 Rate
Applications Systems Analyst II $ 24.05 1.056 $ 25.40 1.057 $ 26.85 1.056 $ 28.35
Programmer Analyst II $ 25.11 1.056 $ 26.51 1.057 $ 28.02 1.056 $ 29.59
Database Analysis II $ 15.87 1.056 $ 16.75 1.057 $ 17.71 1.056 $ 18.70
Computer Support/Operations II $ 27.95 1.056 $ 29.51 1.057 $ 31.19 1.056 $ 32.94
Systems Administration $ 35.55 1.056 $ 37.54 1.057 $ 39.68 1.056 $ 41.91

Position 1998 Rate

Proposed

Esc.

1999 Rate

Proposed

Esc.

2000

Rate

Optimistic

Esc.

2001

Rate

Applications Systems Analyst II $ 24.05

Programmer Analyst II $ 25.11

Database Analysis II $ 15.87

Computer Support/Operations II $ 27.95

Systems Administration $ 35.55

On-Site Labor Costs

Position 1998 Rate Proposed Esc. 1999 Rate Proposed Esc. 2000 Rate Optimistic Esc. 2001 Rate
Applications Systems Analyst II $ 24.05
Programmer Analyst II $ 25.11
Database Analysis II $ 15.87
Computer Support/Operations II $ 27.95
Systems Administration $ 35.55

Position 1998 Rate

Proposed

Esc.

1999 Rate

Proposed

Esc.

2000

Rate

Optimistic

Esc.

2001

Rate

Applications Systems Analyst II24.05$ 1.056 $ 25.40 1.057 $ 26.85 1.056 $ 28.35

Programmer Analyst II25.11$ 1.056 $ 26.51 1.057 $ 28.02 1.056 $ 29.59

Database Analysis II15.87$ 1.056 $ 16.75 1.057 $ 17.71 1.056 $ 18.70

Computer Support/Operations II27.95$ 1.056 $ 29.51 1.057 $ 31.19 1.056 $ 32.94

Systems Administration35.55$ 1.056 $ 37.54 1.057 $ 39.68 1.056 $ 41.91

On-Site Labor Costs

Position 1998 Rate Proposed Esc. 1999 Rate Proposed Esc. 2000 Rate Optimistic Esc. 2001 Rate
Applications Systems Analyst II $ 24.05 1.056 $ 25.40 1.057 $ 26.85 1.056 $ 28.35
Programmer Analyst II $ 25.11 1.056 $ 26.51 1.057 $ 28.02 1.056 $ 29.59
Database Analysis II $ 15.87 1.056 $ 16.75 1.057 $ 17.71 1.056 $ 18.70
Computer Support/Operations II $ 27.95 1.056 $ 29.51 1.057 $ 31.19 1.056 $ 32.94
Systems Administration $ 35.55 1.056 $ 37.54 1.057 $ 39.68 1.056 $ 41.91

Position 1998 Rate

Proposed

Esc.

1999 Rate

Proposed

Esc.

2000

Rate

Optimistic

Esc.

2001

Rate

Applications Systems Analyst II24.05$

Programmer Analyst II25.11$

Database Analysis II15.87$

Computer Support/Operations II27.95$

Systems Administration

On-Site Labor Costs

Position 1998 Rate Proposed Esc. 1999 Rate Proposed Esc. 2000 Rate Optimistic Esc. 2001 Rate
Applications Systems Analyst II $ 24.05
Programmer Analyst II $ 25.11
Database Analysis II $ 15.87
Computer Support/Operations II $ 27.95
Systems Administration

Position

Proposed Total

Costs

Optimistic Total

Objective/Target

(Most Likely)

Pessimestic

Total

Applications Systems

Analyst II

670,620.00$

Programmer Analyst II699,961.00$

Database Analysis II442,331.00$

Computer

Support/Operations II

3,272,426.00$

Systems Administration2,081,535.00$

TOTAL7,166,873.00$

On-Site Labor Costs

Position 1998 Rate Proposed Esc. 1999 Rate Proposed Esc. 2000 Rate Proposed Esc. 2001 Rate Optimistic Esc. 1999 Rate Optimistic Esc. 2000 Rate Optimistic Esc. 2001 Rate Proposed Hrs./Yr. Optimistic Hrs/Yr. 1999 Proposed Total 2000 Proposed Total 2001 Proposed Total Proposed Total Costs 1999 Optimistic Total 2000 Optimistic Total 2001 Optimistic Total Check Optimistic Total Objective Hrs/Yr. 1999 Most Likely Total 2000 Most Likely Total 2001 Most Likely Total Check Objective/Target (Most Likely) Pessimestic Hrs/Yr. 1999 Proposed/ Pessimesitc Total 2000 Proposed/ Pessimesitc Total 2001 Proposed/ Pessimesitc Total Check Total Pessimestic Total Pessimistic Total
Applications Systems Analyst II $ 24.05 1.056 $ 25.40 1.057 $ 26.85 1.056 $ 28.35 1.051 $ 25.28 1.052 $ 26.59 1.051 $ 27.95 8,320 6,240 $ 211,339.00 $ 223,386.00 $ 235,895.00 $ 670,620.00 $ 157,725.67 $ 165,927.41 $ 174,389.70 $ 498,042.78 $ - 0
Programmer Analyst II $ 25.11 1.056 $ 26.51 1.057 $ 28.02 1.056 $ 29.59 1.051 $ 26.39 1.052 $ 27.76 1.051 $ 29.18 8,320 6,240 $ 220,586.00 $ 233,159.00 $ 246,216.00 $ 699,961.00 $ 164,677.41 $ 173,240.63 $ 182,075.90 $ 519,993.94 $ - 0
Database Analysis II $ 15.87 1.056 $ 16.75 1.057 $ 17.71 1.056 $ 18.70 1.051 $ 16.68 1.052 $ 17.55 1.051 $ 18.44 8,320 6,240 $ 139,396.00 $ 147,342.00 $ 155,593.00 $ 442,331.00 $ 104,079.27 $ 109,491.39 $ 115,075.45 $ 328,646.11 $ - 0
Computer Support/Operations II $ 27.95 1.056 $ 29.51 1.057 $ 31.19 1.056 $ 32.94 1.051 $ 29.38 1.052 $ 30.90 1.051 $ 32.48 34,944 34,944 $ 1,031,273.00 $ 1,090,055.00 $ 1,151,098.00 $ 3,272,426.00 $ 1,026,495.72 $ 1,079,873.50 $ 1,134,947.05 $ 3,241,316.28 $ - 0
Systems Administration $ 35.55 1.056 $ 37.54 1.057 $ 39.68 1.056 $ 41.91 1.051 $ 37.36 1.052 $ 39.31 1.051 $ 41.31 17,472 17,472 $ 655,975.00 $ 693,366.00 $ 732,194.00 $ 2,081,535.00 $ 652,807.21 $ 686,753.18 $ 721,777.60 $ 2,061,337.99 $ - 0
TOTAL $ 2,258,569.00 $ 2,387,308.00 $ 2,520,996.00 $ 7,166,873.00 $ 2,105,785.28 $ 2,215,286.12 $ 2,328,265.71 $ 6,649,337.11 $ - 0
OVERHEAD 35% 50% 50% 35% 47% 47% 35% 47% 47% 35% 50% 50%
$ 790,499.15 $ 1,193,654.00 $ 1,260,498.00 $ 3,244,651.15 $ 737,024.85 $ 1,041,184.47 $ 1,094,284.88 $ 2,872,494.21 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

1999

Basic

2000

Option

1

2001

Option

2

1999

Basic

Delta

2000

Option1

Delta

2001

Option2

Delta

1999

Basic

Delta

2000

Option

1

Delta

2001

Option

2

Delta

1999

Basic

Delta

2000

Option

1

Delta

2001

Option

2

Delta

Applics Sys

Anal II

720840960360360480

Progr Analyst

II

8409601080240240360

Database

Anal/Prog II

720840960240240360

PESSIMISTICPROPOSEDOPTIMISTIC

Position

OBJECTIVE/TARGET

On-Call Labor

Position PROPOSED OPTIMISTIC OBJECTIVE/TARGET PESSIMISTIC
1999 Basic 2000 Option1 2001 Option2 1999 Basic Delta 2000 Option1 Delta 2001 Option2 Delta 1999 Basic Delta 2000 Option1 Delta 2001 Option2 Delta 1999 Basic Delta 2000 Option1 Delta 2001 Option2 Delta
Applics Sys Anal II 720 840 960 360 360 480
Progr Analyst II 840 960 1080 240 240 360
Database Anal/Prog II 720 840 960 240 240 360

1999

Rate

2000

Rate

2001

Rate

1999

Rate

2000

Rate

2001

Rate

1999

Rate

2000

Rate

2001

Rate

Applics Sys

Anal II

Progr Analyst

II

Database

Anal/Prog II

Position

OPTOMISTICPESSIMISTIC OBJECTIVE/ TARGET

On-Call Labor

Position OPTOMISTIC OBJECTIVE/ TARGET (MOST LIKELY) PESSIMISTIC
1999 Basic 1999 Rate Total 2000 Option1 2000 Rate Total 2001 Option2 2001 Rate Total 1999 Basic Delta 1999 Rate Total 2000 Option1 Delta 2000 Rate Total 2001 Option2 Delta 2001 Rate Total 1999 Option1 Delta 1999 Rate Total 2000 Option1 Delta 2000 Rate Total 2001 Option2 Delta 2001 Rate Total
Applics Sys Anal II 720 $ - 0 360 50% $ - 0
Progr Analyst II 840 $ - 0 240 71% $ - 0
Database Anal/Prog II 720 $ - 0 240 67% $ - 0

1999 Total2000 Total2001 Total1999 Total2000 Total2001 Total1999 Total2000 Total2001 Total

Applics Sys Anal II

Progr Analyst II

Database Anal/Prog II

Yearly Totals

3 Year Totals

Position

OPTIMISTICPESSIMISTICOBJECTIVE/TARGET (MOST LIKELY)

On-Call Labor

Position OPTIMISTIC OBJECTIVE/TARGET (MOST LIKELY) PESSIMISTIC
1999 Basic 1999 Rate 1999 Total 2000 Option1 2000 Rate 2000 Total 2001 Option2 2001 Rate 2001 Total 1999 Basic Delta 1999 Rate 1999 Total 2000 Option1 Delta 2000 Rate 2000 Total 2001 Option2 Delta 2001 Rate 2001 Total 1999 Option1 Delta 1999 Rate 1999 Total 2000 Option1 Delta 2000 Rate 2000 Total 2001 Option2 Delta 2001 Rate 2001 Total
Applics Sys Anal II 720 $ 38.10
Progr Analyst II 840 $ 39.77
Database Anal/Prog II 720 $ 25.13
Yearly Totals
3 Year Totals

Position

Proposed On-

Site Hrs./Yr.

Optimistic

Hrs/Yr.

Objective/

Target (Most

Likely) Hrs/Yr.

Pessimistic

Applications Systems Analyst II8,320

Programmer Analyst II8,320

Database Analysis II8,320

Computer Support/Operations II34,944

Systems Administration17,472

Total Hours77,376

3 Year Total232,128

Fringe Rate1.47$

Total Fringe113,742.72$

3 Year Total341,228.16$

Total Hours

Position Proposed On-Site Hrs./Yr. Optimistic Hrs/Yr. Objective/ Target (Most Likely) Hrs/Yr. Pessimistic
Applications Systems Analyst II 8,320
Programmer Analyst II 8,320
Database Analysis II 8,320
Computer Support/Operations II 34,944
Systems Administration 17,472
Total Hours 77,376
3 Year Total 232,128
Fringe Rate $ 1.47
Total Fringe $ 113,742.72
3 Year Total $ 341,228.16

1999

Optimistic

Total

2000

Optimistic

Total

2001

Optimistic

Total

Optimistic

Total

1999

Target/Obje

ctive (Most

Likely)

2000

Target/Obje

ctive (Most

Likely)

2001

Target/Object

ive (Most

Likely)

Objective/Tar

get (Most

Likely) Total

1999

Pessimistic

Total

2000

Pessimistic

Total

2001

Pessimistic

Total

Pessimistic

Total

Total Labor Cost 2,218,164$ 2,344,599$ 2,489,693$

OVERHEAD35%47%47%

OVERHEAD TOTALS766,105$ 1,087,409$ 1,148,304$

On-Site Labor Costs

1998 Rate Proposed Esc. 1999 Rate Proposed Esc. 2000 Rate Proposed Esc. 2001 Rate Optimistic Esc. 1999 Rate Optimistic Esc. 2000 Rate Optimistic Esc. 2001 Rate Proposed Hrs./Yr. Optimistic Hrs/Yr. 1999 Optimistic Total 2000 Optimistic Total 2001 Optimistic Total Optimistic Total 1999 Target/Objective (Most Likely) 2000 Target/Objective (Most Likely) 2001 Target/Objective (Most Likely) Check Objective/Target (Most Likely) Total Objective Hrs/Yr. 1999 Pessimistic Total 2000 Pessimistic Total 2001 Pessimistic Total Proposed Optimisti Costs Pessimistic Total Pessimestic Hrs/Yr. 1999 Pessimesitc Total 2000 Pessimesitc Total 2001 Pessimesitc Total Check Total Pessimestic Total Costs Pessimistic Total
Total Labor Cost $ 2,218,164 $ 2,344,599 $ 2,489,693 $ - 0 0% 0% $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
OVERHEAD 35% 47% 47% 35% 50% 50%
OVERHEAD TOTALS $ 766,105 $ 1,087,409 $ 1,148,304 $ - 0 $ - 0 $ - 0 $ - 0

Overhead

Cost Description

Optimistic

Shared Ratio

1999

Optimistic

2000

Optimistic

2001

Optimistic

Most Likely

Shared Ratio

1999

Target/Objecti

ve ( Most

Likely )

2000

Target/Objecti

ve ( Most

Likely )

2001Target/Ob

jective ( Most

Likely )

Pessimistic

Shared Ratio

1999

Pessimistic

2000

Pessimistic

2001

Pessimistic

Target Costs3,962,376$ 4,822,253$ 5,036,313$

Target Fee9%356,614$ 434,003$ 453,268$

Optimist Costs84%3,328,396$ 4,050,693$ 4,230,503$

Pessimistic Costs115%4,556,732$ 5,545,591$ 5,791,760$

Optimistic Fee (Po)20%483,410$ 588,315$ 614,430$

Pessimistic Fee20%237,743$ 289,335$ 302,179$

Fees & Ratio's

Cost Description Optimistic Shared Ratio 1999 Optimistic 2000 Optimistic 2001 Optimistic Most Likely Shared Ratio 1999 Target/Objective ( Most Likely ) 2000 Target/Objective ( Most Likely ) 2001Target/Objective ( Most Likely ) Pessimistic Shared Ratio 1999 Pessimistic 2000 Pessimistic 2001 Pessimistic
Target Costs $ 3,962,376 $ 4,822,253 $ 5,036,313
Target Fee 9% $ 356,614 $ 434,003 $ 453,268
Optimist Costs 84% $ 3,328,396 $ 4,050,693 $ 4,230,503
Pessimistic Costs 115% $ 4,556,732 $ 5,545,591 $ 5,791,760
Optimistic Fee (Po) 20% $ 483,410 $ 588,315 $ 614,430
Pessimistic Fee 20% $ 237,743 $ 289,335 $ 302,179

PROPOSEDTARGET/OBJECTIVEOPTIMISTIC PESSIMISTIC

P

A

= S

CU

(C

T

-C

F

)$210,000

S

CU

Contractors Under Ratio 30%20%

C

T

Target cost15,212,720$ 13,820,342$

C

F

Final Cost14,512,720$ 13,120,342$

P

F

= P

A

+ P

T

$1,883,399

P

T

Target Fee1,673,399$ 1,243,885$

MaxMaximum Fee2,403,610$ 1,686,155$

K

F

C

F +PF

$16,396,119

Contract Total

C

F +Max

$16,916,330

Formula's

On-Site Labor Hours

Position Proposed Hrs./Yr. Proprosed Elements Optimistic Hrs/Yr. Variance Comments Most Likely to Negotiate Hrs/Yr. Variance Comments Pessimestic Hrs/Yr. Variance
Applications Systems Analyst II 8,320 2080hrs/yr. x 2 persons x 2 sites 6,240 25% Take away one person and have one person float between the 2 sites. 8,320 0% Accept as proposed, but use as an incentive to lower the costs 8,320 0%
Programmer Analyst II 8,320 2080hrs/yr. x 2 persons x 2 sites 6,240 25% Take away one person and have one person float between the 2 sites. 8,320 0% Accept as proposed, but use as an incentive to lower the costs 8,320 0%
Database Analysis II 8,320 2080hrs/yr. x 2 persons x 2 sites 6,240 25% Take away one person and have one person float between the 2 sites. 6,240 25% Take away one person and have one person float between the 2 sites. 8,320 0%
Computer Support/Operations II 34,944 ((2080hrs/yr. + (16hrs x 52wks)) x 2 persons x 2 sites x 3 shifts 34,944 0% Accept as proposed, but use as an incentive to lower the costs 34,944 0% Accept as proposed, but use as an incentive to lower the costs 34,944 0%
Systems Administration 17,472 ((2080hrs/yr. + (16hrs x 52wks)) x 2 persons x 2 sites x 3 shifts 17,472 0% Accept as proposed, but use as an incentive to lower the costs 17,472 0% Accept as proposed, but use as an incentive to lower the costs 17,472 0%
Total Hours per year 77,376 71,136 8% 75,296 3% 77,376 0%

Final Cost

Formula's PROPOSED TARGET/OBJECTIVE OPTIMISTIC PESSIMISTIC
PA = SCU(CT-CF) $210,000
SCU Contractors Under Ratio 30% 20%
CT Target cost $ 15,212,720 $ 13,820,342
CF Final Cost $ 14,512,720 $ 13,120,342
PF = PA + PT $1,883,399
PT Target Fee $ 1,673,399 $ 1,243,885
Max Maximum Fee $ 2,403,610 $ 1,686,155
KF CF +PF $16,396,119
Contract Total CF +Max $16,916,330
`

Cost Description

PROPOSED

TOTALS

OPTIMISTIC

OBJECTIVE/

TARGET

REF.

PESSIMISTIC

Target Cost15,212,720$ 13,820,942$

Target Fee1,673,399$ 1,243,885$

Target Price16,886,119$ 15,064,827$

Minimum Fee 1,521,272$ 829,257$

Maximum Fee 2,403,610$ 1,686,155$

Optimistic Cost12,778,685$ 11,609,591$

Pessimistic Cost 16,733,992$ 15,894,084$

Contractor Share Ratio Over10%20%

On-Site Labor Hours

Position Proposed Hrs./Yr. Proprosed Elements Optimistic Hrs/Yr. Variance Comments Most Likely to Negotiate Hrs/Yr. Variance Comments Pessimestic Hrs/Yr. Variance
Applications Systems Analyst II 8,320 2080hrs/yr. x 2 persons x 2 sites 6,240 25% Take away one person and have one person float between the 2 sites. 8,320 0% Accept as proposed, but use as an incentive to lower the costs 8,320 0%
Programmer Analyst II 8,320 2080hrs/yr. x 2 persons x 2 sites 6,240 25% Take away one person and have one person float between the 2 sites. 8,320 0% Accept as proposed, but use as an incentive to lower the costs 8,320 0%
Database Analysis II 8,320 2080hrs/yr. x 2 persons x 2 sites 6,240 25% Take away one person and have one person float between the 2 sites. 6,240 25% Take away one person and have one person float between the 2 sites. 8,320 0%
Computer Support/Operations II 34,944 ((2080hrs/yr. + (16hrs x 52wks)) x 2 persons x 2 sites x 3 shifts 34,944 0% Accept as proposed, but use as an incentive to lower the costs 34,944 0% Accept as proposed, but use as an incentive to lower the costs 34,944 0%
Systems Administration 17,472 ((2080hrs/yr. + (16hrs x 52wks)) x 2 persons x 2 sites x 3 shifts 17,472 0% Accept as proposed, but use as an incentive to lower the costs 17,472 0% Accept as proposed, but use as an incentive to lower the costs 17,472 0%
Total Hours per year 77,376 71,136 8% 75,296 3% 77,376 0%

On-Site Labor Costs

Position 1998 Rate Proposed Esc. 1999 Rate Proposed Esc. 2000 Rate Proposed Esc. 2001 Rate Optimistic Esc. 1999 Rate Optimistic Esc. 2000 Rate Optimistic Esc. 2001 Rate Proposed Hrs./Yr. Optimistic Hrs/Yr. 1999 Proposed Total 2000 Proposed Total 2001 Proposed Total Proposed Total Costs 1999 Optimistic Total 2000 Optimistic Total 2001 Optimistic Total Check Optimistic Total Target Objective Hrs/Yr. 1999 Most Likely Total 2000 Most Likely Total 2001 Most Likely Total Check Most Likely to Negotiate Total Pessimestic Hrs/Yr. 1999 Pessimesitc Total 2000 Pessimesitc Total 2001 Pessimesitc Total Check Total Pessimestic Total Costs Pessimistic Total
Applications Systems Analyst II $ 24.05 1.056 $ 25.40 1.057 $ 26.85 1.056 $ 28.35 1.051 $ 25.28 1.052 $ 26.59 1.051 $ 27.95 8,320 6,240 $ 211,339.00 $ 223,386.00 $ 235,895.00 $ 670,620.00 $ 157,725.67 $ 165,927.41 $ 174,389.70 $ 498,042.78 $ 498,042.78 8,320 $ 211,328.00 $ 223,392.00 $ 235,872.00 $ 670,592.00 $ 670,592.00 8,320 $ 211,328.00 $ 223,392.00 $ 235,872.00 $ 670,592.00 $ 670,592.00 $ 670,592.00
Programmer Analyst II $ 25.11 1.056 $ 26.51 1.057 $ 28.02 1.056 $ 29.59 1.051 $ 26.39 1.052 $ 27.76 1.051 $ 29.18 8,320 6,240 $ 220,586.00 $ 233,159.00 $ 246,216.00 $ 699,961.00 $ 164,677.41 $ 173,240.63 $ 182,075.90 $ 519,993.94 $ 519,993.94 8,320 $ 220,563.20 $ 233,126.40 $ 246,188.80 $ 699,878.40 $ 699,878.40 8,320 $ 220,563.20 $ 233,126.40 $ 246,188.80 $ 699,878.40 $ 699,878.40 $ 699,878.40
Database Analysis II $ 15.87 1.056 $ 16.75 1.057 $ 17.71 1.056 $ 18.70 1.051 $ 16.68 1.052 $ 17.55 1.051 $ 18.44 8,320 6,240 $ 139,396.00 $ 147,342.00 $ 155,593.00 $ 442,331.00 $ 104,079.27 $ 109,491.39 $ 115,075.45 $ 328,646.11 $ 328,646.11 6,240 $ 104,520.00 $ 110,510.40 $ 116,688.00 $ 331,718.40 $ 331,718.40 8,320 $ 139,360.00 $ 147,347.20 $ 155,584.00 $ 442,291.20 $ 442,291.20 $ 442,291.20
Computer Support/Operations II $ 27.95 1.056 $ 29.51 1.057 $ 31.19 1.056 $ 32.94 1.051 $ 29.38 1.052 $ 30.90 1.051 $ 32.48 34,944 34,944 $ 1,031,273.00 $ 1,090,055.00 $ 1,151,098.00 $ 3,272,426.00 $ 1,026,495.72 $ 1,079,873.50 $ 1,134,947.05 $ 3,241,316.28 $ 3,241,316.28 34,944 $ 1,031,197.44 $ 1,089,903.36 $ 1,151,055.36 $ 3,272,156.16 $ 3,272,156.16 34,944 $ 1,031,197.44 $ 1,089,903.36 $ 1,151,055.36 $ 3,272,156.16 $ 3,272,156.16 $ 3,272,156.16
Systems Administration $ 35.55 1.056 $ 37.54 1.057 $ 39.68 1.056 $ 41.91 1.051 $ 37.36 1.052 $ 39.31 1.051 $ 41.31 17,472 17,472 $ 655,975.00 $ 693,366.00 $ 732,194.00 $ 2,081,535.00 $ 652,807.21 $ 686,753.18 $ 721,777.60 $ 2,061,337.99 $ 2,061,337.99 17,472 $ 655,898.88 $ 693,288.96 $ 732,251.52 $ 2,081,439.36 $ 2,081,439.36 17,472 $ 655,898.88 $ 693,288.96 $ 732,251.52 $ 2,081,439.36 $ 2,081,439.36 $ 2,081,439.36
TOTAL $ 2,258,569.00 $ 2,387,308.00 $ 2,520,996.00 $ 7,166,873.00 $ 2,105,785.28 $ 2,215,286.12 $ 2,328,265.71 $ 6,649,337.11 $ 6,649,337.11 7% $ 2,223,507.52 $ 2,350,221.12 $ 2,482,055.68 $ 7,055,784.32 $ 7,055,784.32 2% $ 2,258,347.52 $ 2,387,057.92 $ 2,520,951.68 $ 7,166,357.12 $ 7,166,357.12 $ 7,166,357.12
OVERHEAD 35% 50% 50% 35% 47% 47% 35% 47% 47% 35% 50% 50%
OVERHEAD TOTALS $ 790,499.15 $ 1,193,654.00 $ 1,260,498.00 $ 3,244,651.15 $ 737,024.85 $ 1,041,184.47 $ 1,094,284.88 $ 2,872,494.21 $ 778,227.63 $ 1,104,603.93 $ 1,166,566.17 $ 3,049,397.73 $ 790,421.63 $ 1,193,528.96 $ 1,260,475.84 $ 3,244,426.43

On-Call Labor

Position PROPOSED OPTIMISTIC OBJECTIVE MOST LIKELY TO NEGOTIATE
1999 Basic 1999 Rate 1999 Total 2000 Option1 2000 Rate 2000 Total 2001 Option2 2001 Rate 2001 Total 1999 Basic Delta 1999 Rate 1999 Total 2000 Option1 Delta 2000 Rate 2000 Total 2001 Option2 Delta 2001 Rate 2001 Total 1999 Option1 Delta 1999 Rate 1999 Total 2000 Option1 Delta 2000 Rate 2000 Total 2001 Option2 Delta 2001 Rate 2001 Total
Applics Sys Anal II 720 $ 38.10 $ 27,432.00 840 $ 40.27 $ 33,826.80 960 $ 42.53 $ 40,828.80 360 50% $ 37.91 $ 13,649.34 360 57% $ 39.89 $ 14,359.10 480 50% $ 41.92 $ 20,121.89 720 0% $ 38.10 $ 27,432.00 720 14% $ 40.27 $ 28,994.40 720 25% $ 42.53 $ 30,621.60
Progr Analyst II 840 $ 39.77 $ 33,406.80 960 $ 42.04 $ 40,358.40 1080 $ 44.39 $ 47,941.20 240 71% $ 39.59 $ 9,500.62 240 75% $ 41.64 $ 9,994.65 360 67% $ 43.77 $ 15,756.57 840 0% $ 39.77 $ 33,406.80 840 13% $ 42.04 $ 35,313.60 840 22% $ 44.39 $ 37,287.60
Database Anal/Prog II 720 $ 25.13 $ 18,093.60 840 $ 26.56 $ 22,310.40 960 $ 28.05 $ 26,928.00 240 67% $ 25.02 $ 6,004.57 240 71% $ 26.32 $ 6,316.81 360 63% $ 27.66 $ 9,958.45 720 0% $ 25.13 $ 18,093.60 720 14% $ 26.56 $ 19,123.20 720 25% $ 28.05 $ 20,196.00
Yearly Totals $ 78,932.40 $ 96,495.60 $ 115,698.00 $ 29,154.53 $ 30,670.57 $ 45,836.91 $ 78,932.40 $ 83,431.20 $ 88,105.20
3 Year Totals $ 291,126.00 $ 105,662.01 $ 250,468.80

Total Hours

Position Proposed On-Site Hrs./Yr. Optimistic Hrs/Yr. Most Likely Hrs/Yr.
Applications Systems Analyst II 8,320 6,240 8,320
Programmer Analyst II 8,320 6,240 8,320
Database Analysis II 8,320 6,240 6,240
Computer Support/Operations II 34,944 34,944 34,944
Systems Administration 17,472 17,472 17,472
Total Hours 77,376 71,136 75,296
3 Year Total 232,128 213,408 225,888
Fringe Rate $ 1.47 $ 1.47 $ 1.47
Total Fringe $ 113,742.72 $ 104,569.92 $ 110,685.12
3 Year Total $ 341,228.16 $ 313,709.76 $ 332,055.36

Material

Material 1999 Proposed Costs 2000 Proposed Costs 2001 Proposed Costs Proposed Total 1999 Esc. 2000 Esc. 2001 Esc. 1999 Opt. Rate 1999 Optimistic Target 2000 Opt. Rate 2000 Optimistic Target 2001 Opt. Rate 2001 Optimistic Target Optimistic Total 1999 MLN Rate 1999 Most Likely to Negotiate (MLN) 2000 MLN Rate 2000 Most Likely to Negotiate (MLN) 2001 MLN Rate 2001 Most Likely to Negotiate (MLN) Most Likely to Negotiate Total
Scheduled $200,000 $225,816 $204,514 $630,330 0.930 0.941 0.930 0.930 $200,000.00 0.941 $225,816.00 0.930 $204,514.00 $630,330.00 0.930 $200,000.00 0.941 $225,816.00 0.930 $204,514.00 $630,330.00
Unscheduled $151,320 $190,815 $245,082 $587,217 1.261 1.261 1.284 1.000 $120,000.00 1.050 $158,886.40 1.100 $209,961.21 $488,847.61 1.150 $138,000.00 1.150 $174,018.44 1.150 $219,504.91 $531,523.34
Minor enhancements $40,740 $55,325 $76,525 $172,590 1.358 1.358 1.383 1.000 $30,000.00 1.000 $40,740.06 0.250 $13,833.15 $84,573.21 1.200 $36,000.00 1.200 $48,888.07 0.575 $31,816.25 $116,704.32
Miscellaneous $8,536 $9,108 $9,898 $27,542 1.067 1.067 1.087 1.050 $8,400.00 1.050 $8,962.89 1.050 $9,561.09 $26,923.97 1.050 $8,400.00 1.050 $8,962.89 1.050 $9,561.09 $26,923.97
TOTAL MATERIAL $400,596 $481,064 $536,019 $1,417,679 $358,400.00 $434,405.35 $437,869.45 $1,230,674.80 $382,400.00 $457,685.40 $465,396.24 $1,305,481.64

Fees & Ratio's

Cost Description Proposed Shared Ratio 1999 Proposed 2000 Proposed 2001 Proposed Optimistic Shared Ratio 1999 Optimistic 2000 Optimistic 2001 Optimistic Most Likely Shared Ratio 1999 Most Likely to Negotiate 2000 Most Likely to Negotiate 2001 Most Likely to Negotiate
Target Costs $ 4,188,692.00 $ 5,340,333.40 $ 5,409,027.15 $ 3,835,174.77 $ 4,706,123.20 $ 4,916,586.42 $ 4,109,815.57 $ 5,051,150.92 $ 5,304,754.35
Target Fee 11% $ 460,756.12 $ 587,436.67 $ 594,992.99 9% $ 345,165.73 $ 423,551.09 $ 442,492.78 9% $ 369,883.40 $ 454,603.58 $ 477,427.89
Optimist Costs 84% $ 3,518,501.28 $ 4,485,880.06 $ 4,543,582.81 84% $ 3,221,546.80 $ 3,953,143.49 $ 4,129,932.59 84% $ 3,452,245.08 $ 4,242,966.77 $ 4,455,993.65
Pessimistic Costs 110% $ 4,607,561.20 $ 5,874,366.74 $ 5,949,929.87 115% $ 4,410,450.98 $ 5,412,041.68 $ 5,654,074.38 115% $ 4,726,287.91 $ 5,808,823.55 $ 6,100,467.50
Optimistic Fee (Po) 30% $ 661,813.34 $ 843,772.68 $ 854,626.29 30% $ 529,254.12 $ 649,445.00 $ 678,488.93 30% $ 567,154.55 $ 697,058.83 $ 732,056.10
Pessimistic Fee 10% $ 418,869.20 $ 534,033.34 $ 540,902.72 20% $ 230,110.49 $ 282,367.39 $ 294,995.18 20% $ 246,588.93 $ 303,069.05 $ 318,285.26

1999 Costs

On-Site Support Proposed Hrs./Yr. Esc. 1999 Rate 1999 Proposed Total PROPOSED TOTALS Optimistic Hrs/Yr. Esc. 1999 Rate 1999 Optimistic Total OPTIMISTIC TOTALS Most Likely to Negotiate Hrs/Yr. Esc. 1999 Rate 1999 Most Likely Total MOST LIKELY TO NEGOTIATE TOTALS
Application Systems Analyst II 8,320 1.056 $ 25.40 $ 211,339.00 6,240 1.051 $ 25.28 $ 157,725.67 8,320 1.056 $ 25.40 $ 211,328.00
Programmer Analyst II 8,320 1.056 $ 26.51 $ 220,586.00 6,240 1.051 $ 26.39 $ 164,677.41 8,320 1.056 $ 26.51 $ 220,563.20
Database Analyst II 8,320 1.056 $ 16.75 $ 139,396.00 6,240 1.051 $ 16.68 $ 104,079.27 6,240 1.056 $ 16.75 $ 104,520.00
Computer Support/Operations II 34,944 1.056 $ 29.51 $ 1,031,273.00 34,944 1.051 $ 29.38 $ 1,026,495.72 34,944 1.056 $ 29.51 $ 1,031,197.44
Systems Administration 17,472 1.056 $ 37.54 $ 655,975.00 17,472 1.051 $ 37.36 $ 652,807.21 17,472 1.056 $ 37.54 $ 655,898.88
On-Call Support
Application Systems Analyst II 720 $ 38.10 $ 27,433.00 360 $ 37.91 $ 13,649.34 720 $ 38.10 $ 27,432.00
Programmer Analyst II 840 $ 39.77 $ 33,406.00 240 $ 39.59 $ 9,500.62 840 $ 39.77 $ 33,406.80
Database Analyst II 720 $ 25.13 $ 18,095.00 240 $ 25.02 $ 6,004.57 720 $ 25.13 $ 18,093.60
Total Labor 79,656 $ 2,337,503.00 71,976 $ 2,134,939.81 77,576 $ 2,302,439.92
Fringe $ 1.47 $ 113,742.72 $ 1.47 $ 104,569.92 $ 1.47 $ 110,685.12
Overhead 35% $ 790,499.15 35% $ 737,024.85 35% $ 778,227.63
Material Growth Factors
Scheduled $200,000 $200,000.00 $200,000.00
Unscheduled 1.261 $151,320 1.000 $120,000.00 1.150 $138,000.00
Minor Enhancements 1.358 $40,740 1.000 $30,000.00 1.200 $36,000.00
Misc 1.067 $8,536 1.050 $8,400.00 1.050 $8,400.00
Total Material $400,596 $358,400 $382,400
Total Support Cost $ 3,642,340.87 $ 3,334,934.58 $ 3,573,752.67
G&A 15% $ 546,351.13 15% $ 500,240.19 15% $ 536,062.90
Target Cost $ 4,188,692.00 $ 3,835,174.77 $ 4,109,815.57
Target Fee 11% $ 460,756.12 9% $ 345,165.73 9% $ 369,883.40
Target Price $ 4,649,448.12 $ 4,180,340.50 $ 4,479,698.97
Minimum Fee 90/10 $ 418,869.20 80/20 $ 230,110.49 90/10 $ 246,588.93
Maximum Fee 70/30 $ 661,813.34 80/20 $ 529,254.12 70/30 $ 567,154.55
Optimistic Cost 84% $ 3,518,501.28 84% $ 3,221,546.80 84% $ 3,452,245.08
Pessimistic Cost 110% $ 4,607,561.20 115% $ 4,410,450.98 115% $ 4,726,287.91
Contractor Share Ratio Over 10% 20% 20%
Contractor Share Ratio Under 30% 30% 30%

Summary

Cost Description PROPOSED TOTALS 1999 OPTIMISTIC TOTALS 2000 OPTIMISTIC TOTALS 2001 OPTIMISTIC TOTALS OPTIMISTIC 1999 MOST LIKELY TO NEGOTIATE TOTALS 2000 MOST LIKELY TO NEGOTIATE TOTALS 2001 MOST LIKELY TO NEGOTIATE TOTALS OBJECTIVE/ TARGET REF. PESSIMISTIC
Target Cost $ 15,212,720 $ 4,188,692.00 $ 4,706,123.20 $ 4,916,586.42 $ 4,109,815.57 $ 5,051,150.92 $ 5,304,754.35 $ 13,820,942
Target Fee $ 1,673,399 $ 460,756.12 $ 423,551.09 $ 442,492.78 $ 369,883.40 $ 454,603.58 $ 477,427.89 $ 1,243,885
Target Price $ 16,886,119 $ 4,649,448.12 $ 5,129,674.29 $ 5,359,079.19 $ 4,479,698.97 $ 5,505,754.50 $ 5,782,182.24 $ 15,064,827
Minimum Fee $ 1,521,272 $ 418,869.20 $ 282,367.39 $ 294,995.18 $ 246,588.93 $ 303,069.05 $ 318,285.26 $ 829,257
Maximum Fee $ 2,403,610 $ 661,813.34 $ 649,445.00 $ 678,488.93 $ 567,154.55 $ 697,058.83 $ 732,056.10 $ 1,686,155
Optimistic Cost $ 12,778,685 $ 3,518,501.28 $ 3,953,143.49 $ 4,129,932.59 $ 3,452,245.08 $ 4,242,966.77 $ 4,455,993.65 $ 11,609,591
Pessimistic Cost $ 16,733,992 $ 4,607,561.20 $ 5,412,041.68 $ 5,654,074.38 $ 4,726,287.91 $ 5,808,823.55 $ 6,100,467.50 $ 15,894,084
Contractor Share Ratio Over 10% 20%
Contractor Share Ratio Under 30% 20%

On-Site Support

Proposed

Hrs./Yr.

1999

Rate

1999

Proposed

Total

Proposed

Totals

Optimistic

Hrs/Yr.

1999

Rate

1999

Optimistic

Total

OPTIMISTIC

TOTALS

OBJ

1999

Rate

1999 Obj

Total

OBJECTIVE

Target

TOTALS

Pessimistic

Application Systems Analyst II

8,3201.056 $ 25.40 211,339$ 8,3201.056 $25.40 $ 211,339 $

Programmer Analyst II

8,3201.056 $ 26.51 220,586$ 8,3201.056 $ 26.51 $ 220,586 $

Database Analyst II

8,3201.056 $ 16.75 139,396$ 4,1601.056 $ 16.75 $ 69,698 $

Computer Support/Operations II

34,9441.056 $ 29.51 1,031,273$ 34,9441.056 $ 29.51 $ 1,031,273 $

Systems Administration

17,4721.056 $ 37.54 655,975$ 17,4721.056 $37.54 $ 655,975 $

On-Call Support

$

Application Systems Analyst II

720 $ 38.10 27,433$ 360 $ 38.10 $ 13,717 $

Programmer Analyst II

840 $ 39.77 33,406$ 240 $39.77 $ 9,545 $

Database Analyst II

720 $ 25.13 18,095$ 240 $ 25.13 $ 6,032 $

Total Labor

79,6562,337,503$ 74,0562,218,164$

$

Fringe

$ 1.47

113,743$

$ 1.47

107,628$

$

Overhead

35%

790,499$

35%

766,105$

$

$

Material Growth Factors

$

Scheduled$200,000200,000$

$

Unscheduled1.261$151,3200.970116,400$

$

Minor Enhancements1.358$40,7400.97029,100$

$

Misc1.067$8,5361.0198,148$

$

Total Material$400,596353,648$

$

Total Support Cost3,642,341$ 3,445,545$

$

$

G&A15%546,351$ 15%516,832$

$

$

Target Cost4,188,692$ 3,962,376$

$

Target Fee11%460,756$ 9%356,614$

$

Target Price4,649,448$ 4,318,990$

$

Minimum Fee 90/10418,869$ 80/20237,743$

$

Maximum Fee 70/30661,813$ 80/20183,410$

$

Optimistic Cost84%3,518,501$ 84%483,410$

$

Pessimistic Cost 110%4,607,561$ 115%3,328,396$

$

Contractor Share Ratio Over10%20%%

Contractor Share Ratio Under30%20%%