Sunday, 6 October 2013

Help Me Out!!! An Inventory Paradox

This is a real time problem that Rangeela Pharmasust (RPh) has faced while working at a Pharmacy satellite. RPh believes in Reflective Practice and he believes that if he shares his problems and discuss for the solution it will help both RPh and his readers.

Following is the description of that problem

There are two statelites i.e Location A and Location B and below is the inventory of Product X and Product Y at Location A and B.


Location A
Location B

Physical
System
Difference

Physical
System
Difference
Product X
4
4
0
Product X
4
4
0
Product Y
4
4
0
Product Y
4
4
0

The problem arises when from Location A, product X (Qty :2 )is being dispensed instead of product Y while product Y is being charged. So after this transaction following is the inventory of X and Y at A and B.


Location A
Location B

Physical
System
Difference

Physical
System
Difference
Product X
2
4
-2
Product X
4
4
0
Product Y
4
2
+2
Product Y
4
4
0

Since premises of Location B is close to the target dispensing area and to solve the problem promptly, RPh dispensed product Y from location B and make Product X( i.e. wrongly dispensed from Location A) his inventory at Location B without making any further transaction on system. So after this event following is the inventory of X and Y at A and B.


Location A
Location B

Physical
System
Difference

Physical
System
Difference
Product X
2
4
-2
Product X
6
4
+2
Product Y
4
2
+ou 2
Product Y
2
4
-2

Let suppose we have a limitation to physically move products from location A to B and we have to balance this inventory by making a system transaction.

The question is what transfer you have to make on system to balance this inventory?
Hint: There will be two transfer notes.

You can submit your answer to the link below