Question: Sika case: Develop an optimization template that resolves the supply chain for the current $30-$day lead time. Look at possibly setting up ones and zeros where zero would represent not meeting lead time constraint. All info is provided so that is all i can give you

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

Quarterly Production Parameters

Supply Chain Matrix $($tons$)$

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