To optimize weekly revenues, HR must choose the combination of items A and B to generate for the upcoming week. It takes one minute to mold each unit of Product A, and two minutes to paint each unit. It takes one minute to mold, one minute to paint, and one minute to cut each unit of Product B. For the upcoming week, there will be 300 minutes available for molding, 400 minutes for painting, and 250 minutes for cutting based on the preliminary staff and machine schedules. The management also predicts that each unit of A and B will will have a $3 profit margin and a $2 profit margin, respectively. Use Excel Solver to solve this linear program and display the sensitivity Repor.

2. Two machines (A and B) are used by a corporation to produce two goods (X and Y). The processing times for each unit of X generated are 50 minutes on machine A and 30 minutes on machine B. The processing times for each unit of Y produced are 24 minutes on machine A and 33 minutes on machine B. There will be 3400 minutes of processing time available on machine A, and 3000 minutes on machine B. Demand for X is anticipated to be 35 units this week, whereas demand for Y is anticipated to be 45 units. Use Excel Solver to solve this linear program, then display the sensitivity report.

3. A refinery have two types of crude oil: Type A and Type B, and processing either type into finished fuel products. Type A costs $70 per barrel to procure and costs $1 to process per barrel, while Type B costs $50 per barrel and costs $1.6 per barrel to process.

The refinery produces four end products:

 Gasoline which sells for $150 per barrel, kerosene which sells for $100 per barrel, fuel oil which sells for $85 per barrel, and residual oil which sells for $10 per barrel.

Demand for gasoline is 24,000 barrels per day, kerosene is 2000 barrels per day, fuel oil is 6000 barrels per day.

The refinery suffers from yield loss and for this reason Type A only yields 80% gasoline, 5% kerosene, and 10% fuel oil, while the remaining 5% is residual oil. Type B only yields 44% gasoline, 10% kerosene, and 36% fuel oil, while the remaining 10% is residual oil.

solve this linear program using Excel Solver and show the sensitivity report.

 have a $3 profit margin and a $2 profit margin, respectively. Use Excel Solver to solve this linear program and display the sensitivity.

Answer rating: 100% (QA)

I cannot directly interact with Excel Solver or generate sensitivity reports within this textbased interface However I can provide you with guidance on how to set up and solve these linear programming ... View the full answer