Create the corresponding formulas in column K:

1. For vendors in the Labor category, apply a fee of 6% of the total past due balance (column G)

2. For vendors in the Utilities category, apply a fee of 9% of the total past due balance (column G)

3. For vendors in all other categories, apply a fee of 12% of the total past due balance (column G)

Fixed Fee & 90 Day Penalties Fixed Fee Penalty $ 90-day min amt for penalty $ 90-day penalty percentage 45 50 12% Graduated Penalties - Range Graduated penalty = 3,000 3,000 10,000 TheZone Accounts Payable - Outstanding Balance Report 60Applies Days 90-Days Total Past Fixed 30-Days Past Past Due Vendor Name Category Penalty Past Due Due Due Balance RTF Electric Utilities $ - $ 18,100 $ 0 $ 0 $ 18,100 Ross County Water & SewerUtilities $ 500 0 0 500 YNC Trucking Transportation $ 1 0 ### 3,100 3,100 Italian Leather Group Ltd. Raw Materials $ 1 0 850 5,674 6,524 Union Plastics Raw Materials $ 1 7,250 436 0 7,686 Freight to Go Transportation $ 0 ### 8,730 8,730 Temps R'Us Labor $ 2,700 0 0 2,700 Notworth Telephone Telephone $ 1 250 0 0 250 Penalty $ 0 250 600 Category Penalties Labor 6% Utilities 9% Other 12% 90Fixed Days Graduated Category Penalty Penalty Penalty Penalty $ 0 $ 0 $ 600 45 372 250 45 681 250 45 250 1,048 250 45