Management Science Problem
Please work the following problem on an EXCEL spreadsheet. An elegant solution is not required, Just provide all the steps so I will understand the concept and be able to replicate it for similar problems. Also, provide a written description…