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.

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 16Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
