Create a sales budget with multiple drivers
3:35 min
Dan demonstrates how to create a Sales budget using multiple measures for driver-based budgeting. In this example, Dan brings in quantity, price and margin as additional values and uses them to calculate cost of sales, as well as adding working and reference lines to help drive the budget.
Supporting documentation
Phocas product
Tags
Related video tutorials
Contribute to the workflow
Play your part in the budget or forecast workflow. View your assigned tasks, then complete and submit those tasks.
3:03 min
Spread totals
Distribute total values quickly to determine the individual budget values. You can spread a total you manually enter or a total from a comparison stream, either evenly or proportionally across the period.
4:59 min
Use comparison rows
Use comparison rows in a budget or forecast worksheet to automatically include values from another data stream, such as last year's actuals, last year's budget, the current year's forecast and so on. You can use these values in formulas to calculate the new values or simply have it at hand for references purposes.
4:23 min
Explore the forecast workbook
This video gives an overview of the key elements of a forecast workbook, including how to save time using the ‘spread’ feature.
2:40 min