{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["separate","all-together","Sheet3"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":9,"comments":0,"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":"separate","index":0,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Lot Sizing with Multiple Products Ordered and Delivered Seperately"]
["Annual demand for A, RA =",null,null,240000]
["Annual demand for B, RB =",null,null,30000]
["Annual demand for C, RC =",null,null,10800]
["Product specific ordering cost, sA =",null,null,100]
["Product specific ordering cost, sB =",null,null,100]
["Product specific ordering cost, sC =",null,null,100]
["Unit Cost, CA =",null,null,5]
["Unit Cost, CB =",null,null,4]
["Unit Cost, CC =",null,null,5]
["Common order cost, S = ",null,null,400]
["Holding cost, h =",null,null,0.2]
[]
["Order each product independently"]
[null,"# orders/year","EOQ","Order Cost","Holding Cost","Total cost"]
["A",{"$f":"SQRT((D2*$D$12*D8)/(2*($D$11+D5)))","v":15.491933384829668},{"$f":"SQRT(2*D2*(D11+D5)/(D12*D8))","v":15491.933384829668},{"$f":"B16*($D$11+D5)","v":7745.9666924148341},{"$f":"(C16/2)*D8*$D$12","v":7745.9666924148351},{"$f":"D16+E16","v":15491.93338482967},null,null,{"$f":"SQRT((D2*$D$12*D8)/(2*($D$11+D5)))","v":15.491933384829668}]
["B",{"$f":"SQRT((D3*$D$12*D9)/(2*($D$11+D6)))","v":4.8989794855663558},{"$f":"SQRT(2*D3*(D11+D6)/(D12*D9))","v":6123.724356957945},{"$f":"B17*($D$11+D6)","v":2449.4897427831779},{"$f":"(C17/2)*D9*$D$12","v":2449.4897427831779},{"$f":"D17+E17","v":4898.9794855663558},null,null,{"$f":"SQRT((D3*$D$12*D9)/(2*($D$11+D6)))","v":4.8989794855663558}]
["C",{"$f":"SQRT((D4*$D$12*D10)/(2*($D$11+D7)))","v":3.2863353450309969},{"$f":"SQRT(2*D4*(D11+D7)/(D12*D10))","v":3286.3353450309969},{"$f":"B18*($D$11+D7)","v":1643.1676725154985},{"$f":"(C18/2)*D10*$D$12","v":1643.1676725154985},{"$f":"D18+E18","v":3286.3353450309969},null,null,{"$f":"SQRT((D4*$D$12*D10)/(2*($D$11+D7)))","v":3.2863353450309969}]
[null,null,null,null,null,{"$f":"SUM(F16:F18)","v":23677.248215427026}]
["Your Guess Total Cost",null,23677.248215427026]
["Optimal Solution Cost",null,{"$f":"F19","v":23677.248215427026}]
["Savings from Optimization",null,{"$f":"C20-C21","v":0}]

{"sheet":"all-together","index":1,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Lot Sizing with Multiple Products Ordered and Delivered Together"]
["Annual demand for A, RA =",null,null,{"$f":"separate!D2","v":240000}]
["Annual demand for B, RB =",null,null,{"$f":"separate!D3","v":30000}]
["Annual demand for C, RC =",null,null,{"$f":"separate!D4","v":10800}]
["Product specific ordering cost, sA =",null,null,{"$f":"separate!D5","v":100}]
["Product specific ordering cost, sB =",null,null,{"$f":"separate!D6","v":100}]
["Product specific ordering cost, sC =",null,null,{"$f":"separate!D7","v":100}]
["Unit Cost, CA =",null,null,{"$f":"separate!D8","v":5}]
["Unit Cost, CB =",null,null,{"$f":"separate!D9","v":4}]
["Unit Cost, CC =",null,null,{"$f":"separate!D10","v":5}]
["Common order cost, S = ",null,null,{"$f":"separate!D11","v":400}]
["Holding cost, h =",null,null,{"$f":"separate!D12","v":0.2}]
[]
["Order all products simultaneously "]
[null,"# orders/year","Order Size","Order Cost","Holding Cost","Total cost"]
["A",{"$f":"SQRT((D2*D12*D8+D3*D9*D12+D4*D10*D12)/(2*(D11+D7+D6+D5)))","v":14.01020036565196},{"$f":"D2/B16","v":17130.375992936893},{"$f":"B16*($D$11+D5)","v":7005.1001828259796},{"$f":"(C16/2)*D8*$D$12","v":8565.1879964684467},{"$f":"D16+E16","v":15570.288179294426},null,null,{"$f":"SQRT((D2*D12*D8+D3*D9*D12+D4*D10*D12)/(2*(D11+D7+D6+D5)))","v":14.01020036565196}]
["B",{"$f":"B16","v":14.01020036565196},{"$f":"D3/B17","v":2141.2969991171117},{"$f":"B17*(D6)","v":1401.0200365651961},{"$f":"(C17/2)*D9*$D$12","v":856.51879964684474},{"$f":"D17+E17","v":2257.5388362120407}]
["C",{"$f":"B16","v":14.01020036565196},{"$f":"D4/B18","v":770.86691968216019},{"$f":"B18*(D7)","v":1401.0200365651961},{"$f":"(C18/2)*D10*$D$12","v":385.43345984108009},{"$f":"D18+E18","v":1786.4534964062761}]
[null,null,null,null,null,{"$f":"SUM(F16:F18)","v":19614.280511912744}]
["Your Guess Total Cost",null,19614.280511912744]
["Optimal Solution Total Cost",null,{"$f":"F19","v":19614.280511912744}]
["Savings from Optimization",null,{"$f":"C20-C21","v":0}]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}