Sunday, December 13, 2009

Retail Display Allowance:

RDA is the monies paid by a manufacturer to have their products on display, usually in a certain location.
It can also be defined as the decrease in the amount paid by a retailer to a manufacturer in exchange for a more prominent display of the product in the store or on the shelf.

Thursday, December 10, 2009

Percent Chart:

It is a control chart for evaluating the stability of a process in terms of the percentage of the total number of units in a sample in which an event of a given classification occurs. It is also referred to as a proportion chart.

Monday, December 7, 2009

Counting the number of values between upper and lower limit:

Problem:

Finding the number of values in List1 (Column A) that are larger than 20 and smaller than 50.

Solution:

Use the COUNTIF function as shown in the following formula:
=COUNTIF(A2:A7,"">20"")-COUNTIF(A2:A7,"">=50"")
Or use the SUMPRODUCT function as shown in the following formula:
=SUMPRODUCT((A2:A7>20)*(A2:A7<50))

Sunday, December 6, 2009

Push Items:

Push items are the products that receive maximum marketing and merchandising attention to increase their sales volume.

Wednesday, December 2, 2009

Use Copywriting principles for your presentations:

If you create presentations to sell or to persuade, deciding what you want to say, and in what order, is obviously extremely important. Copywriting is the best way to do so. Copywriting is usually defined as the art and science of writing to sell. From this process, copywriters have derived tried and true principles for effective selling and persuading.
The most common structure is called AIDA:
• Attention: Get attention.
• Interest: Keep interest
• Desire: Create desire
• Action: Spur action
Get attention
In traditional copywriting, you use the heading to get attention. In a presentation, the first words out of your mouth should get your audience's attention.
• Say or do something to get attention.
• Ask the audience a challenging question
• Display a striking, full-slide photo.
• Put a thought-provoking quote on a slide.
• Tell a meaningful story
Keep interest
You hold people's interest by:
• Making sure the content is relevant to your audience
• Providing information they don't know
• Using the Tell 'n' Show (SM) method to communicate visually
• Interacting with the audience, including eye contact, answering questions, and asking questions
Create desire
Create desire by showing the audience how they can benefit and what your points mean to them. Highly sensorial images also help. If you have customer testimonials, use them.
Spur action
At the end of your presentation, summarize what you've said and state your conclusion. Invite comments so that you have a chance to respond to any concerns. Finish by asking for the next step, whether it is signing a contract, approving a project, or setting up another meeting. Have the necessary materials (the contract, approval form, your calendar) so you can accomplish your goal.

Tuesday, December 1, 2009

Drag and Drop Calendar Rescheduling:

We don't have to open/edit a calendar entry in order to reschedule it. From a calendar view, you can drag and drop the entry to either a completely new date/time, or you can drag the start or end time to make the meeting longer or shorter.