logo Hurry, Grab up to 30% discount on the entire course
Order Now logo

Ask This Question To Be Solved By Our ExpertsGet A+ Grade Solution Guaranteed

expert
Cooper EllisManagement
(5/5)

511 Answers

Hire Me
expert
Sachin RanaComputer science
(5/5)

627 Answers

Hire Me
expert
Brijesh AahujaEconomics
(5/5)

930 Answers

Hire Me
expert
Minal JordenOthers
(5/5)

531 Answers

Hire Me
Linear Programming
(5/5)

A manufacturing company has two warehouses from which it distributes its product to five retailers.

INSTRUCTIONS TO CANDIDATES
ANSWER ALL QUESTIONS

There are four linear programming problems in this assignment focusing on transportation, transshipment, and assignment problems. Please submit (i) a single document demonstrating the mathematical formulation for each problem and (ii) four Python files for solving the models using Gurobi optimizer.

Problem 1

A manufacturing company has two warehouses from which it distributes its product to five retailers. At the start of every week, each retailer sends an order to the company’s head office, which is then dispatched from the appropriate warehouse to the retailer. The company would like to have an interactive computer program which they can run week by week to tell them which warehouse should supply which retailer so as to minimize the costs of the whole operation. For example, suppose that at the start of a given week the company has 2000 products at warehouse A, and 3000 products at warehouse B, and that the retailers require 500, 800, 1800, 300, and 700 products respectively.

Transportation Cost of each path is given in the following Table.

a) What data structure can be used to store number of retailers, warehouses capacity, costs information, and retailers’ demand?

b) Create the appropriate data structures in Python (Note: It is not required to solve the model for this question)

c) Formulate the linear programming model for this problem

Problem 2

Oranges are grown, picked, and then stored in warehouses in Tampa, Miami, and Fresno. These warehouses supply oranges to markets in New York, Philadelphia, Chicago, and Boston. The following table shows the shipping costs per truckload (in hundreds of dollars), supply, and demand. 

Because of an agreement between distributors, shipments are prohibited from Miami to Chicago.

a) Formulate this problem as a linear programming model

b) Find the optimal solution by using Python and Gurobi optimizer

Problem 3

Walsh's Fruit Company contracts with growers in Ohio, Pennsylvania, and New York to purchase grapes. The grapes are processed into juice at the farms and stored in refrigerated vats. Then the juice is shipped to two plants, where it is processed into bottled grape juice and frozen concentrate. The capacity at each plant were 140,000 tons. The juice and concentrate are then transported to three food warehouses/distribution centers.

The transportation costs per ton from the farms to the plants and from the plants to the distributors, and the supply at the farms and demand at the distribution centers are summarized in the following tables:

a) Formulate this problem as a linear programming model

b) Determine the optimal shipments from farms to plants to distribution centers to minimize total transportation costs by using Python and Gurobi optimizer

Problem 4

State University has planned six special catered events for the Saturday of its homecoming football game. The events include an alumni brunch, a parents' brunch, a booster club luncheon, a postgame party for season ticket holders, a lettermen's dinner, and a fund-raising dinner for major contributors. The university wants to use local catering firms as well as the university catering service to cater these events, and it has asked the caterers to bid on each event.

The bids (in thousands of dollars) based on menu guidelines for the events prepared by the university are shown in the following table:

The Bon Apetít, Custom, and University caterers can handle two events, whereas each of the other four caterers can handle only one. The university is confident that all the caterers will do a high-quality job, so it wants to select the caterers for the events that will result in the lowest total cost.

a) Formulate this problem as a linear programming model

b) Determine the optimal selection of caterers to minimize total cost by using Python and Gurobi optimizer

(5/5)
Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme