8671296_Question1 - Question 1 A furniture company manufactures desks and chairs Each desk uses four units of wood and each chair uses three units of

8671296_Question1 - Question 1 A furniture company...

This preview shows page 1 - 5 out of 6 pages.

Question 1 Furniture Type Desk Chair Contribution $ 400.00 $ 250.00 Units Produced 200 400 Max Profit $ 180,000.00 Wood Required per unit 4 3 Resource constraints Used Available Available Wood 2000 <= 2000 Chairs Desks Marketing restrictions 400 >= 400 number of chairs prod A furniture company manufactures desks and chairs. Each desk uses four units of wood, and each chair that the number of chairs produced be at least twice the number of desks produced. There are 2000 un
Image of page 1
duced be at least twice the number of desks produced r uses three units of wood. A desk contributes $400 to profit, and a chair contributes $250. Marketing nits of wood available.
Image of page 2
restrictions require
Image of page 3
Microsoft Excel 15.0 Answer Report Worksheet: [Book2]Sheet1 Report Created: 2/21/2015 1:27:21 PM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: GRG Nonlinear Solution Time: 0.031 Seconds. Iterations: 3 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling Convergence 0.0001, Population Size 100, Random Seed 0, Derivatives Forward, Require Bounds
Image of page 4
Image of page 5

You've reached the end of your free preview.

Want to read all 6 pages?

  • Spring '14
  • CHAKRABORTY
  • Chair, Marketing restrictions, Available Wood Used, Units Produced Desk

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture