{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Aggregate Planning"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":51,"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":"Aggregate Planning","index":0,"n_rows":43,"n_cols":17,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Demand Forecast",null,null,"Costs"]
[]
[null,null,"Month","Demand Forecast",null,"Item","Cost"]
[null,null,"January",1600,null,"Materials cost/unit",10]
[null,null,"February",3000,null,"Inventory holding cost/unit/month",2]
[null,null,"March",3200,null,"Marginal cost of stockout/unit/month",5]
[null,null,"April",3800,null,"Hiring and training cost/worker",300]
[null,null,"May",2200,null,"Layoff cost/worker",500]
[null,null,"June",2200,null,"Labor hours required/unit",4]
[null,null,null,null,null,"Regular time cost/hour",4]
[null,null,null,null,null,"Over time cost/hour",6]
[null,null,null,null,null,"Subcontracting cost/unit",30]
[]
[null,"Aggregate Plan Decision Variables",null,null,null,null,null,null,null,null,null,null,null,"Constraints"]
[null,null,"Ht","Lt","Wt","Ot","It","St","Ct","Pt"]
[null,"Period","# Hired","# Laid off","# Workforce","Overtime","Inventory","Stockout","Subcontract","Production","Demand","Price",null,"Workforce","Capacity","Inventory","Overtime"]
[null,0,0,0,80,0,1000,0,0]
[null,1,0,16,64.000000000000014,0,1959.9999999999995,0,0,2559.9999999999986,{"$f":"D5","v":1600},40,null,{"$f":"E19-E18-C19+D19","v":1.4210854715202004E-14},{"$f":"40*E19+F19/4-J19","v":0},{"$f":"G18-H18+J19+I19-K19-G19+H19","v":-9.0949470177292824E-13},{"$f":"10*E19-F19","v":640.00000000000011}]
[null,2,0,0,63.999999999999979,0,1519.9999999999991,0,0,2559.9999999999986,{"$f":"D6","v":3000},40,null,{"$f":"E20-E19-C20+D20","v":-3.5527136788005009E-14},{"$f":"40*E20+F20/4-J20","v":0},{"$f":"G19-H19+J20+I20-K20-G20+H20","v":-9.0949470177292824E-13},{"$f":"10*E20-F20","v":639.99999999999977}]
[null,3,0,0,63.999999999999979,0,879.99999999999841,0,0,2560,3200,40,null,0,0,6.8212102632969618E-13,639.99999999999977]
[null,4,0,0,63.999999999999979,0,0,219.99999999999849,140.00000000000355,2560,3800,40,null,0,0,3.1263880373444408E-13,639.99999999999977]
[null,5,0,0,63.999999999999993,0,140.0000000000006,0,0,2559.9999999999991,2200,40,null,1.4210854715202004E-14,0,-1.4210854715202004E-13,639.99999999999989]
[null,6,0,0,63.999999999999993,0,500,0,0,2559.9999999999995,2200,40,null,{"$f":"E24-E23-C24+D24","v":0},0,0,639.99999999999989]
[null,null,null,null,null,{"$f":"AVERAGE(F18:F24)","v":0},{"$f":"AVERAGE(G18:G24)","v":857.14285714285677},{"$f":"AVERAGE(H18:H24)","v":31.428571428571214},{"$f":"AVERAGE(I18:I24)","v":20.000000000000508}]
[null,"Aggregate Plan Costs"]
[]
[null,"Period","Hiring","Lay off","Regular time","Overtime","Inventory","Stockout","Subcontract","Production"]
[null,1,{"$f":"$G$8*C19","v":0},{"$f":"D19*$G$9","v":8000},{"$f":"E19*$G$11*8*20","v":40960.000000000007},{"$f":"F19*$G$12","v":0},{"$f":"G19*$G$6","v":3919.9999999999991},{"$f":"H19*$G$7","v":0},{"$f":"I19*$G$13","v":0},{"$f":"J19*$G$5","v":25599.999999999985}]
[null,2,{"$f":"$G$8*C20","v":0},{"$f":"D20*$G$9","v":0},{"$f":"E20*$G$11*8*20","v":40959.999999999985},{"$f":"F20*$G$12","v":0},{"$f":"G20*$G$6","v":3039.9999999999982},{"$f":"H20*$G$7","v":0},{"$f":"I20*$G$13","v":0},{"$f":"J20*$G$5","v":25599.999999999985}]
[null,3,0,0,40959.999999999985,0,1759.9999999999968,0,0,25600]
[null,4,0,0,40959.999999999985,0,0,1099.9999999999925,4200.0000000001064,25600]
[null,5,0,0,40959.999999999993,0,280.00000000000119,0,0,25599.999999999993]
[null,6,0,0,40959.999999999993,0,1000,0,0,25599.999999999996]
[]
[null,"Total Cost =",null,{"$f":"+SUM(C29:J34)","v":422660.00000000006}]
[]
[null,"Total Revenue =",null,{"$f":"SUMPRODUCT(K19:K24,L19:L24)","v":640000}]
[null,"Profit =",null,{"$f":"D38-D36","v":217339.99999999994}]
[]
[]
[null,"Seasonal Inventory =",null,null,{"$f":"(((G18+G24)/2)+SUM(G19:G23))/6","v":874.99999999999966}]
[null,"Average flow time =",null,null,{"$f":"E42/(SUM(K19:K24)/6)","v":0.32812499999999989},"months"]