Question: 1. Developing Mathematical Model Develop a LP model that relates workforce and production decisions to monthly costs, and to nd the minimum-cost solution that meets

1. Developing Mathematical Model Develop a LP model that relates workforce and production decisions to monthly costs, and to nd the minimum-cost solution that meets forecasted demands on time and stays within limits on overtime hours and production capacity. {6 marks Word Document} 2. Reproducing the model in Excel and solving the problem Formulating the decision variables, objective function, and constraints in Excel; Setting the Solver parameters: Solving the problem; Interpret the result and providing the schedule. (10 marks Excel Document} 3. The company's CEO is asking your recommendation regarding the initial number of workers (currently 20}. The CEO said, "there is an opportunity to begin the process by selecting any initial number of workers between D and 200\". Investigate the relationship between the initial number of workers and the total cost {preferably by using a graph} and provide your recommendation regarding the best value or the best range of initial number of workers. Explain how changes in initial number of workers impacts the total cost value. (4 marks}
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
