how to make a bar

625 Words2 Pages

Good stuff...be sure to note #1 below

All:

I have created a simple tool that I have given to our UPNY TeleSales reps to help them best identify which rate plan a customer should be on. It should be simple to use. In qualifying the customer, the rep enters the customers expected # of calls he/she will make on a daily basis (weekdays ONLY), and the program will calculate which America's Choice rate plan would be the least expensive, and which rate plan would give the customer the most value (given their usage).

The purpose of the sheet is to help UP-SELL to higher rate plans, focusing more on the VALUE of the plans vs. the COST.

The spreadsheet is LOCKED, prohibiting a rep from making any changes. It allows him/her to enter the # of phone calls the customer is expected to use daily (weekdays). This "should be" the only cell the rep needs to enter in, although one other cell is left UNLOCKED ... the average minutes/call. There are, in 2002, 21.75 weekdays/month, which is hard-coded in.

KEEP IN MIND, PLZ ... this is a simple tool to help guide the rep to which rate plan to suggest. It is not a full blown detailed report of what the customer will be billed. It should NOT be shown to customers. It takes simple assumptions into consideration (ie: should the customer still have >10% of his plan minutes left over at the end of the month or should the delta between two rate plans exceed $25 or more per month, the program will not recommend the next rate plan up). Keep in mind also that this is newly created and has not been tested yet by the reps. Should any reps find any errors or suggestions to improve it, please let me know and I will fix &/or enhance it. It should be self-explanatory, but I will be happy to go over it with anyone that asks. As I hear feedback from reps, I will make changes and send you out a new & improved version.

I am sending this to you in hopes that you might find it useful in your channels as well. If you wish to not receive future versions, just let me know.

INSTRUCTIONS:
1.) The simplicity is to have the reps probe to find out how many calls/weekday the customer is expecting to make. This program DOES NOT calculate "off-peak" airtime.

More about how to make a bar

Open Document