Question
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started