Choosing Correct Price of Quantity Purchased (Staggered Price)

Assalamualaikum.

Masih lg fokus kt scope usahawan... Ada tak usahawan yang offer staggered price to customer depending on quantity purchased?

Cth: Beli 1->5 ea - price/unit = RM5.00
Beli 6->10 ea - price/unit = RM4.50
Beli 11->Above ea - price/unit = RM4.00

Instead of manually select the price, we can just ask Excel to do the work. Just plug in the quantity required in a correct database, Excel will automatically select the right unit price to be used. It is just as easy as ABC!!

Attached herewith is a sample of template that you can try!

Counting Orders (Mengira Order)

Ha, for the first time, moh kita tengok applikasi Excel dalam bisnes. Assuming we have a list of orders untuk t-shirt as below;

In order to know the exact quantity of orders for the respective sizes,  normally we have to manually calculate items one by one. This non value added process of course will take a lot of time depending on the number of orders received that day.

As to shorten the time, why not try using Excel to solve the problem! If you are using the correct formula to do your work, I'm sure you will save more time and most importantly obtain an accurate result.

Then, let's see how can we summarize the info using Excel;

In this example; i use COUNTIF formula as it suite with the problem. 

Hope that will help!

Pengenalan..

Assalamualaikum & Greetings to all..

I've been dreaming to have this kind of blog to share info related to Excel's application as to help people doing and solving their daily works fastest as they can. Either you are a lecturer, teachers, businessman, engineer and so on, Excel can play a vital role in solving your problems whenever you are dealing and analyzing large amount of data.

So, through time, i'll be sharing examples of application that commonly used and needed by most of us.