Introducing The “EASY QUOTE” System

This write up is about a system developed by the Founder and Chief Consultant at Mobritech (Z) Limited.

The system uses inter-linked Microsoft Excel spreadsheets to automatically calculate a quotation to be submitted to a customer for supplying items ordered locally and/or from overseas.

Labour and overhead costs are also calculated for installation of equipment, in case of project work.

The system has been developed from experience gain by the writer who has been a Project Engineer in the Zambian mining industry for a total of eighteen years.

The system uses executable files that generate pre-designed spread sheets which can be used for making quotations. The system may used as many times as required to generate fresh spread sheets every time a new quotation is required to be done.  

INTRODUCING THE “EASY QUOTE” SYSTEMS

I have worked as an Electrical Engineer for the Copper Mining Industry in Zambia, at six mining operation areas, for a total period of 33 years, before my retirement in January 2010.

One of my duties as an engineer, which I have done for close to 18 years, was to invite suppliers and contractors to quote for the supply of equipment to be used in the Mines.

An invitation to tender would inform interested parties to submit their quotations by a given closing date. Before any invitation to tender was given, I would get information on the prices of the equipment to be supplied from the manufacturers or from records of past projects and those kept by the supply department of the Mine.

Installations that involved a variety of equipment would require a preparation of a detailed Scope of Works. A Bill of Quantities and a Bar Chart would then be prepared for the installation of the equipment.

The Bill of Quantities would show the description of equipment, quantities, unit and total cost of the equipment. The cost of labour and other costs such as overheads would be included in the Bill of Quantities.

The preparation of these documents would involve several departments such as the engineering design, quantity surveying and the supply departments. A provisional Budgetary Price for the installation would then be calculated and used as a yardstick for determination of which supplier or contractor would be awarded the contract. The budgetary price would include a profit margin for the contractor.

Once the deadline for closing of tender submission was reached, opening of tenders would then be done by a committee of Mine officials from the contracts office, the supply department and the user department. The committee would then decide who gets the contract. The criteria used for awarding the contract were the submitted tender price, the capacity and past reputation of the contractor. From experience, the lowest tender would necessarily be chosen to do the job.

However, there were cases where the lowest tender price was not chosen because of glaring anomalies in the quoted prices in the Bill of Quantities. There were cases where a supplier or contractor would fail to meet the obligations submitted in the tender.

In order to avoid such a situation, the engineer in charge of the project from the user department was expected to submit a budgetary price for the contract. The engineer from the user department prepared a provisional budgetary cost for the contract.

This would then be checked by other departments such as the finance department with the help of the quantity surveying department. One of the challenges that I faced as a project engineer in the earlier years on the job was the preparation of a budgetary price for a project.

With the help of experienced engineers and other departments one was able to prepare a budget for a project. Large capital projects, involving multi skills, would involve consulting companies outside the Mine to prepare the tender documents.

After my retirement from the Mines, I found myself with the task of working with suppliers and contractors to the Mines to prepare quotations for tendering purposes. When I was working for one company after retirement, I had one assistant who used to prepare quotations. He had been doing the job for close to eight years.

One setback he had was that he used to take an average of two shifts to prepare any quotation. After enquiring from him why he took that long to submit a quotation I learnt, with astonishment, that despite having a desktop computer in his office, he had been using a desktop electronic calculator to do the quotations!

Over the years he had become very proficient and he had mastered on how to use this calculator very well. He was able to add up figures faster than I could do with the machine.

At one time there were five enquiries from one of the newly formed mining companies whose closing date for the submission of tenders was seven days! This was a very big challenge for the assistant. At his rate of preparing previous quotations, it was going to take him fifteen days of continuous work. For him to beat the deadline it meant long hours of work of more than fourteen hours per day. After the quotations were submitted, at the expense of the assistant’s comfort, it was decided at a Management meeting that all personnel in the Sales Department should be trained on how to prepare quotations.

The training did not go very well because most of the personnel were young people who were used to working with pre-prepared Computer spread sheets in order to input data rather than using manual input electronic Calculators.

After studying the method that was used by the assistant, I came up with a system that could do the same calculations on a single Microsoft Excel spread sheet. The only setback was that it took me sometime to have this method to be accepted by the Management, most of who were not very familiar with computers and are jokingly called BBCs (Born Before Computers)!

I managed to teach two young technicians who found it very helpful. The assistant, who is a BBC, continued using the electronic Calculator!

After I left the services of the company I had a closer look at the system and realised that the reason for not accepting it by my previous employers could have been that a lot of people, who were not used to work with spread sheets, would not know how to read information stored in an Excel Workbook in multiple tabs.

I therefore modified the system so that each stage of preparing the quotation is stored in single tab spread sheets whose calculating formulas are related via links. This gave birth to what is called the “Easy Quote” system, which is the subject of this write up.

I have developed four systems as follows:-

1) The Easy Quote Forex – This is targeted for suppliers whose main business is to import goods from overseas suppliers using foreign exchange for selling to their customers in Zambia.

 2) The Easy Quote Local - This is targeted for suppliers whose main business is to purchase goods from local suppliers using Kwacha for selling to their customers in Zambia.

