Editing a cost structure for a budget line

With cost structures, you can configure how Budgeting calculates total monetary amounts using units, rates, factors, and fixed monetary amounts. There are two different methods of editing cost structures: with ranges and without ranges. KBI, Market Segment, Revenue Center, and Percent of Base lines are configured using ranges. Fixed and Job lines are configured without ranges.

Note: Total and Calculated lines do not have a Cost Structure & Results tab.

1. In the upper-left corner of the screen, select Access your applications (  ).
   The menu expands.

2. Select Financial > Budgeting.
   The Budgeting Dashboard screen appears.

3. 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.

4. Select the datasets and periods to work with.
   For more information, see Viewing budget datasets and Viewing information in the Budget Tree screen

5. Locate the line in the Budget Tree.

6. Double-click the budget line for which to edit the cost structure.
   The Edit Budget Line dialog box appears.

7. Select the Cost Structure & Results tab.

8. Edit the table cells as necessary.
   

   Cost Structure & Results fields

   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:  Job Class (  ) Percent of Labor (  ) Percent of Hours (  ) Total	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: KBI = (KBI Units × Cost Per Unit) + (Fixed Costs × Factor) Fixed = Fixed Costs × Factor Market Segment = Fixed Costs × Factor Job Class = (Hours × Adj. Rate) × Factor + (Fixed Costs × Factor) Percent of Labor = Regular Cost + OT Costs + Fixed Costs Revenue Center = Fixed Costs × Factor	All line types.	Read-only.
   Add Range	Opens the Edit Ranges dialog box where you edit and add ranges.	Fixed (  ) KBI (  ) Job Class (  ) Percent of Labor (  ) Percent of Hours (  )
   Table	If a cell is editable, you can double-click and add/edit a value.
   Periods	Financial periods for the budget line.	Fixed (  ) KBI (  ) Market Segment (  ) Job Class (  ) Percent of Labor (  ) Percent of Hours (  ) Calculated (  ) Revenue Center (  )	Read-only.
   Rooms	Number of rooms budgeted.	Market Segment (  )	Read-only.
   Covers	Number of guests budgeted, usually at a banquet, event, or restaurant service.	Revenue Center (  )	Read-only.
   Base Hours	Net hours from the referenced job line.	Percent of Labor (  ) Percent of Hours (  )	Read-only.
   Projected Hours	System-generated hours.	Job Class (  )	Read-only.
   Net Hours	Projected Hours +/− adjustments (including overtime).	Job Class (  ) Percent of Labor (  ) Percent of Hours (  )	Read-only.
   Total Hours	Total number of hours used in calculation.	Job Class (  ) Percent of Labor (  ) Percent of Hours (  )	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.	Calculated (  )	Read-only.
   Overtime %	Percentage of line that is overtime.	Job Class (  ) Percent of Labor (  ) Percent of Hours (  )	Read-only.
   Average Daily Rate	Room Revenue ÷ Total Occupied Rooms	Market Segment (  )	Read-only.
   Average Check	Food revenue ÷ food covers	Revenue Center (  )	Read-only.
   Avg. Rate	Average rate of pay expected for employees during the selected time frame.	Job Class (  ) Percent of Labor (  ) Percent of Hours (  )	Read-only.
   Adjusted Rate	Average rate inclusive of all rate adjustments that have been made.	Job Class (  ) Percent of Labor (  ) Percent of Hours (  )	Read-only.
   Projected Costs	System-generated costs.	Job Class (  ) Percent of Labor (  ) Percent of Hours (  )	Read-only.
   Percentage	Percentage can refer to one of the following: Percent of Base (  ) hours on the Percent of Labor (  )  from the referenced job line. Percent of Base (  ) costs on the Percent of Base (  ) from the referenced budget line.	Percent of Labor (  ) Percent of Base (  )
   Regular Hours %	Percent of regular hours from the referenced job line.	Percent of Hours (  )
   OT Hours %	Percent of OT hours from the referenced job line.	Percent of Hours (  )
   Fixed Costs %	Percent of fixed costs from the referenced job line.	Percent of Hours (  )
   KBI Units	Number of units in the KBI that is referenced on the line.	KBI (  )
   Costs per Unit	Rate that is applied to each unit on the line.	KBI (  )
   Base Fixed Costs	Fixed costs on the referenced job line.	Percent of Labor (  ) Percent of Hours (  )	Read-only.
   Fixed Costs	Costs that do not change with variations in the number of units sold.	Fixed (  ) KBI (  ) Percent of Base (  )
   Fixed	Costs that do not change with variations in the number of units sold.	KBI (  ) Job Class (  ) Percent of Labor (  ) Percent of Hours (  )
   Factor	A percentage adjustment that can be used to acquire a more accurate number.	Fixed (  ) Job Class (  ) KBI (  ) Percent of Base (  )	Read-only.
   Total Costs	Total costs for line.	All line types.	Read-only.

9. To change field values, double-click cells and enter new values.

10. To add a range, do the following:

    1. Select Add Ranges.

    2. From the drop-down list, select the type of range:

       • Costs per Unit

       • Fixed Costs

       • Factor
         The Edit Ranges dialog box appears.

    3. Select Add Range to add as many ranges as necessary.

    4. Edit the fields as necessary.

    5. Select OK.
       The dialog box closes, and the range is added.

11. To edit a range, select Edit Range and complete the steps above used to add a range.

12. If you need to copy and paste an entry:

    • To copy the entry, do one of the following:

      • Right-click the entry and click Copy.
        or

      • Select the entry and press Ctrl+C.

    • To paste an entry, do one of the following:

      • Right-click the cell where you want to paste and select Paste.
        or

      • Select the entry and press Ctrl+V.

13. If you need to copy an entry to all subsequent periods:

    • Right-click your entry and select Copy Down.
      The selected value is copied to all lines below.

14. Select Save.