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
A B C D E F G H I J
Basic EOQ Model (Solver Version)
Data Results Range Name Cell
D = 676 (demand/year) Reorder Point 6.5 AnnualHoldingCost G7
K = $75 (setup cost) AnnualSetupCost G6
h = $600 (unit holding cost) Annual Setup Cost $10,140 DC4
L = 3.5 (lead time in days) Annual Holding Cost $1,500 hC6
WD = 365 (working days/year) Total Variable Cost $11,640 KC5
LC7
Decision Q C11
Q = 5 ReorderPoint G4
TotalVariableCost G8
WD C8
Annual Annual Total
Setup Holding Variable
Q Cost Cost Cost
$10,140.00 $1,500.00 $11,640.00
5$10,140.00 $1,500.00 $11,640.00
7$7,242.86 $2,100.00 $9,342.86
9$5,633.33 $2,700.00 $8,333.33
11 $4,609.09 $3,300.00 $7,909.09
13 $3,900.00 $3,900.00 $7,800.00
15 $3,380.00 $4,500.00 $7,880.00
17 $2,982.35 $5,100.00 $8,082.35
19 $2,668.42 $5,700.00 $8,368.42
21 $2,414.29 $6,300.00 $8,714.29
23 $2,204.35 $6,900.00 $9,104.35
25 $2,028.00 $7,500.00 $9,528.00
1
2
3
4
5
6
7
8
9
10
11
12
13
A B C D E F G H I J
Basic EOQ Model (Solver Version)
Data Results Range Name Cell
D = 676 (demand/year) Reorder Point 6.5 AnnualHoldingCost G7
K = $75 (setup cost) AnnualSetupCost G6
h = $600 (unit holding cost) Annual Setup Cost $3,900 DC4
L = 3.5 (lead time in days) Annual Holding Cost $3,900 hC6
WD = 365 (working days/year) Total Variable Cost $7,800 KC5
LC7
Decision Q C11
Q = 13 ReorderPoint G4
TotalVariableCost G8
WD C8
1
2
3
4
5
6
7
8
9
10
11
12
13
A B C D E F G H I J
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
434,000 $3,000 $2,040 $5,040
542,500 $2,400 $2,550 $4,950
A B C D E F G H I J
Basic EOQ Model (Solver Version)
Data Results Range Name Cell
D = 102,000 (demand/year) Reorder Point 0 AnnualHoldingCost G7
K = $1,000 (setup cost) AnnualSetupCost G6
h = $0.12 (unit holding cost) Annual Setup Cost $12,000 DC4
L = 0 (lead time in days) Annual Holding Cost $510 hC6
WD = 365 (working days/year) Total Variable Cost $12,510 KC5
LC7
Decision Q C11
Q = 8,500 ReorderPoint G4
TotalVariableCost G8
WD C8
Annual Annual Total
Setup Holding Variable
Months Q Cost Cost Cost
$12,000 $510 $12,510
18,500 $12,000 $510 $12,510
217,000 $6,000 $1,020 $7,020
325,500 $4,000 $1,530 $5,530
1
2
3
4
5
6
7
8
9
10
11
12
13
A B C D E F G H I J
Basic EOQ Model (Solver Version)
Data Results Range Name Cell
D = 102,000 (demand/year) Reorder Point 0 AnnualHoldingCost G7
K = $1,000 (setup cost) AnnualSetupCost G6
h = $0.12 (unit holding cost) Annual Setup Cost $2,474 DC4
L = 0 (lead time in days) Annual Holding Cost $2,474 hC6
WD = 365 (working days/year) Total Variable Cost $4,948 KC5
LC7
Decision Q C11
Q = 41,231 ReorderPoint G4
TotalVariableCost G8
WD C8
1
2
3
4
5
6
7
8
9
10
11
12
13
A B C D E F G H I J
Basic EOQ Model (Analytical Version)
Data Results Range Name Cell
D = 102,000 (demand/year) Reorder Point 0 AnnualHoldingCost G7
K = $1,000 (setup cost) AnnualSetupCost G6
h = $0.12 (unit holding cost) Annual Setup Cost $2,474 DC4
L = 0 (lead time in days) Annual Holding Cost $2,474 hC6
WD = 365 (working days/year) Total Variable Cost $4,948 KC5
LC7
Decision Q C11
Q = 41231 (optimal order quantity) ReorderPoint G4
TotalVariableCost G8
WD C8
1
2
3
4
5
6
7
8
9
10
11
12
13
A B C D E F G H I J
1
2
3
4
5
6
7
8
9
10
11
12
13
A B C D E F G H I J
1
2
3
4
5
6
7
8
9
10
11
12
13
A B C D E F G H I J
Basic EOQ Model (Solver Version)
Data Results Range Name Cell
D = 10,400 (demand/year) Reorder Point 100 AnnualHoldingCost G7
K = $20 (setup cost) AnnualSetupCost G6
h = $0.15 (unit holding cost) Annual Setup Cost $144 DC4
L = 2.5 (lead time in days) Annual Holding Cost $108 hC6
WD = 260 (working days/year) Total Variable Cost $252 KC5
LC7
Decision Q C11
Q = 1,442 ReorderPoint G4
TotalVariableCost G8
WD C8
1
2
3
4
5
6
7
8
9
10
11
12
13
A B C D E F G H I J
1
2
3
4
5
6
7
8
9
10
11
12
13
A B C D E F G H I J
Basic EOQ Model (Solver Version)
Data Results Range Name Cell
D = 10,400 (demand/year) Reorder Point 100 AnnualHoldingCost G7
K = $20 (setup cost) AnnualSetupCost G6
h = $0.25 (unit holding cost) Annual Setup Cost $144 DC4
L = 2.5 (lead time in days) Annual Holding Cost $180 hC6
WD = 260 (working days/year) Total Variable Cost $324 KC5
LC7
Decision Q C11
Q = 1,442 ReorderPoint G4
TotalVariableCost G8
WD C8
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
A B C D E F G H I J
Basic EOQ Model (Analytical Version)
Data Results Range Name Cell
D = 10,400 (demand/year) Reorder Point 100 AnnualHoldingCost G7
K = $20 (setup cost) AnnualSetupCost G6
h = $0.20 (unit holding cost) Annual Setup Cost $144 DC4
L = 2.5 (lead time in days) Annual Holding Cost $144 hC6
WD = 260 (working days/year) Total Variable Cost $288 KC5
LC7
Decision Q C11
Q = 1,442 (optimal order quantity) ReorderPoint G4
TotalVariableCost G8
WD C8
Cost Unit Optimal
of Holding Order
Capital Cost Quantity
1,442
10% $0.15 1,665
12% $0.17 1,564
14% $0.19 1,480
16% $0.21 1,407
18% $0.23 1,345
20% $0.25 1,290
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
A B C D E F G H I J
Basic EOQ Model (Analytical Version)
Data Results Range Name Cell
D = 10,400 (demand/year) Reorder Point 100 AnnualHoldingCost G7
K = $20 (setup cost) AnnualSetupCost G6
h = $0.20 (unit holding cost) Annual Setup Cost $144 DC4
L = 2.5 (lead time in days) Annual Holding Cost $144 hC6
WD = 260 (working days/year) Total Variable Cost $288 KC5
LC7
Decision Q C11
Q = 1,442 (optimal order quantity) ReorderPoint G4
TotalVariableCost G8
WD C8
Hours Optimal
of Clerical Setup Order
Time Cost Quantity
1,442
0.5 $10 1,020
0.75 $15 1,249
1$20 1,442
1.25 $25 1,612
1.5 $30 1,766
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
A B C D E F G H I J
Basic EOQ Model (Analytical Version)
Data Results Range Name Cell
D = 10,400 (demand/year) Reorder Point 100 AnnualHoldingCost G7
K = $20 (setup cost) AnnualSetupCost G6
h = $0.20 (unit holding cost) Annual Setup Cost $144 DC4
L = 2.5 (lead time in days) Annual Holding Cost $144 hC6
WD = 260 (working days/year) Total Variable Cost $288 KC5
LC7
Decision Q C11
Q = 1,442 (optimal order quantity) ReorderPoint G4
TotalVariableCost G8
WD C8
Cost Unit Optimal Order Quantity (Q)
of Holding
Capital Cost 0.5 0.75 11.25 1.5 Clerical Hours
1442 $10 $15 $20 $25 $30 Setup Cost
10% $0.15 1,178 1,442 1,665 1,862 2,040
12% $0.17 1,106 1,355 1,564 1,749 1,916
14% $0.19 1,046 1,281 1,480 1,654 1,812
16% $0.21 995 1,219 1,407 1,574 1,724
18% $0.23 951 1,165 1,345 1,504 1,647
20% $0.25 912 1,117 1,290 1,442 1,580
1
2
3
4
5
6
7
8
9
10
11
12
13
14
16
23
28
35
A B C D E F G H I J
Basic EOQ Model (Analytical Version)
Data Results Range Name Cell
D = 6,000 (demand/year) Reorder Point 216 AnnualHoldingCost G7
K = $115 (setup cost) AnnualSetupCost G6
h = $4.20 (unit holding cost) Annual Setup Cost $1,204 DC4
L = 9 (lead time in days) Annual Holding Cost $1,204 hC6
WD = 250 (working days/year) Total Variable Cost $2,407 KC5
LC7
Decision Q C11
Q = 573 (optimal order quantity) ReorderPoint G4
TotalVariableCost G8
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
A B C D E F G H I J
Basic EOQ Model (Solver Version)
Data Results Range Name Cell
D = 6,000 (demand/year) Reorder Point 216
AnnualHolding
G7
K = $115 (setup cost)
AnnualSetupCos
G6
h = $4.20 (unit holding cost) Annual Setup Cost $1,204 DC4
L = 9 (lead time in days) Annual Holding Cost $1,203 hC6
WD = 250 (working days/year) Total Variable Cost $2,407 KC5
LC7
Decision Q C11
Q = 573 ReorderPoint G4
TotalVariableCos
G8
WD C8
Unit Holding Cost
$2,407 $3.15 $3.36 $3.78 $4.20 $4.62 $5.04 $5.25
$86.25 $1,806 $1,866 $1,986 $2,106 $2,227 $2,347 $2,407
$92.00 $1,866 $1,926 $2,046 $2,167 $2,287 $2,407 $2,467
Setup $103.50 $1,986 $2,046 $2,167 $2,287 $2,407 $2,528 $2,588
Cost $115.00 $2,107 $2,167 $2,287 $2,407 $2,528 $2,648 $2,708
1
2
3
4
5
6
7
8
9
10
11
12
13
A B C D E F G H I J