Question
Rule #1: Consider a bidder if its D&B PAYDEX score is at least 90. Rule #2: Consider a bidder if all of the following criteria
Rule #1: Consider a bidder if its D&B PAYDEX score is at least 90.
Rule #2: Consider a bidder if all of the following criteria are met: The bidders D&B PAYDEX score is greater than 65. The bidders D&B Composite Credit Appraisal value is less than or equal to 2. The bidders Net Worth is greater than $500,000.
Rule #3: Consider a bidder if any of the following criteria are met: The bidders D&B Stress Risk Class is equal to 1. The bidders Previous Experience Grade is Satisfactory.
please answer the following using excel and showing the formulas of how you got there thank you!
the number of work days blank in column D if the end date is blank in column B. Check Figure: Cell D12 = 90 Rules Worksheet Rule #1: Consider a bidder if its D&B PAYDEX score is at least 90. Rule #2: Consider a bidder if all of the following criteria are met: The bidder's D&B PAYDEX score is greater than 65. The bidder's D&B Composite Credit Appraisal value is less than or equal to 2. The bidder's Net Worth is greater than $500,000. Rule #3: Consider a bidder if any of the following criteria are met: The bidder's D&B Stress Risk Class is equal to 1. The bidder's Previous Experience Grade is Satisfactory. 4. In column G, calculate whether or not (TRUE/FALSE) the various bidders meet the criteria for Rule #1. Do not use an IF statement. 5. In column H, calculate whether or not (TRUE/FALSE) the various bidders meet the criteria for Rule #2. Do not use an IF statement. 6. In column I, calculate whether or not (TRUE/FALSE) the various bidd meet the criteria for Rule #3. Do not use an IF statement. 7. In cells G8:18, use a function to determine whether or not (TRUE/FALSE) any of the bidders meet each of the various rules. Do not use an IF statement. E G H L Bidder Net Worth (Dollars) D&B Composite Credit Appraisal (1 Best) D&B PAYDEX (100 Best) Rule #1 Rule #2 Rule #3 1 D&B Stress Risk Class (1 Best) 1 1 1 Previous Experience Grade Satisfactory Satisfactory Satisfactory None Unsatisfactory 2 Ribba Technology 3 TDR Corporation 4 ComputerX 5 Exceed WR 6 Roberts Inc. 89 79 $ $ $ $ $ 5,000,000 286,000 4,560,000 1,089,000 23,459,000 21 1 87 3 1 3 2 45 68 2 7 Do any of the bidders meet the rule? 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 25 the number of work days blank in column D if the end date is blank in column B. Check Figure: Cell D12 = 90 Rules Worksheet Rule #1: Consider a bidder if its D&B PAYDEX score is at least 90. Rule #2: Consider a bidder if all of the following criteria are met: The bidder's D&B PAYDEX score is greater than 65. The bidder's D&B Composite Credit Appraisal value is less than or equal to 2. The bidder's Net Worth is greater than $500,000. Rule #3: Consider a bidder if any of the following criteria are met: The bidder's D&B Stress Risk Class is equal to 1. The bidder's Previous Experience Grade is Satisfactory. 4. In column G, calculate whether or not (TRUE/FALSE) the various bidders meet the criteria for Rule #1. Do not use an IF statement. 5. In column H, calculate whether or not (TRUE/FALSE) the various bidders meet the criteria for Rule #2. Do not use an IF statement. 6. In column I, calculate whether or not (TRUE/FALSE) the various bidd meet the criteria for Rule #3. Do not use an IF statement. 7. In cells G8:18, use a function to determine whether or not (TRUE/FALSE) any of the bidders meet each of the various rules. Do not use an IF statement. E G H L Bidder Net Worth (Dollars) D&B Composite Credit Appraisal (1 Best) D&B PAYDEX (100 Best) Rule #1 Rule #2 Rule #3 1 D&B Stress Risk Class (1 Best) 1 1 1 Previous Experience Grade Satisfactory Satisfactory Satisfactory None Unsatisfactory 2 Ribba Technology 3 TDR Corporation 4 ComputerX 5 Exceed WR 6 Roberts Inc. 89 79 $ $ $ $ $ 5,000,000 286,000 4,560,000 1,089,000 23,459,000 21 1 87 3 1 3 2 45 68 2 7 Do any of the bidders meet the rule? 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 25Step 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