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.

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