Vehicle Rate Card File: Difference between revisions

From NEOSYS User Support Wiki
Jump to navigationJump to search
 
(25 intermediate revisions by 4 users not shown)
Line 1: Line 1:
== Entering Vehicle Rate Cards into NEOSYS ==
==Vehicle Rate Cards in NEOSYS==


Standard pricing and costing information can be entered into the Ratecard File in NEOSYS where it can easily be accessed while creating media plans and schedules.
<Image>


Rates can either be gross rates for individual ads or the rate can be per column centimeter or per second etc. When the rate is dependent on size or duration, the final cost per ad is calculated depending on the size/duration entered in the schedule. "Sized" rates are indicated by an asterisk "*" character without the quotes either within or at the end of the specification column. eg INS PG* would be converted to INS PG*20X4 on the schedule. You can also enter the main or fixed sizes of a publication directly into the ratecard like INS PG*20X4.


NEOSYS allows the precise rate card information to be fed in the system which can very easily be retrieved when preparing the schedule. There is a separate column for loadings like color or position loading where the loading charges can be specified.
===Vehicle code, effective date & Comments===
Used to identify a ratecard on ratecard selection in the schedule file.


[[image:ratecard2.jpg | 800 px]]
===Commission %, Agency Fee %, Agent Fee/Discount %, Tax %, Other %===


