price per square feet, but pay per box and sold in pallet
Posted: Sat Dec 23, 2017 12:59 am
I am working to solve pricing issue for flooring products in general. this could be ceramic or vinyl tile or wood flooring. These products are priced in square feet but need to be calculated in box quantities. For example, ceramic tile is 3.95 per SF and each box is 15.25 SF thus minimum order quantity has to be $60.2375, this number has to be rounded as well. A further complication is to calculate the box price to pallet price. Assume this particular pallet has 36 boxes in it and thus the price of 1 pallet of this tile is $2,168.55. And the only field customer could enter is SF. In this example, one pallet is 549 SF and if the customer enters say 650 sf, then the system should automatically round this up to 2 pallets which would be 1098 SF and should show the quantity of 1 pallet.
A similar example is as in this link; http://product-pricing.fmeextensions.n ... ders.html
Any help would be appreciated greatly.
A similar example is as in this link; http://product-pricing.fmeextensions.n ... ders.html
Any help would be appreciated greatly.