Question

please solve it using excelp

14. Indi Inc. is thinking of opening 4 warehouses in four metropolitan areas in India: Delhi, Mumbai, Kolkata, and Chennai. There is a fixed cost associated with oper- ating each warehouse for a week. It is 30,000 rupees for Delhi, 40,000 rupees for Mumbai, 50,000 rupees for Kolkata, and 20,000 rupees for Chennai. Each ware house can ship a maximum 10,000 units per week. Indi Inc. has identified four regions in India with different demand requirements for each. The requirements for North, South, West, and East India are 5,000, 6,000, 4,000, and 5,000, respec tively. The shipping cost per unit is shown below: SOUTH WEST EAST NORTH 280 36.000 DELHI 180 350 250 40,000 320 150 200 275 MUMBAI KOLKATA 300 180 250 100 400 80 290 300 CHENNAI Also, the following requirements must be met: a. If Delhi is opened, Chennai must be opened. b. If Kolkata and Delhi are opened, Mumbai must not be opened. c. Either of Delhi or Mumbai must be opened, but not both Formulate an integer linear program to supply demand at the lowest total cost.

Answer 1

Given that let Xjk be the untt shipped from hus t eiom-K · Y :1,2,3,4 Ah yi be a binar ntege Such that yi-1 ise Vj- O tuhen the ave houte -j i opened othenuise yi o →-let- Minimize -) Totul cost Shipped Cost + And cost of the Openina Ware house and inki the constrain cLcTlyan

Demand Constrains Constraint a Constraint :' Constraint c Non- Negativity and bounds