Explore BrainMass
Share

Formulate and implement a linear/integer programming model in excel to minimize the total cost for the network and to determine the number of plants to be opened and their locations.

Formulate and implement a linear/integer programming model in excel to minimize the total cost for the network and to determine the number of plants to be opened and their locations.

I have already started on two different versions but can not get a linear model. I am stumped and have nowhere else to ask. Please look at the attatched word document (the problem statement and the excel spreadsheet). I really only need help with part 2.

The excel spread sheet has two sheets that are the same question that I tried to do two different ways.

© BrainMass Inc. brainmass.com August 15, 2018, 4:25 pm ad1c9bdddf

Attachments

Solution Summary

This solution is comprised of a detailed explanation to formulate and implement a linear/integer programming model in excel to minimize the total cost for the network and to determine the number of plants to be opened and their locations.

$2.19