100%(1)1 out of 1 people found this document helpful
This preview shows page 3 - 6 out of 6 pages.
LP-3 Problem 1b.b) How many coffee tables and bookcases should be produced if the profit per unit is $20 and $12respectively?
LP-4 Problem 2. The Sweet Smell Fertilizer Company markets bags of manure labeled “not less than 60 lbdry weight.” The packaged manure is a combination of compost and sewage wastes. To provide good-quality fertilizer, each bag should contain at least 30 lb of compost but no more than 40 lb of sewage. Each pound of compost costs Sweet Smell 5¢ and each pound of sewage costs 4¢. Use a graphical LP method to determine the least-cost blend of compost and sewage in each bag.
LP-5 Problem 2b. b) What should be the least-cost blend if each pound of compost and sewage cost 3¢ and 5¢respectively?
LP-6 Problem 3. Solve it Using Excel Solver. Each coffee table produced by Robert West Designers nets the firm a profit of $9. Each bookcase yields a $12 profit. West’s firm is small and its resources limited. During any given production period (of 1 week), 10 gallons of varnish and 12 lengths of high-quality redwood are available. Each coffee table requires approximately 1 gallon of varnish and 1 length of redwood. Each bookcase takes 1 gallon of varnish and 2 lengths of wood. Formulate West’s production-mix decision as a linear programming problem, and solve. How many tables and bookcases should be produced each week? What will the maximum profit be? Furniture Problem and Results in Excel X Y Coffee Tables Book cases Number of units 8.0 2.0 Profit $9 $12 $96.00 Constraints: Varnish 1 1 $10.00 <= 10 Redwood 1 2 $12.00 <= 12 LHS Sign RHS Furniture Formula View X Y Coffee Tables Bookcases Number of units Profit 9 12 =SUMPRODUCT(B6:C6,$B$5:$C$5) Constraints: Varnish 1 1 =SUMPRODUCT(B8:C8,$B$5:$C$5) <= 10 Redwood 1 2 =SUMPRODUCT(B9:C9,$B$5:$C$5) <= 12 LHS Sign RHS Sensitivity ReportVariable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$5 Number of units Coffee Tables 8 0 9 3 3 $C$5 Number of units Bookcases 2 0 12 6 3 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $D$8 Varnish 10 6 10 2 4 $D$9 Redwood 12 3 12 8 2