For tracking a budget with Fohlio and breaking it by Area and Category,
The steps will be:
1. Select the column to track the budget.
2. Set the planned budget per project and per area.
3. Track the budget with each update you make.
Let’s start!
1. Select the column to track the budget:
From the Project Sheets, on the Area Navigator, we will see the Budget is calculated based on the column selected (Client Total, Retail Total….).
You can select which column to be tracked from the Budget drop-down menu.
Make sure that the selected column includes the QTY of the item in its Formula (a Total Price Column)..
If the column you want to select does not appear in the drop-down menu,
please check for this:
A). The column is not in the selected Phase you are in, i.e.: Client Total column exists in Budgeting but not in the Product specification.
B). The column must be a Pricing related column. You can change the Column Property inside Column Settings > Column Property > Pricing Column
After you make sure of these 2 conditions, the column should appear in the Area navigator drop-down menu and you can be selected to Track your budget.
2. Set the planned budget per project and per area.
Set the Planned budget for the whole project when you create the project, or from the Project Editor.
Set the planned budget per Area > from the Area Navigator you can set the budget per Area.
If the Area is parent ie: 1st Floor, the Planned budget will be the sum of all children's areas.
3. Track the budget with each update you make:
After you set up the column you want to use for budgeting and set the planned budget, you can start the tracking.
The budget will be calculated per area, and you can compare it with the planned budget.
If the current budget exceeds the planned budget it will turn red.
-
Pro Tip:
When creating a PDF Table View Presentation > Show Project Total, the column used for budgeting will be used on the report..
We hope this article was helpful, please rate the article, and reach us via Live Help if you still need assistance.