HELP
- Please Solve Excel Assigment Due In 4 Hours Pls Help 1 (102.91 KiB) Viewed 43 times
PLEASE SOLVE EXCEL! ASSIGMENT DUE IN 4 HOURS, PLS HELP
-
answerhappygod
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
PLEASE SOLVE EXCEL! ASSIGMENT DUE IN 4 HOURS, PLS HELP
PLEASE SOLVE EXCEL! ASSIGMENT DUE IN 4 HOURS, PLS
HELP
6. Suppose that a manager must decide which of n warehouses to use for meeting the demands of m customers for a good. The decisions to be made are which warehouses to operate and how much to ship from any warehouse to any customer. The relevant costs are: fi : Fixed operating cost for warehouse i , if opened (for example, a cost to lease the warehouse), Cij : Per-unit operating cost at warehouse i plus the transportation cost for shipping from warehouse i to customer j. There are two types of constraints for the model: (a) The demand dj of each customer must be filled from the warehouses; and (b) Goods can be shipped from a warehouse only if it is opened. Formulate a linear program to minimize the cost of meeting the demands of customers. Solve the model in AMPL/Excel by generating a random instance of the problem involving 10 warehouses, 20 customers. Specify the relevant costs fi and Ci,j randomly.
HELP
6. Suppose that a manager must decide which of n warehouses to use for meeting the demands of m customers for a good. The decisions to be made are which warehouses to operate and how much to ship from any warehouse to any customer. The relevant costs are: fi : Fixed operating cost for warehouse i , if opened (for example, a cost to lease the warehouse), Cij : Per-unit operating cost at warehouse i plus the transportation cost for shipping from warehouse i to customer j. There are two types of constraints for the model: (a) The demand dj of each customer must be filled from the warehouses; and (b) Goods can be shipped from a warehouse only if it is opened. Formulate a linear program to minimize the cost of meeting the demands of customers. Solve the model in AMPL/Excel by generating a random instance of the problem involving 10 warehouses, 20 customers. Specify the relevant costs fi and Ci,j randomly.