hi this my first post and i hope someone here could give me some help.

i want to make a formula to solve my problem about stock item.

for example i want to make stock by this condition (smaller to largest) : (1) pcs, (2) dozen, carton
how i solve that with excel,

thanks for all your help.. sory my english is not to good.

nb : i attached example here.