{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Welcome","HistData","DemoData","SCurve","Optimize","TradeOff"],"not_rendered":{"charts":3,"images":3,"macros":1,"external_links":0,"defined_names":260,"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":"Welcome","index":0,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["©2005 Seref, Ahuja, and Winston"]

{"sheet":"HistData","index":1,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[null,"Customer","Number of Calls","Unit Sales","Profit / Sale","Cost / Call","Total Profit"]
[null,"DELL",318,1791,20,2,{"$f":"D7*$E$8-C7*$F$8","v":43185}]
[null,"GATEWAY",326,443,25,5,{"$f":"D8*$E$9-C8*$F$9","v":9211}]
[null,"HP",325,694,23,3,{"$f":"D9*E9","v":15962}]
[null,"IBM",314,574,26,6,{"$f":"D10*E10","v":14924}]
[null,"MSFT",301,1294,29,8,{"$f":"D11*E11","v":37526}]
[null,"SONY",320,1789,20,4,{"$f":"D12*E12","v":35780}]
[]
[null,null,null,null,null,null,{"$f":"SUM(HistRevenues)","v":156588}]

{"sheet":"DemoData","index":2,"n_rows":21,"n_cols":14,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[null,"Computer Products",null,null,null,null,null,null,"Unit Sales Estimates"]
[null,"Customer","Num Calls","Unit Sales","Rev/Sale","Cost/Call","Total Rev",null,"Customer",0.1,0.5,"--",1.5,10]
[null,"DELL",318,1791,20,2,{"$f":"D8*$E$8-C8*$F$8","v":35184},null,"DELL",500,850,1791,2600,4770]
[null,"GATEWAY",326,443,25,5,{"$f":"D9*$E$9-C9*$F$9","v":9445},null,"GATEWAY",150,230,443,2000,4890]
[null,"HP",325,694,23,3,{"$f":"D10*E10","v":15962},null,"HP",350,450,694,2300,4875]
[null,"IBM",314,574,26,6,{"$f":"D11*E11","v":14924},null,"IBM",200,415,574,2100,4710]
[null,"MSFT",301,1294,29,8,{"$f":"D12*E12","v":37526},null,"MSFT",430,800,1294,2200,4515]
[null,"SONY",320,1789,20,4,{"$f":"D13*E13","v":35780},null,"SONY",480,880,1789,2640,4800]
[]
[]
[null,"Cell Phone Plans",null,null,null,null,null,null,"Unit Sales Estimates"]
[null,"Customer","Num Calls","Unit Sales","Rev/Cust","Cost/Call","Total Rev",null,"Customer",0.1,0.5,"--",1.5,10]
[null,"ATT",310,1357,15,2,{"$f":"D18*E18","v":20355},null,"ATT",450,750,1357,2000,3500]
[null,"CINGULAR",338,1624,14,2.2999999999999998,{"$f":"D19*E19","v":22736},null,"CINGULAR",550,820,1624,2200,4500]
[null,"TMOBILE",311,1011,16,2.5,{"$f":"D20*E20","v":16176},null,"TMOBILE",380,630,1011,1600,3000]
[null,"VERIZON",306,414,14,2.8,{"$f":"D21*E21","v":5796},null,"VERIZON",100,300,414,480,1450]

{"sheet":"SCurve","index":3,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Customer","DELL"]
[null,"Revenue / Sale",20]
[null,"Cost / Call",2]
[null,null,null,null,"($1000s)",null,"($1000s)","($1000s)"]
[null,"Multiple","Number of Calls","Unit Sales","Estimated Profit",null,"Calculated Profit","Error",null,"Parameters"]
[null,0.1,{"$f":"B14*NumCalls","v":31.8},500,{"$f":"(CustRev*D14-CustCost*C14)/1000","v":9.936399999999999},null,{"$f":"(Aparam+((Bparam-Aparam)*C14^Cparam)/(Dparam+C14^Cparam))/1000","v":9.0560951413901609},{"$f":"(E14-G14)^2","v":0.77493664409208707},null,"a",8716.1860863388374]
[null,0.5,{"$f":"B15*NumCalls","v":159},850,{"$f":"(CustRev*D15-CustCost*C15)/1000","v":16.681999999999999},null,{"$f":"(Aparam+((Bparam-Aparam)*C15^Cparam)/(Dparam+C15^Cparam))/1000","v":17.191419725422794},{"$f":"(E15-G15)^2","v":0.25950845664983585},null,"b",83414.454146103875]
[null,"--",318,1791,{"$f":"(CustRev*D16-CustCost*C16)/1000","v":35.183999999999997},null,{"$f":"(Aparam+((Bparam-Aparam)*C16^Cparam)/(Dparam+C16^Cparam))/1000","v":34.830228202550607},{"$f":"(E16-G16)^2","v":0.12515448467057233},null,"c",2.0703458750622494]
[null,1.5,{"$f":"B17*NumCalls","v":477},2600,{"$f":"(CustRev*D17-CustCost*C17)/1000","v":51.045999999999999},null,{"$f":"(Aparam+((Bparam-Aparam)*C17^Cparam)/(Dparam+C17^Cparam))/1000","v":50.13190507278663},{"$f":"(E17-G17)^2","v":0.8355695359572155},null,"d",282170.00972401659]
[null,10,{"$f":"B18*NumCalls","v":3180},4770,{"$f":"(CustRev*D18-CustCost*C18)/1000","v":89.04},null,{"$f":"(Aparam+((Bparam-Aparam)*C18^Cparam)/(Dparam+C18^Cparam))/1000","v":82.25094978957074},{"$f":"(E18-G18)^2","v":46.091202759729669}]
[null,null,null,null,null,null,"Minimize SSE",{"$f":"SUM(H14:H18)","v":48.086371881099382}]

{"sheet":"Optimize","index":4,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Upper Bound on Total Number of Calls"]
[]
[]
[null,"Customer","Lower Bound","Number of Calls","Upper Bound","Unit Sales","Profit / Sale","Cost / Call","Total Profit"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[]
[null,null,null,{"$f":"SUM(CallsDV)","v":0},null,null,null,null,{"$f":"SUM($I$16:$I$17)","v":0}]

{"sheet":"TradeOff","index":5,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":true,"merged":[[8,1,8,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Varrying Upper Bound on Total Number of Calls"]
[null,"Min","Max","Step Size"]
[]
[]
[null,"Upper Bound on Total Number of Calls","Total Overall Revenue"]
[]
[]
[null,null,null,1.0725020000000001]
[null,null,null,1.0725020000000001]
[null,null,null,1.0725020000000001]
[null,null,null,1.0725020000000001]
[null,null,null,1.0725020000000001]
[null,null,null,0]
[null,null,null,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0]