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?

EBK HEALTH ECONOMICS AND POLICY
7th Edition
ISBN:9781337668279
Author:Henderson
Publisher:Henderson
Chapter4: Economic Evaluation In Health Care
Section: Chapter Questions
Problem 7QAP
icon
Related questions
Question
Don't use ai to answer I will report you answer.
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?
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
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
EBK HEALTH ECONOMICS AND POLICY
EBK HEALTH ECONOMICS AND POLICY
Economics
ISBN:
9781337668279
Author:
Henderson
Publisher:
YUZU
Managerial Economics: A Problem Solving Approach
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 (MindTap Course List)
Economics
ISBN:
9781337617383
Author:
Roger A. Arnold
Publisher:
Cengage Learning
Microeconomics
Microeconomics
Economics
ISBN:
9781337617406
Author:
Roger A. Arnold
Publisher:
Cengage Learning
Micro Economics For Today
Micro Economics For Today
Economics
ISBN:
9781337613064
Author:
Tucker, Irvin B.
Publisher:
Cengage,
Survey Of Economics
Survey Of Economics
Economics
ISBN:
9781337111522
Author:
Tucker, Irvin B.
Publisher:
Cengage,