please answer part A until D, give the correct value pls

Practiceos data unpaid invoices Home Insert Draw Pagye Layout Formulas Data Revie N View Read Only - Saive al copy lo edit fx thentent or formula here Boents Due to the recent economic slowdown, some vendors have started to apply different penalty schemes to overdue accounts. A local company has several outstand ing balances on their unpald imoices, You have been asked to help in calculatisg some of these possible penalties that the company might incur, The data file called' Bractice DS data unpaid irveices.xis t contains the unpaid invoices and can be downloaded here. For numericalvalues, enter as whole numbers: a. Some vendors have agreed on an indutry standard penalty of $75 all past doe accounts regardless of the past due amount. These vendors are identifed by the value ThUE under Apolies Fixed Penalay, In column H, for each vendor, use the appropriate formula to calculate whether the company must pay the foxed penality, The total fixed penally amount that the company might have to pay is h. Some vendorscharne penaltyon accounts with 90 -days past due balances In column li use the appropriate formula to calcukate the possible penalty af an 18 is on the balance of $125 ormore on the accounts with 90 -days past doe. The total po-days penalty that the companyinight have to pany is calculate the possible penalty based on the anount of the paut due balance the compary owes by applying the eradoated penaity table (cells F2. H4). The total iradiated ponalty that the carnpany might huve to payls: d Ovenall, including the past imoice balances and the poss ble penalties, the amount that the compamy owes in total is