Master Data Management > Inventory

Main Menu > Master Data Management > Inventory > Scheme & Promotion

Scheme and Promotion produce very pronounced effects to retail business. It is indisputable that Scheme and Promotion offer retail store a series of benefits which other forms of marketing communications cannot duplicate.

•	Increase stock turn and reduce cost: Discounting retail inventories of non-moving or slow-moving products, price promotions effectively liquidate the inventory and reduce the stock holding cost.

•	Increase in sale: It enable customers to try out different products thereby creating more consumer choice. Since different items are on promotion every week, increased consumer choice results in increased sale.

•

Increase walk-in conversion ratio: Providing irresistible deals to visitor will force them to make short-term decisions. The customer usually make their decisions based on the price of the product; therefore, with reduced prices, customer might just be forced to make purchases even if they did not initially intend to do so.

•

Increase in profit levels: Since the appeal of retail products is, to a huge extent, determined by price, sales promotions enable companies to adjust the retail price of the product for short periods of time and with minimal price difference. Sales promotions aim to increase sales in the short-term.

•

Introduce a new product with minimum risk: The principal companies prefer introducing new products backed by a store-based sales promotion. Short-term sales promotions enable retail to offer temporary displays of the products, price cuts and paid advertising, which could result in more sales and revenue with minimum risk.

RanceLab® FusionERPTM 6 offers a bouquet of scheme and promotion fairly customizable to suit your business needs. It is set on:

•	Date Range for single, multiple or all week days

•	Time Range for single, multiple or all week days (Happy Hour Pricing)

•	Product - single, multiple or all products

•	Location - single, multiple or all locations (chain of outlets)

Note: Before using Scheme and Promotion please set “Activation Scheme and Promotion = Yes” in “Main Menu > Master Data Management > Inventory > Location Master (M> I> L)”.

The available options for Scheme and Promotion are as follows:

Name

Particulars

Scheme Name

Enter the name of scheme as per your choice.

Discount Type

Select Scheme type from the list. List are as follows:

Bill Discount

Using Bill Discount method you can set extensive range of discount offers. You can offer discount in % or discount in amount, special discount in % on Birthday or Anniversary, offer a particular product at discounted rate on or above the particular sale value.

Method: Bill Offer
On Amount	Enter bill amount, upon crossing which, the said scheme will be applicable as per the slabs defined.
Offer Item	Press ALT + L to select an item from the list to be offered at lower rate on or greater than the sale value mentioned above.
Qty	Enter quantity of the item to be offered at lower rate on or greater than the sale value as mentioned above.
Sale Amt	Enter the total sale amount for the above item quantity. Rate per unit will be Sale Amt / Qty.
Disc %	Enter discount in percentage value; it is applicable only on the amount entered in “On Amount” field.
Disc Amt	Enter discount in amount applicable only on amount entered in “On Amount” field.
B/A Disc %	Enter Birthday and Anniversary discount percentage.

Example as per slabs shown in the picture above:

1.	Will be offered flat 10% discount on sale value Rs.500/- or above but only on Birthday / Anniversary date.

2.	Will be offered maximum 2 Kg Sugar @ Rs.17 per Kg on sale value Rs.1000/- or above.

3.	Will be offered 1 Kg Sugar free of cost on sale value Rs.2000/- or above.

4.	Will be offered flat 5% discount on sale value Rs.5000/- or above.

5.	Will be offered flat discount of Rs.1350/- on sale value Rs.10000/- or above.

Faq: How will be the Scheme and Promotion applied if someone shops for Rs.7000/- on his Birthday / Anniversary?

Ans: He will be entitled to enjoy both the offers, viz., one for shopping on his Birthday / Anniversary and another for shopping worth >=Rs.5000/-. In this case total discount offered to him / her will be 15% on sale amount, 10% for his Birthday / Anniversary and 5% for shopping worth >=5000/-.

Buy X, Get Y

This method helps you to set a discounted price for quantities of an item, purchased with a specified number of an item.

Method:

Buy Qty. at Full Price

Enter Buy quantity i.e. the quantity on which the scheme will act.

Get Qty. at Discount Price

Enter the quantity which you are offering for discount.

Or Get Discount on Any Qty

Set Yes if you want to sale most valuable at full price and rest of the product(s) at discount in the same invoice.

Discount Price (Sale Value)

Enter discount in value; it will be applicable only on discounted unit.

Or Discount Percentage

Enter discount in percentage; it will be applicable only on discounted unit.

Calculation Based On

Select either minimum value or maximum value on which the software calculates the discount.

•	Maximum Value: Discount will be applicable on the least valued item(s).

•	Minimum Value: Discount will be applicable on the most valued item(s).

Example:

Suppose you have selected 3 products in Buy X, Get Y scheme as “T-shirt H/s”, “T-shirt F/s” and “Formal shirt H/S” with respective sale values as Rs.100/-, Rs. 150/- and Rs. 200/-. You also allowed 50% discount on the 2nd item and the calculation is based on “Minimum Value”.

Now if you scan “T-shirt H/s” and “T-shirt F/s” or 2 “Formal shirt H/S” products it will deduct 50% from that product which has minimum sale value.

More Examples:

•	BOGOF "Buy One, Get One Free"

•	Buy 2 Trousers and get 1 shirt at 50% off

•	Buy 20 KG Rice and Get 1 Kg of Sugar Free