These fields correspond to the calculated bill columns in the schedule file and can be configured to work on the basis of other columns.
e.g Commission 1% on 'One after Gross' is 1% of the bill Load field in the schedule file. (See [[ https://userwiki.neosys.com/index.php/Using_NEOSYS_Media_System#Concepts_and_Calculation_under_Discounts_and_other_charges | Concepts and Calculation under Discounts and other charges)


Below screenshot shows which part of the schedule picks up the Commission, Agency fee, Agent fee/Discount, Tax, Other fee fields of the vehicle ratecard file:
Includes


Users can enter precise ratecard bill and cost information into the Vehicle Rate card which is easily retrieved when preparing a plan or schedule.


[[File:Schedule rate card.jpg | 1400 px]]
<Image>


== Specifying a minimum amount in the rate card ==
# - used to identify the ratecard on ratecard selection in schedule file.
#General calculated charges, such as Commission, Fee and discount (for dropdown options Net, One before Net, etc. see Calculation in discount/charges columns)
#Main ratecard table. (Will be explained in more detail below, with examples)
#Loadings - can be considered a secondary ratecard for additional charges.
#Client Specific rates - Client specific rates section allows users to enter bill and cost discount, commission and other rates for specific clients. <br> Tip: If the client code is left blank then the discounts, commissions and other rates will be applied to all clients.


The 'greater than' sign is required after the percentage and before the minimum amount with no spaces eg 20%>2000 means loading of 20% with a minimum of 2000.
Users can create ratecards, in the schedule file by clicking on the 'File' button on the specification or loading field or by navigating to a new file using the Menu > Media > Files. <br>
To retrieve an existing ratecard, click the Lookup button on the specification field and follow the prompts to select the ad rate specifications.


In the image you can see in the loading section (where the arrow points) an example of how you document a minimum amount in the rate card which on the actual rate card was mentioned as '15% extra charge for full colour (minimum Dhs 3,000)'.
Rates can either be gross rates for individual ads or the rate can be per column centimeter or per second etc. <br>
When the rate is dependent on size or duration, the final cost per ad is calculated depending on the size/duration entered in the schedule. <br>
When making a ratecard selection, users will be prompted to enter the size/duration after selecting the main rate row and column.
"Sized" rates are indicated by an asterisk "*" character without the quotes either within or at the end of the specification column.<br>


[[image:ratecard.jpg]]


Example: INS PG* would be converted to INS PG*20X4 on the schedule. You can also enter the main or fixed sizes of a publication directly into the ratecard like INS PG*20X4.


== Standard rates ==


The standard rates is a table for standard discounts and their corresponding discount values. These standard discounts appear in the "Discount%" field under "Client Specific Rates" as shown in the screenshot below.
<b>Note:</b>


Below screenshot shows the rate card file for the vehicle Copenhagen Connoisseur (COCO). Under Client Specific Rates "SILVER MEMBER" is chosen as the discount for brand "M.N.A.S and Sons" of client "Zenith Media" (ZEME). So in a media schedule for brand MNAS, if the vehicle Copenhagen Connoisseur is used, the discount shown will be -10% since SILVER MEMBER corresponds to -10% in the standard rates table.
*<b>If tags are already entered in the Loading field, the option to choose loading will not be available.</b> <br>To work around this cut tags out Ctrl + X, make new loading selection and paste tags back in to loading field with Ctrl + V.
*<b>Avoid usage of commas in the rate table and instead use single quote or a blank space. e.g. 500 000 or 500'000. </b> Refer to [[Media FAQ#Why is the Gross Amount field picking up the amount before the comma in the Specification field.3F|Gross amount picked up from Ratecard]]


[[image:Standard discounts.jpg]]
[[image:ratecard2.jpg | 800 px]]


[[File:CS discount.jpg| 1300 px]]
Below screenshot shows which part of the schedule picks up the Commission, Agency fee, Agent fee/Discount, Tax, Other fee fields of the vehicle ratecard file:
 
[[File:Schedule rate card.jpg | 1400 px]]

Latest revision as of 12:54, 11 March 2021

Vehicle Rate Cards in NEOSYS

<Image>


Vehicle code, effective date & Comments

Used to identify a ratecard on ratecard selection in the schedule file.

Commission %, Agency Fee %, Agent Fee/Discount %, Tax %, Other %

These fields correspond to the calculated bill columns in the schedule file and can be configured to work on the basis of other columns. e.g Commission 1% on 'One after Gross' is 1% of the bill Load field in the schedule file. (See [[ https://userwiki.neosys.com/index.php/Using_NEOSYS_Media_System#Concepts_and_Calculation_under_Discounts_and_other_charges | Concepts and Calculation under Discounts and other charges)

Includes

Users can enter precise ratecard bill and cost information into the Vehicle Rate card which is easily retrieved when preparing a plan or schedule.

<Image>

  1. - used to identify the ratecard on ratecard selection in schedule file.
  2. General calculated charges, such as Commission, Fee and discount (for dropdown options Net, One before Net, etc. see Calculation in discount/charges columns)
  3. Main ratecard table. (Will be explained in more detail below, with examples)
  4. Loadings - can be considered a secondary ratecard for additional charges.
  5. Client Specific rates - Client specific rates section allows users to enter bill and cost discount, commission and other rates for specific clients.
    Tip: If the client code is left blank then the discounts, commissions and other rates will be applied to all clients.

Users can create ratecards, in the schedule file by clicking on the 'File' button on the specification or loading field or by navigating to a new file using the Menu > Media > Files.
To retrieve an existing ratecard, click the Lookup button on the specification field and follow the prompts to select the ad rate specifications.

Rates can either be gross rates for individual ads or the rate can be per column centimeter or per second etc.
When the rate is dependent on size or duration, the final cost per ad is calculated depending on the size/duration entered in the schedule.
When making a ratecard selection, users will be prompted to enter the size/duration after selecting the main rate row and column. "Sized" rates are indicated by an asterisk "*" character without the quotes either within or at the end of the specification column.


Example: INS PG* would be converted to INS PG*20X4 on the schedule. You can also enter the main or fixed sizes of a publication directly into the ratecard like INS PG*20X4.


Note:

  • If tags are already entered in the Loading field, the option to choose loading will not be available.
    To work around this cut tags out Ctrl + X, make new loading selection and paste tags back in to loading field with Ctrl + V.
  • Avoid usage of commas in the rate table and instead use single quote or a blank space. e.g. 500 000 or 500'000. Refer to Gross amount picked up from Ratecard

Ratecard2.jpg

Below screenshot shows which part of the schedule picks up the Commission, Agency fee, Agent fee/Discount, Tax, Other fee fields of the vehicle ratecard file:

Schedule rate card.jpg