MASTER BUDGETING PRO 4.6_1
Company budgeting workbook for all Excel users. Provides integrated monthly budget - actuals - variances spreadsheet for up to 10 profit divisions or subsidiaries.
Your budget can start at any month end date. The program defaults to the most recent month end for reporting revenues/expenses actuals/variances and totals, and you can adjust the reporting month end to any date you want.
Each of 10 division/department/profit centers has three budget pages: 1). Monthly budget revenues (25 rows each), cost of sales % by each revenue row, expenses by catagories (100 rows each) and overhead allocations: 2). Actual monthly results: 3) Month end budget/actuals/variance reports plus cumulative totals and profit analysis to the chosen month end. You can add rows and categories to each budget and format currencies and cells.
Combined total company report compares total budget sales and operating profits to actuals and analyzes each variance.
Year to date report analyzes each divisional sales performance, cost of sales, expenses and operating profit performance to the selected month end.
Provides benchmark profit margins for individual business sectors
You can budget and report central overhead and fixed expense budgets and allocate these to individual divisions/profit centers if you want, and incorporate these expense into monthly performance reports (or you can select not to allocate).
Minimum requirements: Excel 97 and above. Requires 5 MB disk space.
The download is zipped. After downloading locate the file and double click to decompress. |