Excel spreadsheet calculation models

Three products in one image

Excel spreadsheet calculation models available as PC software products

These software models are problem solvers for many job functions in the private and public sectors.

Eight Excel PC Software calculation models

These software products are mostly used by Entrepreneurs, Business Owners, Engineers, Accountants and Auditors.

Video introduction to our products listed on various pages on this website:

All these software products can help to increase success for first-time Entrepreneurs, existing business ventures and Government entities.

The use, understanding and application of these software products can increase business profitability and service delivery levels of Government entities.

In the work environment, these software products can even become career boosters for the persons implementing the principles applied inside the products.

 1.Spreadsheet calculation model – Inventory control

Excel inventory control calculations model e-boxA 1. Listing of stock items with automatic calculation of economic ordering quantities and re-order levels

This option is available on page B.

1.1. Ordering cost per order:

The first step is to calculate your specific ordering cost per order. You only have to do this once per annum.
You do this by adding up all the relevant annualised costs which are directly ascribable to the purchasing function and dividing it by the total quantity of orders per annum. The areas where you must make changes or enter information are highlighted on all pages.

1.2. Holding cost rate:

In order to carry stock you must provide space, shelves and handling equipment for it. All these are costing money. Furthermore you are likely to have a system and equipment to keep track of stock movements – this is also costing you money.

Thirdly money is tied up in the stock which you keep. Certain items will also become redundant and there may be losses due to perishables, damage and expiry of shelf life.

Another inevitable cost item will be salaries and wages.

One way to calculate your holding cost rate, which is the easiest, is to take your bank borrowing interest rate and add a certain percentage to it.

If for instance your borrowing rate per annum is 20% and you add another 5% for losses, you get 25%.

The other way is to calculate your holding cost rate by adding up all stock holding costs and express it as a % of average inventory value.

1.3. Total lead time:

The total lead time calculated on pages B and D is made up of four periods:

  • Review time in days – the period which elapses between review of when to order until the next review
    Actual delivery in days – the time it takes from ordering date until receipt of goods.
  • Safety stock in days – the quantity of safety stock you wish to hold for deviations in demand and delivery
  • Seasonal trend in days – the quantity of stock you wish to provide for seasonal increases in demand or delivery. You may have experienced increases in certain months of the year.

1.4. Economic ordering quantity formula:

The formula used on pages B and C is as follows:

  • The square root of (2 times ordering cost / holding cost rate)(annual consumption / landed price per unit)
    or the square root of (2 times ordering cost / holding cost rate) times square root of (annual consumption / price).
  • Economic ordering quantity increases with increase in demand and decreases with increase in price.
    This can be clearly seen from the matrix on page C.

1.5. Re-order level:

  • The meaning of re-order level is that when stock depletion takes place to a level of equal to or below this point, you have to re-order the economic ordering quantity.
  • It is thus the trigger when to order again.
  • Your review period may be daily, weekly or monthly. The shorter the period, however, the lower the stock holding.

The re-order level formula is:

  • Average consumption per day times total lead time in days.
  • The re-order level increases with increase in demand and lead time.
  • This can be clearly seen from the matrix on page D.
B 2. One off calculation of economic ordering quantity:

This option is available on page C. You must use the same ordering cost and holding cost rate as calculated before.

C 3. Economic ordering quantity read-off matrix:

This option is also available on page C.

  • You can print it in parts, piece the parts together and use it as a quick desktop reference for everyday use.
  • On page C (2. Economic ordering quantity read-off matrix) the landed cost under column D and the annual consumption in row 28, may not suit you entirely. For instance the currencies can vary very widely from country to country.
  • If this is the case please change the quantities to suit you personally.
D 4. One off calculation of re-order level:

This option is available on page D.

E 5. Re-order level read-off matrix:

This option is available on page D  inside the software and you may use it in the same manner as the previous matrix already discussed.

This Inventory control software product is especially useful for Stock Controllers, Buyers, Entrepreneurs, Business Owners and Maintenance Planners, who may be interested  in improving the availability of needed stock items, with economic viable methods.

