You own your own computer repair business. You maintain an Excel list of clients who have contacted you for repairs in the past two years and a referral list for potential customers. 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 referred to you by existing customers, they are coded as PROS for prospect.
You want to grow your business, and feel the best way to do this is to put together an outreach program for recycling old computers for use in the local community center. You feel this would be a good way to reach new customers by introducing your company and outreach program. Respond fully to the following questions regarding this task:
A - You want to be able to separate your customers from your referrals. Explain how you would do this using Excel.
B - You want to send a letter to each referral, but you don't want it to sound impersonal. Explain how you might achieve this using your Excel file.
C - If you get the results you expect to get from contacting your referrals, you want to be able to do this every six months. Explain how you might use Excel to automate the process of separating your list as you did in Part A.
D - You anticipate that your income will increase by 2% 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.