Allocating Resources in Excel using Solver $-$ Optimize the quantity of individual production

units that depend on varying amounts of fixed resources.

The allocating$-$resources.xlsx spreadsheet contains a model formulation for a toy company

$($Toys For Us$)$ that makes five different toys. These toys use six different materials in

varying amounts. For example, Toy $E$ uses $3$ units of red paint, $0$ unit of blue paint, $2$ units

of white paint, $1$ unit of plastic, and $5$ units of wood, and $3$ units of glue. Column $G$ shows

the current inventory of each type of material. Row $10$ shows the unit profit for each toy.

Run Solver $($being sure to use Simplex LP as the solver$),$ then:

a$)$ discuss the results that you obtain with respect to the quantity of each item produced,

inventory used and remaining, and overall company profit.

b$)$ Discuss which resources are most constrained and what would be the impact if you

were able to add more resources. Experiment with the levels of resources to inform

your discussion