Solve questions $3-5$ in Excel Save your file with your ID on the Desktop.

$3-$ ABC company orders a raw component from an outside supplier at a cost of $$35.$ The annual demand for the raw material is $480$ units. The holding cost is $15\%$ of the actual item cost. The supplier has offered the following schedule of prices and quantities. Recommend the most cost$-$effective order quantity for ABC based on your analysis.

$\backslash$table$[[$Quantity$,$Unit Price $($$$)],[0-49,120],[50-99,105],[99-199,85],[200$ and more,$70]]$

$[4$pts$]$