Reorder Point Simulation

profiletausby
exer13-v2__electronics_superstore_rop_template.xls
Home>Business & Finance homework help>Operations Management homework help>Reorder Point Simulation

Other Features

Other Features
1
Results Details
Show Results Details
Hide Results Details
Resources
Discrete Distributions
Custom Schedules
Return to Control Panel

Model View

Model View
(Note: Cannot edit model here)
Simulation controls:
Time units per simulation ® 600
Number of simulations ® 30
Exits:
1
Name ® Purchase Requests
Time between departures ® Exp(2)
Num. objects per departure ® 1
Work Stations:
1
Name ® Delivery
Working time ® Nor(50,3)
Output # of output Resource Resource
destination(s) ¯ objects ¯ name(s) ¯ # units needed ¯
Reorder Point 75
Buffers:
1 2
Name ® Factory Name ® Reorder Point
Capacity ® 1000 Capacity ® 25
Initial # objects ® 1000 Initial # objects ® 25
Output Output Output Output
destination(s) ¯ group size ¯ destination(s) ¯ group size ¯
Delivery 75 Purchase Requests 1
Return to Control Panel

Control Panel

SimQuick Control Panel by David Hartvigsen
© Prentice-Hall, 2004
Enter/Edit Model:
Elements:
Simulation controls:
Time units per simulation ® 600
Number of simulations ® 30 Simulation(s) completed!
&A
Page &P
Run Simulation(s)
Clear Present Model
Entrances
Work Stations
Buffers
Decision Points
Exits
Results
Custom Schedules
Generated Schedules
Resources
Run Simulation(s)
Clear Model
Entrances
Work Stations
Buffers
Decision Points
Exits
View Results
Other Features
View Model

Discrete Distributions

Discrete Distributions
(Note: Percents columns must sum to 100)
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Values ¯ Percents ¯ Values ¯ Percents ¯ Values ¯ Percents ¯ Values ¯ Percents ¯ Values ¯ Percents ¯ Values ¯ Percents ¯ Values ¯ Percents ¯ Values ¯ Percents ¯ Values ¯ Percents ¯ Values ¯ Percents ¯ Values ¯ Percents ¯ Values ¯ Percents ¯ Values ¯ Percents ¯ Values ¯ Percents ¯ Values ¯ Percents ¯ Values ¯ Percents ¯ Values ¯ Percents ¯ Values ¯ Percents ¯ Values ¯ Percents ¯ Values ¯ Percents ¯
Return to Control Panel
Return to Other Features

Entrances

Entrances
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ®
Time between arrivals ® Time between arrivals ® Time between arrivals ® Time between arrivals ® Time between arrivals ® Time between arrivals ® Time between arrivals ® Time between arrivals ® Time between arrivals ® Time between arrivals ® Time between arrivals ® Time between arrivals ® Time between arrivals ® Time between arrivals ® Time between arrivals ® Time between arrivals ® Time between arrivals ® Time between arrivals ® Time between arrivals ® Time between arrivals ®
Num. objects per arrival ® Num. objects per arrival ® Num. objects per arrival ® Num. objects per arrival ® Num. objects per arrival ® Num. objects per arrival ® Num. objects per arrival ® Num. objects per arrival ® Num. objects per arrival ® Num. objects per arrival ® Num. objects per arrival ® Num. objects per arrival ® Num. objects per arrival ® Num. objects per arrival ® Num. objects per arrival ® Num. objects per arrival ® Num. objects per arrival ® Num. objects per arrival ® Num. objects per arrival ® Num. objects per arrival ®
Output Output Output Output Output Output Output Output Output Output Output Output Output Output Output Output Output Output Output Output
destination(s) ¯ destination(s) ¯ destination(s) ¯ destination(s) ¯ destination(s) ¯ destination(s) ¯ destination(s) ¯ destination(s) ¯ destination(s) ¯ destination(s) ¯ destination(s) ¯ destination(s) ¯ destination(s) ¯ destination(s) ¯ destination(s) ¯ destination(s) ¯ destination(s) ¯ destination(s) ¯ destination(s) ¯ destination(s) ¯
&A
Page &P
Choices for "Time bet. arr." and "Num. ob. per arr.": Nor(m,s), Exp(m), Uni(a,b), Constant, Dis(i), Cus(i)
Return to Control Panel
Examples

Exits

