How to create an electronic spreadsheet budget
Article Abstract:
A quarterly budgeting system for a hypothetical manufacturing firm is set up on a microcomputer using electronic spreadsheets to illustrate the computational and accounting advantages to such automation efforts. The budget system explained is accompanied by sample financial statements such a system could generate. Accountants interested in automating their budgetary activities are warned to: ensure that the system offers enough memory capacity (although 128Kbytes are generally required, most budgets will take up 512Kbytes or more), and invest in well-known spreadsheets(to avoid bugs). The automated budgeting described is accomplished using Multiplan software on a Macintosh microcomputer with 512Kbytes of memory.
Publication Name: Management Accounting (USA)
Subject: Business, general
ISSN: 0025-1690
Year: 1986
User Contributions:
Comment about this article or add new information about this topic:
Are you wasting time with your micro?
Article Abstract:
Use of microcomputers and computer programs in accounting may lead to an expensive loss of time if their use is not carefully managed. The purpose of using computers should be to reduce the amount of time taken up by tedious or difficult calculations. Planning the program requires defining goals, setting a time frame for program completion, clarifying users, understanding user needs, and deciding the form of the output. Writing the program, testing the program, and principles of simplicity are described.
Publication Name: Management Accounting (USA)
Subject: Business, general
ISSN: 0025-1690
Year: 1986
User Contributions:
Comment about this article or add new information about this topic:
Using your PC to project capital funds
Article Abstract:
A Lotus spreadsheet model can be used to calculate capital funds projections on a microcomputer. This allows the manager to figure availability of capital funds and assess one or more proposed projects. The model assumes three basic fund sources for long-term investments: long-term debt financing, new equity monies, and cash financing. The manager is able with the help of the model to adjust assumptions from initial data.
Publication Name: Management Accounting (USA)
Subject: Business, general
ISSN: 0025-1690
Year: 1988
User Contributions:
Comment about this article or add new information about this topic:
- Abstracts: How to have a facelift and get away with it. Intec Copper moves to prove its promise
- Abstracts: Thomas F. Carter of Carter Electronics: Calling for Competition. Stepping Aside
- Abstracts: Do arbitrage pricing models explain the predictability of stock returns? Assessing the market timing performance of managed portfolios
- Abstracts: Bank size, collateral, and net purchase behavior in the Federal Funds Market: empirical evidence. Dividend stripping, risk exposure, and the effect of the 1984 Tax Reform Act on ex-dividend day behavior
- Abstracts: Women in management accounting: determined to succeed. The magic of 3M management accounting excellence. Robert N. Anthony: creating an accounting framework