You own your own small party supply and rental business. You maintain an Excel list of potential customers and clients who have rented or purchased...

You own your own small party supply and rental business. You maintain an Excel list of potential customers and clients who have rented or purchased from you in the past two years. The list includes both physical mailing addresses and e-mail addresses for each person listed. You have a “category“ code to show whether the contact is a client. If they have done business with you, they show a code of “CUST” for customer. If they are potential customers who have not yet purchased or rented from you, they are coded as “PROS” for prospect. You want to grow your business, and feel the best way to do this is to solicit additional business from past customers. Respond fully to the following questions regarding this task:A - (TCO 4) You want to be able to separate your customers from your prospects. Explain how you would do this using Excel. B - (TCO 8) You want to send a letter to each customer, but you don’t want it to sound impersonal. Explain how you might achieve this using your Excel file. C - (TCO 7) If you get the results you expect to get from contacting your customers, you want to be able to do this every month. Explain how you might use Excel to automate the process of separating your list as you did in Part A. D - (TCO 6) You anticipate that your income will increase by 2 percent over the next two months for each 50 letters sent. You want to gauge the impact on your sales of mailing 50, 100, 150, and 200 letters. What Excel tools would you use to evaluate the possible outcome of mailing at each level? Explain.