Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

Creating Budget Lines

As noted in About Budget Lines, there are several different types of budget lines. To create your profit and loss tree, you must create budget lines. Remember that you must first Lock the structure before you can add any budget lines.

Terms & Definitions for Common Fields

Name                                        

Denotes the name of the budget line.

Code

Denotes an alternate short name for the budget line. Many reports need to be coded to one of the following:
AVAILRMS = Available Rooms KBI
TTLRMS = Total Occupied Rooms KBI
POR = Rooms Revenue from occupied rooms
TTL_Revenue = Total Revenue
GOP = Gross Operating Profit
NOP - Net Operating Profit
GOI = Gross Operating Income
NOI - Net Operating Income
TTLRMS = Total Rooms (mirrors the Total Occupied Rooms KBI)

Account Code

Allows you to assign an account code to the budget line.

Allocation Type

Allows you to specify how the budget line is allocated.

  • None. Denotes that you do not wish this budget line to be allocated.
  • Fixed. Denotes that you wish to assign specific allocation percentages for this budget line.
  • Variable. Denotes that you wish Budgeting to determine how a budget line should be allocated.

    This allocation can vary period by period as the relationship between the Percent lines change.

Factor Mode

Determines which elements of the formula have the factor applied. Factors allow you to adjust for circumstances.

There are three formulas that can be selected:

  • Variable. Total Dollars = Units x Rate x Factor + Fixed.
  • Fixed. Total Dollars = Units x Rate + Fixed x Factor.
  • Both. Total Dollars = Units x Rate x Factor + Fixed x Factor.

Show % of Line based on

Allows you to determine which line is to be used when displaying the relationship with the budget line you are editing.

Show % of Parent

Allows you to tell Watson that you want to display the relationship between the budget line you are editing and its parent.

Budget Line Type

Allows you to designate what type of budget line you are creating.

Parent Line Operation

Allows you to select which operation you wish to be applied to the Parent Line for this budget line.

 

Creating Budget Lines

To create new budget lines:

  1. Determine whether the budget structure is locked or unlocked, and click the Lock/Unlock Budget Structure icon if it is unlocked.
  2. Right-click on the total (T) budget line to which you wish to add a new budget line.
  3. Select New Budget Line from the menu. The New Budget Line screen appears.
  4. Enter a Name and Code  for the budget line.
  5. Enter an existing Account Code or click on the ellipses box and choose an account from the list.  
  6. Select an Allocation Type from the drop-down list, if appropriate.
  7. Select a Factor Mode (Variable, Fixed or Both).
  8. Click on the ellipses box and select a budget line that is to be used as the Show % of Line based on.
  9. Select or de-select Calculate % of Parent.
  10. Select the appropriate Budget Line Type for the new budget line you are creating. NOTE: The Divider budget line type is only visible if you are creating a top-level budget line.
  11. Click Next.
  12. Proceed to the sections pertaining to the specific Budget Line Type you selected in Step 10.

Creating Total Lines

To create a total line:

  1. Determine whether the new line should be added or subtracted from it's parent and select Add or Subtract for the Parent Line Operation.
  2. If you chose to allocate in Step 6 of Creating Budget Lines, click Next and proceed to About Configuring Allocations, OR click Finish if you chose not to allocate.
  3. If you need to add other budget lines, return to Creating Budget Lines, OR Click the Save icon if you are finished adding budget lines.

Creating Calculated Lines

To create a calculated line:

  1. Click Add Existing Line.
  2. Select the budget line to be used in the calculation.
  3. Determine whether the budget line is to be added, subtracted, multiplied or divided, and select the appropriate Operation to be performed. Note: This process works like an adding machine: the first operation type must be "add," from there, other lines are added, subtracted, multiplied or divided.
  4. Click OK.
  5. Repeat Steps 1-4 for each budget line that needs to be included in the calculation.
  6. Click the Remove Line button if you need to remove a line from the calculation.
  7. If you chose to allocate in Step 6 of Creating Budget Lines, click Next and proceed to About Configuring Allocations, OR click Finish if you chose not to allocate.
  8. If you need to add other budget lines, return to Creating Budget Lines, OR Click the Save icon if you are finished adding budget lines.

Creating Job Class Lines

To create a Job Class line:

  1. Select the Division, Department and Job to be used for the hours forecast.
  2. If you chose to allocate in Step 6 of Creating Budget Lines, click Next and proceed to About Configuring Allocations, OR click Finish if you chose not to allocate.
  3. If you need to add other budget lines, return to Creating Budget Lines, OR Click the Save icon if you are finished adding budget lines.

Creating KBI Lines

To create a KBI line:

  1. Select the KBI to be used for the forecast.
  2. If you chose to allocate in Step 6 of Creating Budget Lines, click Next and proceed to About Configuring Allocations, OR click Finish if you chose not to allocate.
  3. If you need to add other budget lines, return to Creating Budget Lines, OR Click the Save icon if you are finished adding budget lines.

Creating Market Segment Lines

To create a Market Segment line:

  1. Select a Market Group to be used for the rooms forecast.
  2. Select a Market Segment to be used for the rooms forecast. If you choose All, Budgeting will create a market segment line for every segment in the market group.
  3. If you chose to allocate in Step 6 of Creating Budget Lines, click Next and proceed to About Configuring Allocations, OR click Finish if you chose not to allocate.
  4. If you need to add other budget lines, return to Creating Budget Lines, OR Click the Save icon if you are finished adding budget lines.

Creating Revenue Center Lines

To create a Revenue Center line:

  1. Select the Revenue Center to be used for the rooms forecast.
  2. Select the Revenue Center Period to be used for the rooms forecast. If you choose All, Budgeting will create a revenue center period for every period in the revenue center.
  3. If you chose to allocate in Step 6 of Creating Budget Lines, click Next and proceed to About Configuring Allocations, OR click Finish if you chose not to allocate.
  4. If you need to add other budget lines, return to Creating Budget Lines, OR Click the Save icon if you are finished adding budget lines.

Creating Percent of Base Lines

To create a Percent of Base line:

  1. Select the line to be used for the Basis (the line on which the calculation will be based). NOTE: You cannot choose the line you are creating, or any lines dependent on this line, as the Basis.
  2. If you chose to allocate in Step 6 of Creating Budget Lines, click Next and proceed to About Configuring Allocations, OR click Finish if you chose not to allocate.
  3. If you need to add other budget lines, return to Creating Budget Lines, OR Click the Save button if you are finished adding budget lines.

Creating Fixed Lines

To create a Fixed line:

Fixed lines do not require any further information than that requested on the first screen, in order to be created. However, if you chose to allocate in Step 6 of Creating Budget Lines, click Next and proceed to About Configuring Allocations, OR click Finish if you chose not to allocate.

If you need to add other budget lines, return to About Configuring Allocations, OR Click the Save icon if you are finished adding budget lines.

  • No labels