Describe how to use excel to find list of targeting people

Reference no: EM1367690

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 business from your prospects who have physical addresses in the same zip code as your business location. Respond fully to the following questions regarding this task:

A - Explain how you will use Excel to find in your list the people you are targeting for new business. Be specific.
B - You have used your computer skills to develop and print a beautiful flyer, and you intend to mail it to your prospects. However, you dread hand addressing the envelopes. Explain how you might use Excel to make this go faster.
C - If you get the results you expect to get from contacting your prospects, 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 - Your list is extensive, and mailing letters is expensive. Cost is $15 for every 50 letters mailed. You want to gauge the impact on your income statement of mailing 50, 100, 200, and 400 letters. Explain how you might evaluate this using your Excel tools.

Reference no: EM1367690

Questions Cloud

Monopoly over production : What is the profit-maximizing level of output of master cream (in bottles)? What is the profit-maximizing price? What is the maximum level of profit?

Cultural diversity of the nursing profession : There presently exists a broad discrepancy between the cultural diversity of the nursing profession and that of the general population. What strategies do you think might be employed to offset this discrepancy?

Which nation produce chevrolets also produce toyotas : Utilizing productive efficiency as guide, which nation should produce Chevrolets and which should produce Toyotas.

Oligopolistic market and monopolist market : What are the advantages and disadvantages of the oligopolistic structure? How would an increase in a monopolist's fixed costs affect its profit-maximizing choice of price and quantity?

Describe how to use excel to find list of targeting people : You own your own small party supply and rental business. You maintain an Excel list of potential customers. Describe how you will use Excel to find in your list the people you are targeting for new business. Be specific.

Geographically divided markets : A monopolist sells in two geographically divided markets, the East and West. Marginal cost is constant at $50 in both markets. Demand and marginal revenue in each and every market are as follows:

Why two cars drive on a straight highway : At the same time, car 2 is 1.2 east of mile marker 0 travelling at 30 due wests. Car 1 is speeding up with an acceleration of magnitude 0.20, and car 2 is slowing down with an acceleration of magnitude 0.60.

Faculty role in nursing education : Those who are teaching in the college setting as nursing educators rapidly learn that the role of the faculty takes on many faces. What is your definition of the faculty role in nursing education?

What will be the speed of the last car as it passes : A 95 long train begins uniform acceleration from rest. The front of the train has a speed of 25 while it passes a railway worker who is standing 170 from where the front of train started. What will be the speed of the last car as it passes the wor..

User Account

All Pages