JOB: Calculating Daily Budgets

Whenever a new Job is added to WinTeam or a new Budget History record is added to an existing Job, the system recognizes the need to calculate the Daily Budgets for this record the next time any type of report is run that includes budget information. These reports include the following: Budget Comparison Report, Timekeeping Hours Report, Timesheet Print, Wage Report By Job, Job Cost Report, and On Screen Job Cost. When you run these reports, the system identifies the budget history records in the Job Master File that have not been calculated.

The system calculates budgets for each day of the year beginning with the Budget Effective Date and up through whatever year you have identified in JOB: Defaults.

Note:  Within the Job Defaults screen you are specifying how far out in the future to calculate budget records. If the option selected in Job Defaults screen is Only thru the End of this Fiscal Year, the system calculates daily budgets through the end of the current fiscal year. Once the Budget History Record has been calculated, the budget details cannot be changed in the Job Master File. A notation to the right of the budget history record will indicate Posted-Cannot Edit.

Labor Budgets

Each day of the year has a budget stored for it that can contain things such as: Budgeted Labor Hours, Budgeted Labor Dollars and Budgeted Tax and Insurance. When running reports that include budgeting information, the system is able to find the appropriate budgets for the time period selected and include these on the applicable report. For more information see Job Master File (Budgets tab)

Revenue Budgets

Within the Budget Details area of the Job Master File, you may specify Budgeted Bill Rates for each Hours Description entered. This information can then be used as part of the Daily Budgets calculation. Normally those jobs that are billed on an hourly basis would be the jobs which you would be specifying Hourly Bill Rates for. This would be a very common practice with security contractors.

Note:  Only those Hours Types selected in the budget details area of the Job Master File that have a Hourly Bill Revenue # entered in the Hours Type field will be allowed entry into the Bill Rate field. The reason for this is, in order to print a budgeted revenue amount, we must specify what general ledger number we want to use to show this budget. For this reason, you will not always be allowed entry to this Bill Rate field.