Exits
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Name ® Purchase Requests Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ®
Time between departures ® Exp(2) Time between departures ® Time between departures ® Time between departures ® Time between departures ® Time between departures ® Time between departures ® Time between departures ® Time between departures ® Time between departures ® Time between departures ® Time between departures ® Time between departures ® Time between departures ® Time between departures ® Time between departures ® Time between departures ® Time between departures ® Time between departures ® Time between departures ®
Num. objects per departure ® 1 Num. objects per departure ® Num. objects per departure ® Num. objects per departure ® Num. objects per departure ® Num. objects per departure ® Num. objects per departure ® Num. objects per departure ® Num. objects per departure ® Num. objects per departure ® Num. objects per departure ® Num. objects per departure ® Num. objects per departure ® Num. objects per departure ® Num. objects per departure ® Num. objects per departure ® Num. objects per departure ® Num. objects per departure ® Num. objects per departure ® Num. objects per departure ®
&A
Page &P
Choices for "Time bet. dep." and "Num. ob. per dep.": Nor(m,s), Exp(m), Uni(a,b), Constant, Dis(i), Cus(i)
Return to Control Panel
Examples

Work Stations

Work Stations
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Name ® Delivery Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ®
Working time ® Nor(50,3) Working time ® Working time ® Working time ® Working time ® Working time ® Working time ® Working time ® Working time ® Working time ® Working time ® Working time ® Working time ® Working time ® Working time ® Working time ® Working time ® Working time ® Working time ® Working time ®
Output # of output Resource Resource Output # of output Resource Resource Output # of output Resource Resource Output # of output Resource Resource Output # of output Resource Resource Output # of output Resource Resource Output # of output Resource Resource Output # of output Resource Resource Output # of output Resource Resource Output # of output Resource Resource Output # of output Resource Resource Output # of output Resource Resource Output # of output Resource Resource Output # of output Resource Resource Output # of output Resource Resource Output # of output Resource Resource Output # of output Resource Resource Output # of output Resource Resource Output # of output Resource Resource Output # of output Resource Resource
destination(s) ¯ objects ¯ name(s) ¯ # units needed ¯ destination(s) ¯ objects ¯ name(s) ¯ # units needed ¯ destination(s) ¯ objects ¯ name(s) ¯ # units needed ¯ destination(s) ¯ objects ¯ name(s) ¯ # units needed ¯ destination(s) ¯ objects ¯ name(s) ¯ # units needed ¯ destination(s) ¯ objects ¯ name(s) ¯ # units needed ¯ destination(s) ¯ objects ¯ name(s) ¯ # units needed ¯ destination(s) ¯ objects ¯ name(s) ¯ # units needed ¯ destination(s) ¯ objects ¯ name(s) ¯ # units needed ¯ destination(s) ¯ objects ¯ name(s) ¯ # units needed ¯ destination(s) ¯ objects ¯ name(s) ¯ # units needed ¯ destination(s) ¯ objects ¯ name(s) ¯ # units needed ¯ destination(s) ¯ objects ¯ name(s) ¯ # units needed ¯ destination(s) ¯ objects ¯ name(s) ¯ # units needed ¯ destination(s) ¯ objects ¯ name(s) ¯ # units needed ¯ destination(s) ¯ objects ¯ name(s) ¯ # units needed ¯ destination(s) ¯ objects ¯ name(s) ¯ # units needed ¯ destination(s) ¯ objects ¯ name(s) ¯ # units needed ¯ destination(s) ¯ objects ¯ name(s) ¯ # units needed ¯ destination(s) ¯ objects ¯ name(s) ¯ # units needed ¯
Reorder Point 75
&A
Page &P
Choices for "Working time": Nor(m,s), Exp(m), Uni(a,b), Constant, Dis(i)
Return to Control Panel
Examples

Buffers

