Question

In: Advanced Math

The following has been received as a result of bids. 17. An RFP was issued for...

The following has been received as a result of bids.

17. An RFP was issued for business training in an office environment. As a result, seven proposals were received. The subsequent rated and price evaluations for the firms are below.

Firm                             Rated Evaluation                    Financial Bid

A                                             90                                $150.000

B                                             85                                $140,000

C                                             80                                $120,000

D                                             75                                $110,000

E                                              70                                $120,000

F                                              65                                $119,000

G                                             60                                $100,000               

The evaluated pass mark for this requirement was 70

1. Which firm would be recommended to be awarded the contract if the method of evaluation is the lowest priced responsive (technically compliant) proposal?

2. Which firm would be recommended to be awarded the contract if the method of evaluation is the lowest priced responsive (technically compliant) proposal and there was a stipulated maximum financial budget of $139,000?

3. Which firm would be recommended to be awarded the contract if the method of evaluation is lowest price per point?

4. Which firm would be recommended to be awarded the contract if the method of evaluation is highest combined rating with price at 50% and rated evaluation 50% of the total?

5. Which firm would be recommended to be awarded the contract if the method of evaluation is highest combined rating with price at 25% and rated evaluation 75% of the total?

Note: you MUST show any calculations.

Solutions

Expert Solution

1. technically compliant means F and G are out of the picture. Out of what remain, the lowest priced is D with a bid of 110,000

2. technically compliant means F and G are out of the picture. Out of what remain, the lowest priced is D with a bid of 110,000. Also, this is less than the available fund of 139,000 so this constraint is also taken care of .

3. We calculate price per point

A - 150,000/90 = 1666.7

B - 140,000/85 = 1647

C - 120,000/80 = 1500

D - 110,000/75 = 1466

E - 120,000/70 = 1714

F - 119,000/65 = 1830

G - 100,000/60 = 1666

Lowest is for D

4. lets calibrate the numbers to be between 0 and 100

Evaluation : (x-60)/(90-60) [since 60 and 90 are minimum and maximum respectively]

A: 1 [(90-60)/(90-60) = 1]

B: 0.83

C: 0.67

D: 0.5

E: 0.33

F: 0.17

G: 0

Similarly, for bid: 1- (x - 100,000)/(150000 - 100000) (we subtract from 1 because less bid is better than more bid)

A: 0

B: 0.2

C: 0.6

D: 0.8

E: 0.6

F: 0.62

G: 1

final = 0.5*evaluation + 0.5*bid

A: 0.5*1 + 0.5*0 = 0.5

Similarly,

B: 0.565

C: 0.635

D: 0.65

E: 0.465

F: 0.395

G: 0.5

thus, D is best

5) final = 0.25*bid + 0.75*evaluation

A: 0.25*0 + 0.75*1 = 0.75

Similarly,

B:0.6725

C: 0.6525

D: 0.575

E: 0.3975

F: 0.2825

G: 0.25

A is best in this case


Related Solutions

