Organisation de Recherche Matériel Alternative et Écologique

Bachelors student ISP(Independent Study Project), Belinda Simpson , Faculty of Management, Department of Management Science, leads Our student's in the program:  "Bachelors Of Science Business Management & Administration (Research) or B.Sc. BMA or BBMA (Research)". Our Students work on real-life situation but Enterprises Secrecy are respected in such that a product line and or enterprise name will never be revealed.

EOQ Theorem

---

EOQ = The most economical quantity to order each time an order is placed.
F = Seasonal Factor.
U = Unit of the items used over a period of three years, divided by three, to phase out stock shortages or abnormal sales.
A = Acquisition cost, fixed costs incurred in placing and receiving a single order.
P = Purchase price per unit of inventory.
C = Carrying costs (storage, insurance & spoilage) expressed as a percentage of inventory value.

Let's say that during the month of September the stock drop below the re-order level, thus now the Factor value for October will be used ! The factor are always one month ahead to avoid sudden stock shortage or to reduce the risk of over stock ! By using this Principe and given theorem make some exercises and you will see how this can help your Enterprise to EXTREMELY WELL CONTROL THERE STOCK(Hence more money in the bank, less work(with products), Personnel more available for customer service).

$$ \color{green}{EOQ} = \sqrt{2UA\over \lower2pt{\class{framed}{\,pc\,}}} + b + l $$
$$ \color{green}{EOQ} = \sqrt{2\times 144\times $10\over \lower2pt{\class{framed}{\,$1.00\times 20\%}}} + b + l $$
$$ \color{green}{EOQ} = \sqrt{2 880\over \lower2pt{\class{framed}{\,0.2\,}}} + b + l $$
$$ \color{green}{EOQ} = \sqrt{14 400} + b + l $$
$$ \color{green}{EOQ} = \color{#FF0000}{120   \color{green} + b + l \,units\,} $$
The Seasonal Factor and the + b + l   not jet implemented (Will have to create some tabulation to explain this part soon).

Considering the acquisition and carrying cost, an order of 120 units is the most economical quantity for this item.
An order of 120 units Total cost is 22,00€: Total Cost = acquisition cost + carrying costs thus 22,00€ = 10,00€ + 12,00€

Smaller orders will drive up acquisition cost and larger orders will inflate carrying costs. The Hastings EOQ formula helps to balance these two costs.

See tabulation of data to prove correctness of formula.

EOQ Tabulation

 

	A	B	C	D	E	F	G
1	ANNUAL USAGE	ORDER PER YR	ORDER QUANTITY	ORDER VALUE	ACQUISITION COST	CARRYING COST	TOTAL COST
2	144	1	720	720	10,00	360,00	370,00
3	144	1	576	576	10,00	230,40	240,40
4	144	1	432	432	10,00	129,60	139,60
5	144	1	288	288	10,00	57,60	67,60
6	144	1	144	144	10,00	14,40	24,40
7	144	2	72	72	20,00	7,20	27,20
8	144	3	48	48	30,00	4,80	34,80
9	144	4	36	36	40,00	3,60	43,60
10	144	5	29	29	50,00	2,90	52,90

 

One order per year is the most economical in this case. EOQ formula gets to 120 units lets see if that is the lowest cost ... Get Carrying Cost 20% on (120/2) = 12,00€ plus Acquisition Cost of 10,00€ per order = 22,00€ per order. EOQ formula has thus proofed to be Very valuable and correct since its Fast and extremely precises

Carrying cost is calculated at 20% of the average value of stock on hand(see Carrying Cost Tabulation)

Carrying Cost Tabulation

 

UNITS	20% on value	COST	UNITS	20% on value	COST	UNITS	20% on value	Cost
720	20% on 576€	115,20€	576	20% on 432€	86,40€	432	20% on 288€	57,60€
	20% on(144/2)	14,40€		20% on(144/2)	14,40€		20% on(144/2)	14,40€
576	20% on 432€	86,40€	432	20% on 288€	57,60€	288	20% on  144€	28,80€
	20% on(144/2)	14,40€		20% on(144/2)	14,40€		20% on(144/2)	14,40€
432	20% on 288€	57,60€	288	20% on  144€	28,80€	144	20% on (144/2)	14,40€
	20% on(144/2)	14,40€		20% on(144/2)	14,40€
288	20% on  144€	28,80€	144	20% on (144/2)	14,40€
	20% on(144/2)	14,40€
144	20% on (144/2)	14,40€
	Total Cost	360,00€		Total Cost	230,40€		Total Cost	129,60€
UNITS	20% on value	COST	UNITS	20% on value	Cost	UNITS	20% on value	Cost
288	20% on  144€	28,80€	144	20% on (144/2)	14,40€	72	20% on (72/2)	7,20€
	20% on(144/2)	14,40€				48	20% on (48/2)	4,80€
144	20% on (144/2)	14,40€				36	20% on (36/2)	3,60€
	Total Cost	57,60€		Total Cost	14,40€	29	20% on (29/2)	2,90€

 

Stock Movement Analysis for perioe 2006, 2007, 2008

Stock Sales for 2006, 2007, 2008 and Average of Units issued.

Stock Sales Average for 2006, 2007, 2008 and Average of Units issued.

Pie Chart shows that Ave. and Units are equal in quantity !

You will see the importance of this fact soon !

Most Stock Controllers thinks like a "Pie Chart" thus bringing their flourishing companies to an early "Liquidation" and nobody understanding whats wrong !!!

This Example Stock Item can be classed as a "C" category Item thus(Rather a service Stock Item than a money making Item) More examples will make this clear later. More the value goes up less the order quantity will be for this example. Think like a "Line Chart(Seasonal Factor)" and you can conduct a company from liquidation to a profit with no increase in sales and no price rising(you can maybe consider reducing prices) and you will see an even bigger profit at the end.

By using this kind of "Line Chart" thinking I have seen a company reducing his bank credit (interest rate at 18.6% per year) from 16 000 000 € to 4 000 000 € (just because of intelligent stock control). The computer was thinking and the stock controllers (obviously by using their brains) just needed to verify that (the programmer did not made a human error) there are no errors.

One year later their stock space reduced to half thus freeing valuable space and less stock on-hand less spoilage better control and more free time to concentrate on customer service !!!

The company saved 2 232 000 € on (12 000 000 x 18.6%)interest rate, thus money in there pocket(from all sales made) and not to the bankers pocket via Interest rates ! So all profit of sales (overstocked between 3-6 years depending on stock Items) stayed in the company !!! And they were in Instance of Liquidation and the Liquidator said there is nothing to do ... This Formula brought them back into business end 1990.   Never for Get Liquidators only serves their Greed and will never help a Company to recover or they put them self's out of Business. Fire your Purchase Manager & Stock Controller (If you discover this situation in your company because they give no dammed shit for your Enterprise).