•	Buy an Antonio Bernini watch and get another one worth Rs 12,500 absolutely free.

•	Every Tuesday - Buy 1 large pizza at menu price, get a 2nd pizza of equal or lesser value free.

•	Get a Hauppauge TV Tuner worth Rs. 4500 with every purchase of selected models of Compaq Laptops

•	Buy any Esprit Timewear and get the second one at 50 per cent discount

Coupon (Cross Promotion)

Use this method to print a coupon based on the item. This is used for the cross promotion with other outlets.

Example:

•	On shopping for goods between Rs 299-1499, win free food coupons, video games.

•	Buy 4 Shirt of United Color and get 1 Ray-Ban® sunglasses free.

•	Buy 2 kids t-shirt and get an ice-cream coupon free.

Method:
Coupon File	Select a coupon file from the list. Default is Item Coupon.txt
Valid Days	Enter days of validity for Coupon.
Sale Qty	Enter quantity for Coupon printing.

Mix & Match

You can use this method when all the discounted items share the same price. This discount sets different unit prices for each purchase quantity. In this option you can specify the discount as per quantity of products.

Method: Qty Wise

Qty

Enter quantity.

Discount %

Enter percentage of discount applicable only on quantity entered.

You can use this method when the item for discount have different prices. This type of discount sets a different percentage off the regular price of each item for each purchase quantity.

Example:

•	Buy 2/3 Shirts at 5 % off.

•	Buy 4 to 9 Shirts at 10% off.

•	Buy >=10 Shirts at 20% off.

Amt Off

Enter discount amount applicable only on quantity entered.

You can use this method when the discounted items have different prices. This discount sets off a different amount from the regular price of each item for each purchase quantity.

Example:

•	Buy 2/3/4 Shirts at Rs.50/- off.

•	Buy >=5 Shirt at Rs.100/- off.

Unit Price

Enter rate per unit applicable only on quantity entered.

You can use this method when all the discounted items share the same price. This type of discount sets different unit prices for each purchase quantity. In this option you can specify the Discount as per quantity of products.

Example:

As per the above example if the customer buys 2 or 3 units of that product, then it will cost Rs.200/- each and for >=4 units it will cost Rs.175/- each.

More Example:

•	Any 4 formal shirts for Rs. 999.

•	Buy any 5 game CDs at Rs. 199.

•	Buy 2 Shirts for Rs. 575 Each and Buy 3 Shirts for Rs. 499 Each.

Product Discount

Use this to apply scheme and promotion according to Product Child ID.

RanceLab® FusionERP accepts Product Child IDs in scheme and promotion in Product discount. Please follow the steps as given below to accomplish the task:

1.	Type the name of the scheme at field Scheme Name

2.	Set “Discount Type = Product Discount”.

3.	Enter other details like Date, Time, Weekdays, Location etc.

4.	Press ALT + L at Product field to select the Product Child(s) from the child list. You can use multi selection keys here.

5.	OR you can also scan the product

6.	Set Discount % for every item

7.	Press ALT + S to save.

Date From

Enter the start date of the scheme.

Date To

Enter the end date of the scheme.

Time From

Enter the start time of the scheme.

Time To

Enter the end time of the scheme.

Week Days

Select weekdays here. It will work only on selected weekdays.

Locations

Press Enter key and then select the location(s) by pressing ALT + L. If you leave it blank then the Scheme & Promotion will be applicable for all locations.

Is Coupon Applicable

Set Yes if Discount Coupon is attached with the Scheme & Promotion else set No. Date, Discount and other things of the Discount Coupon will be controlled by the Scheme & Promotion master.

Exclude Sub Group for Bill Discount

Press the Enter key, then press ALT + L to select the Sub-group(s) from the list. You can use multi selection keys here.

Consequently the scheme Bill Discount will not be applicable for the items of corresponding Sub-group(s).

Exclude MOP Types

Press the Enter key, then press ALT + L to set Restricted MOP at "Exclude MOP” field. You can use multi selection keys here.

On setting a MOP here, the said Scheme & Promotion will not be applicable with that MOP irrespective of the setting done in Sales Option.

Exclude Customer Card Types

Press Enter key, then press ALT + L to select the Customer Card Types from the list. You can use multi selection keys here.

Consequently the said Scheme & Promotion will not be applicable for the Customers having corresponding Card Type.

Product

Press ALT + L at Product field to select the Product Child(s) from the child list, you can either use multi selection keys OR scan the product here.

For all the Discount Types other than the Bill Discount you need to select the Product(s) here. Discount Type will be applicable only on the products selected here.

Product Detail

Product

Shows the name of the selected Product Child.

Code

Shows the code of the selected Product Child.

Sub Group

Shows the Sub Group of the selected Product Child.

Brand

Shows the Brand of the selected Product Child.

Pur Rate

Shows the Purchase Rate of the selected Product Child. You cannot modify it.

Sal Rate

Shows the Sal Rate of the selected Product Child. You cannot modify it.

Stock

Show Stock of the selected Product Child. You cannot modify it.

Age

Shows the Age of the selected Product Child. You cannot modify it.

No Sal

Shows No Sal of the selected Product Child. You cannot modify it.

Disc%

Enter Discount % for the Product Child.

MRP

Shows the MRP of the selected Product Child. You cannot modify it.

List1