Question: please help Question 3 4 Points Use this information, along with its associated Sensitivity Report, to answer the following questions A production manager wants to

please help
please help Question 3 4 Points Use this
please help Question 3 4 Points Use this
please help Question 3 4 Points Use this
Question 3 4 Points Use this information, along with its associated Sensitivity Report, to answer the following questions A production manager wants to determine how many units of each product to produce weekly to maximize weekly profits, Production requirements for the products are shown in the following table Material de Mata L. C 35 Material costs $7 a pound, material 2 costs $5 a pound, and labor costs $15 per hour. Product A sells for 5101 a unit, product B sells for $67 a unit and product sells for $97.50 a unt. Each week there are 300 pounds of materia 1: 400 pounds of material, and 200 hours of labor. The output of product should not be more than one-half of the total number of units produced. Moreover, there is a standing order of 10 units of product each week Fanni MX Subject to 105-10-10 A.B.5C300 entrat 2A-4 400 con 46 +2375C 1200 contrat Lost saved 11:35:13 AM Save and Close SubIT number of units produced. Moreover, there is a standing order of 10 units of product each week. MAX Formulation 10A 10B 100 Subject to 3A +B+50 $300 (constraint 1) 2A + 4B 5400 (constraint 92 4A + 28.35C5200 (constraint 13) C10(constraint #4) AB, C20 Sensitivity Report Adjustable Cells Cell $B$4 $C$4 $D$4 Name Optimal Values: A Optimal Values: B Optimal Values: C Final Reduced Value Cost 0 -10 82.5 0 10 0 Objective Coefficient 10 10 10 Allowable Increase 10 1E30 7.5 Allowable Decrease 1E30 4.285 1E30 Constraints Cell Name SE$7 Constraint 1 SE$8 Constraint 2 $E$9 Constraint 3 $E$10 Constraint 4 Final Value 1325 330 200 10 Shadow Price 0 0 5 -75 Constraint R.H.S. Side 300 400 200 10 Allowable Increase 1E30 1E30 35 47 142 Allowable Decrease 167.5 70 165 10 What is the optimal objective function value? Last saved 11:35:13 A SES7 Constraint 1 SES8 Constraint 2 $E$9 Constraint 3 SE$10 Constraint 4 132.5 330 200 10 0 5 -7.5 COOL 300 400 200 10 1E30 1E+30 35 47 142 1675 70 165 10 What is the optimal objective function value? 92.5 B none of these 100 825 E 925

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!