ࡱ> M Pbjbj== !HWW@lL| | | 8  LE8X\($} zLLLLLLLzLhL vL0 | |0ELLX @Introduction to Solver This document is intended to introduce the use of Excel Solver to solve linear programming (LP) problems. We will use the example of Malcolms glass molding operation (see the Word files malcolm.doc, smalcolm.doc, and the Excel file malcolm.xls). The sample Excel screens shown here are from Excel 5.0; more recent versions of Excel have similar features. Maximize:Z=500X1+450X2Subject to:6 X1+5 X2(601 X1+0 X2(810 X1+20 X2(1501 X1+0 X2(00 X1+1 X2(0The Excel file malcolm.xls shows how to set up the problem for solution with Solver. Figure 1 shows the LP Formulation worksheet from malcolm.xls. When you set up a problem for Solver, you follow four steps: 1. Create a spreadsheet with all the information from the LP problem. In the example (Figure 1) you can see the LP information in the first 10 rows. 2. Specify the target cell (which contains the formula for the objective function) that you want to minimize, maximize, or set to a certain value. In MALCOLM.XLS, the target cell is F2, which contains the formula =+B4*B2+C4*C2. 3. Specify the changing cells (called decision variables in LP lexicon) that you want to be adjusted until a solution is found. You can specify up to 200 changing cells, but for this problem we only need 2. The number of cases of 6-oz. glasses to be produced appears in cell B2 (in hundreds of cases), and the number of cases of 10-oz. glasses to be produced appears in cell C2. It doesnt matter what exact values you put into these cells, because Solver will change them anyway, but you do need to put some feasible starting values in the cells. In this example the starting values are set to 1.  Figure 1 LP Formulation worksheet 4. Specify constraint cells that must fall within certain limits or satisfy target values. You can specify up to 500 constraints, 2 for each changing cell plus 100 additional constraints, representing a total of no more than 1000 cells in a problem. In this example there are five constraints. In the example, the constraint cells are D13 through D17. Each of these cells contains a formula which refers to the constraint matrix from B6 to D10. For example, cell D13 contains the formula =+B6*B2+C6*C2, cell D14 contains the formula =+B7*B2+C7*C2, and so forth. After setting up the problem, select Tools - Solver to open up the Solver Parameters dialog box (Figure 2).  Figure 2 Blank Solver Parameters dialog box In this dialog box, you specify (1) the target cell containing the formula for the objective function (F2 in the example); (2) the range of cells containing the decision variables, which Solver calls changing cells (B2.C2 in the example); (3) a set of constraints, clicking on the Add button to use the Add Constraint dialog box (Figure 3). Dont forget to choose the appropriate Equal to radio button for the problem; in this case we want to maximize profit so we select Max.  Figure 3 Add Constraint dialog box The completed Solver Parameters dialog box for the example problem appears as Figure 4.  Figure 4 Completed Solver Parameters dialog box After setting up the problem, click on the Solve button and wait for Solver to find a solution. You can create three types of reports that summarize the results of a successful solution process. For the purposes of this course, we are interested in the Answer Report (Figure 5) and the Sensitivity Report (Figure 6).  Figure 5 Answer Report In the Answer Report (Figure 5) we see several important facts about the Solver solution: (1) the solution will yield a profit of $5,142.85; (2) the solution calls for Malcolm to produce 642 cases of 6-oz glasses and 428 cases of 10-oz glasses; (3) the binding constraints (the constraints which prevent Malcolm from increasing his profit) are the limits on molding capacity and storage space. This is important information because it quickly tells Malcolm that there is no point in trying to increase sales of 6-oz glasses. From the information in the Sensitivity Report (Figure 6), we can make a number of inferences about the Solver solution, most of which are beyond the scope of this course. However, you should pay attention to the column called Shadow Price in the Constraints table. There is a shadow price associated with each of the constraints, as you can see in the table. The shadow price can be interpreted as the amount that the objective function would improve for every unit of relaxation in the constraint. For example, the shadow price associated with the Storage Space constraint is $2.86. This can be interpreted to mean that Malcolm can increase his profit if he can acquire additional storage space at less than $2.86 per unit. You may recall that storage space was defined in hundredths in our formulation, so Malcolm should be prepared to spend up to $.0286 per cubic foot per week for additional storage space.  Figure 6 Sensitivity Report Notes on using Solver: (1) Notice that the Solver solution suggests that Malcolm produce only 642 cases of 6-oz glasses. Remember that Malcolm only has one customer for this product and that she will buy no more than 800 cases. This is an example of an LP formulation that may be leaving out important information. It may be that this customer needs more than 642 cases and will abandon Malcolm as a supplier unless he can produce all the 6-oz glasses she needs. It would be possible to reformulate the problem with a new constraint, setting some minimum quantity of 6-oz glasses, but many of the nuances of management cannot be captured in a mathematical program. Malcolm may want to call his customer before implementing the solution and find out whether or not 642 cases will be satisfactory to her. He might decide to implement a sub-optimal plan, forgoing some profit this week in order to keep a loyal customer. The point here is that the results of any mathematical model ought to be scrutinized with common sense before being implemented. (2) Solver is a relatively new optimization tool, and does not yet completely replace older and more powerful software (e. g. Lindo, Storm, AMPL). In this class we are using Solver for its accessibility, as a vehicle to introduce basic concepts of linear optimization with a familiar spreadsheet package. To solve more complicated problems, you will probably want to take a course in mathematical programming or solicit the help of someone who has. (3) Some users have reported computational problems with Solver. There are some problems, for example, for which Solver comes up with different answers depending on the initial values of the changing cells. One way to help avoid problems with this is to solve your problem several times using different sets of initial changing cell values. (4) When selecting reports for Solver to generate, hold down the Shift key to select more than one type of report at a time. PAGE 1 PAGE 6 Decision Models Prof. Juran   "#$%  E S c  9Aj"OJQJUOJQJjOJQJU jCJOJQJ jCJOJQJCJH*OJQJ5CJOJQJ CJOJQJ CJ(OJQJH{ $(($Ifa$(($ @ ((a$ OHX;;;;; $(($Ifa$$$IfTlִ p{>tpkh 6    4 la;$$$IfTlִ p{>tpkh 6    4 la $(($Ifa$ $(($Ifa$HP;;;;; $(($Ifa$$$IfTlִ p{>tpkh 6    4 la;T$$IfTlִ p{>tpkh 6    4 la $(($Ifa$ $(($Ifa$HP;;;;; $(($Ifa$$$IfTlִ p{>tpkh 6    4 la;`$$IfTlִ p{>tpkh 6    4 la $(($Ifa$ $(($Ifa$  HP;;;;; $(($Ifa$$$IfTlִ p{>tpkh 6    4 la ;P$$IfTlִ p{>tpkh 6    4 la $(($Ifa$$&( $(($Ifa$()sB HBBBBBB(($$IfTlִ p{>tpkh 6    4 la  K@B_wEy:$((a$(( $$((a$Jv{HUi{@AB^_wR^ !'()*+HIJOP j{U0JmHnHu0J j0JUCJ(5>*CJOJQJjsOJQJUjMOJQJU5CJOJQJj:;OJQJUOJQJ CJOJQJje2OJQJU2:   +HIKLMNOP&`#$ @ (((( 0/ =!"#$%"Dd%<  C Abl"FkڈYg/ H"D2n@"FkڈYg/ PNG  IHDR,gAMAPLTEX pHYs+IDATxۖ: D0k:o=g:`KrERN* ؐ*჏ݏ~$K#!~~$f@>yl%̀1u[>O]K[jxlST`ȓmpTx,Q}-H5h^%y;U޽ lBxn\v2[|e-ydEe+ MyGAJ/A0oekk3x~"PdbT&|f<޴ezis (xK{VsoP}o+)̀uܺ2Jw Deg|32ɒ^Z.Oqtˀ"#/St|>|#u d,%*3`*KQGD e7}C^!W/ܲ oG,r3`涺|= 6!W/Gefnusye> zy4.ȀN \S5 JW]7ԥ]P˳^{ENVGke$YЬU6 6`%`xW[ߠNq{BrG뼒AfV-8[z`_pK})Дu UvR&bARo0Eu]5!%P.sT #}@ L!] eErS56HYUJ?}%eר>p3`-爌!*z[H'Wu;#.(GɺtJ෷pR d `au\,CJos3sh_NPVPGG5>qޗC5չiX;zDMAH8Vuk=ur%vqV֮gn\o3OK4"^ AR-lL}X6 ]KhvJa;qDt{C;8Z=|Π4[[O<a| Ei ɿz1C򩏓v[lC`9_L@Ro`?u@ w/TᵸSS mR ۛ`H:V0l>Y;@Jjgx%)6ԁNuĞRȃ ^EPϔ fճE\i!EUTGkp> ]s~ay> ]s~~ _y w#5j:A"Sb^j}6Ֆ!?ʕZ `cz涗e8ZۚU `I9.!p3cۼ,X(wp6';ݺxga~4_*~HrAu\8]16z.OnpyiRCNDDo&2+,oWD%ঠpJy<}(;uX`TYɭgW%h0#[fL 1zV'.B靟+Cu?zW^e5/엸yvW8vghB$sI [_׋,E( qE!{٧V{dкuvWoc\ЛjV'dxBCSjz9H >LZW^V .uKlw]DMۤZfƋXFVS"WQXߍܮp+CtC>Ik;&DXhqS0/H㚩Fp½ ,wCNN\Z>z-ZKPgm7*ܻ"ߊ_nyi8PnUO>i!F .h#`Ah~Q M+(rѫkA .0M:5|a@VT-'aC [_\Y(Aj F!b $(]AqSd%׮R nVs p7ܶ}n~DDDa\52)jʫkb4Z$'HO"uTP9Hnm74GpTX)H.1xMࢩ8|vLHt !Jc%F6hbǫ >h[}@{,Xx3yR=T7o "f>ߣGyIׅ(UCmg `=ܮ'=b_"@7?D"n~D& Abt F"n~D t$5!H!HOC t@$i$h$gWt@$'HOׄPׄ 1#@7?D"n~D[.ETlwlGҕѹǔeR@`XkP#i.fS^PޒW)=Vs#-O`߃Zoq(RNd!'K!wZٲ +ܻG^ˉ~E(]k-A7~.Z8j5l *l*X-!Ur Jxm̷v{7l_x.SBG ʀgdO%?e2a"Lw`BN\X8 j,Bҋ0D`^P/< xF]ࣣOXaHf'49DbơYb|p4VA̩ _/Ϳ@֞#?"n~B"n~^B]*^ gD t@$ܞ4L!̀ ` =G @`Rw @7h0}4L t@$> twB]qHO"@7?D"n~^B]*^ gD to5G#{6t31Qka]=@tMztܞoumݚ`ƪylO|!O3< 0eŕ#2͕ $e:-'X&$s@tÛ_M, uX?e5H9# t@$'HkBKkBl"@7?D"n~Ygt@g!$& wpA%Pi}< g >`06_'HN &X_D:@w<@$ľ`7?D"n~DyMuxM3M0t@$'HONa*8ߖ-.!oە"8(<{/Qe슺3lk3TowH%@h P)v6/Q 06cp- |T~"5Bkml36Dzf$}59resu"z]Se< B$+=!i2{Bľ`7?D"n~DyMuxM3M0t@$'HOFZ nNW{Bi5 `}iuR9"uFZM؜=!,5$]?D: vD " ;>"'8?'HO"@7? . Abt F"n~D Rs O^4M ׅ&oW ԕ@,M8` Xscp<`HG !J"@7?D"n~tQp@@6OD< ODC'Ϯ8$ t@$'HkBKkBl"@7?D"n~D8qJ%h0.]/h0Z3h0.a  &"n~D t@$'HϮ8$'HO"@7? . Abt F"n~D\o(6qK jˌb>4J!n۳ rJhϗA[al.mG?СsMKKzz2d~|ٔQP ,䩩vQ"X(̡u)E5ysML[S FA +bhNuSHQ 4A>R0S~X0`c0 z F("d<@7 ^E]i]`0g( % 8 {ñAbBܔ8+_Y:.B;LMّS< @7gD4<t @7]G59[@7 `u(!|Q!npT~39HPcW@7?'HO"@7? . Abt F"n~Dg;q]ƬNPgΗwYn`=K7[Gt `3슫U̽ ]=jF'v?|44 %c^ī`t|<՘ X*P3t*_/֚$mOi0Qk{DKd\ H@7]}Q |3xh 422 vOmP\Re~ $)QnkEKj/u/y b _APrP<Z^Iy-&5h)v+ k ` 8ُ`)ݒ}e?dx{@7? . Abt F"n~Dg'm#!F!S9gq]q5Me}$^FT9@?\0,.#r4@A @F&D~y? EϘ!jvn`U(ICBT , Z`]Y<@78pr `z"9%\)+ zHY e΅rB \ kh_P7hYhy0 $kBnXn_-myt+ļ`dt<,'N0z>Ch)| ް0"n~B"n~^B]*^ gD t5!å_ԁbO`<kڼ݋wg]Ε!@+f.&t3Sn`i`45Aȣ4Ma`H~Qv' J0 / B QTp7,u,>`0ANtm&p,S| AmD/ds:C#*T1vNthYhy0n z> &@+%h0@)Gt^\a^P37{'6>j^*a @>{Eoj}J6b/`&r~\-b=I-.L'X/P5"׊, u %NO^2}>x D& 2} 420 !{4ُ3fQG˻V`O2@h|]uFjD֏EF}&EȿIENDB`iDdo <  C Ab>پ}BqKn@#2n>پ}BqKnPNG  IHDR13gAMAPLTEX pHYsj 2IDATxݖ 8k uﮙV|&OY U2 R$b!5ZDv '2:2:2({M9[ΤqK|K0:b<31jڟZC Jlvo~mvMlٶn` r<PYf{ۮsyKsy2CmvJYY! ȐyswYܒ,ɶ# ]ϵWA?V:䟯k])sK@A' :됭WmXzivxHn̝ 붐ɵ@=-("[8A]W.B8`q@C {vQu=Z!<_UWQ;>e YP퐎:T-u^LLL3Ig6^Vid K [ա,ejؼ 2ȑ@Nti$2q k%C*!`4ޭx_d<#|E@2e@/t-d [k@! f <0THUҡ,#r{T~rE)ǺHRB@NB7DD@t!s.Q_"ԕ)tЗr wDwW8my7 ?^_ N@Q&Qh.tmEHwS Hv Me-`qȬTW p2PN:ΒG$͕@I@b !vk KOEQ䀄! :%0;;o,6Y@B j74+PklcHtYtEEB-$BeTeQK@8W]|EU;d!rqb&&k lht *D' eenTUX$H@N,LR;ĿJ=>~HGI-@ $~*U@fw Tc@Uu+֋>N c_y";W uJL=@ ;'Xb MF26~# `ot}lw@_OK? ķshrRY]@&i@^B [3]_G3 @*![ɺ>1s\%LrT*[n&)o d=PwPL@u dv @ @ @ @ @ @Ҥ|^IENDB`DdC~b<  C AbE7" 'ǵ#TM8Q!22n7" 'ǵ#TM8QPNG  IHDRC~~gAMAPLTEX pHYsjIDATxі Dyسn 43ULPb[^IFP(L?CK!Zg8zDyb9^/Qq |A9b8 /ssi-^b=UCھ惤%k dF3'$򱂢陜LXn8CenEkabIWcyfq!h_o}4+<\C oaj<0y$k3!szmx9(`E{k<S t3.IENDB`zDdo <  C Ab=r7t ߕn4~;2n=r7t ߕn4PNG  IHDR13gAMAPLTEX pHYsjCIDATx[ اuvg*$ Djj^C8՚J{W @dY]qĬ̿>>uuaiLjۆ_{.$谩=ch { JW[}֮w~XE+ϙ*򂶶}:ߩ>c910BdLk=/B̞٧DuA! d3Ȟy 4cB< leRemQu״> W͢0wY:)E)\=D&"L dzgAdxurL&(c{>4<5oDD6{ vHE@@LU:T臀5"tb6z+:k Z%)[&"LZwE*}5j-Rth܍H2j|]FLڸl,T/ D wYr htMl~j|͓|}34| KTUb{kSi `1(=<8LʫU!NF8..k6%C: ^0_bp1oT* ; @$ae麊QVdFiuDYP @hFDVQ1d(!͇\yW.< -*8|Vq@}oNaL~"Ճb R@Ha}$20ke@kjw ZKK<DflCYz8y4e `0SNl: &e[:B›O  f:RCR70pqQQcY @z G[t6jƀW~)U-Km*b@ WY@< :|yzWߛA~SFaT\j7 R&pȎ}ju0 @wcR)F~nr K[J\(F~b,E@"EM/`M끨t55t1r)aR ¤@I&"L@T;@.ޮ{IENDB`R%Dd%<  C Ab$T z3|\URD$M2n$T z3|\URDPNG  IHDR,gAMAPLTEX pHYs+ IDATxۚ( sQto;3]I{w[jȶ跀?(h~MKGPP61?]r<-`y?Oޖ>gLV9mHi MkmHO ʕ V`CDpZd-j.K&A (*OĹ rT58" cLIFZ_p9-`a-ΊR _tCnTZZN%3h5!1R=/x!7!(WX-@P.IӦ<7 VnIgPШuh }-g5Uǧ!zT)Xhu}7!u]>C#ԭ8 .\S5v>5X 9%?떧rs̳/V\䢐ȯ<. ǎP%@择J 0rBXYkyc-Ħ0P}Kshk 0:(@*"( B>48 ^`P P9g!Uhk!̙` ~~5\$(f_A=͏a5q_6X N|\0y%.8)97!U8sX+xy@/uqDU8\A @WD؃|,aD=@A<;Q 8?.C 8tW0\+?AT&J3_A‡Dv H(dPB`n4ՄQW;Ҡ@i'/LIlAf `ЯɃf V[U+w=WUttcm 5~e,*E N"q7^ y]04-nF-4fRK ΚcqQ#pQ#7!\+C_n/u̩.Y[9ՂVnK_u˽, xIK'_x|R#^_?9xR2U\Jax⩎_\|~Bf\iydzZE':~VcʡhU( El Fbȸc[+':(l':~[[!B|>vz^8~[a&K &qCj@6.nq"6 DϺ K}ӇIS!ϧYKS<{q,o`j x]LH.*p.*p]0. pt 0҇xUۇW VZex덊EkG$^V^3dvuZ8wةW=)`LKr[>WR~ py /5&ֲeWTH_!r".{JWOoE;aLpI_NitT eJ; 0{Z@G(pB*ZuK?ڮ]CZhq26W>@ 2z5]}sчZ PCo4T={w.ٝW^mN7}c ׮[lς+ pR/ / A \+ p@W @ \+ p4B Bw? 8W @ \+ p@W @ w@T`> p3+ p@W @ \+/:k={)-既m0!$ 5ŬW/ o oIܳ|҃)\ͧešC! 0,W.&wg?肁)z&[Dz's+K5݇4O8}]p`ЦQd &85U / |@ \+C_n/u̩.Y[9ՂVnK_u˽, xIK'_x|R#^_?9xR2U\Jax⩎_\|~Bf\iydzZE':~VcʡhU( El Fbȸc[+':(l':~[[!B|>vz^8~[a&K &qCj@6.nq"6 DϺ K}ӇIS!ϧYKS<{q,o`j x]LH.*p.*p]0. pt 0ryF^LVdYl؂x1{^-a17>F&uY)@l &j| y=GT).fU OH땈1>i^j' ZeP?7obb?Rĭ%8> Swঁh{Bj veh&*| \` \ԋG GW @ \+ p@W @ \+ p@W @ \+ p@W @ \+ p@W @ \+ pFA`-8*8Z)(x:u](o;[]nJS;HӷƅXAjT橅g@_J. Ѽ )6Ӗ ha 4.FhDN7V Qp@5z= p|p( p ?|;wfR+\I%^ GB}yZ' pJ÷)LEٮ/fFit8&6 ;/4Zo(V;_o9 dyAKO컧Y`'YQ_(j8mi8 #/ sd%*5wKZl> spJdW ,7#ʈ.˲H+nBjˉ  ,fFxH*x$"/" ‡¡.Dd^k@03-B͓(a_h*[@ktYdNnÔUȸ̨q"z.^@A/ϟ D7K9 +tAIe"BE2xev %Z@+m}]5 hK}aMpwa@t -F.O\/@@tygtl ^#;yܸ/@#i2BIo_ya`B*|p( p ƁFRbb%1R)Fej_ Gh'y ӊUkgMk=!-SA{KKbI_.-q)SZ.]k\V,3cBj!^48 ^p#e pei'%^|&LHA39fF39EQWquX},&RdU vkZ<RMR 1zZcnؾbY|!sK.QW8鲒H8㭑xF,hU85mOH%QBkQl KYw ̊}3YjRa*,ȪTUr\aE5mOH R/w=/? 襖: Oz5e)kQ"߄$ ]pM[zc6Y6W|ۯT|T0P @ \́;^;g +Lc)+NR(X1 Qpdof";E%$~1jUlN-*6>AR+c0A']㜐ZJJc]ptLH] ]ɔ_QŚLl,\` G߄kG-КiNB`+@qdG8LYzZ@83/ ʤSQ7 >yv\oY;5!< AD[?@ZxOmptLHyCjMuRbl85 Vنa'ϼ=xE\"tC?"76U>3l#ήdOH"9`](rⵠ¬3Iʦ^uF V*'*.R..[DJVEf(vT@ʂW'y!j$2`PTyLӫ?oH[ 7*+I,~2桉˫\pLNdZ\ [x( -@ivwC> SVa.֛yy}`'s@4fQw(,|~YYm)kL"\䛐d!YO\ސ₌ONbS8agNYpGui^#{C𙌰֤!٤<{CT0P @ \=5MH-ۀ9OXevЕ:ZF?i=S?oH j՜Sjv|5>ĥTǧ?,F"U3C՟7ʲ/\N +byS1E](kHT.H]1=!5ɔ_(͂£.'rdQlTymKDU`,1 OfT򿯭Xd ϝDbϨ<|A&’C;DU ,8ks?RѷW[1'Q;H@eʒ6Paɭ!#SO+@W.VLxC`2 qAĚ z(hFѭHY̤/!ZIT C3?oH%e 7*}čjU##E!n-EE¡fC8=!`ygK,oVG܀9`5DDu EH V2&J7H\d.9www#`[#t&E )7!B*Һ \{BjT6vti=!-tWR{ q1`B*/@@W @ \+ p@W @ \+ p@W @ \+ p@W @ \+ p@W @ \+ p@x % @\ @ \Y+ pO N.٠ a0 BGS%8T< ypu~ِu%WBY\J3]:%W°\bb9@Brߺm]e $ErEVAʼn\Krd$a}u'5S UUPL*@{HzL&׿d oF(̊k_Y5f5u5 `~& {S $%@RQ-@?|-{Fv;W"#- ϲdδ>,@ڔI}$%@E\'Y=ƿbM"l JNQy~sw끸Ε& &I8a K.@-_%mA m̦k(L6`o hJ {Jƺ`ћ6P2t(P 0k|{X iq$/ynؑ_&Pq+?"k~oB4 f6e2KX!VVm,nNh_a'IDAT!f0Y .`WhoLQ#KzzzYɺOzΘs w}< DpI|\Rs`IJٺ]B \$UX3unWyK* @_ x=eC'^&@ }yM@^Dif )n%xLP.‹(}y׀݀,{ l gR{jݪeu.O>HD@]IENDB`u$Dd%<  C Ab#~DZ3`ɖD3#Js2n#~DZ3`ɖD3PNG  IHDR,gAMAPLTEX pHYs+ IDATx[* 3kv^HBI4=|ogժ~E +Ÿ^x~(6)x(mB׺=#^c,k_+'kG OɲXT%oy`(>,#QG*g_+?YKz;֘V`C!ύ&|u$qNDEˢHrgkl+@yXqTǵe8?iQ" QH"ԗ8OR;T[U o ˄DoO)?5?N+Owu4U#`v"u'G@ԛ?ί6Z*Wi棺E@-Q[ >.5V-Q+o(>G5Zw[^ nB=?G֊?uG@_+Eɤ;=ݚ}] q}Fne:yޏ x{~UEr?b.q.Xml\t0{s!Pj5 }'16g F^iAj,&Qj;JJ`φc2 GSfBVˬmȰ+>Uv-DO `"^%r!re<4Iء{jDw7b.16 J0Fyd|N:dIye2B7J4QC!cc0ʻǦ[&̜ R@#'W @ \+SWf*k۾2%l|`eMޞ'*8ČbN \B|`6b: Nm; Iە&X*k%p(z)!!I<|̩i&_+Iic`5ZHXT ֽ~j!D s׀rbhd5:)ޟ)I6 ;sY[|7)U!?tlunZp8֊K`'N d= ša\$I^ãtJ[KRT4(j֦݆Y]*Z>Pw"4VsV Vv,kQz&-RѳFP%WZjQ6Y-L05%Ys8q$d178Fn@sV 3%Vz=p -Jh U>2ܬwK9)WzfM@ep)A8J#C~˺jRGN_")/tk!s̽}6yN1Xǖ'ԍwÝH?I\"i0S^R#5?kX QR1N֧ 0+ݝp'b% S+~VmROW:ߘ_+Ha}!G^49'`?Rtd(+9 ;!>GO/%% qثc,io]YZ([0hnZxʠs^]jY;w:Q.xv_UGw٬:' QE*~.8.vu@>nMyGˈb<:Zʫ:sNk:۱+ p'f,fY\ \+riB_)硽řWTM2ohmMQkCvOBȟ9!5 d_zE$vl ץ* ͘<;mlJWd|Lu'閊)f|ZG_ިGĢ8R-kd|IΘʺf)B`(rI#PqhF&3n=|<ֱoLzn:N-D&fް:bj&{X%4IǚaF @q 0 X ]–Vonz t<{=6Ch`iX٨}8#@DI1m捺HI{gVϘQc.8)l]dA>9 PF :6Z} )}xERǧZ)/rW`lMHպa">bX ~x ۾!޺Pla`iX C%XN] D"hGC --tʓsc1] 1`}Od)n+q{>T=IWw6Gߐj.>GCTqxZ+Rs*v\t ..AM-TI4z3yػÄT#-xn~Wrd;"C_ &;X W @pCĒ%1 'r+mVE=yzB@&\m7F-@wDRdʔ_>nJ>ccɪnNmM%,kUYLuQNڴ WbVoTRn6[;؜ǖL%[#,&9S#fSI"o5< Э)ݛه\^,Q%"%lC/~LSC򘤹KWe W>_1@&dJIggJb :gv>M;QSme. psu_6 9!uN4Qf&c;7dNnUYTfV ev*)md^2mˣQܬ>UeQl+e"wRE  bp;-SmEp@t}7cϯEnY@vIR, K+ p8nܧ8֙U|wY\fñUJr0UqTZm"ZJ-|A@jE65SNUv*bB*5:)@S}42IG?!*=i%=9?!5 D  [`kBj]zL%[#,ƥe`L,B=,[ Ѱ+-Dzxk|E؜*wHU1@e@(=T)MUY=! B O|C p ;4+qvBjl\ Sn冁h*Cs@}LYۥn''/[OHM^LHwW@W @ \+ p@W @ \+ p@W @ \+ p@W @ \+ p@W @ \+ p@W @ \+ p@W @ \+ p@W @ \+ p@W @ \+ p@W @ \+ p@W @ \+ p@W @ \+ pCH; \+}@W~x Bv]0p%  0\+!0 @p+G}nLf-,#bW@9w=ϿV7Kh<6i %K{1j\ GNsc(d]O$hNeo޳?FynKOF N ,/UkM\x4CiZd)_ V`QvPH,YީHM|A} /: fR맳R& *̤5OgHeߏ7_"@.}G\mÓѣ4x>“ѣ4d( <=J ބ'GiQx2z'GiQx2z'GiQ GƽݝW?qOl흝ݽ1 q08ww'O-?q\Gz=IO|}g'qx0 7gWVKb$qRG:竕J%9yx B_]}leeyiq9A\ӿ^>;8(L}Y@Vjl\ L /~~!lB>V+󋟝yX%;oք6( Wj;܂1+aՕcsy4!ݷoxGr 10 d"z'Q Pxsss*GL O}o<d\ 0Bz@/|l;vrtÞYp'O(bv(̀Tqn; ;޽+IU'bp `8!JW&|dO#1V5cĔ uH<֜>^d1frVOVY">bTK^_8@2NO`~gQtƭ5hKQ| EJB6Nո=8p$;@1~πB 2t1\ux@M{ aqHFj8H!v@a3] LPne&qZ/>x1GctR慪qD=721>crad!G%7!fM@pjuoP{Fwh7,FL/2&y0 " e85޾gQz8'{s5BG10u-LiCA}dT='2׽o=ӌ1'Ԇr.s˨;Cj&U*Gk2ݻwqD'Vrlג}Ln#$L#%mF{kHAJ o [ )2 ߹{/VдKH7!};_gC;ra^dl,.YR~Ճ"!貔f{8˨%W16'w~O<:>3>iR 7W玀vmF6!DB4Ż$]$$ .G4um cp!wZƷ sZr\ˇ{Ft,UN&P8]`{KRfd񴭮FF^BKչCbƎVI WiʹKV )TL+s_ IIS)Hs?w_43\DmaCw>"":N5g {bO )]@BFW+QȈQ/iؚ1ޕ;soK[I8qJ"<'!wPqQRI  g Dń 1Ӊ_s'cU=Xư"*]Hef0߼LB@+&m@k?g`Hg1 Ќ Z+ADF=s\v"X!SeL&,mc;"㿾ݛk'ikj'!nOWYdcqj륆BƆ1ԄiU2}+ v gɚƁ y̖RYǥ~od^8Ix#;D]KX36BAпĝ-W GJFbluU26D'܄SX$^q--Kj_UtE'KVa2wN㆘hF2oRr 8>=R2G-f~QsJyߒv\(sQ~Y2֭W5Fs ?RJ8>#UdmVTQ]ז۽7D6ytD.FY߽u2hH"ьXaz Ѝl{K#B![*񜡙(Ȇ!-քڄ%l6j<, %p߾u8 i(d+Ќk &1 y{LP'GirY ش*IǶ]d[-r(vcOŦ~!2?gxַ^N#:tos>cM}34ED@vNy87[" 4[3RǠsطNM4!ގL( nyKH64^NDfZp`&x1D ʝj rFlhYEҭ-'zA'6vb]klY9Hiȸ{gV4,> :C$YD ,K|Ŷڔm쵳Ө#akyG*@ztُuF.ۄvXؑy>RG+Xh2V2yߊ `M|D_†XlyF)YiR@^9ٴ!n]şC#fA]uS* ٖOFW.jtюQ'FwnŕsLIȐR:b BDl !db2:.)6Q-?ofܑ̣~]?A0OE(b!tit9p$+;퓂%$008u'N Q#h[݊\=6[`lb`2/Jw]tx kMb=ץ>,9@dҐt]#!"c;TpqqWl"cqG`3d7~s^l4f3&")OF72j;sE,6߹˫I ag{qDFAM5cx3FxUB`3Aqq'C |.YV62aƧ9g_1 bT,@a A3}dj꽾.;]|Z }㛗?s1ץ&[c0AoyzHPw=p k2Pif-Q,Se!7d4АN餳``kMNO1օW&AƔWXw 7o/qڨ:iu%\KsHI)x}yrȘףrU?$qe>䰒7^جhcubHdE~Ht7~ d562Zc[vƟ_i`0zgy 4c\|H KJkL2%9~n- +dXZНJ7^֬S'\ xE? L'gXQ2O=BєG-ss@8.zAhlXT6LHsԢa.'4vl MGEh%_||3[FBSp[I4#^ t ľ#:Q^.m(LD6[!#  P5å:L FAFRBl/._\k9'mk|u #q%|Et1X(olll?/V4`-*OD޺d,F+_\е%  ^S*"1QG )ot.(\Thd߿N'5ӑ-HMGj"l.K0е{@jEy},w$< :A:V͘OF.BƆTYd JBndpmC ȢV2~o}1/F7d@SlAM~ri|)=!V&U+2jX(9i7dDY4)IXg@6.P7Eƿ? ȫe!}F=6h> s(O4}[\Th7 0rX9!"S"s2h+h3~"3"wڝ&"KKKh'g GsM.8$tqL1#$$wjR7ʸ"U*YLeQLY;F)p3d]6n#WF^Jsll k?i$0jmwb4XrQ aB^X5#E\\{} a\w:&gW~R&n]5d-EoőQ[i"i'$Ș  \gaܞ3^m16NDI^rrQ[a2Ad#KW6-3sӃ8p=Ni+tZndMohX$wٚEՊA>U&)$@oryܷ322~hdw6lm;axeB)ـ)P3m[q$cO%#Q  UtEgYدsQDZ\d\JN&'O'xu+Qx8YYоE  2ޅLӌj'hr%բjErtEK;a*r)aȕcf|⅏5({Dip+~њAB^8?83 5G Dua@t dlբjEv85$*]Ѿ.[.xM3 P6fL32G Yq:;F-BJ' R$ZTh nnظ/_m!d!&~VQU j|QLq3vR?ubӖ+#TJV鋿;Ѧ9\r5r2?l#,.qBE0'ݓ5#*\X+Gɨ"Ӎ;(ȬV nb-<SE'K[uИQSSۃᡁNMHJEǨɸյ'c1P ;{-} j ьp3}NuӅXYFFKqT30έ=Pb=ǀ㫻A*{# ,Gpbd`ۤ8>ЌVHQb AaSA(X75q4f(љZ,d$lKQ-x%JƿF.}8} }ӏ~lC>Gi$?v Q,JN.ZE|X鰒Ν}$i&z.x?gwviL``+QS\g Xf1$DG +4ӏ5È.?%+S5;xgJRXZ1tv4F1uzf[[$[h.gaz)c;YwFFC@mU):i=j+\{W/ݡӁz^CW|,h .ᄅq}$=E|WX1:>=TS1cfF+NdO=JV 5<6>sO.}үlG!ڎTYХg̤!R ԦTU u%?أ < 2] Ȗs)k+FcdAEga&K]2X)M$Ѻ'&}dP8T.d|m嗖Hr5BcYь 4a180nr%idhS3n #c/.?Ēhl?ęǟ|:ь~t*y|9hBd%RWlYo m2)M K< w?|ri1+qT.GhMGl ^R Yh[tMXc#jl ! p!c2`j!a*#~{v q]'6c:[ )Ɠ&E{wS V?+OB,`ak#ƶPqBKީA`gbBi 1ȸwj)k0"> GF+d:qeWbl@F 3F`o ~8{~ɴnd^`ɫV3ҕWwŃدv}8QÍ'8Iɍ"4p Ҍ/gF\iud*pޛ&8zR/cS$+B_d2+|37<o#O:p:q"ILM =qJ;@5O6b#Ԋ5 t㧱Oia8?IW2^WU<(,&4ĥ *)g2W*JIB9'=.Cړ$v =5>Eg2w*![ºćV0:1[Z\b!a;E@cU9^%td65^ >#ȊSCSx,L c;Xu *ƮFt-YA)Fe'qP*#ha?OVrq{eyks _a5D<?@^!VA9U<:t0z 󈋔ب U,GPoq|@F ٓsGDo}t,L<[>P_'/⃿IUIDATk7*ǡ0dD@t777mxǽqqX14=MR6țw5 B@?ziP`7A0=< DSQ+a8%(bJZPOrv,/Otj9g!m::D vt.P)d̮҅=C\fM+O#\=)bhы*) k_.>j-.މd6J$Le4caub `T&5t! 5kG7k%#+/t[b{8<{-v^ %P@$>R7ޚ1¦S2gO]}3gJP# I@M&-\|t}HD)/X2GoeČVl{l+V(I3(EsOz&Bn0H1N˼b}F5M;S-!`hkZc~z% gOd~NcҬl:5뙈;ldM͸bLZC͹oJV,#%#M`%#[ gZ{SIT 55vi2i 5|Smb8dVwk/FL EԬg7 LZC͹i̐p[9҄cͺ#=SCQ;Ll&7A(s-LjBw ?, (FmRC~S/~6͆"d$1SYJΰL0vZ@"> Plain Text1$OJQJhtH uPH z z z z z z, yPU{  $&()sB   K @B_wEy:   +HIKLMQ000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000@0@0@0@0@000000000000000000:=?BP" ( :P !#OP B!! Qmz  ! - IWQ:::::::: David JuranC:\WINDOWS\DESKTOP\downhill.doc David Juran G:\TEACH\B6015\CBS_S00\blank.doc David Juran G:\TEACH\B6015\CBS_S00\blank.doc David Juran G:\TEACH\B6015\CBS_S00\blank.doc David Juran H:\TEACH\B6015\CBS_S00\blank.docdjuran E:\TEACH\B6015\CBS_S00\blank.doc David JuranD:\DM\B6015\Cbs_spr00\blank.doc David JuranD:\DM\B6015\Cbs_sum01\blank.doc David Juran D:\DM\B6015\Cbs_sum01\solver.doc David Juran D:\DM\B6015\Cbs_sum01\solver.doc0. P = Fz0M FQ6R es 0^`056() hh^h`OJQJo( hh^h`OJQJo(hh^h`.hh^h`.z0MesP =Q6R0{  $&()Q@ py P`@UnknownG:Times New Roman5Symbol3& :ArialABook Antiqua?5 :Courier New"qh KT& KT&;fO /">0e2Q Stern School of Business David Juran Oh+'0  4 @ L Xdlt| f Stern School of Business0ter Normal.dotl David Juran3viMicrosoft Word 9.0i@G@!%@ê@O ՜.+,D՜.+,@ hp  New York University/ e  Title 8@ _PID_HLINKSA 8I$G:\TEACH\B6015\CBS_S00\6015logo.gif  !"#$&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~Root Entry F .Data %\1TableWordDocument!HSummaryInformation(DocumentSummaryInformation8CompObjjObjectPool . .  FMicrosoft Word Document MSWordDocWord.Document.89q