{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Table 5-3 HighOptic","Table 5-3 TelecomOne","Merged Network with All Plants ","Figure 5-12","Table 5-4 Single Sourcing"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":268,"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":"Table 5-3 HighOptic","index":0,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,1,1,6],[11,1,11,6]]}
["Inputs - Costs, Capacities, Demands (Table 11.4 for HighOptic)"]
[null,"Demand City\nProduction and Transportation Cost per 1000 Units",null,null,null,null,null,"Fixed ","Capa-"]
["Supply City","Atlanta","Boston","Chicago","Denver","Omaha","Portland","Cost ($)","city"]
["Baltimore",1675,400,685,1630,1160,2800,7650,18]
["Cheyenne",1460,1940,970,100,495,1200,3500,24]
["Salt Lake",1925,2400,1425,500,950,800,5000,27]
["Memphis",380,1355,543,1045,665,2321,4100,22]
["Wichita",922,1646,700,508,311,1797,2200,31]
["Demand",10,8,14,6,7,11]
[]
["Decision Variables"]
[null,"Demand City - Production Allocation (1000 Units)",null,null,null,null,null,"Plants"]
["Supply City","Atlanta","Boston","Chicago","Denver","Omaha","Portland","(1=open)"]
["Baltimore",0,0,0,0,0,0]
["Cheyenne",0,0,0,6,7,0,1]
["Salt Lake",0,0,0,0,0,11,1]
["Memphis",0,0,0,0,0,0]
["Wichita",0,0,0,0,0,0]
[]
["Constraints"]
["Supply City","Excess Capacity"]
["Baltimore",{"$f":"I4-SUM(B14:G14)","v":18}]
["Cheyenne",{"$f":"I5-SUM(B15:G15)","v":11}]
["Salt Lake",{"$f":"I6-SUM(B16:G16)","v":16}]
["Memphis",{"$f":"I7-SUM(B17:G17)","v":22}]
["Wichita",{"$f":"I8-SUM(B18:G18)","v":31}]
[]
[null,"Atlanta","Boston","Chicago","Denver","Omaha","Portland"]
["Unmet Demand",{"$f":"B9-SUM(B14:B18)","v":10},8,14,0,0,0]
[]
["Objective Function"]
["Cost =",{"$f":"SUMPRODUCT(E15:G16,E5:G6)+SUMPRODUCT(I5:I6,H15:H16)+SUMPRODUCT(H15:H16,H5:H6)","v":21416}]

{"sheet":"Table 5-3 TelecomOne","index":1,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,1,1,6],[11,1,11,6]]}
["Inputs - Costs, Capacities, Demands (Table 11.4 for TelecomOne)"]
[null,"Demand City\nProduction and Transportation Cost per 1000 Units",null,null,null,null,null,"Fixed ","Capa-"]
["Supply City","Atlanta","Boston","Chicago","Denver","Omaha","Portland","Cost ($)","city"]
["Baltimore",1675,400,685,1630,1160,2800,7650,18]
["Cheyenne",1460,1940,970,100,495,1200,3500,24]
["Salt Lake",1925,2400,1425,500,950,800,5000,27]
["Memphis",380,1355,543,1045,665,2321,4100,22]
["Wichita",922,1646,700,508,311,1797,2200,31]
["Demand",10,8,14,6,7,11]
[]
["Decision Variables"]
[null,"Demand City - Production Allocation (1000 Units)",null,null,null,null,null,"Plants"]
["Supply City","Atlanta","Boston","Chicago","Denver","Omaha","Portland","(1=open)"]
["Baltimore",0,8,2,0,0,0,1]
["Cheyenne",0,0,0,0,0,0,0]
["Salt Lake",0,0,0,0,0,0,0]
["Memphis",10,0,12,0,0,0,1]
["Wichita",0,0,0,0,0,0,1]
[]
["Constraints"]
["Supply City","Excess Capacity"]
["Baltimore",{"$f":"I4-SUM(B14:G14)","v":8}]
["Cheyenne",{"$f":"I5-SUM(B15:G15)","v":24}]
["Salt Lake",{"$f":"I6-SUM(B16:G16)","v":27}]
["Memphis",{"$f":"I7-SUM(B17:G17)","v":0}]
["Wichita",{"$f":"I8-SUM(B18:G18)","v":31}]
[]
[null,"Atlanta","Boston","Chicago","Denver","Omaha","Portland"]
["Unmet Demand",{"$f":"B9-SUM(B14:B18)","v":0},0,0,6,7,11]
[]
["Objective Function"]
["Cost =",{"$f":"SUMPRODUCT(B14:D14,B4:D4)+SUMPRODUCT(B7:D8,B17:D18)+H14*H4+SUMPRODUCT(H7:H8,H17:H18)","v":28836}]