Buffers
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Name ® Factory Name ® Reorder Point Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ®
Capacity ® 1000 Capacity ® 25 Capacity ® Capacity ® Capacity ® Capacity ® Capacity ® Capacity ® Capacity ® Capacity ® Capacity ® Capacity ® Capacity ® Capacity ® Capacity ® Capacity ® Capacity ® Capacity ® Capacity ® Capacity ®
Initial # objects ® 1000 Initial # objects ® 25 Initial # objects ® Initial # objects ® Initial # objects ® Initial # objects ® Initial # objects ® Initial # objects ® Initial # objects ® Initial # objects ® Initial # objects ® Initial # objects ® Initial # objects ® Initial # objects ® Initial # objects ® Initial # objects ® Initial # objects ® Initial # objects ® Initial # objects ® Initial # objects ®
Output Output Output Output Output Output Output Output Output Output Output Output Output Output Output Output Output Output Output Output Output Output Output Output Output Output Output Output Output Output Output Output Output Output Output Output Output Output Output Output
destination(s) ¯ group size ¯ destination(s) ¯ group size ¯ destination(s) ¯ group size ¯ destination(s) ¯ group size ¯ destination(s) ¯ group size ¯ destination(s) ¯ group size ¯ destination(s) ¯ group size ¯ destination(s) ¯ group size ¯ destination(s) ¯ group size ¯ destination(s) ¯ group size ¯ destination(s) ¯ group size ¯ destination(s) ¯ group size ¯ destination(s) ¯ group size ¯ destination(s) ¯ group size ¯ destination(s) ¯ group size ¯ destination(s) ¯ group size ¯ destination(s) ¯ group size ¯ destination(s) ¯ group size ¯ destination(s) ¯ group size ¯ destination(s) ¯ group size ¯
Delivery 75 Purchase Requests 1
&A
Page &P
Return to Control Panel
Examples

Decision Points

Decision Points
(Note: Percents columns must sum to 100)
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ® Name ®
Output Output Output Output Output Output Output Output Output Output Output Output Output Output Output Output Output Output Output Output
destinations ¯ Percents ¯ destinations ¯ Percents ¯ destinations ¯ Percents ¯ destinations ¯ Percents ¯ destinations ¯ Percents ¯ destinations ¯ Percents ¯ destinations ¯ Percents ¯ destinations ¯ Percents ¯ destinations ¯ Percents ¯ destinations ¯ Percents ¯ destinations ¯ Percents ¯ destinations ¯ Percents ¯ destinations ¯ Percents ¯ destinations ¯ Percents ¯ destinations ¯ Percents ¯ destinations ¯ Percents ¯ destinations ¯ Percents ¯ destinations ¯ Percents ¯ destinations ¯ Percents ¯ destinations ¯ Percents ¯
&A
Page &P
Return to Control Panel
Examples

Entrance Rules

1 1 1
Name ® Ent1 Name ® Loading Dock 3 Name ® LD2
Time between arrivals ® Nor(5,2) Time between arrivals ® Exp(2) Time between arrivals ® Custom
Num. objects per arrival ® 10 Num. objects per arrival ® Nor(5,1) Num. objects per arrival ® Custom
Output Output Output
destination(s) ¯ destination(s) ¯ destination(s) ¯
P1 DP1 Buffer3
P2
E3
&A
Page &P
Examples:
Note: E3 will not be read because there is a blank cell above it.
Note: There must be a Custom Schedule defined with the name LD2.
Return to Entrances

Exit Rules

1 1
Name ® Ex1 Name ® Exit 5
Time between departures ® Nor(10,2) Time between departures ® Exp(6)
Num. objects per departure ® 25 Num. objects per departure ® Nor(6,2)
&A
Page &P
Examples:
Return to Exits

Work Station Rules

1 1 1
Name ® WS1 Name ® Lathe2 Name ® Bill
Working time ® Nor(5,2) Working time ® Exp(5) Working time ® Uni(3,7)
Output # of output Resource Resource Output # of output Resource Resource Output # of output Resource Resource
destination(s) ¯ objects ¯ name(s) ¯ # units needed ¯ destination(s) ¯ objects ¯ name(s) ¯ # units needed ¯ destination(s) ¯ objects ¯ name(s) ¯ # units needed ¯
WS2 1 Drill2 1 Worker1 1 Shipping 50 Copier 1
WS3 5 Intern 2
&A
Page &P
Examples:
Note: This Work Station requires no resources.
Note: The "5" means that when this Work Station finishes a work cycle, it sends 5 objects to WS3 (hence the number of input objects need not equal the number of output objects).
Return to Work Stations

Buffer Rules

