Note: This problem requires Excel. A firm offers two different prices on its products, depending upon the quantity purchased. Since available resources are limited, the firm would like to prepare an optimal production plan to maximize profits. Product 1 has the following profitability: $75 each for the first 25 units and $60 for each unit over 25. Product 2's profitability is $200 each for the first 50 units and $100 each for each unit over 50. The products each require two raw materials to produce (see table below for usages and available quantities). Product 1 usage Raw Material (gallons per unit) 10 5 Product 2 usage (gallons per unit) 20 A B Use separable programming to find the optimal production plan. Multiple Choice 50 units Product 1, 50 units Product 2 100 units Product 1, 100 units Product 2 100 units Product 1, 50 units Product 2 100 units Product 1, 25 units Product 2 25 units Product 1, 100 units Product 2 Available Quantity (gallons) 1,500 2,000
Note: This problem requires Excel. A firm offers two different prices on its products, depending upon the quantity purchased. Since available resources are limited, the firm would like to prepare an optimal production plan to maximize profits. Product 1 has the following profitability: $75 each for the first 25 units and $60 for each unit over 25. Product 2's profitability is $200 each for the first 50 units and $100 each for each unit over 50. The products each require two raw materials to produce (see table below for usages and available quantities). Product 1 usage Raw Material (gallons per unit) 10 5 Product 2 usage (gallons per unit) 20 A B Use separable programming to find the optimal production plan. Multiple Choice 50 units Product 1, 50 units Product 2 100 units Product 1, 100 units Product 2 100 units Product 1, 50 units Product 2 100 units Product 1, 25 units Product 2 25 units Product 1, 100 units Product 2 Available Quantity (gallons) 1,500 2,000
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter4: Linear Programming Models
Section: Chapter Questions
Problem 73P
Related questions
Question
Transcribed Image Text:Note: This problem requires Excel.
A firm offers two different prices on its products, depending upon the quantity purchased. Since available resources are limited, the firm would like to prepare an optimal production plan to maximize profits. Product 1
has the following profitability: $75 each for the first 25 units and $60 for each unit over 25. Product 2's profitability is $200 each for the first 50 units and $100 each for each unit over 50. The products each require two
raw materials to produce (see table below for usages and available quantities).
Product 1 usage
Raw Material (gallons per unit)
10
5
A
B
Use separable programming to find the optimal production plan.
Multiple Choice
O
O
Product 2 usage Available Quantity
(gallons per unit)
20
7
O
50 units Product 1, 50 units Product 2
100 units Product 1, 100 units Product 2
100 units Product 1, 50 units Product 2
100 units Product 1, 25 units Product 2
25 units Product 1, 100 units Product 2
(gallons)
1,500
2,000
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 4 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,