November 16, 2015

On To Customer Acquisition


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.