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 tot

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 linked in Module 6, answer the following questions. Requirements: Calculate AMC's Relevant Costs of Current Purchasing and JIT Purchasing for Product AProvide management insight into the conclusions Follow the instructions on the Data tab of the worksheet linked in Module 6. Show all calculations within the cells of the Excel spreadsheet. This means that you must use formulas and links so that your thought process can be examined. You must also include a detailed explanation of each journal entry that you make or do not make on each date to convey your thought process. There should be no hard coding of solutions. Review the grading rubric to understand how you will be graded on this assignment. Reach out to your instructor if you have questions about the assignment. Submit your downloaded and completed Excel file (with your name added to the file name) to the CT Assignment dropbox for Module 6.