DATA

QUESTIONS:

PLEASE HELP ME UNDERSTAND THE ABOVE QUESTIONS WITH DETAILED EXPLANATION

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 VI) What would be the impact on the current optimal solution if daily labor availability decreased by 16 hours due to absenteeism? Please explain. VII) How would the total daily profit contribution change if the material availability drops from 240 to 230 pounds per day? Please explain VIII) How would the existing total daily profit contribution change if 10 more pounds of the material could be procured at no additional cost? Please explain. IX) What should the top bosses do if a supplier offers to sell up to 30 pounds of raw material to Brecken Corp. each day at a higher cost (USD1.67/1b. more than its existing cost)? What effect would this have on the total profit contribution per day? Please explain. X) How does the existing optimal daily production plan alter if the profit contribution of product R changes to 9.50 dollars per unit, in terms of overall daily profit contribution and product mix? Please explain