On To Customer Acquisition

Let's go back to our spreadsheet (click here).

Plug in optimized housefile values in the key cells.

• D6 = 0.700.
• D7 = 0.250.
• D8 = 0.100.
• D9 = 0.100.
• D10 = 0.100.
• D11 = 0.450.
• D12 = 0.300.
• D13 = 0.300.
• D14 = 0.200.
• D15 = 0.100.

Now, let's run another simulation. Plug different values into cell D17, until you maximize/optimize profit in Year 10. What value in cell D17 accomplishes this task?

You have 24 hours to complete your homework assignment.