Project Limit View

Navigation:

Project Listing > Limit View

Access Right:

Project Related > Project Limit View in web

 

Purpose

The Project Limit view shows the charges incurred so far and forecasted charges for a project for comparison to an overall project limit. This report has been provided for users who charge their services entirely on a time and materials basis as it provides an early indication of likely overspends against an agreed invoice limit and will be more useful than the profitability view.

 

Additional Information

Project Visibility

By default this view only shows projects from your favourites list. This is because the view combines a lot of data from income schedules, timesheets and resource plans and can take a long time to produce.

However, if you want to view all projects* you have visibility of in this view without it restricting to your favourites you can request this from your system administrator.

They will need to change the Restrict Web Project Views setting on the Control Parameters > Additional Projects tab page. They will then need to grant your user record the Restrict Project Views to Favourites user option via the System Administration > Allocate User Timesheet Options > Web Options tab page.

Please note that the users access right restrictions which limit the user to 'My Project Set' or As Project Leader' still apply.

*Excluding projects which are;-

       Marked as overheads,

       Have no Limits set

       Don't have any invoice values

 

Projects you are a project leader or deputy for are always added to your favourites, as are projects you book time to. To add and remove projects from your favourites list, use the Manage Favourites option under the Home menu.

 

Column

Description

Effective Date

This is not a column in the report but a date which you can enter. It defines the date up to which costs are taken from timesheets and invoices and after which costs are calculated from resource plans or forecasted task dates.

Limit

The agreed invoice limit as entered on the Edit Project Invoicing Parameters page.

If no limit is entered the following calculation is used:-

Sum of Client Fee's (Fixed Fee tasks) +

Sum of Timecharge Estimates (Time-charged tasks) +

Sum of any expenses up to and including the Effective Date.

Fees/Time Invoiced

The value of fixed fee or time-charges invoiced up to and including the Effective Date.

Expenses Invoiced

The value of expenses invoiced up to and including the Effective Date.

Fees/Time WIP

The value of chargeable fees and time earned up to the Effective Date but not yet charged.

Expenses WIP

The value of chargeable expenses which are chargeable prior to the Effective Date but not yet charged.

Forecast Fees/Time

The value of fixed fees and timecharges from the Effective Date to the end of the project. These are calculated as follows:

Fixed fees from monthly fee schedules

Timecharges from future resource plan

If neither of the above are available, the income is forecast using a straight line apportionment between the task dates

Forecast Expenses

 

The value of expenses forecasted to be charged after the effective date. The only way to enter these is to enter expenses as chargeable and date them in the future.

Invoice %

The total amount invoiced as a percentage of the project limit.

Limit – Forecast

The total amount of limit remaining.

Calculation: Limit – Amount Invoiced – WIP Amounts – (Forecast Fees/Time + Forecast Expenses).

Forecast %

The total amount forecast expressed as a percentage of the project limit.

Calculation: (Amount Invoiced + WIP Amount + Forecast Amount) x 100% / Project Limit

RAG

A red/amber/green traffic light shows red if an overspend is likely or green if not.

RED

There has been more invoiced than the Limit

Calculation: Invoice % > 100

AMBER

Forecast to spend more than the Limit

Calculation: Forecast % > 100 and Invoice % < 100

GREEN

Project on schedule to be delivered in accordance to the Limit.

 

Detail Reporting

More detailed reports are available showing the profitability in more detail, and graphically.

To view the profitability for a project in more detail:

1.Select the project you wish to report on.

2.Click the btnGridMenu button.

3.Select one of the reports under the Reporting menu.

Any images shown may be representative of the previous version of Timemaster

Report a problem

Please report any errors on this page to timemastersupport@equisys.com