Consider a manufacturing facility that produces five different products using four machines. The facility has four machines of type

$1$

$,$

$$five of type

$2$

$,$

$$three of type

$3$

$$and seven of type

$4$

$.$

$$Each machine operates

$4$

$0$

$$hours per week. The problem is to determine the optimum weekly production quantities for the products. The goal is to maximize total profit. Analyze the sensitivity report.

Machine Quantity Product

$1$

$$Product

$2$

$$Product

$3$

$$Product

$4$

$$Product

$5$

M

$1$

$4$

$1$

$.$

$2$

$1$

$.$

$3$

$0$

$.$

$7$

$0$

$0$

$.$

$5$

M

$2$

$5$

$0$

$.$

$7$

$2$

$.$

$2$

$1$

$.$

$6$

$0$

$.$

$5$

$1$

M

$3$

$3$

$0$

$.$

$9$

$0$

$.$

$7$

$1$

$.$

$3$

$1$

$0$

$.$

$8$

M

$4$

$7$

$1$

$.$

$4$

$2$

$.$

$8$

$0$

$.$

$5$

$1$

$.$

$2$

$0$

$.$

$6$

Unit profit, $

$$

$$

$1$

$8$

$2$

$5$

$1$

$0$

$1$

$2$

$1$

$5$ provide solution in excel solver