what formula would I use to find the andwer

a: Use Excel formulas to calculate the Actual Sell-thru for each department. Then select whether the departments are Abeve Plan, On Target, or Below Plan, or New Arrivals (items just delivered with not have Sell-Thru data yet). (6 points) b: Explain eae factor that may have affected sell-thru percentages for the under-performing departments (2 points) Question b: ct Explain one factor that may have affected sell-thru percentages for the over-performing departments (2 points) Question e: d: Use Excel formulas to calculate each vender's dollar penetration perceatage for March in the car battery category ( 3 points) \begin{tabular}{c|c|c|c|} \hline Total Sales & Vendor & Sales & Penctration Rate \\ \hline & A & & \\ \hline & B & & \\ \hline & C & & \\ \hline \end{tabular} e: Explain how you would use the penetration iaformation to improve battery sales in future months (2 points) Question e: March Sales Information - Car Battery Category The buyer ordered 225 units of Auto Services items and planned for a 16% sell-thru in the first month. All 225 units were received in the store on March 1, 2021. Of the 225 Auto Services units received, the sellthru on car batteries was highest during March. The buyer ordered car batteries from three (3) different vendors. The total car battery category had $2,380 in sales for March on an average selling price of $119 per battery