{"sheet":"Merged Network with All Plants ","index":2,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,1,1,6],[11,1,11,6]]}
["Inputs - Costs, Capacities, Demands (for TelecomOptic)"]
[null,"Demand City\nProduction and Transportation Cost per 1000 Units",null,null,null,null,null,"Fixed ","Capa-"]
["Supply City","Atlanta","Boston","Chicago","Denver","Omaha","Portland","Cost ($)","city"]
["Baltimore",1675,400,685,1630,1160,2800,7650,18]
["Cheyenne",1460,1940,970,100,495,1200,3500,24]
["Salt Lake",1925,2400,1425,500,950,800,5000,27]
["Memphis",380,1355,543,1045,665,2321,4100,22]
["Wichita",922,1646,700,508,311,1797,2200,31]
["Demand",10,8,14,6,7,11]
[]
["Decision Variables"]
[null,"Demand City - Production Allocation (1000 Units)",null,null,null,null,null,"Plants"]
["Supply City","Atlanta","Boston","Chicago","Denver","Omaha","Portland","(1=open)"]
["Baltimore",0,8.0000000003028635,2.0000000000046612,0,0,0,1]
["Cheyenne",0,0,0,6.0000000002271481,0,0,1]
["Salt Lake",0,0,0,0,0,11.000000000025636,1]
["Memphis",10.000000000023306,0,12.000000000027967,0,0,0,1]
["Wichita",0,0,0,0,7.0000000002650058,0,1]
[]
["Constraints"]
["Supply City","Excess Capacity"]
["Baltimore",{"$f":"I4*H14-SUM(B14:G14)","v":7.9999999996924753},null,"      Total Available Capacity",null,null,{"$f":"SUMPRODUCT(I4:I8,H14:H18)","v":122}]
["Cheyenne",{"$f":"I5*H15-SUM(B15:G15)","v":17.999999999772854}]
["Salt Lake",{"$f":"I6*H16-SUM(B16:G16)","v":15.999999999974364}]
["Memphis",{"$f":"I7*H17-SUM(B17:G17)","v":-5.1272763812448829E-11}]
["Wichita",{"$f":"I8*H18-SUM(B18:G18)","v":23.999999999734996}]
[]
[null,"Atlanta","Boston","Chicago","Denver","Omaha","Portland"]
["Unmet Demand",{"$f":"B9-SUM(B14:B18)","v":-2.3305801732931286E-11},-3.028635120472245E-10,-3.2628122426103801E-11,-2.2714807812462823E-10,-2.6500579508592637E-10,-2.5636381906224415E-11]
[]
["Objective Function"]
["Cost =",{"$f":"SUMPRODUCT(B14:G18,B4:G8)+SUMPRODUCT(H14:H18,H4:H8)","v":48913.00000027402}]

