BUAI 411A GROUP PROJECT PART 2: MultiSales Company
BUAI 411A GROUP PROJECT PART 2
(See the Syllabus for the Due Date)
1. Based on the following model of the problem for the MultiSales Company, write a Python program in Spyder to create an EXCEL spreadsheet model, in which the data are:
n = the number of different types of items that are to be loaded today
m = the number of available trucks
ki = the number of items of type i that are to be loaded today (i = 1, …, n)
wi = the weight of item type i (i = 1, …, n)
cj = the weight capacity of truck j (j = 1, …, m)
You want to find values for the following variables:
Xij = the number of item type i to load on truck j (i = 1, …, n; j = 1, …, m)
Tj = 1 if truck j is used and 0 if truck j is not used (j = 1, …, m)
so as to
Min å j Tj
s. t.
Weight Capacity Constraint
å i wi Xij ≤ cj Tj (j = 1, …, m)
Demand Constraints
å j Xij = ki (i = 1, …, n)
Logical Constraints
All Xij ≥ 0 and integer; and Tj = 0 or 1 for j = 1, …, m
2. Your program should create the model that includes the variables, a formula in a cell for computing the objective function value, and cells for the left-side and right-side of each constraint. Your program should NOT call Solver. (50 points)
3. On or before the due date in the syllabus, upload to Canvas your Python Spyder file.