Consider the relationship between the number of bids an item on eBay received and the item's...
Consider the relationship between the number of bids an item on eBay received and the item's selling price. The following is a sample of 5 5 items sold through an auction. Price in Dollars 22 29 36 44 49 Number of Bids 1 4 5 7 8 Step 1 of 5: Calculate the sum of squared errors (SSE). Use the values b0=−3.8884 and b1=0.2469 for the calculations. Round your answer to three decimal places. Step 2 of 5: Calculate the...
Consider the relationship between the number of bids an item on eBay received and the item's...
Consider the relationship between the number of bids an item on eBay received and the item's selling price. The following is a sample of 55 items sold through an auction. Price in Dollars 31 36 43 47 48 Number of Bids 2 6 7 9 10 Step 1 of 5: Calculate the sum of squared errors (SSE). Use the values b0=−10.0592 and b1=0.4112 for the calculations. Round your answer to three decimal places. Step 2 of 5: Calculate the estimated...
Consider the relationship between the number of bids an item on eBay received and the item's...
Consider the relationship between the number of bids an item on eBay received and the item's selling price. The following is a sample of 55 items sold through an auction. Price in Dollars 22 24 33 36 46 Number of Bids 4 7 7 9 10 Step 1 of 5: Calculate the sum of squared errors (SSE). Use the values b0=0.5961 and b1=0.2113 for the calculations. Round your answer to three decimal places. Step 2 of 5: Calculate the estimated...
Consider the relationship between the number of bids an item on eBay received and the item's...
Consider the relationship between the number of bids an item on eBay received and the item's selling price. The following is a sample of 5 items sold through an auction. Price in Dollars 109 109 132 139 194 Number of Bids 13 13 15 19 20 A. Calculate the sum of squared errors (SSE). Use the values b0=4.5256b0=4.5256 and b1=0.0840b1=0.0840 for the calculations. Round your answer to three decimal places.\ B. Calculate the estimated variance of errors, s2e. Round your...
4. Consider the relationship between the number of bids an item on eBay received and the...
4. Consider the relationship between the number of bids an item on eBay received and the item's selling price. The following is a sample of 5 items sold through an auction. Price in Dollars 137 137 151 180 187 Number of Bids 11 12 15 16 17 Step 1 of 5: Calculate the sum of squared errors (SSE). Use the values b0= −1.8618 and b1= 0.1014 for the calculations. Round your answer to three decimal places. Step 2 of 5:...
1. Consider the relationship between the number of bids an item on eBay received and the...
1. Consider the relationship between the number of bids an item on eBay received and the item's selling price. The following is a sample of 55 items sold through an auction. Price in Dollars 2222 2626 2727 3636 4545 Number of Bids 11 44 55 55 77 Step 1 of 5: Calculate the sum of squared errors (SSE). Use the values b0= −1.9336 and b1= 0.2030 for the calculations. Round your answer to three decimal places. Step 2 of 5:...
8. Consider the relationship between the number of bids an item on eBay received and the...
8. Consider the relationship between the number of bids an item on eBay received and the item's selling price. The following is a sample of 5 items sold through an auction. Price in Dollars 20 36 38 41 42 Number of Bids 5 5 5 8 8 Step 1 of 5: Calculate the sum of squared errors (SSE). Use the values b0= 2.1396 and b1= 0.1147 for the calculations. Round your answer to three decimal places. Step 2 of 5:...
In a Treasury auction of $800 million par value T-bills, the following bids were received: bidder...
In a Treasury auction of $800 million par value T-bills, the following bids were received: bidder bid amount price 1 $ 300 m 0.9820 competitive 2 $ 200 m 0.9850 competitive 3 $ 350 m 0.9825 competitive 4 $ 250 m 0.9835 competitive 5 $150 m 0.9845 competitive 6 $ 220 m Non-competitive Who will receive T-bills in this auction, in what quantity, and at what price?
Williams 400 Company, a publicly traded company, recently issued an RFP for quarterly reviews and the...
Williams 400 Company, a publicly traded company, recently issued an RFP for quarterly reviews and the annual audit. The company is generally perceived to be a desirable client and is expected to be extremely profitable for whichever firm lands the engagement. Shapiro, LLP, a public accounting firm, wishes to propose for the Williams 400 Co. engagement. Required: (a) What potential sources can Shapiro, LLP, utilize to gather information about the Williams 400 Company? (b) After researching the company, what should...
17. An infection with a rhinovirus might result in:                                  
17. An infection with a rhinovirus might result in:                                                                                                 A. common cold              B. genital warts            C. cold sores            D. mumps          E. vomiting                                                                                     18. An example of a disease caused by a retrovirus is:                                                                                         A. mumps         B. influenza             C. syphilis               D. AIDS              E. chickenpox                              19. Naturally acquired active immunity would be most likely acquired through which of the following processes?                                                                       A. vaccination                      B. drinking colostrum C. natural birth    D. infection with disease causing organism followed by recovery.          20....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT