4 rill 1- 234)| ^ 10 11 12 13 14 16 17 89 20 21 01234 5 6 7 8 9 01 1234567 Applying Logic in Decision Making the following Chapher 4 k named Unpaid,zlax located in the Chaptcr 4 folder, and then the workbook e the file as Unpaid Invoice This apter have agreed on an industry-stan Srgardless of the past due amount or number endors are identiied by of the past due amount or number of days past dard penalty of $45 on all past duc due. These corresponding row of column C n column H, which can be copied down the column, listing the utdentified by the value TRUE in the o erfu ation Me corresponding account: $45 for vendors that are participating in this nly penalty and S0 for all other vendors. Only vendors that are owed past duc 4 e the are listed on this sheet. utre another possible penalty whereby only those accounts with 90-days past calcalate es are owed a fee. In column I, write a formula that can be copied down Juc bil amn to calculate the penalty based on the following criteria ne's ent has due and counts with a 90-days past due balance of S50 or more, apply a fee of 12% of the 90-days past due balance. . For all other accounts, no penalty is applied. Another penalty scheme being used by vendors is a graduated method based on the column G). In column 1, write a formula that can be copied total past due balances ( down the column to calculate the penalty based on the followin . For accounts with a past due balance of $10,000 or more, apply a penalty of $600. For accounts with a past duc balance of less than S10,000 but more than $3,000, apply a penalty of $250. For accounts with a total past due balance of less than or equal to $3,000, do not apply a penalty 5. Penalties can sometimes be specific to vendor category. In column K, write a formula that can be copied down the column to calculate the penalty based on the following ntena: . For vendors in the labor category, apply a fee of 6% of the total past due balance. For vendors in the Utilities category, apply a fee of9% of the total past due balance (column G). For vendors in all other categories, apply a fee of 12% of the total past due balance. Format columns H through K to match column G 7. Save and close the Unpaid Invoice Penalties.xls workbook. 257 4 rill 1- 234)| ^ 10 11 12 13 14 16 17 89 20 21 01234 5 6 7 8 9 01 1234567 Applying Logic in Decision Making the following Chapher 4 k named Unpaid,zlax located in the Chaptcr 4 folder, and then the workbook e the file as Unpaid Invoice This apter have agreed on an industry-stan Srgardless of the past due amount or number endors are identiied by of the past due amount or number of days past dard penalty of $45 on all past duc due. These corresponding row of column C n column H, which can be copied down the column, listing the utdentified by the value TRUE in the o erfu ation Me corresponding account: $45 for vendors that are participating in this nly penalty and S0 for all other vendors. Only vendors that are owed past duc 4 e the are listed on this sheet. utre another possible penalty whereby only those accounts with 90-days past calcalate es are owed a fee. In column I, write a formula that can be copied down Juc bil amn to calculate the penalty based on the following criteria ne's ent has due and counts with a 90-days past due balance of S50 or more, apply a fee of 12% of the 90-days past due balance. . For all other accounts, no penalty is applied. Another penalty scheme being used by vendors is a graduated method based on the column G). In column 1, write a formula that can be copied total past due balances ( down the column to calculate the penalty based on the followin . For accounts with a past due balance of $10,000 or more, apply a penalty of $600. For accounts with a past duc balance of less than S10,000 but more than $3,000, apply a penalty of $250. For accounts with a total past due balance of less than or equal to $3,000, do not apply a penalty 5. Penalties can sometimes be specific to vendor category. In column K, write a formula that can be copied down the column to calculate the penalty based on the following ntena: . For vendors in the labor category, apply a fee of 6% of the total past due balance. For vendors in the Utilities category, apply a fee of9% of the total past due balance (column G). For vendors in all other categories, apply a fee of 12% of the total past due balance. Format columns H through K to match column G 7. Save and close the Unpaid Invoice Penalties.xls workbook. 257