Question

A supermarket XYZ is determined to please its customers with a customer advantage card. 30 % percent of all shoppers (given below) is loyal to XYZ. A loyal customer shops at XYZ 80 % of the time. Others shop at XYZ for 10% of the time. A typical customer spends 150.00 each week. This amount as well as the profit margin is the same for loyal customers and others at XYZ. The advantage card is expected to increase 20% of loyal customers and 20% percentage of time loyal customers will shop at XYZ. What is the maximum cost of the advantage card per dollar and the profit per week for the program to be profitable (breakeven)? ***Please use Goal Seek***

Answer 1