GIVEN DATA

QUESTIONS

PLEASE SOLVE THE ABOVE QUESTIONS WITH AS MUCH DETAIL AS POSSIBLE SO I CAN LEARN!!

Brecken Corp. manufactures 4 products, Q, R, S, and T. These items' unit profit contributions are 12 dollars, 10 dollars, 5 dollars and 8 dollars. Labour hours and raw materials are two essential factors for making these products. Every day, 240 lbs of raw material and 500 labour hours are accessible. Furthermore, management desires that the amount of product A produced per day be at least 10 percent of the no. of units generated per day by the other 3 products altogether. We are given the optimal daily production plan, as shown below: Maximize Z= 120 + 10R + 55+ 8T --- Daily profit contribution in USD Subject to, 4Q+ 2R+S+2T = 0 --- min. daily output of product a 6Q + 4R + 25 +41 = 0 non-negative constraints Data: Product Unit profit contribution 0 $12 R $10 s $5 . $8 Units that are to be produced 10 100 0 0 6 Contraints Labour Material Min. Product A 2 4 -0.1 2 1 -0.1 4 LHS 460 240 0 4 2 -0.1 RHS 500 240 0 1 Tot. Gross Profit $1,120 Sensitvity Report Cell $A$8 $B$8 $C$8 $D$8 Name Producto Product R Products Product T Final Value 10 100 0 0 Reduced Cost 0 0 -0.3333 -2 Objective Allowable Coeff. Increase 12 8 10 1.00E+30 5 0.3333 8 2 Allowable Decrease 112 0.5714 1.00E+30 1.00E+30 Final Cell $E$12 $E$13 $E$14 Name Labour Material Minimum A Value 460 240 0 Reduced Objective Allowable Allowable Cost Coeff. Increase Decrease 0 500 1.00E+30 40 4.667 240 20.869 240 -6.667 0 60 12 Solve the following: I) Outline the best product combination and list out the total daily overall profit contribution. II) What is the minimal unit profit contribution of product required for it to be desired to produce as part of the daily product mix? Please explain. III) Should product T be included in the optimal product mix if its unit profit contribution may be enhanced from 8 dollars to 9.80 dollars? Please explain. IV) What effect does it have on the current optimal solution if the unit profit contribution of product Q is reduced from 12 dollars to 4.50 dollars? Please explain. V) Should an additional 20 daily labour hours be made available at no extra cost? Should they be utilized