Versions Compared

Old Version 2

changes.mady.by.user Frank Gambino

Saved on

compared with

New Version Current

changes.mady.by.user Frank Gambino

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

...

Common fields found when creating a budget line

FieldDescription

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
  • —Available Rooms KBI
  • TTLRMS
= Total
  • —Total Occupied Rooms KBI
  • POR
= Rooms
  • —Rooms Revenue from occupied rooms
  • TTL
_Revenue =
  • —Revenue: Total Revenue
  • GOP
= Gross
  • —Gross Operating Profit
  • NOP
- Net
  • —Net Operating Profit
  • GOI
= Gross
  • —Gross Operating Income
  • NOI
- Net
  • —Net Operating Income
  • TTLRMS
= Total
  • —Total Rooms (mirrors the Total Occupied Rooms KBI)

Account Code

Allows you to assign

Assign an account code to the budget line.

Allocation Type

Allows you to specify

Specify how the budget line is allocated.

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

Note: 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
  • —Total Dollars =
Units x Rate x
  • Units × Rate × Factor + Fixed.
  • Fixed
. Total
  • —Total Dollars =
Units x
  • Units × Rate +
Fixed x
  • Fixed × Factor.
  • Both
. Total
  • —Total Dollars =
Units x Rate x
  • Units × Rate × Factor +
Fixed x
  • Fixed × Factor.

Show % of Line based on

Allows you to determine

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

Tell 

Include Page
RMS-ProductName
RMS-ProductName
that you want to display the relationship between the budget line you are editing and its parent.

Budget Line Type

Allows you to designate

Designate what type of budget line you are creating.

Parent Line Operation

Allows you to select

Select which operation you

wish

want to be applied to the Parent Line for this budget line.

 

Creating Budget Lines

To create new budget lines:

...

#Market Segment Lines

...

#Revenue Center Lines

...

#Percent of Base 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 want to add a new budget line.
  3. Select New Budget Line from the menu.
    The New Budget Line screen dialog box 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 Show % of Parent.

  10. Select the appropriate Budget Line Type for the new budget line you are creating.

    NOTE

    Info
    iconfalse

    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.

...

#Total Lines

...

#Calculated Lines

...

#Job Class Lines

...

#KBI Lines

  1. Determine whether the new line should be added or subtracted from its parent, and select either Add or Subtract as the Parent Line Operation.
  2. Click Finish.
    The budget line is created and the dialog box closes.


You can create the following budget line types:

Creating Total Lines
Anchor
Total Lines
Total Lines

...

  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. Do one of the following:
    • If you
    chose , OR click Finish if you chose
    • .
      Or
    • If you decided not to allocate, click Finish.
  3. (Optional) If you need to add other budget lines, return to Creating Budget Lines, OR 169678442.
  4. Click the Save icon if you are finished adding budget lines.

Creating Calculated Lines
Anchor
Calculated Lines
Calculated Lines

...

  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.

    Info
    iconfalse

    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. (Optional) Repeat Steps 1-4 for each budget line that needs to be included in the calculation.
  6. Click the Remove Line button if (Optional) If you need to remove a line from the calculation, click Remove Line.
  7. Do one of the following:
    • If you
    chose , OR click Finish if you chose
    • .
      Or
    • If you decided not to allocate, click Finish.
  8. (Optional) If you need to add other budget lines, return to
    9. Creating Budget Lines, OR
  9. 169678442.
  10. Click the Save icon if you are finished adding budget lines.

Creating Job Class Lines
Anchor
Job Class Lines
Job Class Lines

...

  1. Select the Division, Department and Job to be used for the hours forecast.
  2. Do one of the following:
    • If you
    chose , OR click Finish if you chose
    • .
      Or
    • If you decided not to allocate, click Finish.
  3. (Optional) If you need to add other budget lines, return to
    4. Creating Budget Lines, OR
  4. 169678442.
  5. Click the Save icon if you are finished adding budget lines.

Creating KBI Lines
Anchor
KBI Lines
KBI Lines

...

  1. Select the KBI to be used for the forecast.
  2. Do one of the following:
    • If you
    chose , OR click Finish if you chose
    • .
      Or
    • If you decided not to allocate, click Finish.
  3. (Optional) If you need to add other budget lines, return to
    4. Creating Budget Lines, OR
  4. 169678442.
  5. Click the Save icon if you are finished adding budget lines.

Creating Market Segment Lines
Anchor
Market Segment Lines
Market Segment Lines

...

  1. Select a Market Group to be used for the rooms forecast.

  2. Select a Market Segment to be used for the rooms forecast.

    Info
    iconfalse

    Note: If you

    choose

    select All, Budgeting will create a

    market segment line

    revenue center period for every

    segment

    period in the

    market group

    revenue center.


  3. Do one of the following:
    • If you
    chose , OR click Finish if you chose
    • .
      Or
    • If you decided not to allocate, click Finish.
  4. (Optional) If you need to add other budget lines, return to Creating Budget Lines
    5. , OR
  5. .

  6. Click the Save icon if you are finished adding budget lines.

Creating Revenue Center Lines
Anchor
Revenue Center Lines
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.

    Info
    iconfalse

    Note: If you

    choose

    select All, Budgeting will create a revenue center period for every period in the revenue center.


  3. Do one of the following:
    • If you
    chose , OR click Finish if you chose
    • .
      Or
    • If you decided not to allocate, click Finish.
  4. (Optional) If you need to add other budget lines, return to Creating Budget Lines, OR .
  5. Click the Save icon if you are finished adding budget lines.

Creating Percent of Base Lines
Anchor
Percent of Base Lines
Percent of Base Lines

...

  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. Do one of the following:
    • If you
    chose
    • decided to allocate in Step 6 of Creating Budget Lines, click Next and proceed to About Configuring
    Allocations, OR click Finish if you chose
    • Allocations.
      Or
    • If you decided not to allocate, click Finish.
  3. (Optional) If you need to add other budget lines, return to Creating Budget Lines
    4. , OR
  4. .
  5. Click the Save
    6. button
  6. icon if you are finished adding budget lines.

Creating Fixed Lines
Anchor
Fixed Lines
Fixed Lines

...

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

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