Assignment about SCMD Assignment

SCMD ASSIGNMENT 1
Student Names & IDs
[DATE]
REPORT

Problem formulation
a) The main aim is to minimize the cost shipping strategy of the company.
Decision variables: Lets X j k is the quantity (in tons of product) transported from node j to
node k for feasible region (j, k).
b) Objective function and set of constraints
Objective function
Subject to constraints
1

c) Decision variables and linkage with the data
The decision variables have been used to determine the minimal shipping cost and the
optimal quantities of the product. The connection among the decision variables and the
requisite data have been shown in the excel spreadsheet.
Problem Solving
(a) & (b)
 Put the decision variable’s value zero
 Write the constraints after making references from decision variable’s value
 Write objective function corresponding to cost and decision variables
 Final used solver- add ins of excel to solve the linear programming problem through
simplex method after considering the non-negativity constraints
2