Problem$-1.$

$-$ S S C sells two snow ski models $-$ Jordanelle $\backslash$& Deercrest.

$-$ Manufacturing requires fabrication and finishing.

$-$ The fabrication department has $11$ skilled workers, each of whom works $7$ hours per day. The finishing department has $3$ workers, who also work a $7-$hour shift.

$-$ Each pair of Jordanelle skis requires $3\mathrm{.}5$ labor$-$hours in the fabricating department and $1$ laborhour in finishing.

$-$ The Deercrest model requires $4$ labor$-$hours in fabricating and $1\mathrm{.}5$ labor$-$hours in finishing.

$-$ The company operates $5$ days per week.

$-$ The company anticipates selling at least twice as many Deercrest models as Jordanelle models

$-$ S S C makes a net profit of $\backslash (\backslash$$ $50\backslash )$ on the Jordanelle model and $\backslash (\backslash$$ $65\backslash )$ on the Deercrest model.

$-$ Maximize the total profit Instruction:

$1.$ Use the SklenkaSkis.xlsx dataset $($in the assignment $3$ module$)$

$2.$ Follow the lecture and slides to find constraint $($note that in this problem, there are $11$ workers in fabrication department while there were $12$ workers in the problem we solved in the class$).$ You can see the lecture recording in canvas$-$media gallery.

Submissions:

$1.$ Give the screenshot of your output $($also screenshot of answer report and sensitivity report$)$

$2.$ What is the shadow price and What does it mean?

$3.$ What is the reduced cost and what does it mean?