number 8 - Report Created: 11/28/2010 3:14:38 PM Adjustable...

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

View Full Document Right Arrow Icon
Microsoft Excel 12.0 Answer Report Worksheet: [Book1]Sheet1 Report Created: 11/28/2010 3:14:38 PM Target Cell (Max) Cell Name Original Value Final Value $B$9 Total Profit used 32.5 32.5 Adjustable Cells Cell Name Original Value Final Value $B$4 Bowls Production 25 25 $B$5 Mugs Production 0 0 Constraints Cell Name Cell Value Formula Status Slack $B$7 labor hours used 100 $B$7=$C$7 Not Binding 0
Background image of page 1

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

View Full DocumentRight Arrow Icon
Microsoft Excel 12.0 Sensitivity Report Worksheet: [Book1]Sheet1
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: Report Created: 11/28/2010 3:14:38 PM Adjustable Cells Final Reduced Cell Name Value Gradient $B$4 Bowls Production 25 $B$5 Mugs Production-0.27 Constraints Final Lagrange Cell Name Value Multiplier $B$7 labor hours used 100 0.17 Beaver Creek Pottery Production Profit per unit Bowls 25-$0.50 Mugs $8.00 used avaliable labor hours 100 100 Total Profit 32.5...
View Full Document

Page1 / 3

number 8 - Report Created: 11/28/2010 3:14:38 PM Adjustable...

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