Problem$-1.$

$$ S S C sells two snow ski models $-$ Jordanelle & 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$ labor$-$

hour 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 $$50$ on the Jordanelle model and $$65$ 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?