Advanced Manufacturing Corp. (AMC) wants to be a JIT manufacturing location. Presently it uses EQP and MRP for inventory orders for product A. Under current policy, it orders one time a week for a total of 52 times a year. Under JIT policy, it will order three times a week for a total of 150 times a year. AMC wants to look at the benefits and costs with implementing a JIT purchasing environment. Using the provided data in the Excel Spreadsheet, answer the following questions Required 1). Calculate AMC's Relevant Costs of Current Purchasing and JIT Purchasing for Product A Description of operation Current purchasing EOQ and MRP JIT Purchasing Practice Deliveries 5,000 units purchase 5 times per year 1733 units purchase 150 times per year Required Rate of Return on investmer Purchasing Unit Cost Ordering costs Opportunity costs Relevant Carrying cost Customer return Costs Stockout Costs 18% 18% $9.00 per unit 20.00 per order $ 1.35 per unit of average inventory $3.30 per unit of average invento $9.00 per unit $ 20.00 per order $1.35 per unit of average inventory $ 3.00 per unit of average inventory 10.00 for shipping and processing no stockout costs 10.00 for shipping and processing 4.00 per order Additional