Question $4$: $15$ points

The production planning team is trying to understand how they should source the next week's production to the three available plants: Sheboygen, Kohler and Saukville. They are concerned with four products that can be produced in each facility. The Excel data file you received includes the weekly cost per unit at each facility, the demand for each product, hours available in each plant and the required time per unit at each facility.

Each product can only be sourced to a single facility $($a facility can produce multiple products.$)$ Create an Excel model using the attached data file to determine the sourcing plan to minimize the cost of production. The production team wants to be able to update the model by copying and pasting a new data file directly into your model and running solver.