{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["SolverSimple"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":75,"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":"SolverSimple","index":0,"n_rows":56,"n_cols":6,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
["FROM:","Mark Biegert"]
["SUBJECT:","Simplex Model with Inefficiency And No Switchover Cost"]
["DATE:","2017-05-08"]
[]
["Model Description"]
[null,"Machine 1 and Machine 3 share the same electrical supply. The supply is only adequate to run one Machine at a time."]
[null,"Machine 2 can run full time, but can only make product A"]
[null,"I modeled plant efficiency as a simple fraction. I could model dead time, but it is more work. I thought this was a good start."]
[]
["Model Parameters"]
[null,"Inputs"]
[]
[null,"Mill","Product","Symbol","Up Time"]
[null,"Machine 1","Product A","_k1",0.85,"Machine 1 can only produce Product A"]
[null,"Machine 2","Product A","_k2",0.85,"Machine 2 can only produce Product A"]
[null,"Machine 3","Product B","_k3B",0.85,"Machine 3 can produce either Product B or C"]
[null,"Machine 3","Product C","_k3C",0.85,"Machine 3 can produce either Product B or C"]
[]
[null,"Product","Value","Unit"]
[null,"_Value_A",1,"Normalized $ Per Unit","The relative value of Product A"]
[null,"_Value_B",1,"Normalized $ Per Unit","The relative value of Product B"]
[null,"_Value_C",1,"Normalized $ Per Unit","The relative value of Product C"]
[null,"_Rate_A1",0.9,"units/hour","The production rate of Product A on Machine 1"]
[null,"_Rate_A2",1,"units/hour","The production rate of Product A on Machine 2"]
[null,"_Rate_B",1.3,"units/hour","The production rate of Product B on Machine 3"]
[null,"_Rate_C",2,"units/hour","The production rate of Product C on Machine 3"]
[null,"_Min_A",300,"units","Required minimum production of Product A"]
[null,"_Min_B",200,"units","Required minimum production of Product B"]
[null,"_Min_C",100,"units","Required minimum produciton of Product C"]
[]
["Solution Setup"]
[]
["Test Scenarios"]
[]
[null,"Radio Button","Scenario List","Expected Total"]
[null,null,"Basic Scenario",1728]
[null,null,"Product A Highest Value",10093]
[null,null,"Product B Highest Value",8018]
[null,null,"Product C Highest Value",9975]
[]
["Analysis Table"]
[]
[]
[null,"Parameter","Value","Comment"]
[null,"_T",720,"Assume one month hours (30 daysx24 hours per day) production"]
[null,"_T3B",180.99547511312218,"Time Machine 3 spends on Product B"]
[null,"_T3C",539.00452488687779,"Time Machine 3 spends on Product C"]
[null,"_T1A",{"$f":"_T-_T3B-_T3C","v":0},"Time Machine 1 spends on Product A"]
[null,"_Tsum",{"$f":"SUM(C46:C48)","v":720},"Total Time Machine 1 and 3 Operate"]
[null,"_Na",{"$f":"_Rate_A1*_k1*_T1A+_Rate_A2*_k2*_T","v":612},"Total Number of Product A's"]
[null,"_Nb",{"$f":"_Rate_B*_k3B*(_T-_T1A-_T3C)","v":200.00000000000003},"Total Number of Product B's"]
[null,"_Nc",{"$f":"_Rate_C*_k3C*_T3C","v":916.30769230769226},"Total Number of Product C's"]
[null,"_Va",{"$f":"_Value_A*_Na","v":612},"Value produced by Product A"]
[null,"_Vb",{"$f":"_Value_B*_Nb","v":200.00000000000003},"Value produced by Product B"]
[null,"_Vc",{"$f":"_Value_C*_Nc","v":916.30769230769226},"Value produced by Product C"]
[null,"Total Value",{"$f":"SUM(C53:C55)","v":1728.3076923076924},"Total Product Value from Machines 1-3"]