Marketing Research

Marketing Research - Microsoft Excel 11.0 Answer Report Worksheet[Book1]Sheet1 Report Created 12:13:28 PM Target Cell(Min Cell Name $C$15 Min Cost

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

View Full Document Right Arrow Icon
Microsoft Excel 11.0 Answer Report Worksheet: [Book1]Sheet1 Report Created: 6/8/2009 12:13:28 PM Target Cell (Min) Cell Name Original Value Final Value $C$15 Min Cost line DC 0 20320 Adjustable Cells Cell Name Original Value Final Value $C$13 # of interviews DC 0 240 $D$13 # of interviews DN 0 240 $E$13 # of interviews EC 0 160 $F$13 # of interviews EN 0 360 Constraints Cell Name Cell Value Formula Status Slack $C$18 HH with Children Consumption 400 $C$18>=$E$18 Binding 0 $C$19 HH without Children Consumption 600 $C$19>=$E$19 Not Binding 200 $C$20 Evening Interviews Consumption 40 $C$20>=$E$20 Not Binding 40 $C$21 Evening with Children Consumption 0 $C$21>=$E$21 Binding 0 $C$22 Evening without Children Consumption 0 $C$22>=$E$22 Binding 0 $C$23 Total Interviews Consumption 1000 $C$23=$E$23 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 11.0 Sensitivity Report Worksheet: [Book1]Sheet1 Report Created: 6/8/2009 12:13:28 PM Adjustable Cells Final Reduced Objective Allowable Cell Name Value Cost Coefficient Increase $C$13 # of interviews DC
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.

This note was uploaded on 12/04/2010 for the course ACCT 3200 taught by Professor Martin during the Fall '08 term at Kennesaw.

Page1 / 6

Marketing Research - Microsoft Excel 11.0 Answer Report Worksheet[Book1]Sheet1 Report Created 12:13:28 PM Target Cell(Min Cell Name $C$15 Min Cost

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