Practice Problems for Transport Decisions
Practice Problem 1 (Clark Wright Savings Algorithm)
Consider the following 3 customer locations Austin, Dallas, Houston. The DC (depot) is located
at Sealy. The following are the distances between each location
Se
April 28,
2014
TheItalianFoodCompany.Since1877.
Class: SCM 4362  Barilla SpA
Professor: Dr. Robertson Powell
Members: Zach Cousins, John Enick, Zaid
Background A Quick Introduction
Barilla SpA is an Italian based company created in
Parma, Italy by Pietro
Customer service
Customer Service can be viewed:
As an activity
In terms of performance levels
As a philosophy of management
LOGISTICS/SC CUSTOMER
SERVICE
Customer service is a process for providing significant
valueadded benefits to the supply chain in
Product characteristics
Product offering
Tangible part (physical characteristics)
Intangible part (service characteristics)
Weight,
volume, shape, performance, durability, etc.
Aftersales
support, company reputation, timeliness,
responsiveness, etc.
LO
Problem 1:
The tracking signals computed using past demand history for three different products are as follows. Each product used
the same forecasting technique.
1
2
3
4
5
6
7
8
9
10
TS 1
2.70
2.32
1.70
1.10
0.87
0.05
0.10
0.40
1.50
2.20
TS 2
1.54

FourStarIndustries:
MatchingSupplyandDemand
Team8
VictoriaPerales
VellaEsqueda
BrunoSubieta
AlejandroCastor
ChrisMundy
FourStarHistory
Founded in 1966 by Gim Sin and his wife , Four Star Industries is a family
owned and operated spring mattress manufactur
1) How would we figure out a question like this? "What percentage of days during Quarter 4
did Team KK have sales of 1kg Mixed Fruit Muesli when it was in stock?" I use
"production and operation" to calculate this, I tried several times, but still didn't
Using units of measure
Conversi
on of
Units
Creating
Algebraic
Formulas
to
Convert
Units
Importance of recognizing
units of measure
Units of Measure give numbers context
In business, any calculations that you make will have an associated
unit of measure
W
Transportation models
Using
Solver to
Optimize
Matching
Resource
s with
Needs
Background Information  continued
The company must decide exactly the number of units to
send from each plant to each center a shipping plan.
A typical transportation problem r
INTRODUCTION TO NonLinear
Models
Introducti
on to
Nonlinear
Models
Nonlinear
Functions
Using
1
Trendline
Nonlinear Equations
Definition of Nonlinear Equations
Equation whose graph does not form a straight line
(linear) is called a Nonlinear Equation (in
Enterprise Resource Planning
Final Exam Review
Check the Exam Schedule and Class Notes for the Date/Time of the Exam
Examination Format (100 points total)
21 multiple choice problems (2 or 3 points each) from lectures 16  25
9 multiple choice problems (2
Chuanxiong Wu
ERP 11:301:00
Individual Reflection on Project Learnings
Before the extend game, my team did analysis of the price and cost. We considered
the conditions of our competition and pricing strategy. My team used the cost based
pricing structure
Transportation models
Using
Solver to
Optimize
Matching
Resource
s with
Needs
Transportation Example
Products made at 5 plants
Plant B Capacity = 800 units
Plant C Capacity = 1390 units
Plant D Capacity = 2900 units
Plant A Capacity = 1500 units
Plant E C
Product mix models
Linear
Optimizat
ion
Models
Optimizat
ion using
Solver
Sensitivit
Linear Programming definitions
Objective
Constraints
Nonnegativity
Equality
Inequality
Changing Cells
Solutions
Feasible Solution
Feasible Region
Infeasible Region
Unboun
Simple Regression
Using
StatTools
to
calculate
the
regressio
n of two
variables
Introduction
Briefly revisit the Golf Club Demand Example from
the Intro to Nonlinear file.
Scatterplots
Trendline equations
Predictions
Absolute Percent Error
Mean Absolute P
Blending Models
Construct
ing Linear
Models
Introducin
g NonLinear
Solver
Hiring Trail Guides
An outdoor recreation company hires college students over the summer
to lead their trail excursions.
They provide three types of trail excursions: Easy, Moderate
Aggregate planning
Creating
Worker
Schedule
s
Music Tech Manufacturing Problem
Complete Chapter 4, Problem 80
Assume that No Backlog is Allowed
Additional questions to answer using SolverTable
At what firing cost would the model suggest to not fire any wo
Data Tables and
form controls
Form
Controls
One and
TwoWay
Data
Tables
Condition
al
Formattin
Creating mathematical
business models
Functionality: Must accurately represent the business situation and
assumptions about how the business works
Results: Mus
Filters and Pivot tables
Using
Filters to
extract
data from
a table
Using
Pivot
Tables to
answer
Table A: Boeing Sales Data
How many US orders?
How many US orders of the 7879?
How many US orders of the 7879 in 2007?
How many planes did Boeing sell of mo
Introduction to simulation
Incorpora
ting the
Randomn
ess of
Real
Processe
s Into
Models
Distribution of Presidents heights
Using the list of U.S. Presidents heights, determine the most likely
distribution that fits the data.
Practice creating random dist
INTRODUCTION TO SOLVER &
Building Mathematical models
Introducti
on to
Solver
Structurin
g
Business
Models in
Excel
Creating
For you to practice
Create a mathematical model in Excel for calculating your final grade
in this course.
Assumptions:
Excel
Quiz
Forecasting
Estimatin
g Future
Performa
nce
Forecasting quotes
Prediction is very difficult, especially if its
about the future. Nils Bohr
I always avoid prophesying beforehand
because it is much better to prophesy after
the event has already happened.
W