workbook PO611.xlsx can be found in the first screenshot. Please follow the instructions to complete the workbook. Thanks in advance!

Steps To Success: Level 3 The Zone is considering different bids for the supply of plastic resins used to manufacture skis and needs to determine which bidder should be awarded the contract (PO #611). The Zone's accounts payable group has asked you to make some determinations regarding whether specific bidders should be rejected based on their lack of financial stability. Part of the analysis has already been completed, as shown in Figure 4.47. Figure 4.47: Bidder List Financial Evaluation worksheet D E F G H A B 1 PO 611 Bidder List Financial Evaluation Final Recommendation Not Worth 2 Customer Name Dollars) 3 BFF Industnes $ 158,00 4 NE Plastic 239 227,000 5 Perpo Moldng 35 500 000 0 Alma 182 690 000 7 JF & Sons 487 000 Argree Inc 17.043 000 9 ROM Plastics 613 800,000 10 Soto Services 452 000 11 NRKK 780,000 12 SPOM 84 830.000 13 DAH DER SE 06BCCAR PAYDEX Risk Class (1 Beat) (100 Best) 11 Bort) 1 90 1 2 85 1 2 98 1 3 55 2 1 32 1 3 0 1 4 83 3 1 73 1 2 79 2 2 87 1 Rulo 71 Rulo 2 Rule 13 FALSE TRUE FALSE TRUE FALSE FALSE TRUE FALSE TRUE TRUE FALSE FALSE FALSE TRUE FALSE TRUE FALSE FALSE TRUE FALSE FALSE FALSE TRUL FALSE TRUE FALSE FALSE TRUE FALSE FALSE 271 Copyright 2014 Congelewing. All Rights Resereed. May tot be copied code duplicated in whole input. De to electeerigher some third party may be appressed from the look and Chapter Titiuil mine artsmal thaay priori ummall turing pries the right stial arterit at time it tuight trarietio Shop TPPng 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 bidder's 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 bidder's PAYDEX score is over 90. Complete the following: 1. Open the workbook named P0611.xlsx in the Chapter 4 folder, and then save the file as P0611 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 casier 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 P0611 Credit Analysis xlsx workbook. Steps To Success: Level 3 The Zone is considering different bids for the supply of plastic resins used to manufacture skis and needs to determine which bidder should be awarded the contract (PO #611). The Zone's accounts payable group has asked you to make some determinations regarding whether specific bidders should be rejected based on their lack of financial stability. Part of the analysis has already been completed, as shown in Figure 4.47. Figure 4.47: Bidder List Financial Evaluation worksheet D E F G H A B 1 PO 611 Bidder List Financial Evaluation Final Recommendation Not Worth 2 Customer Name Dollars) 3 BFF Industnes $ 158,00 4 NE Plastic 239 227,000 5 Perpo Moldng 35 500 000 0 Alma 182 690 000 7 JF & Sons 487 000 Argree Inc 17.043 000 9 ROM Plastics 613 800,000 10 Soto Services 452 000 11 NRKK 780,000 12 SPOM 84 830.000 13 DAH DER SE 06BCCAR PAYDEX Risk Class (1 Beat) (100 Best) 11 Bort) 1 90 1 2 85 1 2 98 1 3 55 2 1 32 1 3 0 1 4 83 3 1 73 1 2 79 2 2 87 1 Rulo 71 Rulo 2 Rule 13 FALSE TRUE FALSE TRUE FALSE FALSE TRUE FALSE TRUE TRUE FALSE FALSE FALSE TRUE FALSE TRUE FALSE FALSE TRUE FALSE FALSE FALSE TRUL FALSE TRUE FALSE FALSE TRUE FALSE FALSE 271 Copyright 2014 Congelewing. All Rights Resereed. May tot be copied code duplicated in whole input. De to electeerigher some third party may be appressed from the look and Chapter Titiuil mine artsmal thaay priori ummall turing pries the right stial arterit at time it tuight trarietio Shop TPPng 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 bidder's 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 bidder's PAYDEX score is over 90. Complete the following: 1. Open the workbook named P0611.xlsx in the Chapter 4 folder, and then save the file as P0611 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 casier 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 P0611 Credit Analysis xlsx workbook