please help, need to use excel to solve

N M Solver settings: Solver is used must be saved. 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 15: 0.04 Cohort site: 100 Any (positive cohort site Cost of Advantage Card per 1$: Profit per week: Do not round this valut Remember that you may add as many calcuated cells as needed CURRENT (NO CARD) Pet. Loyal to XYZ: 30.0% Others: 70.0% Cohort-based calculations: % of Time go % of time go to XYZ elsewhere 80.0% 20.0% 10.0% 90.0% This model will be tested on different sets of input data, % of Time go WITH ADVANTAGE CARD Pet. to XYZ Expected increase : 10.0% 10.0%