The following is an extract from the Strongware System Operator Guide.
5.5 Organizational Planning with BudgetSS and OrgBudgt The underlying notion for sequencing your activities is the procedure of "Plan-Program-Budget-Schedule", or "PPBS". You can set up a organizational planning and budgetting model for your organization, similar to your personal budget model, BudTax, using your OrgBudgt spreadsheet. You can relate your budget to your Strategic Organizational Planning process.
You can open your OrgBudgt spreadsheet and save a copy of it for your
organization as a starting point. You can customize your copy of OrgBudgt to
accomodate your organization or business. You can use it in a company or
corporation for your various departmental financial responsibility center
managers with specific programs, products, or services.
You can enter data for individual items into your *OrgBudgtS Screen sheet and it will summarize the data, for example, on a monthly basis; you can then copy and paste the sums into your OrgBudgt sheet.
You can notice how the advertising is set up for mutiple product markets.
You can also insert rows for product or service Costs of Goods Sold and sum
them, if you like.
You can track your bank balances and petty cash or out-of-pocket expenses.
OrgBudgt is set up your for quarterly and annual summaries of planning estimates and actuals.
You can consider each financial center with an accountable manager as a
small business, that is, a Line Item.
You can aggregate their OrgBudgt data into your Master Organizational OrgBudgt by
copying and pasting and summing.
You can duplicate your OrgBudgt for future years, going out as far as you feel
confident for long-range planning. If your periodic operations are constant,
you can simply copy+paste from one period to others.
a. PAL-TA-PAL. Your OrgBudgt has an annual budget with the Potential Assets and Liabilities -TransActions,
PAL-TA-PAL, notion. The left- and right-hand columns are for your Annual
Report statements, summarizing inventories, bank balances, and so on.
( PAL-TA-PAL is omitted from the example below.)
b. Translating with BudgetSS. You can arrange your Line
Items and translate your Probable Periodic Values, PPVs, from your LaPS database records for your
income and expenses.
You can copy+paste or translate your data from your LaPS record for your Line Item
into your OrgBudgt. You can fill in the LaPS "Budget Item" field just as you
filled in this field in your PrsNote. You can then translate with the
BudgetSS report just as you did with your BudTaxSS report and
import it to your OrgBudgt model just as you did with your BudTax model.
The main differences are that, whereas you used your PrsNote 'Estimated
Total' for planning and the 'Actual Total' for recording, you can use your
LaPS 'Real' for planning and your 'Problem' for recording.
If all goes as planned, you will have zeroes as 'Problem' figures, but, if
you do have differences, you can enter them in the 'Problem' column and then
update your budget with the 'Real + Problem' just as you did with PrsNote BudTax
for the 'Actual Total'.
+--------------------------------------------+------+------+------ | 98BUD 1998 | | | | W128 YOUR BUSINESS NAME Monthly | | | | Budget:| | | +------------------------------------+-------+------+------+------ |BANK BEGINNING BALANCE | | | 1000 | +------------------------------------+-------+------+------+------ | Automatic Deposits > | 100 | | 100 | | Added Deposits > | 500 | | 700 | +------------------------------------+-------+------+------+------ |PART I INCOME: | |January |Februa +------------------------------------+-------+------+------+------ | NCOME: PROGRAM / MARKET / CLIENT | | Real | Prob | | PROGRAM 1042 | 300 | Plan | Actl | /////////////////////////////////////////////////////////////// +------------------------------------+-------+------+------+------ | 1. SUBTOTAL INCOME | 849 | | 0 | | 2. Returns/Allowances | 0 | | | +------------------------------------+-------+------+------+------ | 3. Subt. 2 from 1: NET INCOME | 849 | | 0 | +------------------------------------+-------+------+------+------ |Pt III Cost of Goods Sold | | | | | 33. Inventory @ begin month | 840 | | 840 | | 34. Purchases less personal | | | | | 35. Cost of labor | 0 | | 0 | | 36. Materials & Supplies | 0 | | 0 | | For: |X | | | | 37. Other costs | 0 | | 0 | | For: |X | | | | 38. Sum L7..L10 (33.37) | 840 | | 840 | | 39. Inventory @ end of mo/year | 616 | | 840 | +------------------------------------+-------+------+------+------ | 40. Cost of Goods Sold | 224 | | 0 | +------------------------------------+-------+------+------+------ | 5. GROSS PROFIT | 625 | | 0 | +------------------------------------+-------+------+------+------ | 6. Other Income | | | | | For: | | | | +------------------------------------+-------+------+------+------ | 7. GROSS INCOME | 625 | | 0 | +------------------------------------+-------+------+------+------ |PART II EXPENSES | |January Februar +------------------------------------+-------+------+------+------ //////////////////////////////////////////////////////////////////// | Misc. Expense #1 | | -100 | -101| | For: | |Eyeglasses | +------------------------------------+-------+------+------+------Printing: You can use your spreadsheet function for copying values to another sheet for printing customized parts. A sheet of newspaper can be used for mounting six letter-size sheets with two-sided tape.
a. Balance Sheets. You can emphasize your PAL-TA-PAL by deleting the IRS and monthly columns so as to highlight the beginning PAL, the Totals, and the ending PAL.
b. Working sheets. You can delete the PALs and IRS columns and print only the monthly or quarterly columns. You can also highlight quarters and sub-totals by daleting the minor rows. ( BE SURE TO BACKUP YOUR ORIGINAL SHEET TO RETAIN FORMULAE.)
Back to -> *Home
