Horner's Hockey supplies manufactures three kinds of hockey sticks. Horner's has $1200$ machine hours to make the sticks. Due to quality issues, Horner's has decided to add a testing step in their manufacturing process. There are $800$ testing hours available and it takes $0\mathrm{.}5,1$ and $1\mathrm{.}5$ testing hours respectively to make one unit of wood, steel, and graphite sticks.

$\backslash$table$[[,,,,],[,,,,]]$

Required:

In excel, using linear programming, determine the optimal product mix for Horner. Use the link below to access the file to complete the work $-$ the template has been started far you but will require you to complete it and set up the linear programming information. $(7$ marks$)$

What is the optimal production mix? $(1$ mark$)$

What is the contribution associated with the optimal production mix? $(1$ mark$)$

What constraints are binding and which are not? $(2$ marks$)$