Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Problem 3: The Outdoor Furniture Corporation manufactures two products, benches and picnic tables, for use in yards and parks. The firm has two main resources
Problem 3: The Outdoor Furniture Corporation manufactures two products, benches and picnic tables, for use in yards and parks. The firm has two main resources labor and redwood, linear program has been formulated to solve the problem of how many benches (defined as x1) and how many picnic tables (defined as x2) to produce in the next production cycle so as to obtain the largest possible profit. The printout below shows the optimal solution and sensitivity reports for this LP obtained from ExcelSolver. Microsoft Excel Answer Report Target Cell (Max) Cell Name $D$7 Total Profit Original Value Final Value 4250 Name Adjustable Cells Cell $B$5 $C$5 Original Value 0 Final Value 125 0 constraints Cel Cel Value Bindir SD$10 SD$11 Labor Used (hours) Redwood Used (feet) 1725 $D$10
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started