The presentation in Microsoft Presentations displayed below, is included as a bonus, with this software product. This product may just be on your wish list for a career booster.

Stock control presentation e-cover

Learn the theory behind stock/inventory control, how to calculate purchasing cost, economic order quantity per item, how to calculate re-order levels and how to calculate safety stock levels (Theta formula, calculating latest consumption trend quantities for production machinery spares) for risk aversion of possible production/sales losses (deterioration of service delivery levels).

In statistics, θ, the lowercase Greek letter ‘theta’, is the usual name for a (vector of) parameter(s) of some general probability distribution. A common problem is to find the value(s) of theta. Notice that there isn’t any meaning in naming a parameter this way. We might as well call it anything else. In fact, a lot of distributions have parameters which are usually given other names. For example, it is common use to name the the mean and deviation of the normal distribution μ (read: ‘mu’) and deviation σ (‘sigma’), respectively.

In the case of calculating safety stock here, we can for instance define that Theta means the average of the previous three monthly consumption quantities. If it indicates an upward trend, then we must add something (a quantity) to the calculation formula for stock re-order levels. On the other hand, if it indicates a downward trend, we must vice versa deduct a quantity. In other words re-order levels must follow the latest trends. You can also define an own meaning to θ (Theta symbol in formulas, to fit your organisation requirements).

When you click the buy button for Inventory control, you must see the following at the top when the PayPal page opens:

MNR PIERRE D B DU PLESSIS

Shopping buy button

The price is only $20.00 through the secure servers of PayPal.

2. Spreadsheet calculation model – Business Plan Preparation

Excel business plan calculations model e-box

  • Page B is a worksheet to work out the cash requirements and operating cost for the first month.
  • Page C is where you work out the sales volume for the first month and subsequent 11 months.
  • Page D is your financial statements for 12 months, where you can do adjustments, with floating graphical illustration.

This Business plan preparation software product is especially useful for Entrepreneurs, Business Owners, Accountants, Auditors and any person who may need finance for a new business start-up, business expansion or Government projects.

The presentations in Microsoft Presentations displayed below, are included as a bonus, with this software product. These products may just be on your wish list for career boosters.

How to compile a Business Plan:

How to do annual operating expense budgeting: How to motivate capital professionally:

How to compile a business plan presentation e-cover

Operational expense budgeting presentation e-cover Professional capital motivation presentation e-cover

When you click the buy button for Business plan preparation, you must see the following at the top when the PayPal page opens:

MNR PIERRE D B DU PLESSIS

Shopping buy button

The price is only $10.00 through the secure servers of PayPal.

3. Spreadsheet calculation model – Equipment Economic replacement point in time – When to replace

Excel equipment replacement calculations model e-box

This Equipment replacement software product is especially useful for Entrepreneurs, Business Owners, Accountants, Auditors, Engineers and Maintenance Planners.

Learn how to make informed and wise economic equipment replacement decisions for any type of organisation.

When you click the buy button for Equipment replacement, you must see the following at the top when the PayPal page opens:

MNR PIERRE D B DU PLESSIS

Shopping buy button

The price is only $20.00 through the secure servers of PayPal.

4. Spreadsheet calculation model – Aggregate logistics planning – Scheduling of raw material

Excel aggregate logistics planning calculations model e-box

This Aggregate logistics planning software product is especially useful for Stock Controllers, Buyers, Entrepreneurs, Business Owners, Production Managers and Logistics Managers, who want to plan the availability scheduling of important bulk/strategic raw material stock , for uninterrupted production.

Learn how to apply backward scheduling of ordering point in time, to avoid/minimise unavailability of important high consumption production raw materials, which may cause serious production losses (deterioration of service delivery levels).

When you click the buy button for Aggregate logistics planning, you must see the following at the top when the PayPal page opens:

MNR PIERRE D B DU PLESSIS

Shopping buy button

The price is only $10.00 through the secure servers of PayPal.

