decision analysis - University of Redlands

Download Report

Transcript decision analysis - University of Redlands

Lecture
6
Inventory Management
Chapter 11
1
Economic Production Quantity (EPQ)




Economic production quantity (EPQ) model: variant of
basic EOQ model
Production done in batches or lots
Replenishment order not received in one lump sum
unlike basic EOQ model
Inventory is replenished gradually as the order is
produced


This model's variable costs are



hence requires the production rate to be greater than the
demand rate
annual holding cost, and
annual set-up cost (equivalent to ordering cost).
For the optimal lot size,

annual holding and set-up costs are equal.
2
EPQ = EOQ with Incremental Inventory
Replenishment
3
EPQ Model Assumptions

Demand occurs at a constant rate of D items per
year.
 Production capacity is p items per year.

p >D

Set-up cost: $Co per run.
 Holding cost: $Ch per item in inventory per year.
 Purchase cost per unit is constant (no quantity
discount).
 Set-up time (lead time) is constant.
 Planned shortages are not permitted.
4
EPQ Model Formulae

Optimal production lot-size (formula 11-16 of book)
Q0 
2 DC o
Ch
p
pD

Run time: Q */p

Time between set-ups (cycle time): Q */D years

Total cost (formula 11.15 of book)
1
D
D
TC  (1  )QCh  Co
2
P
Q
5
Example: Non-Slip Tile Co.






Non-Slip Tile Company (NST) has been using production runs of
100,000 tiles, 10 times per year to meet the demand of 1,000,000
tiles annually.
The set-up cost is $5,000 per run
Holding cost is estimated at 10% of the manufacturing cost of $1
per tile.
The production capacity of the machine is 500,000 tiles per month.
The factory is open 365 days per year.
Determine




Optimal production lot size
Annual holding and setup costs
Number of setups per year
Loss/profit that NST is incurring annually by using their present
production schedule
6
Management Scientist Solutions



Optimal TC = $28,868
Current TC = .04167(100,000) + 5,000,000,000/100,000
= $54,167
LOSS
= 54,167 - 28,868 = $25,299
7
Economic Production Quantity Assumptions
Only one item is involved 
 Annual demand is known 
 Usage rate is constant 
 Usage occurs continually
 Production occurs periodically
 Production rate is constant
 Lead time does not vary 
 No quantity discounts 

8
Operations Strategy

Too much inventory

Tends to hide problems
 Easier to live with problems than to eliminate
them
 Costly to maintain

Wise strategy

Reduce lot sizes
 Reduce safety stock
9
The Balance Sheet – Dell Computer Co.
28-Jan-00 29-Jan-99
Current assets:
Cash
Short-term investments
Account receivables, net
Inventories
Other
Total current assets
Property, plant, and equipment, net
Long-term investments
Equity securities and other
investments
Goodwill and others
Total assets
Change
Percent
$3,809
323
2,608
391
550
7,681
765
1,048
$1,726
923
2,094
273
791
5,807
523
532
$2,083
(600)
514
118
(241)
1,874
242
516
121%
-65%
25%
43%
-30%
32%
46%
97%
1,673
304
$11,471
--15
$6,877
1,673
289
$4,594
1927%
67%
$3,538
1,654
5,192
508
463
6,163
$2,397
1,298
3,695
512
349
4,556
$1,141
356
1,497
(4)
114
1,607
48%
27%
41%
-1%
33%
35%
---
---
3,583
1,260
465
5,308
1,781
606
(66)
2,321
1,802
654
531
2,987
101%
108%
$11,471
$6,877
$4,594
67%
LIABILITIES AND STOCKHOLDERS' EQUITY
Current liabilities:
Accounts payable
Accrued and other
Total current liabilities
Long-term debt
Other
Total liabilities
Stockholders' equity:
Preferred stock
Common stock and capital
in excess of $0.01 per value
Retained earnings
Other
Total stockholders' equity
Total liabilities and
stockholders' equity
129%
10
Income Statement – Dell Computer Co.
(in millions, except per share amount)
Net revenue
Cost of revenue
Gross margin
Operating expenses:
Selling, general and administrative
Research, development, and engineering
Total operating expenses
Operating income
Other income
Income before income taxes
Provision for income taxes
Net income
Earnings per common share:
Basic
Diluted
Weighted average shares outstanding:
Basic
Diluted
Retained Earnings:
Balances at beginning of period
Net income
Repurchase of common stocks
Balances at end of period
Fiscal Year Ended
28-Jan-00 29-Jan-99
$25,265 $18,243
20,047
14,137
5,218
4,106
2,387
568
2,955
2,263
188
2,451
785
$1,666
1,788
272
2,060
2,046
38
2,084
624
$1,460
$0.66
$0.61
$0.58
$0.53
2,536
2,728
2,531
2,772
606
1,666
(1,012)
$1,260
607
1,460
(1,461)
$606
11
Debt Ratio


