An Excel worksheet that models the problem and use Solver to get a solution to the base case. Modify the worksheet and explore the consequences of each alternative.

Develop one worksheet for the problem and the options Save solutions for all options as scenarios - Save everything that changes on the worksheet for each option - not just the Solver By Changing Variable Cells A worksheet comparing the various options and results Add a worksheet with your recommended option for the problem - Include all details

Honest Abe Furniture manufactures tables and chairs and sells unfinished tables, unfinished chairs, finished tables, and finished chairs. A table requires 40 board ft of wood, and a chair requires 30 board ft of wood. Honest Abe's current supplier has 70,000 board ft of wood available for purchase at $1.25 per board ft each month. It takes 2 hours of skilled labor to manufacture an unfinished table or an unfinished chair. Three more hours of skilled labor will turn an unfinished table into a finished table, and 2 more hours of skilled labor will turn an unfinished chair into a finished chair. A total of 6,000 hours of skilled labor are available each month. Honest Abe's current labor cost is $15.75 per hour. All furniture produced can be sold. An unfinished table is sold for $110. A finished table is sold for $165. Unfinished chairs and finished chairs sell for $95 and $135 respectively. Honest Abe is considering changing suppliers. The new supplier can supply up to 90,000 board ft of wood per month but at an increased cost. The new cost is $1.35 per board ft. To change suppliers, Honest Abe would need to spend $5,000 up front. Make a recommendation on which supplier to use.

***** I Specifically need the constraints for the second scenario for the second supplier***