Assume the following marketing costs and profit values associated with an upcoming promotional campaign:

Promotional cost per Facebook Impression: $0.97

The net value of a paid order (including average billing costs): $15.67

Cost of an unpaid order (including average billing costs): $7.87

Also, assume the following probabilities of ordering and paying for three customers.

Probability of Probability of

Customer Ordering Not Paying

Mr. Gita 25% 07%

Ms. Nikita 36% 20%

Which customer is more profitable?

Show your result and work in EXCEL step by step.

Expected Profit – who is the most profitable

Answer rating: 100% (QA)

Expected profit from the customer Value of the paid order P... View the full answer