Problem $3\text{'}$s Model Solver input question $20$ points

A small company that produces craftsmanship clocks. Two of the employees, Perla and Rebeca can work upto $40$

hours a week, but the third employee, Jack, can only work $20$ hours per week.

The company makes two types of clocks: Grandfather Clock and Wall Clock, and ships to the market. The

manufacturing process consists of two parts, where Perla is responsible from clock mechanical assembly of clocks

and Rebeca is responsible from wood case carving of clocks. Jack's responsibility is to pack and ship clocks to the

market. Table below provides the time it takes to process each activity for both product types.

Also, in order to get the special discount from the trucking company Jack agrees to ship at least $7$ products weekly.

If each Grandfather $($G$)$ Clock brings a profit of $$300$ and each Wall $($W$)$ Clock generates a profit of $$200,$ what

would be the best product mix to optimize the firm's weekly profit, given that there is enough demand.

ABC Consulting runs an LP model for the company's weekly production plans using the model below:

Let $G$ and $W$ repesent the amount of Grantfather clocks and Wall clocks manufacture each week, then

Max. $F$ Fok $=300G+200W$

s$.$t$.$

$6G+4\mathrm{.}5W40$

$8G+4W40$

$3G+2W20$

$G+w>7$

G$.W0$

and generates the results provided in the Q$3$ Answer Report and Q$3$ Sensitivity Report $.$ Using these worksheets answer the following questions.

You can input the above symbolic model into the excel worksheet and solve using SOLVER; which is $20$ points.