Question: Sika case: Sika is looking to optimize their supply chain in order to lower lead times. Using the template provided, develop an optimization template that resolves the supply chain for the current $30-$day lead time. The porofessor has suggested that we set up a lead time constraint so that when the lead time is greater than $30,$ the supply for that location should be $0.$ Mayybe we can look at setting up another array that has $0$s in places where the lead time constraint is unmet.

Please look at the excel template I need to use and provide a step by step explanation as well as an image of your spreadsheet that shows your fomulas solver etc. There is no more information provided in this problem you just have to edit the spreadsheet.

Quarterly Production Parameters

Supply Chain Matrix $($tons$)$

Lead Time Matrix $($Order Processing and Transportation$)$ Days