INSTRUCTIONS

Answer with some data analytics screenshots (excel) and explanations. Don't rush answers and take your time, please. Need it in 2 days. Answer each question in detail.

DISCUSSION QUESTIONS - (APC EUROPE) 1A) If you were in the position of Rick Coyne, what would be your response to Max Brisco's request? What recommendations would you make and why?

1B). What are the implications for the change in corporate strategy on Spartan's operations? How easy a task will it be to make this change? 2. How does a change from a job shop to a flow operation impact the requirements of the materials function and Spartan's suppliers? What changes will have to be made? 3. Is it reasonable to expect an improvement in inventory turns from four times to twenty times? How can this be accomplished? 4. Should Rick Coyne commit to a 10 percent reduction in prices from suppliers? Do you think this target is achievable? If so, how?

5. Can we cut lead times from 14 weeks to six weeks? What changes will have to be made to Spartan's supply chain to achieve this objective?

6. Perform a SWOT and SOAR analysis.