solver_farm

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

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full DocumentRight Arrow Icon
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
Background image of page 2
Background image of page 3
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 Right Arrow Icon
Ask a homework question - tutors are online