reviewing customer data and creating discount options for different marketing campaigns, as well as generating a summary table to analyze the number of customers receiving various levels of discounts.

Review the customer data found on the marketing campaign Excel spreadsheet Download marketing campaign Excel spreadsheet to consider what you know about the customers.
Demographics: age, income level, gender
Inside member or not
Total past purchase(s)
Total purchases in the past six months
Total purchases in the past year
Campaign Options
Campaign 1: Give members 10% discount and no discount for non-members
Campaign 2: give customers who have purchased more than $1000 in the past year, 40% off, more than $500, 30% off
Campaign 3: give customers who have purchased more than $1000 in the past year, 40% off, more than $500, 30% off, more than $250, 20%
Campaign 4: Give card members who have purchased more than $800 in the past year and more than $200 in the past six months 50% off.
Campaign 5: Give members (no matter how much they have purchased), or customers who have purchased more than $800 in the past six months 40%
Campaign 6: Give members who have purchased more than $1000 in the past year 40% off, give the rest of members 20% 0ff, give nonmembers who have purchased more than $500 in the past six months 10%.
Campaign 7:40% for member whose past year purchase is between $1500-$2000
30%, $1000-$1500
20%, $500-$1000
15%, $250-$500
10%, $100-$250
0,0-$100
Campaign 8: give a cash back of 5% of their purchase in the past 6 months with $40 maximum cash back, calculate the cash back value for each customer.
Campaign 9: give a cash back of 5% of their purchase in the past 6 months with $5 minimum cash back, calculate the cash back value for each customer.
Download the Marketing Campaign Excel document Download Marketing Campaign Excel document, using the Excel document,
Generate the discount for each customer in each campaign (9 columns representing the 9 campaigns)
Based on the first seven columns created in #1 (campaigns 1-7), create a summary (6 x 7) table that provides an overview of the number of customers who are given different levels of discount (0, 10%, 20%, 30%, 40%, 50%). NOTE: Please identify a general formula that can be applied to all cells in the summary table.