{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Tables 8-2, 8-3","Planning","Plan Chart","Sheet2","Sheet3","Sheet4"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":192,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Plan Chart","index":2,"reason":"not_a_worksheet"}],"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":"Tables 8-2, 8-3","index":0,"n_rows":24,"n_cols":2,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Aggregate Planning (Chapter 8-9)"]
[]
["Demand Forecast"]
[]
["Month","Demand Forecast"]
["January",1600]
["February",3000]
["March",3200]
["April",3800]
["May",2200]
["June",2200]
[]
["Costs"]
[]
["Item","Cost"]
["Materials cost/unit",10]
["Inventory holding cost/unit/month",2]
["Marginal cost of stockout/unit/month",5]
["Hiring and training cost/worker",300]
["Layoff cost/worker",500]
["Labor hours required/unit",4]
["Regular time cost/hour",4]
["Over time cost/hour",6]
["Marginal subcontracting cost/unit",30]

{"sheet":"Planning","index":1,"n_rows":25,"n_cols":16,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Aggregate Plan Decision Variables",null,null,null,null,null,null,null,null,null,null,null,"Constraints"]
[null,"Ht","Lt","Wt","Ot","It","St","Ct","Pt"]
["Period","# Hired","# Laid off","# Workforce","Overtime","Inventory","Stockout","Subcontract","Production","Demand","Price",null,"Workforce","Capacity","Inventory","Overtime"]
[0,0,0,80,0,1000,0,0]
[1,0,14,66.000000000386862,0,2040.0000000154753,0,0,2640.0000000154755,{"$f":"IF($E$24=0,'Tables 8-2, 8-3'!B6,IF(Planning!A5=Planning!$E$25,'Tables 8-2, 8-3'!B6*(1+Planning!$H$24)+Planning!$H$25*('Tables 8-2, 8-3'!B7+'Tables 8-2, 8-3'!B8),IF(Planning!A5<=2+Planning!$E$25,IF(A5>$E$25,(1-Planning!$H$25)*'Tables 8-2, 8-3'!B6,'Tables 8-2, 8-3'!B6),'Tables 8-2, 8-3'!B6)))","v":1600},{"$f":"IF($E$24=1,IF(A5=$E$25,$H$23-1,$H$23),$H$23)","v":40},null,{"$f":"+D5-D4-B5+C5","v":3.8686209791194415E-10},{"$f":"40*D5+(E5/4)-I5","v":0},{"$f":"+F4-G4+I5+H5-J5-F5+G5","v":2.2737367544323206E-13},{"$f":"-E5+10*D5","v":660.00000000386865}]
[2,0,0,66.000000000386848,0,1680.0000000309485,0,0,2640.0000000154737,{"$f":"IF($E$24=0,'Tables 8-2, 8-3'!B7,IF(Planning!A6=Planning!$E$25,'Tables 8-2, 8-3'!B7*(1+Planning!$H$24)+Planning!$H$25*('Tables 8-2, 8-3'!B8+'Tables 8-2, 8-3'!B9),IF(Planning!A6<=2+Planning!$E$25,IF(A6>$E$25,(1-Planning!$H$25)*'Tables 8-2, 8-3'!B7,'Tables 8-2, 8-3'!B7),'Tables 8-2, 8-3'!B7)))","v":3000},40,null,-1.4210854715202004E-14,0,6.8212102632969618E-13,660.00000000386854]
[3,0,0,66.000000000386848,0,1120.000000117828,8.2052566878601019E-8,0,2640.0000000154741,{"$f":"IF($E$24=0,'Tables 8-2, 8-3'!B8,IF(Planning!A7=Planning!$E$25,'Tables 8-2, 8-3'!B8*(1+Planning!$H$24)+Planning!$H$25*('Tables 8-2, 8-3'!B9+'Tables 8-2, 8-3'!B10),IF(Planning!A7<=2+Planning!$E$25,IF(A7>$E$25,(1-Planning!$H$25)*'Tables 8-2, 8-3'!B8,'Tables 8-2, 8-3'!B8),'Tables 8-2, 8-3'!B8)))","v":3200},40,null,0,0,1.0647000974031207E-8,660.00000000386854]
[4,3.2935290252882449E-7,0,66.000000329739748,0,4.345892627153586E-9,1260.0000263834411,39.999960395541848,2640.0000131895877,{"$f":"IF($E$24=0,'Tables 8-2, 8-3'!B9,IF(Planning!A8=Planning!$E$25,'Tables 8-2, 8-3'!B9*(1+Planning!$H$24)+Planning!$H$25*('Tables 8-2, 8-3'!B10+'Tables 8-2, 8-3'!B11),IF(Planning!A8<=2+Planning!$E$25,IF(A8>$E$25,(1-Planning!$H$25)*'Tables 8-2, 8-3'!B9,'Tables 8-2, 8-3'!B9),'Tables 8-2, 8-3'!B9)))","v":5060},39,null,-2.0210955745645926E-15,0,0,660.00000329739748]
[5,0,0,66.000000329739748,0,1.0430014741136775E-8,380.00001319993765,0,2640.0000131895886,{"$f":"IF($E$24=0,'Tables 8-2, 8-3'!B10,IF(Planning!A9=Planning!$E$25,'Tables 8-2, 8-3'!B10*(1+Planning!$H$24)+Planning!$H$25*('Tables 8-2, 8-3'!B11+'Tables 8-2, 8-3'!B12),IF(Planning!A9<=2+Planning!$E$25,IF(A9>$E$25,(1-Planning!$H$25)*'Tables 8-2, 8-3'!B10,'Tables 8-2, 8-3'!B10),'Tables 8-2, 8-3'!B10)))","v":1760},40,null,0,0,9.0949470177292824E-13,660.00000329739748]
[6,0,0,66.000000329737631,0,500,0,0,2640.0000131895081,{"$f":"IF($E$24=0,'Tables 8-2, 8-3'!B11,IF(Planning!A10=Planning!$E$25,'Tables 8-2, 8-3'!B11*(1+Planning!$H$24)+Planning!$H$25*('Tables 8-2, 8-3'!B12+'Tables 8-2, 8-3'!B13),IF(Planning!A10<=2+Planning!$E$25,IF(A10>$E$25,(1-Planning!$H$25)*'Tables 8-2, 8-3'!B11,'Tables 8-2, 8-3'!B11),'Tables 8-2, 8-3'!B11)))","v":1760},40,null,-2.1174173525650986E-12,0,4.5474735088646412E-13,660.00000329737634]
[null,null,null,null,{"$f":"AVERAGE(E4:E10)","v":0},{"$f":"AVERAGE(F4:F10)","v":905.714285739861},{"$f":"AVERAGE(G4:G10)","v":234.28571995220449},{"$f":"AVERAGE(H4:H10)","v":5.7142800565059781}]
["Aggregate Plan Costs"]
[]
["Period","Hiring","Lay off","Regular time","Overtime","Inventory","Stockout","Subcontract","Material"]
[1,{"$f":"+'Tables 8-2, 8-3'!$B$19*B5","v":0},{"$f":"+C5*'Tables 8-2, 8-3'!$B$20","v":7000},{"$f":"+D5*'Tables 8-2, 8-3'!$B$22*8*20","v":42240.000000247594},{"$f":"+E5*'Tables 8-2, 8-3'!$B$23","v":0},{"$f":"+F5*'Tables 8-2, 8-3'!$B$17","v":4080.0000000309506},{"$f":"+G5*'Tables 8-2, 8-3'!$B$18","v":0},{"$f":"+H5*'Tables 8-2, 8-3'!$B$24","v":0},{"$f":"I5*'Tables 8-2, 8-3'!$B$16","v":26400.000000154756}]
[2,{"$f":"+'Tables 8-2, 8-3'!$B$19*B6","v":0},{"$f":"+C6*'Tables 8-2, 8-3'!$B$20","v":0},{"$f":"+D6*'Tables 8-2, 8-3'!$B$22*8*20","v":42240.000000247586},{"$f":"+E6*'Tables 8-2, 8-3'!$B$23","v":0},{"$f":"+F6*'Tables 8-2, 8-3'!$B$17","v":3360.000000061897},{"$f":"+G6*'Tables 8-2, 8-3'!$B$18","v":0},{"$f":"+H6*'Tables 8-2, 8-3'!$B$24","v":0},{"$f":"I6*'Tables 8-2, 8-3'!$B$16","v":26400.000000154738}]
[3,{"$f":"+'Tables 8-2, 8-3'!$B$19*B7","v":0},{"$f":"+C7*'Tables 8-2, 8-3'!$B$20","v":0},{"$f":"+D7*'Tables 8-2, 8-3'!$B$22*8*20","v":42240.000000247586},{"$f":"+E7*'Tables 8-2, 8-3'!$B$23","v":0},{"$f":"+F7*'Tables 8-2, 8-3'!$B$17","v":2240.000000235656},{"$f":"+G7*'Tables 8-2, 8-3'!$B$18","v":4.1026283439300511E-7},{"$f":"+H7*'Tables 8-2, 8-3'!$B$24","v":0},{"$f":"I7*'Tables 8-2, 8-3'!$B$16","v":26400.000000154741}]
[4,{"$f":"+'Tables 8-2, 8-3'!$B$19*B8","v":9.8805870758647343E-5},{"$f":"+C8*'Tables 8-2, 8-3'!$B$20","v":0},{"$f":"+D8*'Tables 8-2, 8-3'!$B$22*8*20","v":42240.000211033439},{"$f":"+E8*'Tables 8-2, 8-3'!$B$23","v":0},{"$f":"+F8*'Tables 8-2, 8-3'!$B$17","v":8.691785254307172E-9},{"$f":"+G8*'Tables 8-2, 8-3'!$B$18","v":6300.0001319172052},{"$f":"+H8*'Tables 8-2, 8-3'!$B$24","v":1199.9988118662554},{"$f":"I8*'Tables 8-2, 8-3'!$B$16","v":26400.000131895875}]
[5,{"$f":"+'Tables 8-2, 8-3'!$B$19*B9","v":0},{"$f":"+C9*'Tables 8-2, 8-3'!$B$20","v":0},{"$f":"+D9*'Tables 8-2, 8-3'!$B$22*8*20","v":42240.000211033439},{"$f":"+E9*'Tables 8-2, 8-3'!$B$23","v":0},{"$f":"+F9*'Tables 8-2, 8-3'!$B$17","v":2.086002948227355E-8},{"$f":"+G9*'Tables 8-2, 8-3'!$B$18","v":1900.0000659996883},{"$f":"+H9*'Tables 8-2, 8-3'!$B$24","v":0},{"$f":"I9*'Tables 8-2, 8-3'!$B$16","v":26400.000131895886}]
[6,{"$f":"+'Tables 8-2, 8-3'!$B$19*B10","v":0},{"$f":"+C10*'Tables 8-2, 8-3'!$B$20","v":0},{"$f":"+D10*'Tables 8-2, 8-3'!$B$22*8*20","v":42240.000211032086},{"$f":"+E10*'Tables 8-2, 8-3'!B23","v":0},{"$f":"+F10*'Tables 8-2, 8-3'!$B$17","v":1000},{"$f":"+G10*'Tables 8-2, 8-3'!$B$18","v":0},{"$f":"+H10*'Tables 8-2, 8-3'!$B$24","v":0},{"$f":"I10*'Tables 8-2, 8-3'!$B$16","v":26400.000131895082}]
[]
["Total Cost =",null,{"$f":"+SUM(B15:I20)","v":438920.00013935013}]
[null,null,null,null,null,"Base Price",null,40]
["Total Revenue =",null,{"$f":"SUMPRODUCT(J5:J10,K5:K10)","v":650140},"Promote? (0/1)",1,"Consumption",null,0.1]
["Profit =",null,{"$f":"C24-C22","v":211219.99986064987},"Month (1/4)",4,"Forward buy",null,0.2]

{"sheet":"Sheet2","index":3,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Aggregate Plan"]
[]
["Period","# Hired","# Laid off","# Workforce","over time","Inventory","Stockout","Subcontract","Production","Demand"]
[0,0,0,80,null,1000,0,0]
[1,0,18,62,0,1880,0,0,2480,1600]
[2,0,0,62,0,1360,0,0,2480,3000]
[3,0,0,62,620,794.99999999999943,0,0,2635,3200]
[4,0,0,62,620,0,370.0000000000008,0,2635,3800]
[5,0,0,62,620,65.000000000000526,0,0,2635,2200]
[6,0,0,62,620,500,0,0,2635,2200]
[]
["Aggregate Plan Costs"]
[]
["Period","Hiring","Lay off","Regular time","Over time","Inventory","Stockout","Subcontract"]
[1,{"$f":"+'Tables 8-2, 8-3'!$B$19*Sheet2!B5","v":0},{"$f":"+C5*'Tables 8-2, 8-3'!$B$20","v":9000},{"$f":"+D5*'Tables 8-2, 8-3'!$B$22*8*20","v":39680},{"$f":"+E5*'Tables 8-2, 8-3'!B23","v":0},{"$f":"+F5*'Tables 8-2, 8-3'!$B$17","v":3760},{"$f":"+G5*'Tables 8-2, 8-3'!$B$18","v":0},{"$f":"+H5*'Tables 8-2, 8-3'!$B$24","v":0}]
[2,{"$f":"+'Tables 8-2, 8-3'!$B$19*Sheet2!B6","v":0},{"$f":"+C6*'Tables 8-2, 8-3'!$B$20","v":0},{"$f":"+D6*'Tables 8-2, 8-3'!$B$22*8*20","v":39680},{"$f":"+E6*'Tables 8-2, 8-3'!B24","v":0},{"$f":"+F6*'Tables 8-2, 8-3'!$B$17","v":2720},{"$f":"+G6*'Tables 8-2, 8-3'!$B$18","v":0},{"$f":"+H6*'Tables 8-2, 8-3'!$B$24","v":0}]
[3,{"$f":"+'Tables 8-2, 8-3'!$B$19*Sheet2!B7","v":0},{"$f":"+C7*'Tables 8-2, 8-3'!$B$20","v":0},{"$f":"+D7*'Tables 8-2, 8-3'!$B$22*8*20","v":39680},{"$f":"+E7*'Tables 8-2, 8-3'!B25","v":0},{"$f":"+F7*'Tables 8-2, 8-3'!$B$17","v":1589.9999999999989},{"$f":"+G7*'Tables 8-2, 8-3'!$B$18","v":0},{"$f":"+H7*'Tables 8-2, 8-3'!$B$24","v":0}]
[4,{"$f":"+'Tables 8-2, 8-3'!$B$19*Sheet2!B8","v":0},{"$f":"+C8*'Tables 8-2, 8-3'!$B$20","v":0},{"$f":"+D8*'Tables 8-2, 8-3'!$B$22*8*20","v":39680},{"$f":"+E8*'Tables 8-2, 8-3'!B26","v":0},{"$f":"+F8*'Tables 8-2, 8-3'!$B$17","v":0},{"$f":"+G8*'Tables 8-2, 8-3'!$B$18","v":1850.0000000000041},{"$f":"+H8*'Tables 8-2, 8-3'!$B$24","v":0}]
[5,{"$f":"+'Tables 8-2, 8-3'!$B$19*Sheet2!B9","v":0},{"$f":"+C9*'Tables 8-2, 8-3'!$B$20","v":0},{"$f":"+D9*'Tables 8-2, 8-3'!$B$22*8*20","v":39680},{"$f":"+E9*'Tables 8-2, 8-3'!B27","v":0},{"$f":"+F9*'Tables 8-2, 8-3'!$B$17","v":130.00000000000105},{"$f":"+G9*'Tables 8-2, 8-3'!$B$18","v":0},{"$f":"+H9*'Tables 8-2, 8-3'!$B$24","v":0}]
[6,{"$f":"+'Tables 8-2, 8-3'!$B$19*Sheet2!B10","v":0},{"$f":"+C10*'Tables 8-2, 8-3'!$B$20","v":0},{"$f":"+D10*'Tables 8-2, 8-3'!$B$22*8*20","v":39680},{"$f":"+E10*'Tables 8-2, 8-3'!B28","v":0},{"$f":"+F10*'Tables 8-2, 8-3'!$B$17","v":1000},{"$f":"+G10*'Tables 8-2, 8-3'!$B$18","v":0},{"$f":"+H10*'Tables 8-2, 8-3'!$B$24","v":0}]
[]
["Total Cost =",null,{"$f":"+SUM(B15:H20)","v":258130}]

{"sheet":"Sheet3","index":4,"n_rows":24,"n_cols":16,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Aggregate Plan Decision Variables",null,null,null,null,null,null,null,null,null,null,null,"Constraints"]
[]
["Period","# Hired","# Laid off","# Workforce","Overtime","Inventory","Stockout","Subcontract","Production","Demand",null,null,"Workforce","Production","Inventory","Over time"]
[0,0,0,80,0,1000,0,0]
[1,0,28.75,51.25,0,1450,0,0,2050,1600,null,null,{"$f":"+D5-D4-B5+C5","v":0},{"$f":"40*D5+(E5/4)-I5","v":0},{"$f":"+F4-G4+I5+H5-J5-F5+G5","v":0},{"$f":"-E5+10*D5","v":512.5}]
[2,0,0,51.25,0,499.99999999999926,0,0,2050,3000,null,null,0,0,7.3896444519050419E-13,512.5]
[3,16.25,0,67.5,0,0,0,0,2700,3200,null,null,0,0,-9.0949470177292824E-13,675]
[4,0,0,67.5,0,0,500,600.00000000000091,2700,3800,null,null,0,0,9.0949470177292824E-13,675]
[5,0,0,67.5,0,0,0,0,2700,2200,null,null,0,0,0,675]
[6,0,0,67.5,0,500,0,0,2700,2200,null,null,0,0,0,675]
[]
["Aggregate Plan Costs"]
[]
["Period","Hiring","Lay off","Regular time","Over time","Inventory","Stockout","Subcontract","Material"]
[1,{"$f":"+'Tables 8-2, 8-3'!$B$19*Sheet2!B5","v":0},{"$f":"+C5*'Tables 8-2, 8-3'!$B$20","v":14375},{"$f":"+D5*'Tables 8-2, 8-3'!$B$22*8*20","v":32800},{"$f":"+E5*'Tables 8-2, 8-3'!$B$23","v":0},{"$f":"+F5*'Tables 8-2, 8-3'!$B$17","v":2900},{"$f":"+G5*'Tables 8-2, 8-3'!$B$18","v":0},{"$f":"+H5*'Tables 8-2, 8-3'!$B$24","v":0},{"$f":"I5*'Tables 8-2, 8-3'!$B$16","v":20500}]
[2,{"$f":"+'Tables 8-2, 8-3'!$B$19*Sheet2!B6","v":0},{"$f":"+C6*'Tables 8-2, 8-3'!$B$20","v":0},{"$f":"+D6*'Tables 8-2, 8-3'!$B$22*8*20","v":32800},{"$f":"+E6*'Tables 8-2, 8-3'!$B$23","v":0},{"$f":"+F6*'Tables 8-2, 8-3'!$B$17","v":999.99999999999852},{"$f":"+G6*'Tables 8-2, 8-3'!$B$18","v":0},{"$f":"+H6*'Tables 8-2, 8-3'!$B$24","v":0},{"$f":"I6*'Tables 8-2, 8-3'!$B$16","v":20500}]
[3,{"$f":"+'Tables 8-2, 8-3'!$B$19*Sheet2!B7","v":0},{"$f":"+C7*'Tables 8-2, 8-3'!$B$20","v":0},{"$f":"+D7*'Tables 8-2, 8-3'!$B$22*8*20","v":43200},{"$f":"+E7*'Tables 8-2, 8-3'!$B$23","v":0},{"$f":"+F7*'Tables 8-2, 8-3'!$B$17","v":0},{"$f":"+G7*'Tables 8-2, 8-3'!$B$18","v":0},{"$f":"+H7*'Tables 8-2, 8-3'!$B$24","v":0},{"$f":"I7*'Tables 8-2, 8-3'!$B$16","v":27000}]
[4,{"$f":"+'Tables 8-2, 8-3'!$B$19*Sheet2!B8","v":0},{"$f":"+C8*'Tables 8-2, 8-3'!$B$20","v":0},{"$f":"+D8*'Tables 8-2, 8-3'!$B$22*8*20","v":43200},{"$f":"+E8*'Tables 8-2, 8-3'!$B$23","v":0},{"$f":"+F8*'Tables 8-2, 8-3'!$B$17","v":0},{"$f":"+G8*'Tables 8-2, 8-3'!$B$18","v":2500},{"$f":"+H8*'Tables 8-2, 8-3'!$B$24","v":18000.000000000029},{"$f":"I8*'Tables 8-2, 8-3'!$B$16","v":27000}]
[5,{"$f":"+'Tables 8-2, 8-3'!$B$19*Sheet2!B9","v":0},{"$f":"+C9*'Tables 8-2, 8-3'!$B$20","v":0},{"$f":"+D9*'Tables 8-2, 8-3'!$B$22*8*20","v":43200},{"$f":"+E9*'Tables 8-2, 8-3'!$B$23","v":0},{"$f":"+F9*'Tables 8-2, 8-3'!$B$17","v":0},{"$f":"+G9*'Tables 8-2, 8-3'!$B$18","v":0},{"$f":"+H9*'Tables 8-2, 8-3'!$B$24","v":0},{"$f":"I9*'Tables 8-2, 8-3'!$B$16","v":27000}]
[6,{"$f":"+'Tables 8-2, 8-3'!$B$19*Sheet2!B10","v":0},{"$f":"+C10*'Tables 8-2, 8-3'!$B$20","v":0},{"$f":"+D10*'Tables 8-2, 8-3'!$B$22*8*20","v":43200},{"$f":"+E10*'Tables 8-2, 8-3'!B23","v":0},{"$f":"+F10*'Tables 8-2, 8-3'!$B$17","v":1000},{"$f":"+G10*'Tables 8-2, 8-3'!$B$18","v":0},{"$f":"+H10*'Tables 8-2, 8-3'!$B$24","v":0},{"$f":"I10*'Tables 8-2, 8-3'!$B$16","v":27000}]
[]
["Total Cost =",null,{"$f":"+SUM(B15:I20)","v":427175}]
[]
["Total Revenue =",null,{"$f":"SUM(J5:J10)*31","v":496000}]

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