Help with Optimization and Decision Support Modeling for Business HW2

I have attached a word document named OSCM-471571_Homework2_Sp23.docx which is the hw along with its excel template named hw2 template. I also attached solved practice problems along with their excel spreadsheets solved as well to be used as a sample. The hw needs to be submitted as a word doc.