Spreadsheet calculation model 1

The business plan profit projection for entrepreneurs, as annexure to the presentation: "How to compile a Business Plan" on the previous page.

Spreadsheet calculation model 2

Inventory control quick reference matrix guideline of EOQ (for variable price and usage) and ROL (for variable usage and delivery). For supervisors, buyers, storekeepers and stock controllers; goes hand-in-hand with stock control principles explained in the presentation: "How to control stock levels" on the previous page.

Spreadsheet calculation model 3

Ammortisation for finance planners and controllers.

Spreadsheet calculation model 4

Breakeven turnover analysis for variable required profit levels after tax; for business evaluators, chief executives and business owners.

Spreadsheet calculation model 5

Cash flow projections on a twelve month rolling basis for entrepreneurs and finance planners.

Spreadsheet calculation model 6

Calculation of economic equipment replacement point in time, based on maintenance cost history, cost of capital and replacement cost, for maintenance and capacity planners.

Spreadsheet calculation model 7

Aggregate logistics planning, based on backward scheduling, starting from the marketing plan and going right through to ordering of required components or raw material. For marketing administrators, production planners, component or raw material planners, buyers and despatch controllers in a manufacturing environment.

Spreadsheet calculation model 8

Customer service efficiency measurement for improvement of departmental performance.