Question: solve questions. 9) A portion of the variable cells section of the sensitivity report in Excel appears in the table below. HOW many potential customers
solve questions.

9) A portion of the variable cells section of the sensitivity report in Excel appears in the table below. HOW many potential customers 1Lvill be reached by the optimal advertising campaign? A} 1?-7r' B) 3.990 (3) 42pm} D) cannotbe determined from the sensitivity report 10) "Which of these statements about the sensitivity report for the constraints is best? Final Shadow Constraint Allowable Allowable Cell Name Value Price RH. Side Increase Decrease SGSS Budget 3500 12 3500 2560 3440 All Only $940 of the advertising budget is being spent on this campaign. B) The advertising campaign needs another $2,560 to reach the maximum number of customers. C) It is possible to reach enough customers by spending only $60. D) For every $1 increase in the budget, the ad campaign can reach twelve more customers
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
