Control Sheet - Salaries & Wages

Allowances 

You can select more than one Allowance for a selected person.

This is only available if there is at least one active (non-retired) allowance on that control sheet type.

When an allowance is selected, the weekly rate calculation is updated for that person to include the selected allowance(s).

Budget & Forecasting Enhancements

On Salaries and Wages Control sheets there are comment boxes for:

• One-off Cost
• Worst
• Target
• Best
• Forecast Final Cost

Worst, Target & Best fields:

• Time (no. of weeks) (Number)
• Weekly Cost (Number)
• Other Items (Number)
• Total Position: (Time x Weekly Cost) + Other Items (Calculation)

Approve Button (Only can be pressed by Control Sheet Approvers)

• Copies Final Forecast Cost into Previous Forecast
• Variance is different between Current and Previous Forecast

Budget Rows

• Original Budget (Number) (Manual Entry only)
• Approved Variations (Number) (Manual Entry only)
• Approved Budget (Calc) (Original Budget + Approved Variations)
• Gain / Loss: Approved Budget - Final Forecast Cost (Calculation)
• Append Delta to Worst, Target and Best labels.
• Update Excel export based on new rows / columns and config settings.

Default Allocations

When set up by your administrator the control sheet will display:

• A Start Date column (Month - Year selection)
• A Finish Date column (Month - Year selection)
• A row for default allocation % (Default 100%)

When both the start and finish dates are entered, the applicable months will be pre-allocated as per the default allocation.

Insert Row

To insert a row, Click on the Insert Row button.

This will insert the row after the currently selected row.