Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions

Question

Explain the importance of industry analysis

Answered: 1 week ago