1. order completeness is much more important in internation logistics that it is
domestically because of longer supply chains and the higher costs of back orders
and expedited shipments
2. In the global logistics model presented in class customer service
Study Guide for Exam 2
The exam will be about 70% new material and 30% old material.
Old material: see study guide for exam 1; I am not going to ask a question about the net
present value.
New material:
Intro to ethics (I am holding you accountable for th
Parameter
Order Quantity
Annual demand
Standard deviation of annual demand
Mean lead time
Standard deviation of lead time
Type 1 Service Level
Inventory holding cost factor (annual)
Unit purchase cost
Holding cost per unit per year
Backordering cost per u
A
v
w
L
sL
D
sD
alpha
1
2
3
$
$
4,500
250
18%
2.1
0.8
191
66
98%
LTD
s
z
401.1
180.26
2.05
Reorder point
Order quantity
Avg. inventory
771.32
677.05
708.75
A
v
w
L
sL
D
sD
1
2
3
4
$
$
320
24
26%
0.2
0.12
110,000
alpha
33,000
94%
s
z
19,800
1.55
Safety sto
Questions
1
2
3
4
5
Calculate the optimal inventory control parameters Q and R for the data given in the next worskheet.
For the scenario calculated in Q.1, what is the total annual inventory holding cost?
Now imagine that a new forecasting software allow
Questions
1
2
3
4
5
6
7
8
9
Answers
3
4
5
6
7
8
9
Calculate as many forecasts in year 2016 as technically possible using each of the techniques on the data tab of this spread
Please note the implicit assumption that you are at the end of year 2015 and try
Questions
1
2
3
4
5
6
Answers
1
2
3
4
5
Calculate the optimal inventory control parameters Q and R for the data given in the next worskheet.
For the scenario calculated in Q.1, what is the total annual inventory holding cost?
Now imagine that a new foreca
Parameters
Question 1
Demand
v
w
h
A
$
$
2,000
380
20%
76.00
392.00
EOQ
G (EOQ)
$
144
10,916
Q*
2DA
h
G Q
Question 2
# of orders/year
13.92 orders
Question 3
Time b/w orders
26.2 days
Question 4
Q2
G (Q2 = 100)
100
11640
Q3
G (Q3 = 200)
200
11520
Q
D
h
Questions
1
2
3
4
5
Calculate the optimal inventory control parameters Q and R for the data given in the next worskheet.
For the scenario calculated in Q.1, what is the total annual inventory holding cost?
Now imagine that a new forecasting software allow
Bill of materials
Level
A
0
B (1)
E (2)
C (1)
F (1)
G (1)
D (1)
E (1)
1
F (4)
2
G (3)
MRP
Week
Demand
Scheduled receipts
On-hand
Order release
0
1
2
3
4
5
6
7
8
Bill of materials
Level
A
B (1)
E (2)
C (1)
F (1)
G (1)
D (1)
E (1)
F (4)
G (3)
MRP
Week
0
Dem
A
v
w
L
sL
D
sD
alpha
1
2
3
$
$
4,500
250
18%
2.1
0.8
191
66
98%
LTD
s
z
401.1
180.26
2.05
Reorder point
Order quantity
Avg. inventory
771.32
677.05
708.75
A
v
w
L
sL
D
sD
1
2
3
4
$
$
320
24
26%
0.2
0.12
110,000
alpha
33,000
94%
s
z
19,800
1.55
Safety sto
1. Rays Satellite Emporium wishes to determine the best order size, safety stock and reordering point
for its best-selling newly remodeled satellite dishthe SuperRay. Ray estimated the following
information from his detailed records on his favorite dish.
Questions
1
2
3
4
5
6
7
8
9
Answers
3
4
5
6
7
8
9
Calculate as many forecasts in year 2016 as technically possible using each of the techniques on the data tab of this spread
Please note the implicit assumption that you are at the end of year 2015 and try
New Perspectives Excel 2013
Tutorial 3: SAM Project 1a
Spring Software
Enhance a Timesheet
Author: Ryan Kidd
Note: Do not edit this sheet. If your name does not appear in cell
B6, please download a new copy of the file from the SAM website.
Spring Softwar
New Perspectives Excel 2013
Tutorial 2: SAM Project 1a
Spring Software
Formatting a Worksheet
Author: Ryan Kidd
Note: Do not edit this sheet. If your name does not appear in cell B6,
please download a new copy of the file from the SAM website.
Spring Soft
3009 N. College Ave.
Fayetteville, AR 72703
479.442.0100 ph.
479.442.0110 fax
QTY
100
100
100
100
100
100
100
0
100
UNITS OF
MEASURE
QTY
PRICE
EXTEND
3.0 OZ.
2.0 OZ.
1.0 OZ.
2.0 OZ.
8.0 PC.
2.0 PC.
5.0 OZ.
PORK
BEEF BRISKET
PORK LOIN
PULLED CHICKEN
CHICKE
Mark Millar, one of the best known supply chain experts in Asia and beyond, has
set a further standard in his book Global Supply Chain Ecosystems which provides
valuable insights for business leaders who are managing and developing their
global supply cha
Parameter
Order Quantity
Annual demand
Standard deviation of annual demand
Mean lead time
Standard deviation of lead time
Type 1 Service Level
Inventory holding cost factor (annual)
Unit purchase cost
Holding cost per unit per year
Backordering cost per u
Questions
1
2
3
4
5
6
7
8
9
Answers
3
4
5
6
7
8
9
Calculate as many forecasts in year 2016 as technically possible using each of the techniques on the data tab of this spread
Please note the implicit assumption that you are at the end of year 2015 and try
Inventory Control: Risk Pooling
Today
o Risk Pooling
Concept
Risk pooling strategies
DC Centralization- Illustration
In inventory systems, safety stock is used as a buffer against uncertainty.
Therefore, we would need less safety stock as uncertainty
Questions
1
2
3
4
5
6
7
8
9
Calculate the optimal inventory control parameters Q and R for the data given in the next worskheet.
For the scenario calculated in Q.1, what is the average inventory level?
For the scenario calculated in Q.1, what is the expec
Logistics Strategies Exam #1
Chapter 5- Supply Chain Performance Measures and Financial Analysis:
The scope and complexity of global supply chains require the development and use of
effective measures to evaluate the performance of the managers involved
Alex Burns
Business Logistics
Executive Decision: Global Logistics
The main goal of this video is to show that logistics is what makes our world go round.
Without good logistics and supply chain management goods wouldnt be produced as efficiently
as possi
Group 7 project outline
Andrew Bogner
Randy May
Russell 6055
Gray 9» YuhuiLiu
3/12/13
Topic:
Counterfeiting was a major curiosity specically how the supply chain was being used to accomplish it,
but also what the SC could due to eliminate it?
o Ack
Ch. 3
Cabotage restrictions- foreign trucking
companies are restricted from hauling
intracountry shipments
Focus production- a given plant produces
one or two items of the companys total
product line
Liner Service- scheduled service on regular
routes
Char
SKU rationalization, a method of risk pooling, is one of the key trends in retailing. See the attached
#K1003c (these are identical towels in different colors). The store manager considers discontinuing
#K1003b and #K1003c) and stocking red towels only (i
TLOG 3623
MRP exercise
Level 0
Level 1
Level 2
A
LT=1
B
LT=2
C
LT=3
D
LT=0
Week
Demand
Scheduled receipts
On hand
Order release
Demand
Scheduled receipts
On hand
Order release
Demand
Scheduled receipts
On hand
Order release
Demand
Scheduled receipts
On ha
Questions
1 - Using the data set below, please produce sales forecasts for Q25-Q28 using simple linear regression.
2 - Please calculate one aggregate measure of forecast bias and at least two aggregate measures of magnitude of FE.
3 - In what direction ar