Three types of appliances, A, B, and C, can be manufactured on one of two machines, 1 and 2. The variable costs (that is, per unit cost) of each appliance on each machine are A B C 1 $13 $8 $10 2 $11 $12 $7 There is an initial setup cost (fixed cost) to make each appliance on each machine. (Each fixed cost is incurred at most once, and it is incurred only if one or more of that appliance type is made on that machine): A B C 1 $52 $90 $60 2 $64 $60 $75 The time (in hours) required to make each appliance on each machine: ABC 1 0.4 1.1 0.9 2 0.5 1.2 1.3 We have to make 4 of appliance A, 9 of appliance B, and 5 of appliance C for a customer order. We can use Machine 1 for up to 10 hours and Machine 2 for up to 7 hours. Formulate an ILP problem that models this situation. Set it up in Excel and use solver to find the optimal solution. What is the minimum cost to make the necessary numbers of appliances?
Three types of appliances, A, B, and C, can be manufactured on one of two machines, 1 and 2. The variable costs (that is, per unit cost) of each appliance on each machine are A B C 1 $13 $8 $10 2 $11 $12 $7 There is an initial setup cost (fixed cost) to make each appliance on each machine. (Each fixed cost is incurred at most once, and it is incurred only if one or more of that appliance type is made on that machine): A B C 1 $52 $90 $60 2 $64 $60 $75 The time (in hours) required to make each appliance on each machine: ABC 1 0.4 1.1 0.9 2 0.5 1.2 1.3 We have to make 4 of appliance A, 9 of appliance B, and 5 of appliance C for a customer order. We can use Machine 1 for up to 10 hours and Machine 2 for up to 7 hours. Formulate an ILP problem that models this situation. Set it up in Excel and use solver to find the optimal solution. What is the minimum cost to make the necessary numbers of appliances?
Chapter4: Economic Evaluation In Health Care
Section: Chapter Questions
Problem 7QAP
Related questions
Question
Don't use ai to answer I will report you answer.
Transcribed Image Text:Three types of appliances, A, B, and C, can be manufactured on one of two machines, 1 and 2.
The variable costs (that is, per unit cost) of each appliance on each machine are
A B C
1 $13 $8 $10
2 $11 $12 $7
There is an initial setup cost (fixed cost) to make each appliance on each machine. (Each fixed cost is incurred at most once, and it is incurred only if one or more of that appliance type is made on
that machine):
A B C
1 $52 $90 $60
2 $64 $60 $75
The time (in hours) required to make each appliance on each machine:
ABC
1 0.4 1.1 0.9
2 0.5 1.2 1.3
We have to make 4 of appliance A, 9 of appliance B, and 5 of appliance C for a customer order. We can use Machine 1 for up to 10 hours and Machine 2 for up to 7 hours.
Formulate an ILP problem that models this situation. Set it up in Excel and use solver to find the optimal solution. What is the minimum cost to make the necessary numbers of appliances?
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
Recommended textbooks for you
Managerial Economics: A Problem Solving Approach
Economics
ISBN:
9781337106665
Author:
Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:
Cengage Learning
Economics (MindTap Course List)
Economics
ISBN:
9781337617383
Author:
Roger A. Arnold
Publisher:
Cengage Learning
Managerial Economics: A Problem Solving Approach
Economics
ISBN:
9781337106665
Author:
Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:
Cengage Learning
Economics (MindTap Course List)
Economics
ISBN:
9781337617383
Author:
Roger A. Arnold
Publisher:
Cengage Learning
