Add Budget Lines wizard and Edit Budget Line dialog box
The tables in this section describe the fields that you encounter when adding a budget line in the Edit Structure screen and when editing a budget line in the Budget Tree screen.
-
In the upper-left corner of the screen, select Access your applications ( ).
The menu expands. -
Select Financial > Budgeting.
The Budgeting Dashboard screen appears.
-
Do one of the following:
To access a specific line from the Budgeting Dashboard:
In the left pane, double-click a line.
The Budget Tree screen opens to the selected line in the budget tree structure. The section of the budget structure appears partially expanded to display all totals at the same level in the tree menu.
To access the Budget Tree screen:
From the Budgeting menu pane, select Budget Tree ( ).
The Budget Tree screen appears.
-
In the upper-left corner of the screen, select Access your applications ( ).
The menu expands. -
Select Financial > Budgeting.
The Budgeting Dashboard screen appears.
-
In the Budgeting menu pane, select Budget Configuration ( ) > Budget Structure.
The Budget Structure screen appears.
Fields on the Add Budget Lines wizard and the Edit Budget Line dialog box
Note: If you are adding a budget line, these fields appear in the Add Budget Lines wizard. If you are editing a budget line, these fields appear in the Edit Budget Line dialog box.
Note: If you are adding a budget line, the Cost Structure & Results fields are not available in the Add Budget Lines wizard.
Note: Available tabs depend on the line type that you are adding or editing. If tabs are unavailable, the text appears in a lighter font color. Also, a notification on the General tab tells you which tabs are unavailable for line type.
General budget line fields on the Add Budget Line wizard and the Edit Budget Line dialog box
Field | Description | Notes |
---|---|---|
Name |
Name of the budget line. If you are editing a budget line, this field is auto-filled from your initial setup. To rename the line, enter a new name in the field. |
Required. |
Code |
Unique numerical code associated with the budget line. |
Required. Although the software automatically selects the code, you can overwrite the entry in the field. |
Line Type |
Budget line type associated with the budget line. Options include:
|
Required. |
Show % of Line based on |
Opens the Select Budget line dialog box where you select which line is to be used when displaying the relationship with the budget line you are editing. For example, if you are working with best available rate (that is, the Name field is Best Available Rate or BAR) and you select Total Revenue for this Show % of Line based on field, the selection will display BAR's percentage of Total Revenue. |
The default percent line is configured in Setup > Property > Property Budgeting. |
Active |
Select if the budget line is active. Active lines appear with a value and are calculated in the budget. Inactive lines appear with a zero value and are not calculated in the budget. Note: Deactivating a line does not erase the value or configuration. When you reactivate the line, the originally configured value will be calculated in the budget. |
Default: Active. |
Show % of Parent |
Select to display the relationship between the budget line you are editing and its parent. |
Default: Active. |
Copy from Dataset ( ) |
Turn on to copy from dataset. |
|
Select Dataset |
Select an existing dataset from the drop-down list. When you select a dataset from which to copy, the following note appears: This Budget Line will be added to the current working dataset as active. |
A dataset is not available to copy if:
|
Line-specific fields on the Add Budget Line wizard and the Edit Budget Line dialog box
Note: The fields that appear on this tab depend on the line type that you have selected to edit as well as options that you select on the tab.
Note: Job ( ), Percent of Labor ( ), and Percent of Hours ( ) line types share the same configuration fields.
Field | Description | Appears only for selected detail line types | Notes |
---|---|---|---|
Account |
Account code assigned to the budget line. The account is associated with the revenue or expense amount being budgeted by the line. Either select the account from the drop-down list, search for a specific account by entering the name or number, or select the Add Account ( ) option to add a new account. For information on adding an account, see Add Account dialog box in Budgeting. To remove an account, select the Clear value () button. Important: If you are importing P&L Actuals, UniFocus recommends that you do not attach an account number to a Total line. Although your data would export correctly, it would not correctly import P&L Actuals because importing would pull the data into a Total line. The Total line is the sum of everything beneath it. If the sum of child lines is zero, the Total line will be zero. Also, if an account if configured on multiple lines and you're importing P&L Actuals, the first line with the account number is where it will be imported. If that first line is the Total line, the sum will be zero. |
|
|
Regular Costs Account |
Regular Costs Account code assigned to the budget line. The Regular Costs Account includes costs attributed to regular hours (or non-premium hours that are calculated as regular hours regular × rate of pay). These costs are exported to this account. Either select the account from the drop-down list, search for a specific account by entering the name or number, or select the Add Account ( ) option to add a new account. For information on adding an account, see Add Account dialog box in Budgeting. To remove an account, select the Clear value () button. |
|
|
Regular Hours Account |
Regular Costs Account code assigned to the budget line. The Regular Hours account includes regular or non-overtime/-premium hours as calculated by the labor standards. These hours are exported to this account, Either select the account from the drop-down list, search for a specific account by entering the name or number, or select the Add Account ( ) option to add a new account. For information on adding an account, see Add Account dialog box in Budgeting. To remove an account, select the Clear value ( ) button. |
|
|
OT Costs Account |
OT Costs Account code assigned to the budget line. The OT Costs Account includes the overtime costs that are associated with the hours designated in the Adjust Hours and Rates screen as overtime (calculated as OT hours × OT rate of pay). These costs are exported to this account. Either select the account from the drop-down list, search for a specific account by entering the name or number, or select the Add Account ( ) option to add a new account. For information on adding an account, see Add Account dialog box in Budgeting. To remove an account, select the Clear value ( ) button. |
|
|
OT Hours Account |
OT Hours Account code assigned to the budget line. The OT Hours Account includes the overtime hours as designated in the Adjust Hours and Rates screen. These hours are be exported to this account. Either select the account from the drop-down list, search for a specific account by entering the name or number, or select the Add Account ( ) option to add a new account. For information on adding an account, see Add Account dialog box in Budgeting. To remove an account, select the Clear value ( ) button. |
|
|
Factor Mode |
Determines which elements of the formula have the factor applied. Factors allow you to adjust for circumstances.
|
|
By default, the software applies a factor of 1 to return the same value. This value is inherited on Percent of Hours and Percent of Labor Lines. |
Use Salaried Factor |
Select for jobs with a Salaried Standard. |
|
Only select this option if the job you selected is using a Salaried Standard. The selection is inherited on Percent of Hours and Percent of Labor Lines. |
Discretionary |
Indicates that the budget line is discretionary. |
|
This option is only available for expense lines. |
Performance Measure |
Performance measures are analytical options that can be used if there is a need to see values other than POR, PAR, Percent of Line, or Average. The most common type of performance measure is Labor Productivity or Full Time Equivalents (FTE). Note: Although performance measures can be applied to several line types, they are typically used for Job line. Note: The recommended use of performance measures is to display productivity number or FTE calculations on Job type lines. Options include:
|
All line types, except for divider:
|
The available options depend on the selected line type. |
Formula 1 -2 |
Select a configured budget formula or create a new budget formula. To create a new formula, select Add/Edit Formulas. For more information, see the following: |
|
This field appears only if the selected Performance Measure is:
|
Data Type |
Select one of the following:
Values are displayed as percentages. Tip: To determine which data type to use, ask yourself whether you are dividing costs by costs or units by units. For example, do you want to divide Total Room Revenue by Total Revenue for a hotel to see the percentage, or do you want to divide Total Hours worked for the department by the Total Hours worked by the division to find the percentage of labor for the department or job. |
|
This field appears only if the selected Performance Measure is:
|
Revenue Center |
Revenue center associated with the budget line. |
|
Required. |
Market Segment |
Select the market segment to which the budget line is applied. |
|
Required. |
Calculation Configuration |
Select the calculation configuration method for the line or add a new formula. |
|
|
PM Name |
A brief description of your performance measure. For example, Weekly 40 FTE, Units per Hours, or Cost of Labor Percentage. |
|
This field appears only if the selected Performance Measure is:
|
Format as Percentage |
Select to format the amount as a percentage. |
|
This field appears only if the selected Performance Measure is:
|
Job Class Line |
Select a budget line to calculate the percentage. Select the Select Budget Line ( ) button to open the Select Budget Line dialog box. |
|
Required. |
Job class |
Select a labor structure to receive hours from the standard. |
|
|
FTE Type |
The configured full-time equivalent (FTE) associated with the line. For more information, see Configuring a Full Time Equivalent (FTE) in Budgeting. |
|
Required. Appears only if the following Performance Measure is selected:
|
KBI |
The configured KBI associated with the line. |
|
Required. Appears only if the following Performance Measure is selected:
|
Units |
The unit type displayed for the line. |
|
Required. Appears only if the following Performance Measure is selected:
|
Goals |
When goals are configured, the information icon for the line displays the percent variance of budgeted productivity to this goal. This field will be used for future functionality and does not affect current system performance. |
|
Required. Appears only if the following Performance Measure is selected:
|
Allocation fields on the Add Budget Line wizard and the Edit Budget Line dialog box
Note: The fields that appear on this tab depend on the line type that you have selected to edit as well as options that you select on the tab.
Note:Job ( ), Percent of Labor ( ), and Percent of Hours ( ) line types share the same configuration fields.
Note: Market Segment and Revenue Center lines do not support allocations.
Field | Description | Appears only for selected detail line types | Notes |
---|---|---|---|
Note |
A system-generated note about issues related to your budget setup. |
|
Read-only. This note appears only if there is an available notification about your configuration. |
Allocation Type |
Options include:
|
|
|
Name |
Name of the selected line. |
|
Read-only. |
Account |
Account associated with the selected budget line. |
|
Read-only. |
Line Type |
Line type associated with the selected budget line. |
|
Read-only. |
Add Line section |
|
|
This section appears only if Fixed or Variable are selected as the Allocation Type. |
Add Line |
Opens the Configure Fixed Allocation Line dialog box, where you add a new allocation line. |
|
|
Edit Line |
Select to edit the highlighted budget line. |
|
|
Calculate Percentage based on Units |
Select to have all percentage calculations based on Units rather than the default Dollars. |
|
|
Table | |||
Budget Line |
Budget line to which you are allocating. |
|
|
Percent |
Specifies the percentage amount that you want allocated to the budget line. |
|
|
Percent line |
The budget lines that RMS uses to determine the allocation percent. |
|
|
Actions |
Available actions include:
|
|
The options that you see depend on your configuration and selections. |
Buttons |
|||
Add to working dataset |
Select this button to add the line to the working dataset. |
||
Add to multiple datasets |
Select this button to open the Add to dataset(s) dialog box, where you can add the line to multiple datasets. |
You can add the line to up to five datasets. |
Fields on the Cost Structure & Results tab of the Edit Budget Line dialog box
Note: The fields that appear on this tab depend on the line type that you have selected to edit as well as options that you select on the tab.
Note: If you are adding a budget line, the Cost Structure & Results fields are not available in the Add Budget Lines wizard.
Note:Job ( ), Percent of Labor ( ), and Percent of Hours ( ) line types share the same configuration fields.
Note: If Percent is selected as the Performance Measure on the Line-Specific Options tab, the Cost Structure & Results tab is not available for the line type.
Field | Description | Appears only for selected detail line types | Notes |
---|---|---|---|
Name |
Name of the budget line. |
All line types. |
Read-only. |
Account |
Account number associated with the budget line. |
For Regular Cost Accounts:
|
Read-only. |
Line Type |
Type of line type that you are editing. |
All line types. |
Read-only. |
Factor Mode |
The factor mode applied to the line: variable or fixed.
|
All line types. |
Read-only. |
Total Costs |
Formula for calculating total costs. Formulas per line type:
|
All line types. |
Read-only. |
Add Range |
Opens the Edit Ranges dialog box where you edit and add ranges. |
|
|
Table | If a cell is editable, you can double-click and add/edit a value. |
|
|
Periods |
Financial periods for the budget line. |
|
Read-only. |
Rooms |
Number of rooms budgeted. |
|
Read-only. |
Covers |
Number of guests budgeted, usually at a banquet, event, or restaurant service. |
|
Read-only. |
Base Hours |
Net hours from the referenced job line. |
|
Read-only. |
Projected Hours |
System-generated hours. |
|
Read-only. |
Net Hours |
Projected Hours +/− adjustments (including overtime). |
|
Read-only. |
Total Hours |
Total number of hours used in calculation. |
|
Read-only. |
Total Units |
Total number of items used in calculation. For example, rooms, hours, covers, etc. are all units. Units are typically generated by the forecasting process. |
|
Read-only. |
Overtime % |
Percentage of line that is overtime. |
|
Read-only. |
Average Daily Rate |
Room Revenue ÷ Total Occupied Rooms |
|
Read-only. |
Average Check |
Food revenue ÷ food covers |
|
Read-only. |
Avg. Rate |
Average rate of pay expected for employees during the selected time frame. |
|
Read-only. |
Adjusted Rate |
Average rate inclusive of all rate adjustments that have been made. |
|
Read-only. |
Projected Costs |
System-generated costs. |
|
Read-only. |
Percentage |
Percentage can refer to one of the following:
|
|
|
Regular Hours % |
Percent of regular hours from the referenced job line. |
|
|
OT Hours % |
Percent of OT hours from the referenced job line. |
|
|
Fixed Costs % |
Percent of fixed costs from the referenced job line. |
|
|
KBI Units |
Number of units in the KBI that is referenced on the line. |
|
|
Costs per Unit |
Rate that is applied to each unit on the line. |
|
|
Base Fixed Costs |
Fixed costs on the referenced job line. |
|
Read-only. |
Fixed Costs |
Costs that do not change with variations in the number of units sold. |
|
|
Fixed |
Costs that do not change with variations in the number of units sold. |
|
|
Factor |
A percentage adjustment that can be used to acquire a more accurate number. |
|
Read-only. |
Total Costs |
Total costs for line. |
All line types. |
Read-only. |