-answer report on excel

-sensitivity report on excel

1) A company produces two products: A and B. Product A sells for $11 per unit and product B sells for $23 per unit. To produce a unit of A requires 2 hours on assembly line 1 and 1 unit of raw material. To produce a unit of product B requires 2 units of raw material, 1 unit of A, and 2 hours on assembly line 2. There are 1,300 hours of time available on line 1 and 500 hours on line 2. A unit of raw material can be purchased for $5 a unit or produced at no cost by using 2 hours of time on line 1. Let A=# of units of product A to manufacture Let B=#of units of product B to manufacture Let RMM = # of units or raw material to manufacture Let RMB = # of units of raw material to purchase Objective Function Max Z=11A+23B - 5RMB s.t. 2A +2B +2RMM 2B A +3B - RMM - RMB