2.3.11 B - An Example LP Pr An Example LP Pr Blue Ridge Hot...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: An Example LP Pr An Example LP Pr Blue Ridge Hot Tubs produces tw tubs: Aqua-Spas & Hydro-Luxes. There are 200 pumps, 1566 hou and 2880 feet of tubing available Aqua-Spa Pumps 1 Labor 9 hours Tubing 12 feet Unit Profit $350 Aqua-Spa Pumps 1 Labor 9 hours Tubing 12 feet Unit Profit $350 roblem roblem wo types of hot . urs of labor, le. Hydro-Lux 1 6 hours 16 feet $300 Hydro-Lux 1 6 hours 16 feet $300 Microsoft Excel 12.0 Answer Report Worksheet: [Solver Example 1-1A.xls]SLN Template Report Created: 02/03/2011 8:54:52 PM Target Cell (Max) Cell Name Original Value Final Value $D$4 Profit Total Profit $66,150 $66,000 Adjustable Cells Cell Name Original Value Final Value $B$2 Prod QTY Aqua 84 80 $C$2 Prod QTY Hydro 117 120 Constraints Cell Name Cell Value Formula Status Slack $D$7 Pump Required Resources 200 $D$7<=$F$7 Binding $D$8 Labor Required Resources 1440 $D$8<=$F$8 Not Binding 126 $D$9 Tubing Required Resources 2880 $D$9<=$F$9 Binding Microsoft Excel 12.0 Sensitivity Report Worksheet: [Solver Example 1-1A.xls]SLN TemplateWorksheet: [Solver Example 1-1A....
View Full Document

This note was uploaded on 05/09/2011 for the course MGMT 3100 taught by Professor Camateros during the Fall '08 term at CSU East Bay.

Page1 / 6

2.3.11 B - An Example LP Pr An Example LP Pr Blue Ridge Hot...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online