3) The Easy Quote Deluxe - This is targeted for suppliers whose main business is to purchase goods both from overseas and local suppliers using Kwacha and foreign exchange for selling to their customers in Zambia. This system is really a combination of the Easy Quote Forex and the Easy Quote Local.

4) The Easy Quote Project - This is targeted for suppliers and contractors whose main business is to purchase goods both from overseas and local suppliers using Kwacha and foreign exchange for supplying and installation of equipment for their customers in Zambia. This system is really a combination of the Easy Quote Deluxe and a package that calculates the labour and overhead costs for a given project.

5) The Easy Quote Demo - This is a demonstration package that works on the principle of the Easy Quote Forex system. The system is meant to demonstrate to potential customers who would like to adopt the Easy Quote systems into their businesses. As its name implies, its usefulness is limited. It is meant to be a training tool for the other systems.

 I have prepared manuals on how to use the first three systems mentioned above. These manuals, the Easy Quote Demo and a copy of this write up maybe downloaded for review at the following link:-

http://sdrv.ms/PQTyoW

 I do not intend to prepare a manual for the Easy Quote Project system for now because it is very similar to the other three. An in-house training session could be arranged for customers interested to learn how the four systems work. As is applicable to any new product, the systems are subject to redesign and improvement from time to time. I am open to any comments and advice on how the systems could be improved.

For more information about the systems and how to purchase them please send enquiries to any of the following e-mails:-

m.nasilele@gmail.com
henry.nasilele@mobritech.com
sales@mobritech.com

Alternatively, an enquiry could be done by filling a form at the “Contact Me” page on our company website or at:-

http://henrynasilele.weebly.com/contact-me.html

Henry Musialela Nasilele (B.Eng., R.Eng, MEIZ)
Founder and Principal Consultant,
Mobritech (Z) Limited.
Nkana East Kitwe
Republic of Zambia
1st May 2012

Web Links 

http://henrynasilele.weebly.com
http://www.linkedin.com/in/henrynasilele
http://chamber.com/henry-nasilele
http://www.facebook.com/hmsialex
http://twitter.com/hmsialex

Why Zambia Won The 2012 AFCOM Cup

After the dramatic win by the Zambian national soccer team over the Ivory Coast soccer team in Libreville, Gabon on 12 February 2012 several people have put forward their opinions as to why we won. Many football analysers have labelled Zambians as "underdogs" from the beginning of the tournament.

Despite all the odds Zambians carried the day on 12 February 2012. In this post I put forward my belief as to why we won.

1) We Zambians won not because of what people thought of us but because of our resolve to win. The so-called soccer analysists and specialists have been proved to be greatest pathological liars. The word "underdog" belongs to the dark world of Satan.

2) We won not because of "Good luck" but because we were destined to win. When God says YES in your life, no man can say no!

3) We won not because of the desire to have more wealth but because of our faith in the Lord. "But seek ye first the kingdom of God, and his righteousness; and all these things shall be added unto you. " (Matthew 6:33).

4) We won not because a Sangoma foresaw it but because our God was on our side. If God is for us who can be against us ? I therefore, rebuke Satan for some nonbelievers suggesting that the South African Sangoma who foresaw be invited for the celebrations.

A Sangoma will never be a messenger of God ! He is destined to be punished by the wrath of God.

"And when they had gone through the isle unto Paphos, they found a certain sorcerer, a false prophet, a Jew, whose name was Bar-jesus. Which was with the deputy of the country, Sergius Paulus, a prudent man; who called for Barnabas and Saul, and desired to hear the word of God.

But Elymas the sorcerer (for so is his name by interpretation) withstood them, seeking to turn away the deputy from the faith. Then Saul, (who also is called Paul,) filled with the Holy Ghost, set his eyes on him, And said, O full of all subtilty and all mischief, thou child of the devil, thou enemy of all righteousness, wilt thou not cease to pervert the right ways of the Lord?

 And now, behold, the hand of the Lord is upon thee, and thou shalt be blind, not seeing the sun for a season. And immediately there fell on him a mist and a darkness; and he went about seeking some to lead him by the hand." (Acts 13:6-11).

Our victory was prophesied by several men and women of God without the cheap publicity through the press as of the Sangoma. Some of the prophetic messages were in form of parables. No one rushed to the press to publish it, but as Christians, we kept the faith and prayed over it.

The prize for false prophets can sometimes be inflicted by the devil himself as happened to the seven sons of Sceva.

"Then certain of the vagabond Jews, exorcists, took upon them to call over them which had evil spirits the name of the Lord Jesus, saying, We adjure you by Jesus whom Paul preacheth. And there were seven sons of one Sceva, a Jew, and chief of the priests, which did so. And the evil spirit answered and said, Jesus I know, and Paul I know; but who are ye? And the man in whom the evil spirit was leaped on them, and overcame them, and prevailed against them, so that they fled out of that house naked and wounded." (Acts 19:13-16).

Those who are in support of the Sangoma from South Africa to be invited to Zambia and be part of the celebrations need deliverance and prayer !

The greatest honour to Zambia is winning the Cup, 19 years after the whole National Soccer Team, Officials and Crew perished in a Aircraft crash on the coast of Gabon in Libreville where the final Match was played yesterday. May their souls rest in eternal peace.

Amen !