{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Answer Report 1","Sensitivity Report 1","Hoth solution","Battle of Hoth"],"not_rendered":{"images":3,"macros":1,"defined_names":57},"read":"whole","date_system":"1900"}

{"sheet":"Answer Report 1","index":0,"n_rows":32,"n_cols":7,"rows_kept":32}
["Microsoft Excel 14.3 Answer Report"]
["Worksheet: [Hoth_Skis_3.xlsx]Hoth solution"]
["Report Created: 3/2/2014 9:43:20 PM"]
[" Result:  Solver found a solution.  All constraints and optimality conditions are satisfied."]
[" Solver Engine "]
[null," Engine:   Simplex LP "]
[null," Solution Time:  0.579139  Seconds. "]
[null," Iterations:  4  Subproblems:  0"]
[" Solver Options "]
[null," Max Time   Unlimited ,  Iterations   Unlimited ,  Precision  0.000001,  Use Automatic Scaling "]
[null," Max Subproblems   Unlimited ,  Max Integer Sols   Unlimited ,  Integer Tolerance  1%,  Assume NonNegative "]
[]
[]
[" Objective Cell  (Max)"]
[null,"Cell","Name","Original Value","Final Value"]
[null,"$E$26","Profit Contribution Total Profit",0,{"v":750,"d":"$750.00"}]
[]
[]
[" Variable Cells "]
[null,"Cell","Name","Original Value","Final Value"," Integer "]
[null,"$B$16","Quantity Produced At-At",0,0," Contin "]
[null,"$C$16","Quantity Produced Snow Speeder",0,14," Contin "]
[null,"$D$16","Quantity Produced Tauntaun",0,2," Contin "]
[]
[]
["Constraints"]
[null,"Cell","Name","Cell Value","Formula","Status","Slack"]
[null,"$E$17","Assembly Hours Used",64,"$E$17<=$E$6","Not Binding",20]
[null,"$E$18","Finishing Hours Used",21,"$E$18<=$E$7","Binding",0]
[null,"$E$19","Equipping Hours Used",30,"$E$19<=$E$8","Binding",0]
[null,"$E$20","Feeding Hours Used",4,"$E$20<=$E$9","Not Binding",6]
[null,"$E$23","Market mixture  Excess Snow Speeder",14,"$E$23>=0","Not Binding",14]

{"sheet":"Sensitivity Report 1","index":1,"n_rows":20,"n_cols":8,"rows_kept":20}
["Microsoft Excel 14.3 Sensitivity Report"]
["Worksheet: [Hoth_Skis_3.xlsx]Hoth solution"]
["Report Created: 3/2/2014 9:43:20 PM"]
[]
[]
[" Variable Cells "]
[{"$nulls":3},"Final","Reduced","Objective","Allowable","Allowable"]
[null,"Cell","Name","Value","Cost","Coefficient","Increase","Decrease"]
[null,"$B$16","Quantity Produced At-At",0,-25,75,25,1E+30]
[null,"$C$16","Quantity Produced Snow Speeder",14,0,50,1E+30,0]
[null,"$D$16","Quantity Produced Tauntaun",2,0,25,0,9.375]
[]
["Constraints"]
[{"$nulls":3},"Final","Shadow","Constraint","Allowable","Allowable"]
[null,"Cell","Name","Value","Price","R.H. Side","Increase","Decrease"]
[null,"$E$17","Assembly Hours Used",64,0,84,1E+30,20]
[null,"$E$18","Finishing Hours Used",21,0,21,1.5,2.25]
[null,"$E$19","Equipping Hours Used",30,25,30,3,2]
[null,"$E$20","Feeding Hours Used",4,0,10,1E+30,6]
[null,"$E$23","Market mixture  Excess Snow Speeder",14,0,0,14,1E+30]

{"sheet":"Hoth solution","index":2,"n_rows":26,"n_cols":5,"rows_kept":26,"merged":[[3,1,3,3]]}
["The Battle of Hoth"]
[]
["Data"]
[null,"Product"]
["Department","At-At","Snow Speeder","Tauntaun","Limitation (hours)"]
["Assembly",6,4,4,{"$f":"12*7","v":84}]
["Finishing",1,1.5,0,{"$f":"3*7","v":21}]
["Equipping",4,2,1,{"$f":"10*3","v":30}]
["Feeding",0,0,2,{"$f":"2*5","v":10}]
[]
["Profit/unit",{"v":75,"d":"$75.00"},{"v":50,"d":"$50.00"},{"v":25,"d":"$25.00"}]
[]
[]
["Products"]
[null,"At-At","Snow Speeder","Tauntaun"]
["Quantity Produced",0,14,2,"Hours Used"]
["Assembly",{"$f":"B6*$B$16","v":0},{"$f":"C6*$C$16","v":56},{"$f":"D6*$D$16","v":8},{"$f":"SUM(B17:D17)","v":64}]
["Finishing",{"$f":"B7*$B$16","v":0},{"$f":"C7*$C$16","v":21},{"$f":"D7*$D$16","v":0},{"$f":"SUM(B18:D18)","v":21}]
["Equipping",{"$f":"B8*$B$16","v":0},{"$f":"C8*$C$16","v":28},2,30]
["Feeding",{"$f":"B9*$B$16","v":0},{"$f":"C9*$C$16","v":0},4,4]
[]
[{"$nulls":4},"Excess Snow Speeder"]
["Market mixture ",{"$nulls":3},{"$f":"C16-2*B16","v":14}]
[]
[{"$nulls":4},"Total Profit"]
["Profit Contribution",{"$f":"B11*$B$16","v":0},{"$f":"C11*$C$16","v":{"v":700,"d":"$700.00"}},{"$f":"D11*$D$16","v":{"v":50,"d":"$50.00"}},{"$f":"SUM(B26:D26)","v":{"v":750,"d":"$750.00"}}]

{"sheet":"Battle of Hoth","index":3,"n_rows":26,"n_cols":5,"rows_kept":26,"merged":[[3,1,3,3]]}
["The Battle of Hoth"]
[]
["Data"]
[null,"Product"]
["Department","At-At","Snow Speeder","Tauntaun","Limitation (hours)"]
["Assembly",6,4,4,{"$f":"12*7","v":84}]
["Finishing",1,1.5,0,{"$f":"3*7","v":21}]
["Equipping",4,2,1,{"$f":"10*3","v":30}]
["Feeding",0,0,2,{"$f":"2*5","v":10}]
[]
["Profit/unit",{"v":75,"d":"$75.00"},{"v":50,"d":"$50.00"},{"v":25,"d":"$25.00"}]
[]
[]
["Products"]
[null,"At-At","Snow Speeder","Tauntaun"]
["Quantity Produced",0,0,0,"Hours Used"]
["Assembly"]
["Finishing"]
["Equipping"]
["Feeding"]
[]
[{"$nulls":4},"Excess Snow Speeder"]
["Market mixture "]
[]
[{"$nulls":4},"Total Profit"]
["Profit Contribution"]