Sign-in
About our forums

Our forum platform uses a separate login to identify you; it's not the same as your LiquidPlanner application login.

>> Login to the forums now 

If you wish to post and subscribe to change notifications, you will need to create a forum account.

After you login, you can access your profile by clicking your name floating at the top of the page. Clicking your name will also allow you to subscribe to e-mail change notification messages for the section you are currently looking at. 

Note, the forums are a public area. Do not post any private workspace content.

User Forum > Forecasting?

Hi all!

My wife is still trying to decide which tool they will be using at her organisation, currently 50 employees + 50 consultants approximately, running lots of concurrent projects. Over the weekend she got the task of forecasting three projects that are running and the respective project managers gave her Excel files with various information about their planned activity.

Now, the data is in the form of planned number of hours per week (for the next 3-6 months) for the involved members. Typically 40 or 20, but some people only being available during specific periods. Some are employees and some are consultants. The consultants have individual rates and they are the "cost" in all this, and an interesting twist is that the managers that themselves often are consultants, often do not know the rates! But disregarding that part - how do you approach such forecasting in LP? I have made the following observations:

1. In LP we need at least one task per member in order to "put the hours" somewhere, ok, fine, doable.

2. But... the rates mechanism (the beta stuff, haven't played with it, only read about it) are only used for reported actual spent hours, right?

3. And AFAICT there is no report that can show me "upcoming hours per month" and of course not "upcoming cost per month".

So is there stuff in the pipeline (like more reports and the ability to connect a rate to "planned" hours?) or do I need to take some other approach to be able to do forecasting like this?

regards, Göran

January 24, 2010 | Registered CommenterGöran Krampe

Hi, nice to meet you.

Yes #1 is required and will be the basis for forecasting. Creating a task for a person, that is associated with a client/project, estimating it, and setting the activity will associate that work with a pay rate (and billing rate).

re #2: In the current beta release of rate sheets we only apply the ratesheet when you export time log records. We don't have a forecast report yet, but that is one of the things we will deliver in the Budget Controls release targeted for this summer. It will work off the same rate sheet data.

re #3 we don't have that report designed yet either; if you are interested in working more closely with us on your requirements and/or using a temporary LP + Microsoft Excel solution let us know and we can continue the discussion via email.

January 24, 2010 | Registered CommenterCharles Seybold