1 1
Name ® B1 Name ® Storage Area 3
Capacity ® 5 Capacity ® 50
Initial # objects ® 0 Initial # objects ® Nor(3,1)
Output Output Output Output
destination(s) ¯ group size ¯ destination(s) ¯ group size ¯
Processor 6 1 End Area 2 4
Decision Point 1 1
&A
Page &P
Examples:
Note: Storage Area 3 sends groups (or bundles or batches) of 4 objects to End Area 2. Such a group is then considered to be a single object.
Return to Buffers

Decision Point Rules

1
Name ® DP
Output
destination(s) ¯ Percent ¯
Buffer 1 10
Work Station 1 30
Exit 2 60
&A
Page &P
Example:
Note: The numbers in the percent column must sum to 100.
Return to Decision Points

Custom Schedules

Custom Schedules
A Custom Schedule can have at most 1,000 arrivals/departures
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Times ¯ Quantity arriving/departing ¯ Times ¯ Quantity arriving/departing ¯ Times ¯ Quantity arriving/departing ¯ Times ¯ Quantity arriving/departing ¯ Times ¯ Quantity arriving/departing ¯ Times ¯ Quantity arriving/departing ¯ Times ¯ Quantity arriving/departing ¯ Times ¯ Quantity arriving/departing ¯ Times ¯ Quantity arriving/departing ¯ Times ¯ Quantity arriving/departing ¯ Times ¯ Quantity arriving/departing ¯ Times ¯ Quantity arriving/departing ¯ Times ¯ Quantity arriving/departing ¯ Times ¯ Quantity arriving/departing ¯ Times ¯ Quantity arriving/departing ¯ Times ¯ Quantity arriving/departing ¯ Times ¯ Quantity arriving/departing ¯ Times ¯ Quantity arriving/departing ¯ Times ¯ Quantity arriving/departing ¯ Times ¯ Quantity arriving/departing ¯
&A
Page &P
Return to Control Panel
Return to Other Features

Resources

Resources
Name ¯ Number available ¯
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
&A
Page &P
Return to Control Panel
Return to Other Features

Results

