PLEASE FORMAT THE QUESTION USING EXCEL $($PROVIDE THE FORMULAS FOR EACH OF THE CELLS$)$ I HAVE PROVIDE THE ANSWERS TO THE

QUESTIONS BELOW. PLEASE ONLY PROVIDE THE EXCEL SHEET WITH THE FORMULAS: A company currently using an inspection process in its material receiving department is trying to install an overall cost reduction

program. One possible reduction is the elimination of one inspection position. This position tests material that has a defective content on the average of

$0\mathrm{.}04.$ By inspecting all items, the inspector is able to remove all defects. The inspector can inspect $50$ units per hour. The hourly rate including fringe

benefits for this position is $$9.$ If the inspection position is eliminated, defects will go into productpage $387$ assembly and will have to be replaced later at

a cost of $$10$ each when they are detected in final product testing. $($Answer in Appendix E$)$

Should this inspection position be eliminated?

What is the cost to inspect each unit?

Is there benefit $($or loss$)$ from the current inspection process? How much? $1$ a$.$ Cost when not inspecting $=$$$20/$hr$,$ cost to inspect $=$$$9/$hr$,$ therefore

inspect; b$.$ $$0\mathrm{.}18$ each; c$.$ $$0\mathrm{.}22$ per unit.