Share
Explore BrainMass

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.

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