{"sheet":"Figure 5-12","index":3,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,1,1,6],[11,1,11,6]]}
["Inputs - Costs, Capacities, Demands (for TelecomOptic)"]
[null,"Demand City\nProduction and Transportation Cost per 1000 Units",null,null,null,null,null,"Fixed ","Capa-"]
["Supply City","Atlanta","Boston","Chicago","Denver","Omaha","Portland","Cost ($)","city"]
["Baltimore",1675,400,685,1630,1160,2800,7650,18]
["Cheyenne",1460,1940,970,100,495,1200,3500,24]
["Salt Lake",1925,2400,1425,500,950,800,5000,27]
["Memphis",380,1355,543,1045,665,2321,4100,22]
["Wichita",922,1646,700,508,311,1797,2200,31]
["Demand",10,8,14,6,7,11]
[]
["Decision Variables"]
[null,"Demand City - Production Allocation (1000 Units)",null,null,null,null,null,"Plants"]
["Supply City","Atlanta","Boston","Chicago","Denver","Omaha","Portland","(1=open)"]
["Baltimore",0,8.0000000003028635,2.0000000018171828,0,0,0,1]
["Cheyenne",0,0,0,6.0000000002271472,6.9999999993564135,11.000000000416437,1]
["Salt Lake",0,0,0,0,0,0,0]
["Memphis",10.000000000378579,0,11.999999998712827,0,9.0859231249851291E-10,0,1]
["Wichita",0,0,0,0,0,0,0]
[]
["Constraints"]
["Supply City","Excess Capacity"]
["Baltimore",{"$f":"I4*H14-SUM(B14:G14)","v":7.9999999978799536}]
["Cheyenne",{"$f":"I5*H15-SUM(B15:G15)","v":0}]
["Salt Lake",{"$f":"I6*H16-SUM(B16:G16)","v":0}]
["Memphis",{"$f":"I7*H17-SUM(B17:G17)","v":0}]
["Wichita",{"$f":"I8*H18-SUM(B18:G18)","v":0}]
[]
[null,"Atlanta","Boston","Chicago","Denver","Omaha","Portland"]
["Unmet Demand",{"$f":"B9-SUM(B14:B18)","v":-3.7857894596982078E-10},-3.028635120472245E-10,-5.3000981381501333E-10,-2.2714718994620853E-10,-2.6500579508592637E-10,-4.1643666293111892E-10]
[]
["Objective Function"]
["Cost =",{"$f":"SUMPRODUCT(B14:G18,B4:G8)+SUMPRODUCT(H14:H18,H4:H8)","v":47401.000001618915}]

{"sheet":"Table 5-4 Single Sourcing","index":4,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[1,1,1,6],[20,1,20,6],[11,1,11,6]]}
["Inputs - Costs, Capacities, Demands (Table 11.4 for TelecomOptic)"]
[null,"Demand City\nProduction and Transportation Cost per 1000 Units",null,null,null,null,null,"Fixed ","Capa-"]
["Supply City","Atlanta","Boston","Chicago","Denver","Omaha","Portland","Cost ($)","city"]
["Baltimore",1675,400,685,1630,1160,2800,7650,18]
["Cheyenne",1460,1940,970,100,495,1200,3500,24]
["Salt Lake",1925,2400,1425,500,950,800,5000,27]
["Memphis",380,1355,543,1045,665,2321,4100,22]
["Wichita",922,1646,700,508,311,1797,2200,31]
["Demand",10,8,14,6,7,11]
[]
["Decision Variables"]
[null,"Demand City Supplied (1 indicates Cities Supplied)",null,null,null,null,null,"Plants"]
["Supply City","Atlanta","Boston","Chicago","Denver","Omaha","Portland","(1=open)"]
["Baltimore",0,0,0,0,0,0,0]
["Cheyenne",0,0,0,0,0,0,0]
["Salt Lake",0,0,0,1,0,1,1]
["Memphis",1,1,0,0,0,0,1]
["Wichita",0,0,1,0,1,-1.1102230246251565E-16,1]
[]
["Resulting Production Allocation"]
[null,"Demand City - Production Allocation (1000 Units)"]
["Supply City","Atlanta","Boston","Chicago","Denver","Omaha","Portland"]
["Baltimore",{"$f":"B14*B$9","v":0},0,0,0,0,0]
["Cheyenne",0,0,0,0,0,0]
["Salt Lake",0,0,0,6,0,11]
["Memphis",{"$f":"B17*B$9","v":10},8,0,0,0,0]
["Wichita",0,0,14,0,7,-1.2212453270876722E-15]
[]
["Constraints"]
["Supply City","Excess Capacity"]
["Baltimore",{"$f":"I4*H14-SUMPRODUCT(B14:G14,$B$9:$G$9)","v":0}]
["Cheyenne",{"$f":"I5*H15-SUMPRODUCT(B15:G15,$B$9:$G$9)","v":0}]
["Salt Lake",{"$f":"I6*H16-SUMPRODUCT(B16:G16,$B$9:$G$9)","v":10}]
["Memphis",{"$f":"I7*H17-SUMPRODUCT(B17:G17,$B$9:$G$9)","v":4}]
["Wichita",{"$f":"I8*H18-SUMPRODUCT(B18:G18,$B$9:$G$9)","v":10}]
[]
[null,"Atlanta","Boston","Chicago","Denver","Omaha","Portland"]
["Demand",{"$f":"SUM(B14:B18)","v":1},1,1,1,1,0.99999999999999989]
[]
["Objective Function"]
["Cost =",{"$f":"SUMPRODUCT(B23:G27,B4:G8)+SUMPRODUCT(H14:H18,H4:H8)","v":49717}]