{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Optimize"],"not_rendered":{"charts":2,"images":7,"macros":1,"external_links":0,"defined_names":0,"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":"Optimize","index":0,"n_rows":17,"n_cols":15,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Lotsizing with time-varying demand"]
[]
["User should change only the blue cells."]
[]
[null,null,"Wagner-Whitin lotsizes -- optimal lotsizes"]
[null,"Period",1,{"$f":"C6+1","v":2},3,4,5,6,7,8,9,10,11,12,"Totals"]
[null,"Beginning inventory",0,{"$f":"C13","v":29},{"$f":"D13","v":0},61,0,60,34,0,45,0,0,56]
[null,"Demand",69,29,36,61,61,26,34,67,45,67,79,56,{"$f":"SUM(C8:N8)","v":630}]
[null,"Ordering (setup) cost/order",85,102,102,101,98,114,105,86,119,110,98,114]
[null,"Procurement cost/unit",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Carrying cost/unit/period",1,1,1,1,1,1,1,1,1,1,1,1]
[null,"Order quantity (lotsizes)",98,0,97,0,121,0,0,112,0,67,135,0,{"$f":"SUM(C12:N12)","v":630}]
[null,"Ending inventory",{"$f":"C7+C12-C8","v":29},{"$f":"D7+D12-D8","v":0},61,0,60,34,0,45,0,0,56,0]
[null,"Procurement cost",{"$f":"C12*C10","v":0},{"$f":"D12*D10","v":0},{"$f":"E12*E10","v":0},{"$f":"F12*F10","v":0},{"$f":"G12*G10","v":0},0,0,0,0,0,0,0,{"$f":"SUM(C14:N14)","v":0}]
[null,"Ordering cost",{"$f":"IF(C12>0,C9,0)","v":85},{"$f":"IF(D12>0,D9,0)","v":0},{"$f":"IF(E12>0,E9,0)","v":102},{"$f":"IF(F12>0,F9,0)","v":0},{"$f":"IF(G12>0,G9,0)","v":98},0,0,86,0,110,98,0,{"$f":"SUM(C15:N15)","v":579}]
[null,"Carrying cost",{"$f":"C11*C13","v":29},{"$f":"D11*D13","v":0},{"$f":"E11*E13","v":61},{"$f":"F11*F13","v":0},{"$f":"G11*G13","v":60},34,0,45,0,0,56,0,{"$f":"SUM(C16:N16)","v":285}]
[null,"Total period cost",{"$f":"SUM(C14:C16)","v":114},0,163,0,158,34,0,131,0,110,154,0,{"$f":"SUM(C17:N17)","v":864}]