Lesson 5 – Assigning Rates

Scroll down  Image255.gif (856 bytes) to see complete section.

What You Will Learn

How to open the Rates window.

Moving around the Rates window.

Getting Started

 Open the RedBook Catalogue Lookup window. If you are not sure how to open the RedBook Catalogue Lookup window refer to:

Lesson 1 To open the RedBook Catalogue Lookup window

 

 Rate Sheet Concepts

Each price catalogue that you have on your Winpriser system has a set of rate sheets. A price catalogue may have many rate sheets assigned to it. There is no limit to the number of rate sheets that you can have for a price catalogue.

A rate sheet is simply a collection of rates. There are four different types of rate sheets. A rate sheet can be defined as a discount rate sheet, as a markup rate sheet, as a markdown rate sheet or as a labour rate sheet:

Discount Rate Sheet - contains a list of supplier discount categories and discount percent values offered by a supplier.

Markup Rate Sheet - contains a list of markup categories and markup percent rates that you have defined.

Markdown Rate Sheet - contains a list of various markdown categories and markdown percent rates that you have defined for the current price catalogue.

Labour Rate Sheet - contains a list of labour categories and labour cost/hour rates that you have defined.

 

Rate sheets are subdivided into rate categories or classes. Each rate class on a rate sheet has one or more catalogue product items assigned to it. This link that you establish between a specific rate class and a specific product item or group of product items is done only when you are first setting up your rate sheets. The extra work required when setting up your rate sheets in this way will more than be made up in the time that you save when a rate sheet must be revised.

After you have created a rate sheet for a supplier, whenever that supplier’s discount percentage changes, all you have to do is change the discount rate percent value in the existing rate sheet table. The individual discounts for all the product items assigned to that discount rate class are updated for you automatically.

 If you choose, you do not have to create rate sheets at all! , Discounts, markups and markdowns can be added directly to the job worksheet as the material for a job is taken off.

 Opening the Rates window

1 From the Catalogue Lookup menu, select the Items | Rates menu option.

OR

Click on the Rates button in the Catalogue toolbar.

2 The Rates window for the currently open price catalogue will appear:

 

 Rates window tabs

The Rates window is divided into 4 window tabs. Each tab represents a different type of rate sheet. The majority of your time will be spent in the Discounts tab. It is here that you would setup rate sheets for each supplier that you buy from.

Each tab of the Rates window contains two tables. The top table contains a list of rate sheets associated with the active price catalogue and the bottom table contains a list of rate descriptions or classes that belong to the selected rate sheet. See below:

Discounts:

 

Markups:

Markdowns:

:

 

Labour:

Each Rates tab window allows you to add, edit, and delete rate sheets. Within each rate sheet you can add, edit and delete rate classes.

The upper portion of the Rates window shows a list of the rate sheets that you have created in this tab. The lower portion contains a list of all the rate classes belonging to a selected rate sheet. As shown above, the column descriptions in this table will vary with each Rate window tab. Each line in the lower table is an individual rate class or category as shown below:

 

Discount Rate Sheet example

 

 Rate Class Definition

A rate class definition in a rate sheet has 3 data field entries:

Description: Description of the rate class. This data field can be up to 30 characters in length.

Value: Numerical percentage value of the rate. This data field can be in the range –9999.999 to +9999.999.

Code: An optional code typically used by a supplier to represent a specific rate class. This field can be up to 10 characters in length.

 

The Discounts tab has an additional feature called Duplicate.

This option allows you to copy the contents of one rate sheet to another rate sheet. All rate classes in the source rate sheet and all the product item assignments for each rate class are duplicated in the target rate sheet.

 End of Lesson