E
Ed
Hello,
I have a price list which includes Item #, cost, markup %, and price
(approx. 300 products). Now, I want to add approx. 100 more products to the
list; and I need to apply a markup % to the new products that will be based
on the markup % in the current price list.
Is there a way to Match the New product Cost to the closest Existing product
Cost and assign it the same markup %?
Example:
Item # Cost Markup (%) Price Cost (New Product) Markup (%)
4343 2.18 77.98% 3.88 2.10 ?
333 3.25 75.93% 5.72 2.55 ?
334343 4.30 76.31% 7.58 3.50 ?
65656 5.44 70.71% 9.29 6.74 ?
67676 5.99 69.91% 10.18 7.05 ?
787878 6.23 69.69% 10.57 8.88 ?
11212 7.08 69.20% 11.98 9.87 ?
899889 10.09 68.98% 17.05 10.00 ?
Thank you in advance.
Ed.
I have a price list which includes Item #, cost, markup %, and price
(approx. 300 products). Now, I want to add approx. 100 more products to the
list; and I need to apply a markup % to the new products that will be based
on the markup % in the current price list.
Is there a way to Match the New product Cost to the closest Existing product
Cost and assign it the same markup %?
Example:
Item # Cost Markup (%) Price Cost (New Product) Markup (%)
4343 2.18 77.98% 3.88 2.10 ?
333 3.25 75.93% 5.72 2.55 ?
334343 4.30 76.31% 7.58 3.50 ?
65656 5.44 70.71% 9.29 6.74 ?
67676 5.99 69.91% 10.18 7.05 ?
787878 6.23 69.69% 10.57 8.88 ?
11212 7.08 69.20% 11.98 9.87 ?
899889 10.09 68.98% 17.05 10.00 ?
Thank you in advance.
Ed.