 |
 |
|
|
This view will output:
all client WIP budgets which have been entered at JOB TYPE level
the actual figures posted within the period, along with the variance between the actual and the budgeted figures
an OtherBudget value representing the sum of all budgeted figures which have not been entered at Job Type level
Inherits columns from the following views:
ibvClientCategorisation (All columns)
idvJobGroup (VisibleID as JobGroup and Description as JobGroupDescription - if no job group, then blank)
idvJobType (VisibleID as JobType and Description as JobTypeDescription)
| PeriodYear | The year of the budget |
| PeriodNumber | The time period number within the year |
| ExpectedCharge | The budgeted charge amount in money |
| ExpectedCost | The budgeted cost amount in money |
| ExpectedTime | The budgeted amount in minutes |
| ActualCharge | The actual WIP posted |
| ActualCost | The actual WIP posted |
| ActualTime | The actual Time posted in minutes |
| VarianceCharge | The variance between the actual and the expected charge expressed as an amount |
| VarianceCost | The variance between the actual and the expected charge expressed as an amount |
| VarianceTime | The variance between the actual and the expected charge expressed in minutes |
Group by the period number within the year and by job type.
Expense postings excluded from actual figures
Any posting types which are not included in Gross WIP figures. The posting types being equivalent to those which make up the Gross WIP (Time) figure on the WIP Movements report