What It Measures: The extent to which a firm uses debt financing
How You Compute: The ratio of total debt to total assets
Total debt
Debt ratio =
Total assets
$6,163

$11,471
 53.73%
12
Inventory Turnover Ratio


What It Measures: How effectively a firm is
managing its inventories.
How You Compute: This ratio is computed by
dividing sales by inventories
Sales
Inventory turnover ratio =
Average inventory balance
$25,265

 76.10 tim es
($273 $391) / 2
13
Lecture
6
MGMT 650
Simulation – Chapter 13
14
Simulation Is …

Simulation – very broad term
 methods and applications to imitate or mimic real
systems, usually via computer
Applies in many fields and industries

Simulation models complex situations

Models are simple to use and understand

Models can play “what if” experiments

Extensive software packages available



ARENA, ProModel
Very popular and powerful method
15
Applications

Manufacturing facility
 Bank operation
 Airport operations (passengers, security, planes,
crews, baggage, overbooking)
 Hospital facilities (emergency room, operating
room, admissions)
 Traffic flow in a freeway system
 Waiting lines - fast-food restaurant, supermarkets
 Emergency-response system
 Military
16
Example – Simulating Machine Breakdowns



The manager of a machine shop is concerned about
machine breakdowns.
Historical data of breakdowns over the last 100 days is as
follows
Number of Breakdowns
Frequency
0
10
1
30
2
25
3
20
4
10
5
5
Simulate breakdowns for the manager for a 10-day period
17
Simulation Procedure
Number of Breakdowns
0
1
2
3
4
5
Day
1
2
3
4
5
6
7
8
9
10
Frequency
10
30
25
20
10
5
100
Random Number
90
73
82
16
94
92
68
5
84
91
Probability Cum Prob
0.10
0.10
0.30
0.40
0.25
0.65
0.20
0.85
0.10
0.95
0.05
1.00
Corresponding Random Numbers
01 to 10
11 to 40
41 to 65
61 to 85
86 to 95
96 to 00
Simulated # of Breakdowns
4
3
3
1
4
4
3
0
3
4
19
Expected number
of breakdowns
= 1.9 per day
18
Statistical Analysis
Day #
Replication 1 Replication 2 Replication 3 Replication 4 Replication 5 Replication 6 Replication 7 Replication 8Replication 9 Replication 10
1
1
4
4
1
0
2
5
1
1
0
2
3
5
0
2
0
4
3
2
0
3
3
3
1
1
1
2
1
0
1
1
5
4
1
2
2
3
2
3
1
1
1
1
5
2
0
1
1
1
5
2
2
0
2
6
0
2
3
1
3
1
4
3
2
2
7
1
1
2
2
1
2
1
1
1
0
8
3
3
2
2
0
4
2
1
3
2
9
1
1
1
2
2
1
4
0
1
4
10
5
1
3
2
3
2
1
0
1
1
2.00
2.00
1.90
1.70
1.40
2.50
2.30
1.20
1.10
2.00
95 % confidence interval for mean breakdowns for the 10-day
period is given by:
xt
n 1;1

2
s
0.458
 1.81 2.262(
)  [1.665,1.955]
n
10
19
Monte Carlo Simulation
Monte Carlo method: Probabilistic simulation
technique used when a process has a random
component




Identify a probability distribution
Setup intervals of random numbers to match
probability distribution
Obtain the random numbers
Interpret the results
20
Example 2 – Simulating a Reorder Policy






