2 The Quantity in Units and Inventory Cost per unit are given in rang Write a formula in D4 to calculate "Quantity Dollars" based on the 2(a) Quantity Dollars = Quantity Units * Inventory Cost Per Unit Copy the formula down through to cell D15." Write a formula in D17 to compute total Quantity Dollars. 2()Total quantity dollars is the sum of quantity dollars, computed in $ Write a formula in E4 to calculate "% Dollars" based on the Quanti % Dollars = Quantity Dollars / Total Quantity Dollars. "C In the formula, make sure that you fix the row reference of cell Tot Copy the formula down through to cell E15. Write a formula in F4 to calculate "Cumulative Dollars" based on t Cumulative Dollars = Sum of all % Dollars up to the current row. It can be done in two ways, 2(d) First Approach: Write a formula in F4 and refer to cell E4. In F5 cel down to F15. Second Approach: Write a smart formula to achieve this in one sin Copy the formula down through to cell F15. Perform ABC Analysis. In ABC analysis, we classify the category i You can read about it here : https:/whatis.techtarget.com/definiti grey (!) If Cumulative Dollars is 80% and :95% then classify category as C Using IF Write a formula in cell G4 to perform ABC analysis. Copy t