ID;PWXL;N;E
P;PGeneral
P;P0
P;P0.00
P;P#,##0
P;P#,##0.00
P;P#,##0_);;\(#,##0\)
P;P#,##0_);;[Red]\(#,##0\)
P;P#,##0.00_);;\(#,##0.00\)
P;P#,##0.00_);;[Red]\(#,##0.00\)
P;P"$"#,##0_);;\("$"#,##0\)
P;P"$"#,##0_);;[Red]\("$"#,##0\)
P;P"$"#,##0.00_);;\("$"#,##0.00\)
P;P"$"#,##0.00_);;[Red]\("$"#,##0.00\)
P;P0%
P;P0.00%
P;P0.00E+00
P;P##0.0E+0
P;P#\ ?/?
P;P#\ ??/??
P;Pm/d/yy
P;Pd\-mmm\-yy
P;Pd\-mmm
P;Pmmm\-yy
P;Ph:mm\ AM/PM
P;Ph:mm:ss\ AM/PM
P;Ph:mm
P;Ph:mm:ss
P;Pm/d/yy\ h:mm
P;Pmm:ss
P;Pmm:ss.0
P;P@
P;P[h]:mm:ss
P;P_("$"* #,##0_);;_("$"* \(#,##0\);;_("$"* "-"_);;_(@_)
P;P_(* #,##0_);;_(* \(#,##0\);;_(* "-"_);;_(@_)
P;P_("$"* #,##0.00_);;_("$"* \(#,##0.00\);;_("$"* "-"??_);;_(@_)
P;P_(* #,##0.00_);;_(* \(#,##0.00\);;_(* "-"??_);;_(@_)
P;FArial;M200
P;FArial;M200;SB
P;FArial;M200;SI
P;FArial;M200;SBI
P;EArial;M200
F;P0;DG0G8;SM0;M255
B;Y71;X9;D0 0 70 8
O;L;D;V0;K47;G100 0.001
F;W1 1 10
NN;Nsolver_adj;EHome2!R22C2:R27C7,Home2!R30C2:R35C7,Home2!R38C2:R43C7
NN;Nsolver_drv;E1
NN;Nsolver_est;E1
NN;Nsolver_itr;E100
NN;Nsolver_lhs1;ER50C2:R55C7
NN;Nsolver_lhs2;ER58C2:R63C4
NN;Nsolver_lhs3;ER66C2:R71C7
NN;Nsolver_lhs4;ER22C2:R27C7
NN;Nsolver_lhs5;ER30C2:R35C7
NN;Nsolver_lhs6;ER38C2:R43C7
NN;Nsolver_lin;E1
NN;Nsolver_num;E6
NN;Nsolver_nwt;E1
NN;Nsolver_opt;ER47C2
NN;Nsolver_pre;E0.000001
NN;Nsolver_rel1;E2
NN;Nsolver_rel2;E1
NN;Nsolver_rel3;E3
NN;Nsolver_rel4;E3
NN;Nsolver_rel5;E3
NN;Nsolver_rel6;E3
NN;Nsolver_rhs1;E0
NN;Nsolver_rhs2;ER58C6:R63C8
NN;Nsolver_rhs3;E0
NN;Nsolver_rhs4;E0
NN;Nsolver_rhs5;E0
NN;Nsolver_rhs6;E0
NN;Nsolver_scl;E0
NN;Nsolver_sho;E0
NN;Nsolver_tim;E100
NN;Nsolver_tmp;E0
NN;Nsolver_tol;E0.05
NN;Nsolver_typ;E1
NN;Nsolver_val;E0
F;SIDM3;Y1;X1
C;K"Homework 2, Management Science Techniques for Consultants"
F;SDM1;Y3
C;K"Production Data"
C;Y5;X2;K"P1"
C;X3;K"P2"
C;X4;K"P3"
C;X5;K"P4"
C;X6;K"P5"
C;X7;K"P6"
C;Y6;X1;K"Grinding"
C;X2;K0.5
C;X3;K0.7
C;X4;K0.5
C;X5;K0
C;X6;K0.2
C;X7;K0.3
C;Y7;X1;K"Horizontal"
C;X2;K0.2
C;X3;K0.3
C;X4;K0
C;X5;K0.3
C;X6;K0
C;X7;K0.4
C;Y8;X1;K"Vertical"
C;X2;K0.1
C;X3;K0
C;X4;K0.8
C;X5;K0
C;X6;K0.7
C;X7;K0
C;Y10;X1;K"Profit"
C;X2;K10
C;X3;K6
C;X4;K8
C;X5;K4
C;X6;K11
C;X7;K9
F;SDM1;Y12;X1
C;K"Demand"
C;Y13;K"August"
C;X2;K500
C;X3;K1000
C;X4;K300
C;X5;K300
C;X6;K800
C;X7;K200
C;Y14;X1;K"September"
C;X2;K600
C;X3;K600
C;X4;K200
C;X5;K500
C;X6;K400
C;X7;K300
C;Y15;X1;K"October"
C;X2;K300
C;X3;K500
C;X4;K200
C;X5;K10
C;X6;K500
C;X7;K400
C;Y16;X1;K"November"
C;X2;K200
C;X3;K300
C;X4;K500
C;X5;K500
C;X6;K200
C;X7;K800
C;Y17;X1;K"December"
C;X2;K0
C;X3;K100
C;X4;K400
C;X5;K100
C;X6;K1100
C;X7;K300
C;Y18;X1;K"January"
C;X2;K500
C;X3;K500
C;X4;K800
C;X5;K300
C;X6;K1000
C;X7;K500
F;SDM1;Y21;X1
C;K"Production (Decisions)"
C;Y22;K"August"
C;Y23;K"September"
C;Y24;K"October"
C;Y25;K"November"
C;Y26;K"December"
C;Y27;K"January"
F;SDM1;Y29
C;K"Inventory (Decisions)"
C;Y30;K"August"
C;Y31;K"September"
C;Y32;K"October"
C;Y33;K"November"
C;Y34;K"December"
C;Y35;K"January"
F;SDM1;Y37
C;K"Sales (Decisions)"
C;Y38;K"August"
C;Y39;K"September"
C;Y40;K"October"
C;Y41;K"November"
C;Y42;K"December"
C;Y43;K"January"
F;SIDM3;Y45
C;K"Model:"
F;SDM1;Y47
C;K"Profit:"
C;X2;K0;ER[-37]C*SUM(R[-9]C:R[-4]C)+R[-37]C[+1]*SUM(R[-9]C[+1]:R[-4]C[+1])+R[-37]C[+2]*SUM(R[-9]C[+2]:R[-4]C[+2])+R[-37]C[+3]*SUM(R[-9]C[+3]:R[-4]C[+3])+R[-37]C[+4]*SUM(R[-9]C[+4]:R[-4]C[+4])+R[-37]C[+5]*SUM(R[-9]C[+5]:R[-4]C[+5])-0.5*SUM(R[-17]C:R[-12]C[+5])
F;SDM1;Y49;X1
C;K"Conservation"
C;X3;K"(Production in time t + inventory in t-1 = sales in t + inventory in t)"
C;Y50;X1;K"August"
C;X2;K0;ER[-28]C-R[-20]C-R[-12]C
C;X3;K0;ER[-28]C-R[-20]C-R[-12]C
C;X4;K0;ER[-28]C-R[-20]C-R[-12]C
C;X5;K0;ER[-28]C-R[-20]C-R[-12]C
C;X6;K0;ER[-28]C-R[-20]C-R[-12]C
C;X7;K0;ER[-28]C-R[-20]C-R[-12]C
C;Y51;X1;K"September"
C;X2;K0;ER[-28]C+R[-21]C-R[-20]C-R[-12]C
C;X3;K0;ER[-28]C+R[-21]C-R[-20]C-R[-12]C
C;X4;K0;ER[-28]C+R[-21]C-R[-20]C-R[-12]C
C;X5;K0;ER[-28]C+R[-21]C-R[-20]C-R[-12]C
C;X6;K0;ER[-28]C+R[-21]C-R[-20]C-R[-12]C
C;X7;K0;ER[-28]C+R[-21]C-R[-20]C-R[-12]C
C;Y52;X1;K"October"
C;X2;K0;ER[-28]C+R[-21]C-R[-20]C-R[-12]C
C;X3;K0;ER[-28]C+R[-21]C-R[-20]C-R[-12]C
C;X4;K0;ER[-28]C+R[-21]C-R[-20]C-R[-12]C
C;X5;K0;ER[-28]C+R[-21]C-R[-20]C-R[-12]C
C;X6;K0;ER[-28]C+R[-21]C-R[-20]C-R[-12]C
C;X7;K0;ER[-28]C+R[-21]C-R[-20]C-R[-12]C
C;Y53;X1;K"November"
C;X2;K0;ER[-28]C+R[-21]C-R[-20]C-R[-12]C
C;X3;K0;ER[-28]C+R[-21]C-R[-20]C-R[-12]C
C;X4;K0;ER[-28]C+R[-21]C-R[-20]C-R[-12]C
C;X5;K0;ER[-28]C+R[-21]C-R[-20]C-R[-12]C
C;X6;K0;ER[-28]C+R[-21]C-R[-20]C-R[-12]C
C;X7;K0;ER[-28]C+R[-21]C-R[-20]C-R[-12]C
C;Y54;X1;K"December "
C;X2;K0;ER[-28]C+R[-21]C-R[-20]C-R[-12]C
C;X3;K0;ER[-28]C+R[-21]C-R[-20]C-R[-12]C
C;X4;K0;ER[-28]C+R[-21]C-R[-20]C-R[-12]C
C;X5;K0;ER[-28]C+R[-21]C-R[-20]C-R[-12]C
C;X6;K0;ER[-28]C+R[-21]C-R[-20]C-R[-12]C
C;X7;K0;ER[-28]C+R[-21]C-R[-20]C-R[-12]C
C;Y55;X1;K"January"
C;X2;K0;ER[-28]C+R[-21]C-R[-20]C-R[-12]C
C;X3;K0;ER[-28]C+R[-21]C-R[-20]C-R[-12]C
C;X4;K0;ER[-28]C+R[-21]C-R[-20]C-R[-12]C
C;X5;K0;ER[-28]C+R[-21]C-R[-20]C-R[-12]C
C;X6;K0;ER[-28]C+R[-21]C-R[-20]C-R[-12]C
C;X7;K0;ER[-28]C+R[-21]C-R[-20]C-R[-12]C
F;SDM1;Y57;X1
C;K"Hours"
C;X2;K"Grinding"
C;X3;K"Horiz"
C;X4;K"Vert"
F;SDM1;X5
C;K"Limit"
C;X6;K"Grinding"
C;X7;K"Horiz"
C;X8;K"Vert"
C;X9;K"(Hours used cannot be more than available hours)"
C;Y58;X1;K"August"
C;X2;K0;ESUMPRODUCT(R6C2:R6C7,R[-36]C:R[-36]C[+5])
C;X3;K0;ESUMPRODUCT(R7C2:R7C7,R[-36]C[-1]:R[-36]C[+4])
C;X4;K0;ESUMPRODUCT(R8C2:R8C7,R[-36]C[-2]:R[-36]C[+3])
C;X6;K1536;E24*16*4
C;X7;K768;E24*16*2
C;X8;K1152;E24*16*3
C;Y59;X1;K"September"
C;X2;K0;ESUMPRODUCT(R6C2:R6C7,R[-36]C:R[-36]C[+5])
C;X3;K0;ESUMPRODUCT(R7C2:R7C7,R[-36]C[-1]:R[-36]C[+4])
C;X4;K0;ESUMPRODUCT(R8C2:R8C7,R[-36]C[-2]:R[-36]C[+3])
C;X6;K1536;E24*16*4
C;X7;K768;E24*16*2
C;X8;K1152;E24*16*3
C;Y60;X1;K"October"
C;X2;K0;ESUMPRODUCT(R6C2:R6C7,R[-36]C:R[-36]C[+5])
C;X3;K0;ESUMPRODUCT(R7C2:R7C7,R[-36]C[-1]:R[-36]C[+4])
C;X4;K0;ESUMPRODUCT(R8C2:R8C7,R[-36]C[-2]:R[-36]C[+3])
C;X6;K1536;E24*16*4
C;X7;K768;E24*16*2
C;X8;K1152;E24*16*3
C;Y61;X1;K"November"
C;X2;K0;ESUMPRODUCT(R6C2:R6C7,R[-36]C:R[-36]C[+5])
C;X3;K0;ESUMPRODUCT(R7C2:R7C7,R[-36]C[-1]:R[-36]C[+4])
C;X4;K0;ESUMPRODUCT(R8C2:R8C7,R[-36]C[-2]:R[-36]C[+3])
C;X6;K1536;E24*16*4
C;X7;K768;E24*16*2
C;X8;K1152;E24*16*3
C;Y62;X1;K"December"
C;X2;K0;ESUMPRODUCT(R6C2:R6C7,R[-36]C:R[-36]C[+5])
C;X3;K0;ESUMPRODUCT(R7C2:R7C7,R[-36]C[-1]:R[-36]C[+4])
C;X4;K0;ESUMPRODUCT(R8C2:R8C7,R[-36]C[-2]:R[-36]C[+3])
C;X6;K1536;E24*16*4
C;X7;K768;E24*16*2
C;X8;K1152;E24*16*3
C;Y63;X1;K"January"
C;X2;K0;ESUMPRODUCT(R6C2:R6C7,R[-36]C:R[-36]C[+5])
C;X3;K0;ESUMPRODUCT(R7C2:R7C7,R[-36]C[-1]:R[-36]C[+4])
C;X4;K0;ESUMPRODUCT(R8C2:R8C7,R[-36]C[-2]:R[-36]C[+3])
C;X6;K1536;E24*16*4
C;X7;K768;E24*16*2
C;X8;K1152;E24*16*3
F;SDM1;Y65;X1
C;K"Unmet Demand"
C;X3;K"(Sales no more than demand I.e. Unmet demand >= 0)"
C;Y66;X1;K"August"
C;X2;K500;ER[-53]C-R[-28]C
C;X3;K1000;ER[-53]C-R[-28]C
C;X4;K300;ER[-53]C-R[-28]C
C;X5;K300;ER[-53]C-R[-28]C
C;X6;K800;ER[-53]C-R[-28]C
C;X7;K200;ER[-53]C-R[-28]C
C;Y67;X1;K"September"
C;X2;K600;ER[-53]C-R[-28]C
C;X3;K600;ER[-53]C-R[-28]C
C;X4;K200;ER[-53]C-R[-28]C
C;X5;K500;ER[-53]C-R[-28]C
C;X6;K400;ER[-53]C-R[-28]C
C;X7;K300;ER[-53]C-R[-28]C
C;Y68;X1;K"October"
C;X2;K300;ER[-53]C-R[-28]C
C;X3;K500;ER[-53]C-R[-28]C
C;X4;K200;ER[-53]C-R[-28]C
C;X5;K10;ER[-53]C-R[-28]C
C;X6;K500;ER[-53]C-R[-28]C
C;X7;K400;ER[-53]C-R[-28]C
C;Y69;X1;K"November"
C;X2;K200;ER[-53]C-R[-28]C
C;X3;K300;ER[-53]C-R[-28]C
C;X4;K500;ER[-53]C-R[-28]C
C;X5;K500;ER[-53]C-R[-28]C
C;X6;K200;ER[-53]C-R[-28]C
C;X7;K800;ER[-53]C-R[-28]C
C;Y70;X1;K"December"
C;X2;K0;ER[-53]C-R[-28]C
C;X3;K100;ER[-53]C-R[-28]C
C;X4;K400;ER[-53]C-R[-28]C
C;X5;K100;ER[-53]C-R[-28]C
C;X6;K1100;ER[-53]C-R[-28]C
C;X7;K300;ER[-53]C-R[-28]C
C;Y71;X1;K"January"
C;X2;K500;ER[-53]C-R[-28]C
C;X3;K500;ER[-53]C-R[-28]C
C;X4;K800;ER[-53]C-R[-28]C
C;X5;K300;ER[-53]C-R[-28]C
C;X6;K1000;ER[-53]C-R[-28]C
C;X7;K500;ER[-53]C-R[-28]C
E