A B 1 Problem 6-13 C D E F G H I House Lawyer Doctor 4 Number of units 5 Profit 6 Constraints: 7 Labor Hours 8 Houses do LHS Sign RHS - A cleaning crew currently spends 6 hours per house cleaning eight houses every day, for a profit 13 of $15 per hour. The crew now wants to offer its services to other houses, as well as small 14 professional offices. The crew believes it will take 7 hours to clean the office of a lawyer and that 15 the profit for doing so will be $19 per hour. It will take 10 hours to clean a doctor's office and that 16 the profit for doing so will be $25 per hour. The crew can make 120 hours of labor available per day and does not want to cancel any of its existing house contracts. What is the best mix of homes and offices to clean per day to maximize profit? Remember that your solution must be in whole numbers. Clipboard Merge & Center - Currency 5 %9 9 Alignment Condition Formatting Number 1 Problem 6-18 K L M Andover Hamilton Easy Nebraska Southern Manuel Builders Rest Invest? (1 = Yes) 5 Exp return (S'000) 5 Constraints: 7 Cost (5000) 3 No more than 1 bond At least two utility O At least two regular 1 At least five total LHS Sign RHS Stockbroker Susan Drexler has advised her client as shown in the table below. NoN The client agrees to this list but provides several conditions: (1) No more than 3,000,000 can be invested, (2) the money is to be spread among at least five investments, (3) no more than one type of bond can be purchased, (4) at least two utility stocks must be purchased, and 1 (5) at least two regular stocks must be purchased. Formulate this as a 0-1 IP problem for Ms. Drexler to maximize expected return. Solve it by using Excel Expected Cost Return (thousand (thousand Andover municipal Olhando P6-13 can P6-18 26 P6-23 Font Merge & Center - $ % 9 4 Alignment Conditional Format Formatting Tible Number E Stockbroker Susan Drexler has advised her client as shown in the table below. L M N The client agrees to this list but provides several conditions (1) No more than $3,000,000 can be invested, (2) the money is to be spread 19 among at least five investments, (3) no more than one type of bond can be purchased, (4) at least two utility stocks must be purchased, and (5) at least two regular stocks must be purchased. Formulate this as a 0-1 IP problem for Ms. Drexder to maximize expected retum Solved by using Excel Expected Cost Return (thousand (thousand s) 25 $400 $1,000 $35 $100 $350 Andover municipal 26 bonds 27 Hamilton city bonds East Power & Light 28 Co. Nebraska Electric 29 Service Southern Gas and 30 Electric 31 Manuel Products Co. 32 Builders Paint Co. 33 Rest Easy Hotels Co. $30 $65 $700 $490 $270 $800 $500 $45 $20 $90 $50 34 35 P6-13 P6-18 P6-23