{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Explanation","Module1","Report","Model"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":37,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Module1","index":1,"reason":"part_missing"}],"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":"Explanation","index":0,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[[2,2,2,6]]}
[]
[]
[null,null,"Pigskin Planning Problem"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"If this doesn't work, you'll need to add the Solver Add-In."]
[null,null,"Click the Office Button and go to Excel Options and click Add-Ins."]

{"sheet":"Report","index":2,"n_rows":43,"n_cols":12,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[null,"Summary of optimal solution",null,null,null,null,"Monthly schedule"]
[]
[null,"Planning horizon (months)",null,null,6,null,"Month 1"]
[null,"Total production cost",null,null,{"$f":"Total_production_cost","v":19185},null,null,"Units",null,null,"Dollars"]
[null,"Total holding cost",null,null,{"$f":"Total_holding_cost","v":0},null,null,"Start with",{"$f":"Beginning_inventory","v":50}]
[null,"Total cost",null,null,{"$f":"Total_cost","v":19185},null,null,"Produce",{"$f":"Model!B16","v":50},null,"Production cost",{"$f":"I6*Model!B12","v":625}]
[null,null,null,null,null,null,null,"Demand is",{"$f":"Model!B11","v":100}]
[null,null,null,null,null,null,null,"End with",{"$f":"Model!B22","v":0},null,"Holding cost",{"$f":"I8*Holding_cost_percent*Model!B12","v":0}]
[]
[null,null,null,null,null,null,"Month 2"]
[null,null,null,null,null,null,null,"Units",null,null,"Dollars"]
[null,null,null,null,null,null,null,"Start with",{"$f":"I8","v":0}]
[null,null,null,null,null,null,null,"Produce",{"$f":"Model!C16","v":150},null,"Production cost",{"$f":"I13*Model!C12","v":1897.5}]
[null,null,null,null,null,null,null,"Demand is",{"$f":"Model!C11","v":150}]
[null,null,null,null,null,null,null,"End with",{"$f":"Model!C22","v":0},null,"Holding cost",{"$f":"I15*Holding_cost_percent*Model!C12","v":0}]
[]
[null,null,null,null,null,null,"Month 3"]
[null,null,null,null,null,null,null,"Units",null,null,"Dollars"]
[null,null,null,null,null,null,null,"Start with",{"$f":"I15","v":0}]
[null,null,null,null,null,null,null,"Produce",{"$f":"Model!D16","v":300},null,"Production cost",{"$f":"I20*Model!D12","v":3825}]
[null,null,null,null,null,null,null,"Demand is",{"$f":"Model!D11","v":300}]
[null,null,null,null,null,null,null,"End with",{"$f":"Model!D22","v":0},null,"Holding cost",{"$f":"I22*Holding_cost_percent*Model!D12","v":0}]
[]
[null,null,null,null,null,null,"Month 4"]
[null,null,null,null,null,null,null,"Units",null,null,"Dollars"]
[null,null,null,null,null,null,null,"Start with",{"$f":"I22","v":0}]
[null,null,null,null,null,null,null,"Produce",{"$f":"Model!E16","v":350},null,"Production cost",{"$f":"I27*Model!E12","v":4462.5}]
[null,null,null,null,null,null,null,"Demand is",{"$f":"Model!E11","v":350}]
[null,null,null,null,null,null,null,"End with",{"$f":"Model!E22","v":0},null,"Holding cost",{"$f":"I29*Holding_cost_percent*Model!E12","v":0}]
[]
[null,null,null,null,null,null,"Month 5"]
[null,null,null,null,null,null,null,"Units",null,null,"Dollars"]
[null,null,null,null,null,null,null,"Start with",{"$f":"I29","v":0}]
[null,null,null,null,null,null,null,"Produce",{"$f":"Model!F16","v":300},null,"Production cost",{"$f":"I34*Model!F12","v":3825}]
[null,null,null,null,null,null,null,"Demand is",{"$f":"Model!F11","v":300}]
[null,null,null,null,null,null,null,"End with",{"$f":"Model!F22","v":0},null,"Holding cost",{"$f":"I36*Holding_cost_percent*Model!F12","v":0}]
[]
[null,null,null,null,null,null,"Month 6"]
[null,null,null,null,null,null,null,"Units",null,null,"Dollars"]
[null,null,null,null,null,null,null,"Start with",{"$f":"I36","v":0}]
[null,null,null,null,null,null,null,"Produce",{"$f":"Model!G16","v":350},null,"Production cost",{"$f":"I41*Model!G12","v":4550}]
[null,null,null,null,null,null,null,"Demand is",{"$f":"Model!G11","v":350}]
[null,null,null,null,null,null,null,"End with",{"$f":"Model!G22","v":0},null,"Holding cost",{"$f":"I43*Holding_cost_percent*Model!G12","v":0}]

{"sheet":"Model","index":3,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
["Aggregate Planning Model"]
[]
["Input data"]
[]
["Holding cost percent",7.0000000000000007E-2,null,"(for relating unit holding cost to unit production cost)"]
["Beginning inventory",50]
[]
["Demands, unit production costs, and unit inventory holding costs:"]
[]
["Month",1,2,3,4,5,6]
["Demand",100,150,300,350,300,350]
["Unit production cost",12.5,12.65,12.75,12.75,12.75,13]
[]
["Production plan"]
[]
["Units produced",50,150,300,350,300,350]
[null,"<="]
["Production capacity",300,300,350,350,400,400]
[]
["Meet demand",0,0,0,0,0,0]
[null,"<=","<=","<=","<=","<=","<="]
["Ending inventory",{"$f":"Beginning_inventory + B16 - B11","v":0},{"$f":"B22+C16 - C11","v":0},{"$f":"C22+D16 - D11","v":0},{"$f":"D22+E16 - E11","v":0},{"$f":"E22+F16 - F11","v":0},{"$f":"F22+G16 - G11","v":0}]
[null,"<="]
["Storage capacity",100,100,100,100,125,125]
[]
["Summary of costs"]
["Total production cost",{"$f":"SUMPRODUCT(Unit_production_cost,Units_produced)","v":19185}]
["Total holding cost",{"$f":"Holding_cost_percent*SUMPRODUCT(Unit_production_cost,Ending_inventory)","v":0}]
["Total cost",{"$f":"Total_production_cost+Total_holding_cost","v":19185}]