Question: 2. What is the average cost per raw material ingredient by vendor? (Hint: Create two PivotTable calcu-lations. Cost per unit of measure = Total Cost/Size
2. What is the average cost per raw material ingredient by vendor? (Hint: Create two PivotTable calcu-lations. Cost per unit of measure = Total Cost/Size and Cost per unit = Total quantity/Total Cost)

(answer in excel spreadsheet and explain how you used excel)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
