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.




Profit per New Customer

It's common for folks to measure cost per new customer. Total Marketing Cost = $10,000. Total New Customers = 130. Cost per New C...