Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed

image text in transcribed

image text in transcribed

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 25

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

A Textbook Of Cost And Management Accounting

Authors: M N Arora

11th Edition

9390470501, 978-9390470501

More Books

Students also viewed these Accounting questions