Help with Optimization and Decision Support Modeling for Business HW4

I have attached a word document named OSCM-471571_Homework4_Sp23 which is the hw along with its excel files template named hw 4 templates. 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.