Help with optimization and decision support modeling for business hw4 | OSCM 471 | University of Arizona

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.