Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help with part b. I have completed part b, but when I solve in solver is says Solver found a solution but nothing

I need help with part b. I have completed part b, but when I solve in solver is says "Solver found a solution but nothing appear the table appeared blank. The Excel document I completed is below. I need visual steps in part b to help me solve part b because I dont believe its right

Excel document: https://1drv.ms/x/s!AoQGMTkNnGG_hxsY36KfBQm6dIb0

23. A company manufactures three products: A, B, and C. The company currently has an order for 3 units of product A, B and C. The company currently has an order for 3 units of product A, 7 units of product B, and 4 units of product C. There is no inventory for any of these products. All three products require special processing that can be done on one of two machines. The cost of producing each product on each machine is summarized in the following table:

Cost of Producing a Unit of Product

Machine

A

B

C

1

$13

$9

$10

2

$11

$12

$8

The time required to produce each product on each machine is summarized in the following table:

Time (Hours) Needed to Produce a Unit of Product

Machine

A

B

C

1

0.4

1.1

0.9

2

0.5

1.2

1.3

Assume machine 1 can be used for eight hours and machine 2 can be sued for six hours. Each machine must undergo a special setup operation to prepare it to produce each product. After completing this setup for a product, any number of that product type can be produced. The setup costs for producing each product on each machine are summarized in the following table.

Setup Costs for Producing a Unit of Product

Machine

A

B

C

1

$55

$93

$60

2

$65

$58

$75

a.Formulate an ILP model to determine how many units of each product to produce on each machine in order to meet demand at a minimum cost.

b.Implement your model in a spreadsheet and solve it.

c.What is the optimal solution?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database And Expert Systems Applications 31st International Conference Dexa 2020 Bratislava Slovakia September 14 17 2020 Proceedings Part 1 Lncs 12391

Authors: Sven Hartmann ,Josef Kung ,Gabriele Kotsis ,A Min Tjoa ,Ismail Khalil

1st Edition

303059002X, 978-3030590024

More Books

Students also viewed these Databases questions

Question

lead bullets as forensic evidence

Answered: 1 week ago

Question

Define Gini index.

Answered: 1 week ago

Question

=+and non-compete agreements in three to five different countries.

Answered: 1 week ago