{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["PDFPlot","OverTime"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":0,"defined_names":60,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"PDFPlot","index":0,"n_rows":104,"n_cols":2,"rows_kept":104,"cut":false,"hidden":true,"merged":[]}
["x","Probability density function"]
[-4196.64599609375,0]
[-4196.64599609375,0]
[-3951.841552734375,0]
[-3707.037353515625,0]
[-3462.23291015625,0]
[-3217.428466796875,0]
[-2972.624267578125,0]
[-2727.81982421875,0]
[-2483.015380859375,0]
[-2238.211181640625,0]
[-1993.40673828125,0]
[-1748.6024169921875,0]
[-1503.798095703125,0]
[-1258.99365234375,0]
[-1014.1893310546875,0]
[-769.385009765625,0]
[-524.58062744140625,0]
[-279.77627563476563,0]
[-34.971912384033203,0.86563128232955933]
[209.83244323730469,4.0000006556510925E-3]
[454.63681030273438,3.7000004667788744E-3]
[699.441162109375,3.8000005297362804E-3]
[944.24554443359375,4.5999996364116669E-3]
[1189.0499267578125,3.7000004667788744E-3]
[1433.854248046875,3.4000002779066563E-3]
[1678.6585693359375,3.1000000890344381E-3]
[1923.462890625,3.8000005297362804E-3]
[2168.267333984375,4.1000004857778549E-3]
[2413.07177734375,2.899999963119626E-3]
[2657.8759765625,3.3000002149492502E-3]
[2902.680419921875,3.8000005297362804E-3]
[3147.48486328125,3.5000003408640623E-3]
[3392.2890625,2.79999990016222E-3]
[3637.093505859375,3.0000000260770321E-3]
[3881.897705078125,2.699999837204814E-3]
[4126.7021484375,1.8999994499608874E-3]
[4371.50634765625,3.5000003408640623E-3]
[4616.31103515625,2.3999996483325958E-3]
[4861.115234375,2.699999837204814E-3]
[5105.91943359375,2.3999996483325958E-3]
[5350.72412109375,2.899999963119626E-3]
[5595.5283203125,2.3999996483325958E-3]
[5840.33251953125,1.5999996103346348E-3]
[6085.13720703125,1.699999556876719E-3]
[6329.94140625,3.0000000260770321E-3]
[6574.74560546875,1.9999993965029716E-3]
[6819.55029296875,1.8999994499608874E-3]
[7064.3544921875,2.699999837204814E-3]
[7309.15869140625,1.2999997707083821E-3]
[7553.96337890625,1.699999556876719E-3]
[7798.767578125,2.2999995853751898E-3]
[8043.57177734375,1.4999996637925506E-3]
[8288.3759765625,1.699999556876719E-3]
[8533.1806640625,1.3999997172504663E-3]
[8777.9853515625,7.9999997979030013E-4]
[9022.7890625,1.699999556876719E-3]
[9267.59375,1.3999997172504663E-3]
[9512.3984375,2.1999995224177837E-3]
[9757.2021484375,1.1999998241662979E-3]
[10002.0068359375,1.3999997172504663E-3]
[10246.8115234375,1.2999997707083821E-3]
[10491.615234375,1.1999998241662979E-3]
[10736.419921875,6.99999975040555E-4]
[10981.224609375,1.4999996637925506E-3]
[11226.0283203125,1.1999998241662979E-3]
[11470.8330078125,1.2999997707083821E-3]
[11715.6376953125,3.9999998989515007E-4]
[11960.44140625,8.9999998454004526E-4]
[12205.24609375,1.1999998241662979E-3]
[12450.05078125,9.9999993108212948E-4]
[12694.8544921875,7.9999997979030013E-4]
[12939.6591796875,2.9999998514540493E-4]
[13184.4638671875,3.9999998989515007E-4]
[13429.267578125,8.9999998454004526E-4]
[13674.072265625,9.9999993108212948E-4]
[13918.876953125,7.9999997979030013E-4]
[14163.6806640625,3.9999998989515007E-4]
[14408.4853515625,2.9999998514540493E-4]
[14653.2900390625,6.99999975040555E-4]
[14898.09375,6.99999975040555E-4]
[15142.8984375,2.9999998514540493E-4]
[15387.703125,6.99999975040555E-4]
[15632.5068359375,9.9999997473787516E-5]
[15877.3115234375,3.9999998989515007E-4]
[16122.115234375,6.99999975040555E-4]
[16366.919921875,2.9999998514540493E-4]
[16611.724609375,3.9999998989515007E-4]
[16856.529296875,9.9999997473787516E-5]
[17101.333984375,3.9999998989515007E-4]
[17346.13671875,8.9999998454004526E-4]
[17590.94140625,4.9999996554106474E-4]
[17835.74609375,1.9999999494757503E-4]
[18080.55078125,2.9999998514540493E-4]
[18325.35546875,3.9999998989515007E-4]
[18570.16015625,1.9999999494757503E-4]
[18814.962890625,4.9999996554106474E-4]
[19059.767578125,2.9999998514540493E-4]
[19304.572265625,2.9999998514540493E-4]
[19549.376953125,3.9999998989515007E-4]
[19794.181640625,2.9999998514540493E-4]
[20038.986328125,2.9999998514540493E-4]
[20283.7890625,1.9999999494757503E-4]
[25179.876953125,5.9999997029080987E-4]

{"sheet":"OverTime","index":1,"n_rows":33,"n_cols":14,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Parameter","Value"]
["DD",30]
["C_OT",1000,null,"p","mu(p)","Integrand","C_OT","C_PD","C_Total",null,{"$f":"D3","v":"p"},{"$f":"G3","v":"C_OT"},{"$f":"H3","v":"C_PD"},{"$f":"I3","v":"C_Total"}]
["C_PD",10000,null,0,{"$f":"mu_0/(1+0.01*D4)","v":29.375},{"$f":"CONCATENATE(\"(x-DD)*pdfnormal(x,\",ShowstringValue(E4),\",sigma)\")","v":"(x-DD)*pdfnormal(x, 29.375,sigma)"},{"$f":"C_OT*D4","v":0},{"$f":"numint(F4,DD,DD+sigma*5)*C_PD","v":21587.958335876465},{"$f":"G4+H4","v":21587.958335876465},null,{"$f":"D4","v":0},{"$f":"G4","v":0},{"$f":"H4","v":21587.958335876465},{"$f":"I4","v":21587.958335876465}]
["Datapoints",25,null,{"$f":"D4+1","v":1},{"$f":"mu_0/(1+0.01*D5)","v":29.084158415841586},{"$f":"CONCATENATE(\"(x-DD)*pdfnormal(x,\",ShowstringValue(E5),\",sigma)\")","v":"(x-DD)*pdfnormal(x, 29.0841584158416,sigma)"},{"$f":"C_OT*D5","v":1000},20278.415679931641,{"$f":"G5+H5","v":21278.415679931641},null,1,1000,20278.415679931641,21278.415679931641]
[null,35,null,{"$f":"D5+1","v":2},28.799019607843135,{"$f":"CONCATENATE(\"(x-DD)*pdfnormal(x,\",ShowstringValue(E6),\",sigma)\")","v":"(x-DD)*pdfnormal(x, 28.7990196078431,sigma)"},2000,19047.112464904785,21047.112464904785,null,2,2000,19047.112464904785,21047.112464904785]
[null,28,null,3,28.519417475728154,{"$f":"CONCATENATE(\"(x-DD)*pdfnormal(x,\",ShowstringValue(E7),\",sigma)\")","v":"(x-DD)*pdfnormal(x, 28.5194174757282,sigma)"},3000,17889.860868453979,20889.860868453979,null,3,3000,17889.860868453979,20889.860868453979]
[null,41,null,4,28.245192307692307,{"$f":"CONCATENATE(\"(x-DD)*pdfnormal(x,\",ShowstringValue(E8),\",sigma)\")","v":"(x-DD)*pdfnormal(x, 28.2451923076923,sigma)"},4000,16802.613735198975,20802.613735198975,null,4,4000,16802.613735198975,20802.613735198975]
[null,22,null,5,27.976190476190474,"(x-DD)*pdfnormal(x, 27.9761904761905,sigma)",5000,15781.491994857788,20781.491994857788,null,5,5000,15781.491994857788,20781.491994857788]
[null,31,null,6,27.712264150943394,"(x-DD)*pdfnormal(x, 27.7122641509434,sigma)",6000,14822.769165039063,20822.769165039063,null,6,6000,14822.769165039063,20822.769165039063]
[null,28,null,7,27.453271028037381,"(x-DD)*pdfnormal(x, 27.4532710280374,sigma)",7000,13922.876119613647,20922.876119613647,null,7,7000,13922.876119613647,20922.876119613647]
[null,25,null,8,27.199074074074073,"(x-DD)*pdfnormal(x, 27.1990740740741,sigma)",8000,13078.410625457764,21078.410625457764,null,8,8000,13078.410625457764,21078.410625457764]
["muHat",{"$f":"AVERAGE(B5:B12)","v":29.375},null,9,26.949541284403669,"(x-DD)*pdfnormal(x, 26.9495412844037,sigma)",9000,12286.132574081421,21286.132574081421,null,9,9000,12286.132574081421,21286.132574081421]
["sigmaHat",{"$f":"STDEV(B5:B12)","v":6.1629654272227468},null,10,26.704545454545453,"(x-DD)*pdfnormal(x, 26.7045454545455,sigma)",10000,11542.95802116394,21542.95802116394,null,10,10000,11542.95802116394,21542.95802116394]
["mu_0",{"$f":"muHat","v":29.375},null,11,26.463963963963963,"(x-DD)*pdfnormal(x, 26.463963963964,sigma)",11000,10845.943689346313,21845.943689346313,null,11,11000,10845.943689346313,21845.943689346313]
["sigma",{"$f":"sigmaHat","v":6.1629654272227468},null,12,26.227678571428569,"(x-DD)*pdfnormal(x, 26.2276785714286,sigma)",12000,10192.312002182007,22192.312002182007,null,12,12000,10192.312002182007,22192.312002182007]
[null,null,null,13,25.995575221238941,"(x-DD)*pdfnormal(x, 25.9955752212389,sigma)",13000,9579.4260501861572,22579.426050186157,null,13,13000,9579.4260501861572,22579.426050186157]
[null,null,null,14,25.76754385964912,"(x-DD)*pdfnormal(x, 25.7675438596491,sigma)",14000,9004.7937631607056,23004.793763160706,null,14,14000,9004.7937631607056,23004.793763160706]
[null,null,null,null,null,null,null,"Min=",{"$f":"MIN(I4:I18)","v":20781.491994857788},null,null,null,null,20781.491994857788]
[]
["Solver solution:"]
[]
["Parameter","Value"]
["p",4.8388593260537638,null,null,null,"The B(r;mu;sigma) function is implemented in VBA in the BackorderLib module:"]
["mu",{"$f":"mu_0/(1+0.01*p)","v":28.019190774140696}]
["C__OT",{"$f":"C_OT*p","v":4838.8593260537637}]
["C__PT",{"$f":"C_PD*B(DD,mu,sigma)","v":15941.722445790563}]
["C__Total",{"$f":"C__OT+C__PT","v":20780.581771844329},null,null,null,"where"]
[]
[]
[]
[]
[null,null,null,null,null,"and D is N(mu,sigma^2)"]