Question: Please help me do it in excel solver IAC International will assign has 4 types of Molding Machines available and requires assigning 5 types of

Please help me do it in excel solver

IAC International will assign has 4 types of Molding Machines available and requires assigning 5 types of products grouped by customer (Ford, Chevrolet, KIA, Toyota and Honda). The quantity of Molding Machines available per type of machine are: 50 Type 1 machines, 60 Type 2 machines, 40 Type 3 machines and 60 Type 4 machines. The number of products to be made are 40 for Ford, 40 for Chevrolet, 60 for KIA, 20 for Toyota and 50 for Honda. Type 4 machines cannot be assigned Toyota products. Neither type 1 machines can produce Chevrolet products. The table shows the Unit Cost in dollars of assigning each product to each type of machine. IAC International seeks to minimize operating costs.

Please help me do it in excel solver IAC

Using the transport method determine: Define the Model Variables Define the objective function of the Model. Define the Model constraints

Ford 1 Tipo de Producto KIA Toyata 6 Honda 30 18 Chevrolet 20 10 30 40 20 30 4 8 Tipo de Maquina - W NP 10 14 30 28 26 30 16

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!