solver cattle wheat

# Solver cattle wheat - \$B\$10 Minimum Herd-size Policy Forumula 113.64 \$B\$11 Minimum Bushles Policy Forumula 193181.82 Microsoft Excel 10.0 Limits

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

Microsoft Excel 10.0 Answer Report Worksheet: [Book1]Sheet1 Report Created: 10/29/2007 10:43:23 AM Target Cell (Max) Cell Name Original Value Final Value \$B\$5 Objective Function (profit) 0 470454.55 Adjustable Cells Cell Name Original Value Final Value \$B\$2 Cattle 0 113.64 \$B\$3 Wheat Bushels 0 193181.82 Constraints Cell Name Cell Value Formula Status \$B\$8 Acerage Forumula 5000 \$B\$8<=\$D\$8 Binding \$B\$9 Water Forumula 5,000,000 \$B\$9<=\$D\$9 Binding \$B\$10 Minimum Herd-size Policy Forumula 113.64 \$B\$10>=\$D\$10 Not Binding \$B\$11 Minimum Bushles Policy Forumula 193181.82 \$B\$11>=\$D\$11 Not Binding

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

View Full Document
Slack 0 0 63.64 143181.82
Microsoft Excel 10.0 Sensitivity Report Worksheet: [Book1]Sheet1 Report Created: 10/29/2007 10:43:23 AM Adjustable Cells Final Reduced Cell Name Value Gradient \$B\$2 Cattle 113.64 0 \$B\$3 Wheat Bushels 193181.82 0 Constraints Final Lagrange Cell Name Value Multiplier \$B\$8 Acerage Forumula 5000 30.45 \$B\$9 Water Forumula 5,000,000

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: \$B\$10 Minimum Herd-size Policy Forumula 113.64 \$B\$11 Minimum Bushles Policy Forumula 193181.82 Microsoft Excel 10.0 Limits Report Worksheet: [Book1]Limits Report 1 Report Created: 10/29/2007 10:43:23 AM Target Cell Name Value \$B\$5 Objective Function (profit) 470454.55 Adjustable Lower Target Upper Target Cell Name Value Limit Result Limit Result \$B\$2 Cattle 113.64 113.64 470454.55 113.64 470454.55 \$B\$3 Wheat Bushels 193181.82 50000 155454.55 193181.82 470454.55 Solver Variables Cattle 113.64 Wheat Bushels 193181.82 Objective Function (profit) 470454.55 Constraints Forumula Sign Constant Acerage 5000 <= 5000 Water 5,000,000 <= 5,000,000 Minimum Herd-size Policy 113.64 >= 50 Minimum Bushles Policy 193181.82 >= 50000 Acres of Wheat 3863.64...
View Full Document

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

### Page1 / 5

Solver cattle wheat - \$B\$10 Minimum Herd-size Policy Forumula 113.64 \$B\$11 Minimum Bushles Policy Forumula 193181.82 Microsoft Excel 10.0 Limits

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

View Full Document
Ask a homework question - tutors are online