Question: Need help with part C can't seem to figure it out. Please use excel solver or solve by hand. Thanks! Polly Astaire makes fine clothing


Need help with part C can't seem to figure it out. Please use excel solver or solve by hand. Thanks!
Polly Astaire makes fine clothing for big and tall men. A few years ago Astaire entered the sportswear market with the Sunset line of shorts, pants, and shirts. Management wants to make the amount of each product that will maximize profits. Each type of clothing is routed through two departments, A and B. The relevant data for each product are as follows: Processing Time (hr) Product Department A Department B Material (yd) Shirts 2 Shorts 2 1 Pants 4 pants, $21. Department A has 120 hours capacity, department B has 140 hours of capacity, and 80 yards of material are available. Each shirt contributes $10 to profits and overhead; each pair of shorts, $13; and each pair a. Let X, = number of shirts produced, X2 = number of shorts produced, X = number pants produced Specify the objective function and constraints for the problem. Objective function: Maximize Z = 10 X, + 13 X, + 21 X, Constraints: Department A: 2 X, + 2 X2 + 3 X, S 120 Department B: 1X, + 3 X2 + 4 X s 140 Material: 2 X, + 1 X2 + 4X, BO Nonnegativity: X, X, 20 b. A linear programming software shows that all three constraints are binding. The optimal solution is (enter your responses rounded to two decimal places): X = 20, X, = 40, X3 = 0 c. How much should Astaire be willing to pay for an extra hour of department A capacity? Astaire should be willing to add an extra hour of department A capacity if its cost were less than $ 3.00. (Enter your response rounded to the nearest cent.) How much for an extra hour of department B capacity? Astaire should be willing to add an extra hour of department B capacity if its cost were less than $ 2. (Enter your response rounded to the nearest cent.) For what range of right-hand values are these shadow prices valid? For department A capacity, the lower end of the range is 98 hours and the upper end of the range is 120 hours. (Enter your responses rounded to the nearest whole number.) For department B capacity, the lower end of the range is 140 hours and the upper end of the range is 176 hours. (Enter your responses rounded to the nearest whole number.)Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
