Targeting for new business, Computer Engineering

Assignment Help:

Assume you own your own small party supply and rental business. You keep an Excel list of potential customers and clients who have rented or purchased from you in the past 2 years. The list has both physical mailing addresses and e-mail addresses for every person listed. You have a “category“code to demonstrate whether the contact is a client. If they have done business with you, they demonstrate 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 produce your business, and feel the best way to do this is to solicit business from customers who show a physical address in the similar zip code as your business location. Respond fully to the following questions regarding this task:
 
A - Describe how you will use Excel to find in your list the people you are targeting for new business. Be specific.
B - You want to send a letter to every person on your list from Part A of this question. You have a nice form letter that you have used in the past. Explain how you might personalize the letter by adding your customer names.
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 - You want to gauge the impact of mailing to only your customers, to only your prospects, or to everyone on your list. You have the numbers for each group, the estimated cost per letter, and the expected increase in income for each letter mailed. What Excel tools might you use to see the anticipated outcome for each of the three situations?


Related Discussions:- Targeting for new business

What are the attributes of the method, What are the attributes of the metho...

What are the attributes of the method? During implementation a process is characterized by various attributes maintain by the system: Its state Its identification

Keyboard status word generator, Q.  Write short note on Interfacing Keyboar...

Q.  Write short note on Interfacing Keyboard, giving block diagram. Why do we need to introduce circuitry called Keyboard Status Word Generator?

Define macros, Define macros.   A macro is a pre-processor directive wh...

Define macros.   A macro is a pre-processor directive which is a program that processes the source code before it passes by the compiler. These are placed in the source program

How can we pass selection and parameter data to a report, How can we pass s...

How can we pass selection and parameter data to a report? There are three options for passing selection and parameter data to the report. Using SUBMIT...WITH Using a rep

Illustrate the system architecture, Question: a) Explain why pervasive...

Question: a) Explain why pervasive computing can be termed as a "technology that disappears". b) List and describe four main components of a MOTE used in Wireless Sensor N

Flowchart, How to calculate the flowchart

How to calculate the flowchart

Gnome, Explain briefly about GNOME desktop

Explain briefly about GNOME desktop

What are the advantages of segmentation, What are its advantages? How is se...

What are its advantages? How is segmentation implemented in typical microprocessors? The first benefit that memory segmentation has is that only 16 bit registers are necessary

Write your array of text into file, Part I: 1. The program starts by prin...

Part I: 1. The program starts by printing your initial with an end sign ">". For example, "cjx >"; 2. Then, you can type in the following "vi filename". For example, "vi myp.c

Explain virtual address, What is virtual address? The binary address th...

What is virtual address? The binary address that the processor used for either instruction or data known as virtual address.

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd