Complete the following: 1. Open the workbook named Unpaid.xlsx located in the Chapter 4 folder, and then save the file as Unpaid Invoice Penalties.xlsx 2. Some vendors have agreed on an industry-standard penalty of S45 on all past due accounts regardless of the past due amount or number of days past due. These vendors are identified by the value TRUE in the corresponding row of column C. Write a formula in column H, which can be copied down the column, listing the penalty for the corresponding account: $45 for vendors that are participating in this standard penalty and So for all other vendors. Only vendors that are owed past duc balances are listed on this shect. 3. Calculate another possible penalty whereby only those accounts with 90-days past due balances are owed a fee. In column I, write a formula that can be copied down the column to calculate the penalty based on the following criteria: For accounts with a 90-days past due balance of $50 or more, apply a fee of 12% of the 90-days past due balance. For all other accounts, no penalty is applied. 4. Another penalty scheme being used by vendors is a graduated method based on the total past due balances (column G). In column J, write a formula that can be copied down the column to calculate the penalty based on the following criteria: For accounts with a past due balance of $10,000 or more, apply a penalty of S600. For accounts with a past due balance of less than $10,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 criteria: 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 of 9% of the total past due balanc (column G). For vendors in all other categories, apply a fee of 12% of the total past due balans 6. Format columns H through K to match column G. 7. Save and close the Unpaid Invoice Penalties.xlsx workbook. Graduated peally Penalty 3.000 a 3,000 250 10.000 000 Category Partition Labor Us Other 6% 9% 12 TheZone Accounts Payable - Outstanding Balance Report Applies Food 20-Days Past 60-Days 90 Days Total Past Vendor Name Category Penalty Due Past Due Pas Due Due Balance Penalty 90 Days Penalty Graduated Penalty Category Penalty 18.100 0 0 NO 16.100 100 2.100 6624 RTF Electric Ross County Verse YNC Trucking Italian Leather Group Union Plastic Pro to go Temps RUS Noworth Telephone 050 Utine U Transportation Raw Materials Raw Materials Transportation Labor Telephone 0 0 3.100 5,674 0 8,730 0 0 7250 0 2.700 250 790 0 87 2.700 250 0