valuationbreak evenprofitcontributionforecastshiftqueuingbusiness analysis
accountbasbudgetBAS-I.Cshare valueshort salesinvestment
site mapform1

Browse All Question and Answer Items

Items selected where Item is 48

Questions & Answers

Q: Just bought the Forecast and Budget Builder. We have a seasonal business with 4 retail locations, service and construction. I have revenue and expense history prepared by our accountant, broken down by cost centers. This is what I plan to achieve. Input 1 year of historical data - revenue and expenses (fixed and variable) cut spending by percentage in the variable area define labor costs to budget project growth location analysis for marketing etc. On the budget by month screen - how much of the input area is formulas? I can't see any of the formulas...should I be able to? How should I start this project. On the monthly budget page? Any help would be appreciated.

A: The Forecast and Budget Builder is a high level tool. On the input sheet there are broad categories and forecast inputs. This is where you start, with a few basic inputs you can develop a high level forecast for 3 years. Once you are happy with this you can adjust the revenue percentages in the Budget by Month Master. This allows you set set seasonality/monthly variations. On the Budget by Month sheet you can then refine this calculated budget further with the capacity to vary the value of each line item. Input cells are blue, most other cells include hidden formula (you should not change these and they are hidden). Many clients use this to build a forecast high level budget (ie it only has set line items) and then use the Budget Tool Business https://bizpep.com/BudgetTool.html to establish an item by item budget.

Question and Answer Item 48 - Browse All Question and Answer Items