please answer part A-D

Due to the recent economic slowdown, some vendors have started to apply different penalty schemes to overdue accounts. A local company has severaf outstanding bylances on their unpaid invoices. You havo boen asked to help in calculating some of these possible peralties that the company might incur. The data filc called Practire DS Foe numorical yalues, enter as whole numbers: a. Some vendors tave agreed on anindustry standard penalty of $75 all past due accounts regardless of the past due amount. These vendors are identified by the value TRUE under Applies fixed Penalty. In column H. for each vendon use the aboropriate formula to calculate whether the compamy must p.ay the fined penai ty. The total foxed penalty aroxint that the company might have to pay is batance of $125 or more on the accounts with 90 -dars past due. The total 90 -dars penalty that the company might have to pay is ponalty that the conpanx might have to pay lis: d. Overall, imfuding the past imoice balances and the possible penalties, the amount that the company owes in total is: Accounts Payable - Outstanding Balance Report Vendor Name RTF Electric Ross County Water \& Sewer YNC Trucking Heilinin Leather Group Lta Union Plastics Freight to Go Temps RUs Notworth Telephone Total Applies Fixed Penalty FALSE FALSE TRUE TRUE FALSE TRUE FALSE TRUE Category Ublaties Uullies Transportation Raw Materials Risw Materials Transportation Labor Telephone Telephone 30-Oays Past Due 5 Past Due Past Due Balance ( 19700 \begin{tabular}{rr} \hline & 19700 \\ \hline & 500 \end{tabular} 3.100 6.524 7.686 8.730 2.700 100