Chapter 36: Performing Spreadsheet What-If Analysis
751
FIGURE 36.6The setup for a two-input data table.
FIGURE 36.7This worksheet calculates the net profit from a direct-mail promotion.
On the CD
This workbook, named direct mail.xlsx, is available on the companion CD-ROM. n
This model uses two input cells: the number of promotional pieces mailed and the anticipated
response rate. The following items appear in the Parameters area:l Printing costs per unit: The cost to print a single mailer. The unit cost varies with the
quantity: $0.20 each for quantities less than 200,000; $0.15 each for quantities of
200,001 through 300,000; and $0.10 each for quantities of more than 300,000. The fol-
lowing formula is used:
=IF(B4<200000,0.2,IF(B4<300000,0.15,0.1))