solver_farm

# solver_farm - Cell Name Original Value Final Value \$B\$2 COW...

This preview shows pages 1–3. Sign up to view the full content.

Melissa Pongrac 9:00 Microsoft Excel 10.0 Answer Report Worksheet: [Solver_Basics.xls]BASICS Report Created: 4/14/2008 9:34:20 AM Target Cell (Max) Cell Name Original Value Final Value \$B\$5 Objective function 0 470454.55 Adjustable Cells Cell Name Original Value Final Value \$B\$2 COW 0 113.64 \$B\$3 WHEAT 0 193181.82 Constraints Cell Name Cell Value Formula Status Slack \$B\$8 Acreage Formula 5000 \$B\$8<=\$D\$8 Binding 0 \$B\$9 Water Formula 5000000 \$B\$9<=\$D\$9 Binding 0 \$B\$10 Minimum herd policy Formula 113.64 \$B\$10>=\$D\$10 Not Binding 63.64 \$B\$11 Minimum wheat policy Formula 193181.82 \$B\$11>=\$D\$11 Not Binding 143181.82

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

View Full Document
Melissa Pongrac 9:00 Microsoft Excel 10.0 Answer Report Worksheet: [Solver_Basics.xls]BASICS Report Created: 4/14/2008 9:39:03 AM Target Cell (Max) Cell Name Original Value Final Value \$B\$5 Objective function 470454.55 470284 Adjustable Cells
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Cell Name Original Value Final Value \$B\$2 COW 113.64 113 \$B\$3 WHEAT 193181.82 193220 Constraints Cell Name Cell Value Formula Status Slack \$B\$8 Acreage Formula 4994.4 \$B\$8<=\$D\$8 Not Binding 5.6 \$B\$9 Water Formula 5000000 \$B\$9<=\$D\$9 Binding \$B\$10 Minimum herd policy Formula 113 \$B\$10>=\$D\$10 Not Binding 63 \$B\$11 Minimum wheat policy Formula 193220 \$B\$11>=\$D\$11 Not Binding 143220 \$B\$2 COW 113 \$B\$2=integer Binding Melissa Pongrac 9:00 Solver variables COW 113 WHEAT 193220 Objective function 470284 Constraints Formula Operator Constant Acreage 4994.4 <= 5000 Water 5000000 <= 5000000 Minimum herd policy 113 >= 50 Minimum wheat policy 193220 >= 50000 Whole cow 113 int integer Bushels/1000 acres 50000...
View Full Document

## This note was uploaded on 04/30/2008 for the course BUSN 111 taught by Professor Joy during the Spring '08 term at Gonzaga.

### Page1 / 3

solver_farm - Cell Name Original Value Final Value \$B\$2 COW...

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

View Full Document
Ask a homework question - tutors are online