77%(26)20 out of 26 people found this document helpful
This preview shows page 1 - 5 out of 6 pages.
Question 1Furniture TypeDeskChairContribution$400.00 $250.00Units Produced200400Max Profit$ 180,000.00Wood Required per unit43Resource constraintsUsedAvailableAvailable Wood2000<=2000ChairsDesksMarketing restrictions400>=400number of chairs prodA furniture company manufactures desks and chairs. Each desk uses four units of wood, and each chairthat the number of chairs produced be at least twice the number of desks produced. There are 2000 un
duced be at least twice the number of desks producedr uses three units of wood. A desk contributes $400 to profit, and a chair contributes $250. Marketingnits of wood available.
Microsoft Excel 15.0 Answer ReportWorksheet: [Book2]Sheet1Report Created: 2/21/2015 1:27:21 PMResult: Solver found a solution.All Constraints and optimality conditions are satisfied.Solver EngineEngine: GRG NonlinearSolution Time: 0.031 Seconds.Iterations: 3 Subproblems: 0Solver OptionsMax Time Unlimited,Iterations Unlimited, Precision 0.000001, Use Automatic ScalingConvergence 0.0001, Population Size 100, Random Seed 0, Derivatives Forward, Require Bounds
You've reached the end of your free preview.
Want to read all 6 pages?
Chair,Marketing restrictions,Available Wood Used,Units Produced Desk