代写GROUP PROJECT FOR SCMG 411A THE WAREHOUSE PICK-UP PROBLEM代做Python语言

GROUP PROJECT FOR SCMG 411A

THE WAREHOUSE PICK-UP PROBLEM

The Vice President of Operations for ABC Logistics has asked your group to automate the daily process of sending a fleet of trucks located at a single depot to pick up some number of identical items at a fixed number of warehouses located in Ohio (see the file GroupProject.xlsx). On some days, there might be enough trucks to pick up all of the items at all of the warehouses; however, on other days there might not be enough trucks to do so. The goal of this project is to build and solve a model that determines how to use the fleet of trucks available each day to pick up as many of the items from the warehouses as possible in a single trip, given that each truck can only go to one warehouse.

You will do this project in the following two parts and a portion of your grade depends on how well you follow the directions given below.

PROJECT PART 1 (See the Syllabus for the Due Date)

Build a model for solving a general version of this problem by following these instructions:

1.   Each day the Dispatch Manager knows the number of identical items to be picked up at each warehouse (see B12:B18 of the file). However, there are different types of trucks at the depot. The Dispatch Manager knows the number of available trucks of each type i and the number of items that each such truck can hold (see cells B3:D4 in the file).

Perform. each of the following tasks.

a.  Identify all of the data for a general problem by using appropriate symbols for each data item whose value needs to be provided. For example, one of the data items is M = the number of different types of trucks at the depot. (15 points)

b.  Draw a specific network diagram that includes all of the data in the file GroupProject.xlsx. State the meaning of the nodes and arcs in the context of the problem. (5 points)

c. Build and classify a paper model with variables, objective function and constraints (that uses as few variables as you can), to determine the maximum number of items the available trucks at the depot can pick up from the warehouses, keeping in mind that each truck can go to only one warehouse. (30 points)

2.   On or before the due date in the syllabus, upload to Canvas a single .pdf file with your solutions to 1(a), (b), and (c).