I have a complicated assignment involving case study that I mustconvert to a lin

I have a complicated assignment involving case study that I mustconvert to a linear programming model and use the Solver functionin Excel to solve the problem. I must also obtain the sensitivityrange report for the problem to discuss both of these answers intwo paragraphs. I am seeking assistance because the linearprogramming model that I entered in Excel is obviously incorrectbecause I getting all zeros through the Solver function. Myprofessor also informed the class this week that there are 9decision variables and 9 constraints. I did not come up this manyof either. I need someone well-versed and familiar with thisstatistic blended type problem. I must get this assignment finishedthis week. I will attach what I have completed as well as the casestudy problem.