Building a OPEX rolling forecast

Post Reply
IsaacLau
Posts: 1
Joined: Sat Jan 14, 2017 1:20 am
OLAP Product: TM1
Version: 15.0.4885.1001
Excel Version: 2013

Building a OPEX rolling forecast

Post by IsaacLau »

Hi Friends... I am new to TM1 and would like to get some help from the community.

I plan to use TM1 for rolling forecast of OPEX involving several departments.

I have a Cube with YTD actual costs and ask other departments to update the forecasted OPEX, and I have another cube containing the budget data.
I would like them to input comments for the variances between 1) actual and budgets 2) forecast and budget.

For example, assuming there is a saving of 50,000 actual admin cost against budget, and there are 2 reasons contributing of 20,000 and 30,0000 saving each, I am hoping they can input the comments as follow:

Dept Saving Explanation
Admin 20,000 Reason 1
Admin 30,000 Reason 2

It would be perfect if there is any alert to the contributor if the total savings mentioned by them is less than the total.

How should I build it in TM1?

Appreciate any advice.
Post Reply