5. Spreadsheet calculation model – amortisation – Present values, Outstanding debt and Future values

Excel ammortisation calculations model e-box

This Amortisation software product is especially useful for Entrepreneurs, Business Owners, Accountants, Auditors, Project Engineers and any person who may need it for professional motivation of new small and big capital budgeting and budgeting of expansion projects.

The presentations in Microsoft Presentations displayed below, are included as a bonus, with this software product. These products may just be on your wish list for career boosters.

How to compile a Business Plan: How to motivate capital professionally: Project Planning & Execution:
How to compile a business plan presentation e-cover Professional capital motivation presentation e-cover Project planning and execution presentation e-coverx

Learn how to apply the principles inside the software and presentation products, to be more successful with your recommendations and completion of projects, for increased productivity (increase of service delivery levels).

When you click the buy button for the Amortisation software, you must see the following at the top when the PayPal page opens:

MNR PIERRE D B DU PLESSIS

Shopping buy button

The price is only $10.00 through the secure servers of PayPal.

6. Spreadsheet calculation model – Break even analysis – Break even for various turnover and profit levels

Excel breakeven calculations model e-box

This Break even software product is especially useful for Entrepreneurs, Business Owners, Accountants, Auditors, Project Engineers and any person who may need it for professional motivation of new small and big capital budgeting and budgeting of expansion projects. It also goes hand-in-hand with the Business plan preparation software product and Amortisation software product. 

The software provides break even points in both volume outputs and monetary values (zero profit) and targeted profit margins (volume and profit targeted percentages) for a manufacturing, wholesale, retail and any other type of business (also volume and value).

Firstly this software program helps the user to identify variable and fixed cost levels for either a product line or a business, which are used in further financial calculations. The program will then calculate the break even point to enable you to compare whether you operate above or below this point.

Secondly you can list different profit values which you may desire and this program will indicate what the corresponding turnover must be to achieve such profits.

When you click the buy button for the Break even software, you must see the following at the top when the PayPal page opens:

MNR PIERRE D B DU PLESSIS

Shopping buy button

The price is only $10.00 through the secure servers of PayPal.

7. Spreadsheet calculation model – Cash flow projection – 12 Months rolling

Excel cash flow calculation model e-box

This Cash flow projection software is a great help to those involved in the future affordability and availability of funds for budgets, capital expenditure, profitability and when to plan for reduction or increase of external finance.

When you click the buy button for Cash flow projection software, you must see the following at the top when the PayPal page opens:

MNR PIERRE D B DU PLESSIS

Shopping buy button

The price is only $10.00 through the secure servers of PayPal.

8. Spreadsheet calculation model – Customer service efficiency – Service levels for job cards, deliveries and purchasing

Excel customer service calculations model e-box

This Customer service efficiency software is a great help for persons interested in higher productivity levels. The principles can also be expanded to persons in other job tasks. It is similar to a performance management system, wherein key result indicators are measured for improvement of performance levels.

When you click the buy button for Customer service efficiency software, you must see the following at the top when the PayPal page opens:

MNR PIERRE D B DU PLESSIS

Shopping buy button

The price is only $10.00 through the secure servers of PayPal.

The following two e-guides are included as bonuses for any single product purchase listed above:
  1. The business plan blueprint, shortening your business learning curve.
  2. Guide to writing a business plan authored by reputable auditors, in the form of a ready-made template.

Business plans duo

When you reach a stage where an organisation has outgrown the usefulness of an Excel Spread Sheet Software, or is already there, internal or external software coders can be used to convert the same principles and formulas into more sophisticated computer systems for organisation-wide subsidiary usage. It is, however, important for someone inside the organisation to first understand the concepts, secondly to be able to specify to coders what the requirements for the system must be.

Any system can even be used on a worldwide scale through a cloud server.

The motto is: “Get to grips and then specify”.

Busines card for Pierre Du Plessis

Other Web Assets:
Rapid work performance excellence.
Finance for all property types.

Ten year maintenance plan footer image