LP 3 Problem 1b b How many coffee tables and bookcases should be produced if

# Lp 3 problem 1b b how many coffee tables and

• Notes
• 6
• 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 Report Variable 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