| |
|
|
 |
The new business plan
start up calculations
This spreadsheet model helps you to work
out the viability of a new venture. It gives you the capital requirements
to start up a new business, as well as monthly operating cost, monthly
income and monthly profit.
Once you have finalised it, you will be able
to use it as a motivation to arrange external finance and as a budget plan
against which you can measure actual results.
You should also order the
presentations module "Planning a new Business" as a guideline for planning
your new business venture and use the spreadsheet model to do all the
calculations. $19.00 |
| |
|
|
 |
Inventory control
calculations
Make economic buying decisions
and plan when to buy to avoid downtime - for purchasers, engineers,
supervisors and foremen.
This program allows you to modify inputs such
as purchasing cost, holding cost, price and usage quantities to suit your
particular situation.
What you get is calculation of economic order
quantities and re-order levels for various usage and price levels on a
read-off matrix. A printout can also be made for daily continuous usage by
purchasers, engineers, supervisors and maintenance personnel. It can guide
people to make economic purchasing decisions for the
organisation.
You should also order
the management module "Stock Control Techniques" as a guideline and use
this model for all the calculations. $19.00 |
| |
|
 |
Equipment replacement
calculations
Make economic replacement
decisions to increase availability and organisation profits - easy to use
scientific method. This model calculates the economic replacement point in
time for any piece of equipment or machinery. You get financial and
statistical calculation of desirable replacement moment in time. In this
model you have to enter the annual operating cost, average inflation rate,
financial interest rate and replacement value for each piece of equipment.
The model calculates the total payback annuity on capital and operating
cost and the economic life span. Economic life span in turn are based on
the square root of (2 x avg annual present value ops cost / replacement
value). A warning signal becomes operative when economic life span is
reached. Includes a floating graph.
It can be useful for monitoring
replacement of vehicles, be it on-road or off-road.
You should also order the presentations module "How
to motivate Capital". $19.00 |
| |
|
|
 |
Ammortisation
calculations
Monitor investments, debt, hire
purchase installments and payback of loans. Do various calculations and
see the impact of interest rates instantly. You get financial calculations
based on variable interest rates, periods and amounts. This model
calculates the answers to the following most asked questions: 1. How many
periodic payments must be made to achieve a specific future financial
target? 2. How long will it take for my investment to grow to a specific
future financial target? 3. What periodic payment is required to pay back
a loan? 4. What interest rate is necessary to increase a single investment
to a specific future target? 5. What is the present value of a future
annuity investment? 6. What will the future value be of a periodic annuity
investment at the end of the period? Furthermore examples of amortisation
on a monthly basis and an annual basis are included for monitoring of
payback of loans or credit purchases. $19.00 |
| |
|
 |
Logistics planning
calculations
Aggregate organisational
planning of sales, production and supportive logistics - for medium to
large sized manufacturers and corporate logistics
planners.
This program can be used
to plan desirable distribution rate of final products, production
quantities of final products, stock levels of final products and raw
materials/spares/sub-assemblies and the supply plan for incoming goods,
based on the sales forecast, where a direct relationship (dependant
demand) exists between one unit of production and units of raw
materials/spares/sub-assemblies.
You must obtain the following
information on a monthly basis from other sources within the organisation
(Most of it will remain relatively stable once you have obtained
it):
Updated Sales forecast, stock balances as at previous month end,
production backlog, production capacities per product line, the
proportional relationship between a unit of final product and the
materials it is made up off , delivery periods of supplies.
You can
also incorporate this program into another program to make your existing
system more comprehensive.
Sales Forecast:
The sales forecast is the essence of the whole
game plan. It is the starting point for all the other calculations. You
have to change it on a monthly basis to keep track of reality for the
whole forecasted period. The forecasted period must be longer than 12
months to provide for backward scheduling of ordering needs for 12
months.
Safety stock levels of final
products:
The purpose of safety
stock is to support sales, when production falls behind sales due to
disruptions, stoppages, maintenance, lack of raw materials. You have to
change the proportion of safety stock (as a proportion of sales forecast)
according to your specific needs. Provision has been made to alter the
proportion in any particular month for seasonal trends. You also have to
quote the ending balance of each product as at previous month
end.
Production Plan:
The production plan is calculated to support
sales and safety stock. The idea is to produce for sales and any shortages
in safety stock and to catch up on any backlogs from the past. You have to
spread out any backlogs over any period to suit
yourself.
Raw Materials/Spares:
Raw materials /spares needs and arrival plans
are calculated to support production and safety
stock.
Summary:
Floating graphs are included. $19.00 |
| |
|
 |
Breakeven analysis
calculations
Plan volumes, profit and market
penetration strategies.
You get financial breakeven calculations for
various fixed costs, variable costs, sales targets and profit targets.
Variable costs are those which fluctuate directly in proportion to volume
of sales or production. In other words if sales goes up so does purchases
as purchases will vary with sales.
The use of the variable cost method
in calculating breakeven point, is the most correct method for all
organisations. However, it is not always the most convenient method.
Therefore you can also use two other methods in the same way, namely cost
of sales and landed cost. If you use landed cost and mark-up rate, you
assume that administrative and selling expenses in the trade account and
all other expenses in the profit and loss account are fixed costs.
If
you use cost of sales and gross profit rate you also assume that all
expenses in the profit and loss account are fixed. Fixed cost can usually
accommodate increases in volume up to a certain limit. If you want to go
beyond that limit, additional capital expenditure may be required, which
in turn will increase total fixed cost. Breakeven = Fixed cost /
contribution rate
The breakeven point is where turnover just covers
variable cost as well as fixed cost without making any profit. The
calculations are based on the assumption that the profit margin remains
unchanged.
Provision has been made for a read off matrix which
calculates required sales volumes for various required profit margins and
a read off matrix for calculation of required sales volumes for various
levels of fixed and variable costs to break even.
You should also order the presentations module
"Planning a new Business", where the theory of breakeven analysis is
covered in detail, complete with examples of various price strategies.
$19.00 |
| |
|
 |
Customer service
efficiency calculations
Increase departmental
performance and organisation profits - for internal service providers such
as workshops, despatching, purchasing and CAPEX projects.
Encourage employees and departments to improve
performance!
You get tracking calculations of service efficiency
measured against targets.
This measuring technique of customer service
can be used by workshops for job cards and by sales/distribution
departments for despatch of orders received.
Measuring is by dates. It
can also be used by other functions where customer service is of
importance such as in purchasing and projects.
The percentage
efficiency is calculated for each instance as well as the average for all
cases. A floating graph is also included. $19.00 |
| |
|
 |
Cash flow
calculations
Helps you to identify required
actions timeously to eliminate cash deficits and to arrange finance - easy
to use for all sized businesses and corporate accountants. This model
allows you to do projections for 12 months ahead. It helps you to take
prior actions to rectify cash outcomes ahead of time. It also helps you to
plan for finance and loans before it is too late. Easy to use and adapt.
$19.00 |
| |
|