please answer part A-D correctly

Practice OS data unpaid invoices Horne Insert Draw Page Lajout Formulas Dats Review View (8) Resd Only - Save a copy lo edit. f. Enter test on formula here Due to the recent cconomic slowdown, some vendors have started to apply different penalify schemes to overdue accounits. A local company has several outstanding balances on their unpaid invoices. You have been asked to help in calculating some of these possible penalities that the company might incur. The data file called Practi: eDS data unpaid inoices.xisx of contains the unpaid invoices and can be downloaded here. For numerical values, enter as wholenumbers. TRUE under Applies Fixed Penalty, In column H, for each vendor, use the appropriate formula to calculate whether the compamy must pay the fixed penalty, The total fined penaity amoust that the company might have to pay is batance of $125 or more on the accounts with 90 -days past due The total 90 -days penalty that the company might have to pay is cilculate the possible penalty based on the amount of the past due balance the compary owes by applying the graduated penalty table (celis F2 244 . The total gradunted penaty that the cocriarry midht have topary is: d. Overall, including the past invoice batances and the possible penalties, the amount that the compary owes in totat is