Tuesday, 24 January 2017

Inventory and Gross Profit Calculation

Assalamualaikum..

A few months ago, I joined an entrepreneurship training in Perak, as a facilitator. This training  was managed by FAMA as to help entrepreneurs managing their account and expenses accordingly. And most of the participants are small retailers which most of their products' price are subjected to Government price control. Hence, the profit is not that much compared to others.

So, as to adjust the profit margin, they have to closely monitor the stocks and % of discounts given to ensure that daily sales & profits are reachable within target.

Looking at their needs, then I have construct a simple but yet reliable application  to capture all the above aspects. This template is best used for ready made product and required to be key in daily for good results.


Feel free to try..;-)


Monday, 9 January 2017

Gender Identification Based On IC No. - Part2

Assalamualaikum

Further to our previous discussion on Gender Identification Based on IC, let's take a look for the 2nd case which is having data of IC Numbers without '-'.

The formula does not much differ compared to the 1st case. All you have to do is just eliminate the Right Formula while others are remain the same. Please refer pic below for easy reference;


Have a nice working days!