The Work in Hand Schedule screen is integrated within Unsecured Works Maintenance, to allow for time-based allocation of the expected project Turnover, Costs, and Margin values, over the expected Contract execution period.
The WIH review and allocation process commences with the selection and display of the WIH yearly analysis screen, which dissects the project duration into financial year elements with key project financial values and completion percentages shown.
The direct data entry of a value or percentage against either of the Turnover, Cost, or Margin fields (dependant on Project Type), on a yearly analysis line is permitted for any year during the expected project execution period.
The objective of this screen is to allow the user to distribute the WIH Total values shown under each column, within the project execution period. Once this process is complete, there should be no ‘Unallocated’ values displayed on this screen.
Having allocated values over the financial year records, it is then necessary for the user to allocate this forecast Turnover, Cost, and Margin over the months within each financial year. This is achieved by selecting the relevant year, right-clicking, and choosing Select, and the 12-month dissected screen view displays with each month between project start and finish available for user allocation of Turnover, Cost, and Margin (dependant on Project Type).
Right-click and choose Select. The following screen displays.
The user can then allocate the outstanding Turnover, Cost, and Margin by month by either of the following methods and utility options:
- Select the Clear Totals checkbox to initialise all Project and Forecast Turnover, Cost, and Margin values recorded for the financial year displayed.
- Select the Prorata Totals checkbox and click OK. The outstanding (unallocated) values will then be equally spread over the available (data entry capable) months of the year selected.
- The user can directly enter the required values or completion percentages, against each data entry capable month row displayed to ensure that no remaining ‘Unallocated’ WIH values exist for that financial year. Alternatively, select the Accumulate Totals checkbox to update the financial year totals displayed.
- S-Curves can also be used to automatically allocate the monthly amounts based on the S-Curve. See the Function Guide ‘S-Curves for WIH Forecasting’.