This case study is about Supply Chain Analysis and Design, it has 3 questions. 1. Developing an LP (Linear Programming) model that relates workforce and production decisions to monthly costs, and to find the minimum-cost solution that meets forecasted demands on time and stays within limits on overtime hours and production capacity. 2. Reproducing the model in Excel and solving the problem 3. Explain how changes in an initial number of workers impact the total cost value. Further instructions are in the uploaded PDF.