Simulation Results
Element Element Statistics Overall Simulation Numbers
types names means 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
Work Station(s) Delivery Final status NA Not Working Not Working Working Not Working Not Working Working Working Not Working Working Working Not Working Not Working Not Working Not Working Not Working Not Working Not Working Not Working Working Not Working Not Working Not Working Not Working Not Working Working Not Working Not Working Working Not Working Not Working
Final inventory (int. buff.) 13.47 26 21 0 9 14 0 0 16 0 0 13 11 7 4 30 49 18 18 0 19 27 24 19 41 0 5 11 0 8 14
Mean inventory (int. buff.) 17.84 17.86 18.65 16.47 18.12 17.43 16.00 17.42 16.27 17.30 17.12 17.55 18.43 17.42 17.97 19.80 16.09 18.07 18.37 18.57 19.17 19.53 21.42 16.80 16.79 18.35 16.86 17.52 16.56 18.78 18.40
Mean cycle time (int. buff.) 36.85 39.12 40.12 32.93 37.36 36.56 32.01 34.85 34.37 34.60 34.24 36.69 38.26 35.67 36.42 44.00 29.61 38.45 39.08 37.14 40.93 42.91 46.56 35.87 30.17 36.71 34.30 36.37 33.12 38.58 38.59
Work cycles started 4.33 4 4 5 4 4 5 5 4 5 5 4 4 4 4 4 5 4 4 5 4 4 4 4 5 5 4 4 5 4 4
Fraction time working 0.34 0.34 0.34 0.34 0.34 0.34 0.36 0.36 0.35 0.37 0.36 0.34 0.33 0.33 0.35 0.32 0.39 0.34 0.32 0.33 0.33 0.33 0.32 0.34 0.40 0.34 0.35 0.35 0.33 0.33 0.33
Fraction time blocked 0.66 0.66 0.66 0.66 0.66 0.66 0.64 0.64 0.65 0.63 0.64 0.66 0.67 0.67 0.65 0.68 0.61 0.66 0.68 0.67 0.67 0.67 0.68 0.66 0.60 0.66 0.65 0.65 0.67 0.67 0.67
Buffer(s) Factory Objects leaving 325.00 300 300 375 300 300 375 375 300 375 375 300 300 300 300 300 375 300 300 375 300 300 300 300 375 375 300 300 375 300 300
Final inventory 675.00 700 700 625 700 700 625 625 700 625 625 700 700 700 700 700 625 700 700 625 700 700 700 700 625 625 700 700 625 700 700
Minimum inventory 675.00 700 700 625 700 700 625 625 700 625 625 700 700 700 700 700 625 700 700 625 700 700 700 700 625 625 700 700 625 700 700
Maximum inventory 1000.00 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000
Mean inventory 813.95 824.43 819.50 817.11 820.58 819.10 812.18 812.36 825.54 804.28 807.25 815.12 809.44 808.72 814.04 830.80 788.11 820.12 821.61 809.38 818.49 816.46 821.50 818.13 791.46 807.59 813.15 821.07 805.85 802.32 822.90
Mean cycle time 1520.50 1648.86 1639.00 1307.38 1641.17 1638.19 1299.48 1299.78 1651.07 1286.84 1291.60 1630.24 1618.88 1617.45 1628.08 1661.60 1260.98 1640.23 1643.23 1295.00 1636.99 1632.92 1643.00 1636.26 1266.34 1292.15 1626.29 1642.15 1289.35 1604.63 1645.81
Reorder Point Objects leaving 293.23 274 279 302 291 286 314 313 284 308 306 287 289 293 296 270 326 282 282 303 281 273 276 281 334 302 295 289 303 292 286
Final inventory 23.30 25 25 23 25 25 11 12 25 17 19 25 25 25 25 25 25 25 25 22 25 25 25 25 25 23 25 25 22 25 25
Minimum inventory 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Maximum inventory 25.00 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25 25
Mean inventory 20.84 21.27 21.26 20.52 20.75 21.09 20.69 20.43 20.69 20.18 20.99 20.28 20.20 20.83 20.41 21.33 20.27 20.32 20.78 21.21 21.57 21.07 21.71 20.20 20.11 21.60 20.83 21.20 20.63 21.30 21.56
Mean cycle time 42.78 46.57 45.73 40.77 42.77 44.24 39.53 39.16 43.72 39.32 41.16 42.39 41.94 42.66 41.36 47.40 37.30 43.24 44.22 41.99 46.06 46.30 47.21 43.13 36.12 42.90 42.36 44.01 40.84 43.76 45.23
Exit(s) Purchase Requests Objects leaving process 293.23 274 279 302 291 286 314 313 284 308 306 287 289 293 296 270 326 282 282 303 281 273 276 281 334 302 295 289 303 292 286
Object departures missed 9.37 2 0 10 4 6 8 15 12 12 7 18 19 12 19 13 8 19 16 9 3 8 10 13 3 4 15 0 12 3 1
Service level 0.97 0.99 1.00 0.97 0.99 0.98 0.98 0.95 0.96 0.96 0.98 0.94 0.94 0.96 0.94 0.95 0.98 0.94 0.95 0.97 0.99 0.97 0.97 0.96 0.99 0.99 0.95 1.00 0.96 0.99 1.00
&A
Page &P
Return to Control Panel

Solution

Inputs Results
Order size: 75 Order size ROP Service level Mean number of orders Total mean inventory Total cost
Outputs: 0.97 4.33 38.68 ?
ROP: 25 35 25 0.94 8.65 18.86 ?
45 25 0.97 6.80 24.13 1403.82
Ordering cost: 100 55 25 0.96 6.00 28.06 ?
65 25 0.98 5.00 33.40 1501.87
Holding cost: 0.5 75 25 0.97 4.30 39.09 ?
Note: The "# of output objects" for Delivery and the "Output group size" for Factory are linked to cell C5 above; the "Capacity" and "Initial # objects" of Reorder Point are linked to cell C7 above. Thus to run the various scenarios you only need to update the values in cells C5 and C7 above and then read the solution from Outputs.

ModWriteResults

R1
Purchase Requests
FG4
FG3
FG2
FG1
B3
B2
B1
&A
Page &P

ModMainProgram

Element Index Element Name Element Type Table Column Priority Original Index
1 Delivery Work Station 4 50 1
2 Factory Buffer 3 50 2
3 Reorder Point Buffer 6 50 3
4 Purchase Requests Exit 3 50 4
5 5
6 6
7 7
8 8
9 9
10 10
11 11
12 12
13 13
14 14
15 15
16 16
17 17
18 18
19 19
20 20
21 21
22 22
23 23
24 24
25 25
26 26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
&A
Page &P

ModSimulation

Resource Index Name ¯ Number available ¯ Original Index
1 1
2 2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
&A
Page &P