gmg2/4000/excel/EO… · XLS file · Web view · 2005-01-18EPQ EOQ EOQ Calculator with backorders...
32
EOQ Calculator K 2 c 5 h 1 λ 100 opt. order interva 0.20 opt. order quantit 20.00 opt. average cost $20.00 Order Quantity Holding CostSetup Cost 5 2.50 40.00 10 5.00 20.00 15 7.50 13.33 20 10.00 10.00 25 12.50 8.00 30 15.00 6.67 35 17.50 5.71 40 20.00 5.00 45 22.50 4.44 50 25.00 4.00 55 27.50 3.64 60 30.00 3.33 65 32.50 3.08 70 35.00 2.86 75 37.50 2.67 80 40.00 2.50 85 42.50 2.35 90 45.00 2.22 Anual Cost $
Transcript of gmg2/4000/excel/EO… · XLS file · Web view · 2005-01-18EPQ EOQ EOQ Calculator with backorders...
EOQ Calculator
K 2c 5h 1λ 100
opt. order interval 0.20opt. order quantity 20.00
opt. average cost $20.00
Order Quantity Holding Cost Setup Cost5 2.50 40.00
10 5.00 20.0015 7.50 13.3320 10.00 10.0025 12.50 8.0030 15.00 6.6735 17.50 5.7140 20.00 5.0045 22.50 4.4450 25.00 4.0055 27.50 3.6460 30.00 3.3365 32.50 3.0870 35.00 2.8675 37.50 2.6780 40.00 2.5085 42.50 2.3590 45.00 2.2295 47.50 2.11
100 50.00 2.00
0 10 20 30 40 50 60 70 80 900.005.00
10.0015.0020.0025.0030.0035.0040.0045.00
Total Average Inventory Cost
Holding CostSetup CostTotal
Order Quantity (Q)
Anua
l Cos
t $
105 52.50 1.90110 55.00 1.82115 57.50 1.74120 60.00 1.67125 62.50 1.60130 65.00 1.54135 67.50 1.48140 70.00 1.43145 72.50 1.38150 75.00 1.33155 77.50 1.29160 80.00 1.25165 82.50 1.21170 85.00 1.18175 87.50 1.14180 90.00 1.11185 92.50 1.08190 95.00 1.05195 97.50 1.03200 100.00 1.00205 102.50 0.98210 105.00 0.95215 107.50 0.93220 110.00 0.91225 112.50 0.89230 115.00 0.87235 117.50 0.85240 120.00 0.83245 122.50 0.82250 125.00 0.80
255 127.50 0.78260 130.00 0.77265 132.50 0.75270 135.00 0.74275 137.50 0.73280 140.00 0.71285 142.50 0.70290 145.00 0.69295 147.50 0.68300 150.00 0.67
Total42.5025.0020.8320.0020.5021.6723.2125.0026.9429.0031.1433.3335.5837.8640.1742.5044.8547.2249.6152.00
0 10 20 30 40 50 60 70 80 900.005.00
10.0015.0020.0025.0030.0035.0040.0045.00
Total Average Inventory Cost
Holding CostSetup CostTotal
Order Quantity (Q)
Anua
l Cos
t $
54.4056.8259.2461.6764.1066.5468.9871.4373.8876.3378.7981.2583.7186.1888.6491.1193.5896.0598.53
101.00103.48105.95108.43110.91113.39115.87118.35120.83123.32125.80
128.28130.77133.25135.74138.23140.71143.20145.69148.18150.67
EPQ Calculator
K 2c 5h 1λ 100μ 100000
opt. order interval 0.20opt. order quantity 20.01
opt. average cost $19.99
Order Quantity Holding Cost Setup Cost5 2.50 40.00
10 5.00 20.0015 7.49 13.3320 9.99 10.0025 12.49 8.0030 14.99 6.6735 17.48 5.7140 19.98 5.0045 22.48 4.4450 24.98 4.0055 27.47 3.6460 29.97 3.3365 32.47 3.0870 34.97 2.8675 37.46 2.6780 39.96 2.5085 42.46 2.35
0 10 20 30 40 50 60 70 80 900.005.00
10.0015.0020.0025.0030.0035.0040.0045.00
Total Average Inventory Cost
Holding CostSetup CostTotal
Order Quantity (Q)
Anua
l Cos
t $
90 44.96 2.2295 47.45 2.11
100 49.95 2.00105 52.45 1.90110 54.95 1.82115 57.44 1.74120 59.94 1.67125 62.44 1.60130 64.94 1.54135 67.43 1.48140 69.93 1.43145 72.43 1.38150 74.93 1.33155 77.42 1.29160 79.92 1.25165 82.42 1.21170 84.92 1.18175 87.41 1.14180 89.91 1.11185 92.41 1.08190 94.91 1.05195 97.40 1.03200 99.90 1.00205 102.40 0.98210 104.90 0.95215 107.39 0.93220 109.89 0.91
225 112.39 0.89230 114.89 0.87235 117.38 0.85240 119.88 0.83245 122.38 0.82250 124.88 0.80255 127.37 0.78260 129.87 0.77265 132.37 0.75270 134.87 0.74275 137.36 0.73280 139.86 0.71285 142.36 0.70290 144.86 0.69295 147.35 0.68300 149.85 0.67
Total42.5025.0020.8319.9920.4921.6523.2024.9826.9228.9831.1133.3035.5437.8240.1342.4644.81
0 10 20 30 40 50 60 70 80 900.005.00
10.0015.0020.0025.0030.0035.0040.0045.00
Total Average Inventory Cost
Holding CostSetup CostTotal
Order Quantity (Q)
Anua
l Cos
t $
47.1849.5651.9554.3556.7659.1861.6164.0466.4768.9171.3673.8176.2678.7181.1783.6386.0988.5691.0293.4995.9698.43
100.90103.37105.85108.32110.80
113.28115.75118.23120.71123.19125.68128.16130.64133.12135.61138.09140.57143.06145.54148.03150.52
EOQ Calculator with backorders
K 2c 5h 1b 9λ 100
optimal order interval 0.190optimal average cost $18.97optimal order quantity 20.00
backorder (b) optimal average cost ($)
5 346.416 361.817 374.178 384.319 392.79
10 400.0011 406.2012 411.6013 416.3314 420.5315 424.2616 427.6217 430.6418 433.3919 435.8920 438.1821 440.2822 442.22
0 5 10 15 20 25 30 35 40 45 50 55340
360
380
400
420
440
460
480
Backorder vs. Cost
Backorder (b)
Cos
t ($)
23 444.0124 445.6725 447.2126 448.6527 450.0028 451.2629 452.4430 453.5631 454.6132 455.6033 456.5334 457.4235 458.2636 459.0637 459.8138 460.5439 461.2240 461.8841 462.5142 463.1143 463.6844 464.2345 464.7646 465.2647 465.7548 466.2249 466.6750 467.10
0 5 10 15 20 25 30 35 40 45 50 55340
360
380
400
420
440
460
480
Backorder vs. Cost
Backorder (b)
Cos
t ($)
0 5 10 15 20 25 30 35 40 45 50 55340
360
380
400
420
440
460
480
Backorder vs. Cost
Backorder (b)
Cos
t ($)
0 5 10 15 20 25 30 35 40 45 50 55340
360
380
400
420
440
460
480
Backorder vs. Cost
Backorder (b)
Cos
t ($)
0 5 10 15 20 25 30 35 40 45 50 55340
360
380
400
420
440
460
480
Backorder vs. Cost
Backorder (b)
Cos
t ($)
0 5 10 15 20 25 30 35 40 45 50 55340
360
380
400
420
440
460
480
Backorder vs. Cost
Backorder (b)
Cos
t ($)
EOQ Calculator with backorders
K 2c 5h 1b 9λ 100μ 1000
optimal order interval 0.222optimal average cost $18.00optimal order quantity 20.00
backorder (b) optimal average cost ($)
5 346.416 361.817 374.178 384.319 392.79
10 400.0011 406.2012 411.6013 416.3314 420.5315 424.2616 427.6217 430.6418 433.39
0 5 10 15 20 25 30 35 40 45 50 55340
360
380
400
420
440
460
480
Backorder vs. Cost
Backorder (b)
Cos
t ($)
19 435.8920 438.1821 440.2822 442.2223 444.0124 445.6725 447.2126 448.6527 450.0028 451.2629 452.4430 453.5631 454.6132 455.6033 456.5334 457.4235 458.2636 459.0637 459.8138 460.5439 461.2240 461.8841 462.5142 463.1143 463.6844 464.2345 464.7646 465.2647 465.7548 466.2249 466.6750 467.10
0 5 10 15 20 25 30 35 40 45 50 55340
360
380
400
420
440
460
480
Backorder vs. Cost
Backorder (b)
Cos
t ($)
0 5 10 15 20 25 30 35 40 45 50 55340
360
380
400
420
440
460
480
Backorder vs. Cost
Backorder (b)
Cos
t ($)
0 5 10 15 20 25 30 35 40 45 50 55340
360
380
400
420
440
460
480
Backorder vs. Cost
Backorder (b)
Cos
t ($)
0 5 10 15 20 25 30 35 40 45 50 55340
360
380
400
420
440
460
480
Backorder vs. Cost
Backorder (b)
Cos
t ($)
0 5 10 15 20 25 30 35 40 45 50 55340
360
380
400
420
440
460
480
Backorder vs. Cost
Backorder (b)
Cos
t ($)
Reducing Setup Costs
K Average Cost Cost Reduction
100 $141.3590 $134.10 $7.2580 $126.43 $7.6770 $118.26 $8.1760 $109.49 $8.7750 $99.95 $9.5440 $89.40 $10.5530 $77.42 $11.9820 $63.21 $14.2110 $44.70 $18.512 $19.99 $24.71
0 20 40 60 80 100 120$0.00
$20.00
$40.00
$60.00
$80.00
$100.00
$120.00
$140.00
$160.00
Setup Cost vs. Average Cost
Setup Cost (K)
Cos
t
0 20 40 60 80 100 120$0.00
$20.00
$40.00
$60.00
$80.00
$100.00
$120.00
$140.00
$160.00
Setup Cost vs. Average Cost
Setup Cost (K)
Cos
t
Sensitivity Analysis
T a(T) a(T)/a(T^*)
0.05 $42.50 2.1259379690.10 $25.00 1.2503751880.15 $20.83 1.0418125730.20 $19.99 10.25 $20.49 1.0248874440.30 $21.65 1.0831248960.35 $23.20 1.1604194950.40 $24.98 1.2496248120.45 $26.92 1.3467706080.50 $28.98 1.4494747370.55 $31.11 1.5562212920.60 $33.30 1.6659996660.65 $35.54 1.7781102090.70 $37.82 1.8920531690.75 $40.13 2.0074620640.80 $42.46 2.1240620310.85 $44.81 2.241642880.90 $47.18 2.3600411320.95 $49.56 2.4791277221.00 $51.95 2.59879941.05 $54.35 2.7189725821.10 $56.76 2.839578881.15 $59.18 2.9605618031.20 $61.61 3.081874271.25 $64.04 3.203476738
1.30 $66.47 3.3253357451.35 $68.91 3.4474227851.40 $71.36 3.5697134281.45 $73.81 3.6921866111.50 $76.26 3.814824079
0.00 0.20 0.40 0.60 0.80 1.00 1.20 1.40 1.600%
100%
200%
300%
400%
Sensitivity Analysis
a(T)
T
a(T)
0.00 0.20 0.40 0.60 0.80 1.00 1.20 1.40 1.600%
100%
200%
300%
400%
Sensitivity Analysis
a(T)
T
a(T)
0.00 0.20 0.40 0.60 0.80 1.00 1.20 1.40 1.600%
100%
200%
300%
400%
Sensitivity Analysis
a(T)
T
a(T)
![[XLS]pefni.files.wordpress.com · Web view100 MG/TAB SOLU.TAB KUVAN A16AX07 SAPROPTERIN DIHYDROCHLORIDE Από του στόματος χορήγηση (υγρές ή ημιστερεές](https://static.fdocument.org/doc/165x107/5b02786a7f8b9af1148fbdb1/xlspefnifiles-view100-mgtab-solutab-kuvan-a16ax07-sapropterin-dihydrochloride.jpg)
