The worksheet contains the names of the bidders, their D&B ratings, and the results of

the following analysis:

Column F contains the results of applying Rule #1: Allow to bid if the bidders net

worth is greater than $500,000.

Column G contains the results of applying Rule #2: Allow to bid if the bidder has a

CCAR of 1 and a stress risk class of 1.

Column H contains the results of applying Rule #3: Allow to bid if the bidders

PAYDEX score is over 90.

Complete the following:

1. Open the workbook named PO611.xlsx in the Chapter 4 folder, and then save the

file as PO611 Credit Analysis.xlsx.

2. Write a formula in column I that can be copied down the column to make a final

determination of Allow to bid, Do not include, or Get more data based on

the following criteria:

Recommend to Do not include if none of the rules are TRUE.

Recommend to Get more data if only Rule #2 is TRUE or only Rule #3 is

TRUE.

Recommend to Allow to bid if the bidder is not recommended as Do not

include or Get more data.

TROUBLESHOOTING: To complete this exercise, be sure to use parentheses in

pairs and commas to separate arguments. It is very easy to misplace, fail to include, or

include extra parentheses and commas when entering this type of complex formula,

resulting in error messages or incorrect values. Excel color coordinates the pairs of

parentheses, making it easier to spot errors.

3. To make the worksheet easier to view, split the window to show the titles in rows 1

and 2 and the row heading in column A.

4. Save and close the PO611 Credit Analysis.xlsx workbook.

G Final Recommendation 85 A1 IX fx PO 611 Bidder List Financial Evaluation A B D E F H 1 PO 611 Bidder List Financial Evaluation D&B D&B Stress Net Worth D&B CCAR PAYDEX Risk Class 2 Customer Name (Dollars) (1 Best) (100 Best) (1 Best) Rule #1 Rule #2 Rule #3 3 BFF Industries $ 158,000 1 90 1 FALSE TRUE FALSE 4 NE Plastic 239,227,000 2 1 TRUE FALSE FALSE 5 Pergo Molding 35,500,000 2 98 1 TRUE FALSE TRUE 6 Allma 182,680,000 3 55 2 TRUE FALSE FALSE 7 JF & Sons 487,000 1 32 3 FALSE FALSE FALSE 8 Argree Inc. 17,043,000 3 0 1 TRUE FALSE FALSE 9 RGM Plastics 613,800,000 4 83 3 TRUE FALSE FALSE 10 Soto Services 452,000 1 73 1 FALSE TRUE FALSE 11 NRKK 780,000 2 79 2 TRUE FALSE FALSE 12 SPDM 64,830,000 2 87 1 TRUE FALSE FALSE 13 14 3 NN G Final Recommendation 85 A1 IX fx PO 611 Bidder List Financial Evaluation A B D E F H 1 PO 611 Bidder List Financial Evaluation D&B D&B Stress Net Worth D&B CCAR PAYDEX Risk Class 2 Customer Name (Dollars) (1 Best) (100 Best) (1 Best) Rule #1 Rule #2 Rule #3 3 BFF Industries $ 158,000 1 90 1 FALSE TRUE FALSE 4 NE Plastic 239,227,000 2 1 TRUE FALSE FALSE 5 Pergo Molding 35,500,000 2 98 1 TRUE FALSE TRUE 6 Allma 182,680,000 3 55 2 TRUE FALSE FALSE 7 JF & Sons 487,000 1 32 3 FALSE FALSE FALSE 8 Argree Inc. 17,043,000 3 0 1 TRUE FALSE FALSE 9 RGM Plastics 613,800,000 4 83 3 TRUE FALSE FALSE 10 Soto Services 452,000 1 73 1 FALSE TRUE FALSE 11 NRKK 780,000 2 79 2 TRUE FALSE FALSE 12 SPDM 64,830,000 2 87 1 TRUE FALSE FALSE 13 14 3 NN