A company produces three products: #1, #2, and #3. The per unit resource required for each...

 

Transcribed Image Text:

A company produces three products: #1, #2, and #3. The per unit resource required for each product and the corresponding unit profits are given in the following table, along with the amount of each resource available in the upcoming production period. Formulate a spreadsheet model for this problem and use Solver to: 1. Determine the production levels that would maximize the total profit. 2. Generate a sensitivity report and discuss which type of resource is the most valuable to the firm by using the appropriate measure on the sensitivity report. Resource/Product Plastic (oz) Polymers (g) Production time (min) Unit Profit # 1 150 60 200 $720 #2 80 40 20 $250 #3 100 60 100 $650 Available 16200 9500 18000 A company produces three products: #1, #2, and #3. The per unit resource required for each product and the corresponding unit profits are given in the following table, along with the amount of each resource available in the upcoming production period. Formulate a spreadsheet model for this problem and use Solver to: 1. Determine the production levels that would maximize the total profit. 2. Generate a sensitivity report and discuss which type of resource is the most valuable to the firm by using the appropriate measure on the sensitivity report. Resource/Product Plastic (oz) Polymers (g) Production time (min) Unit Profit # 1 150 60 200 $720 #2 80 40 20 $250 #3 100 60 100 $650 Available 16200 9500 18000

Answer rating: 100% (QA)

Here is the spreadsheet model and solution using Solver 1 2 3 Plastic required oz 150 80 40 Plastic ... View the full answer