A supermarket XYZ is determined to please its customers with a customer advantage card. Currently a certain percentage of all shoppers (given below) is loyal to XYZ. A loyal customer shops at XYZ some % of the time (also given below). Others shop at XYZ for a smaller % of time. A typical customer spends a given amount 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 the percentage of loyal customers and the percentage of time loyal customers will shop at XYZ is given below. These percentages will not change for others. What is the maximum cost of the advantage card per dollar and the profit per week for the program to be profitable (break even)? Average Spending/wk: $ 175.00 Profit margin per 1$: 0.04 Cohort size: Any (positive) cohort size Do not round this value. Cost of Advantage Card per 1$: Profit per week: CURRENT (NO CARD) Loyal to XYZ: Others: Cohort-based calculations: % of Time go Pct. to XYZ 30.0% 80.0% 10.0% Remember that you may add as many calcuated cells as needed. This model will be tested on different sets of input data. WITH ADVANTAGE CARD Expected increase: % of Time go Pct. to XYZ 10.0% 10.0%