The manager of a truck dealership wants to acquire some insight into
how a proposed policy for reordering trucks might affect order
frequency
Under the new policy, 2 trucks will be ordered every time the
inventory of trucks is 5 or lower
Due to proximity between the dealership and the local office, orders
can be filled overnight
The “historical” probability for daily demand is as follows
Demand (x)
P(x)
0
0.50
1
0.40
2
0.10
Simulate a reorder policy for the dealer for the next 10 days
Assume a beginning inventory of 7 trucks
21
Example 2 Solutions
x
0
1
2
P(x)
0.5
0.4
0.1
Cum P(x) RN
0.5 01 to 50
0.9 51 to 90
1.0 91 to 00
Day
1
2
3
4
5
6
7
8
9
10
RN
81
20
82
34
85
35
10
14
84
92
Demand Begin Inv End Inv Reorder
1
7
6
0
0
6
6
0
1
6
5
2
0
7
7
0
1
7
6
0
0
6
6
0
0
6
6
0
0
6
6
0
1
6
5
2
2
7
5
2
22
In-class Example 3 using MS-Excel





The time between mechanics’ requests for tools in a
AAMCO facility is normally distributed with a mean of
10 minutes and a standard deviation of 1 minute.
The time to fill requests is also normal with a mean of 9
minutes and a standard deviation of 1 minute.
Mechanics’ waiting time represents a cost of $2 per
minute.
Servers represent a cost of $1 per minute.
Simulate arrivals for the first 9 mechanic requests and
determine




Service time for each request
Waiting time for each request
Total cost in handling all requests
Assume 1 server only
23
AAMCO Solutions
Inter-request time Cum Int-req time Service Time Service Begins Service Ends Wait
8.76
8.76
9.57
8.76
18.33
5.49
14.25
9.25
18.33
27.58
5.21
19.46
8.63
19.46
28.09
3.98
23.44
8.19
23.44
31.63
4.66
28.10
6.09
28.10
34.19
6.71
34.81
9.15
34.81
43.96
6.31
41.12
9.93
41.12
51.05
5.57
46.70
8.66
46.70
55.36
6.38
53.08
9.67
53.08
62.75
Sum of wait
Server cost/min
Waiting cos/min
Total cost
Time
0.00
4.08
0.00
0.00
0.00
0.00
0.00
0.00
0.00
4.08
1
2
70.91
24
Simulation Models Are Beneficial

Systematic approach to problem solving
 Increase understanding of the problem
 Enable “what if” questions
 Specific objectives
 Power of mathematics and statistics
 Standardized format
 Require users to organize
25
Different Kinds of Simulation

Static vs. Dynamic


Continuous-change vs. Discrete-change


Can the “state” change continuously or only at
discrete points in time?
Deterministic vs. Stochastic


Does time have a role in the model?
Is everything for sure or is there uncertainty?
Most operational models:

Dynamic, Discrete-change, Stochastic
26
Discrete Event Simulation
Example 1 - A Simple Processing System
27
Advantages of Simulation

Solves problems that are difficult or
impossible to solve mathematically
 Flexibility to model things as they are (even
if messy and complicated)
 Allows experimentation without risk to
actual system

Ability to model long-term effects

Serves as training tool for decision makers
28
Limitations of Simulation

Does not produce optimum solution

Model development may be difficult

Computer run time may be substantial

Monte Carlo simulation only applicable to
random systems
29
Fitting Probability Distributions to Existing Data
Data Summary
Number of Data Points
Min Data Value
Max Data Value
Sample Mean
Sample Std Dev
= 187
= 3.2
= 12.6
= 6.33
= 1.51
Histogram Summary
Histogram Range
Number of Intervals
= 3 to 13
= 13
30
ARENA – Input Analyzer
Distribution Summary
Distribution:Gamma
Expression: 3 + GAMM(0.775, 4.29)
Square Error:0.003873
Chi Square Test
Number of intervals
=7
Degrees of freedom
=4
Test Statistic
= 4.68
Corresponding p-value = 0.337
Kolmogorov-Smirnov Test
Test Statistic
= 0.0727
Corresponding p-value > 0.15
Data Summary
Number of Data Points
Min Data Value
Max Data Value
Sample Mean
Sample Std Dev
= 187
= 3.2
= 12.6
= 6.33
= 1.51
Histogram Summary
Histogram Range
Number of Intervals
= 3 to 13
= 13
31
Simulation in Industry
32
Course Conclusions




Recognize that not every tool is the best fit for every problem
Pay attention to variability
 Forecasting
 Inventory management - Deliveries from suppliers
Build flexibility into models
Pay careful attention to technology
 Opportunities


Improvement in service and response times
Risks
 Costs involved
 Difficult to integrate
 Need for periodic updates
 Requires training

Garbage in, garbage out
 Results and recommendations you present are only as reliable as the model and its
inputs

Most decisions involve tradeoffs
Not a good idea to make decisions to the exclusion of known information

33