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
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!
No comments:
Post a Comment