Marketing Research SOLVED IN CLASS

Marketing Research SOLVED IN CLASS - Microsoft Excel 12.0...

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: [Marketing Research SOLVED IN CLASS.xlsx]Sheet1 Report Created: 9/8/2010 5:32:17 PM Target Cell (Min) Cell Name Original Value Final Value $B$14 Min DC 20320 20320 Adjustable Cells Cell Name Original Value Final Value $B$12 Interviews DC 240 240 $C$12 Interviews DN 240 240 $D$12 Interviews EC 160 160 $E$12 Interviews EN 360 360 Constraints Cell Name Cell Value Formula Status Slack $B$17 Interviews LHS 1000 $B$17=$D$17 Not Binding 0 $B$18 HH w/children LHS 400 $B$18>=$D$18 Binding 0 $B$19 HH w/o children LHS 600 $B$19>=$D$19 Not Binding 200 $B$20 Evening LHS 40 $B$20>=$D$20 Not Binding 40 $B$21 Evening w/children LHS 0 $B$21>=$D$21 Binding 0 $B$22 Evening w/o children LHS 0 $B$22>=$D$22 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: [Marketing Research SOLVED IN CLASS.xlsx]Sheet1 Report Created: 9/8/2010 5:32:17 PM Adjustable Cells Final Reduced Objective Allowable Cell Name Value Cost Coefficient Increase $B$12 Interviews DC 240 0 20 5 $C$12 Interviews DN
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 6

Marketing Research SOLVED IN CLASS - Microsoft Excel 12.0...

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