I have a workbook with multiple sheets, but am only concerned with the first two; Product Inputs and Outputs. Product Inputs includes information such as item identification numbers, dimensions, weights, etc. Outputs then takes those numbers and calculates profit, overhead, and quantity we want to purchase and also contains references from Product Inputs so the data can be properly analyzed. Many companies that we purchase products from offer a flat discount plus an additional discount on top of it. It is very rare that these two discounts are compounded (a 20% flat discount and a 5% additional discount equals 25% total discount), and instead are factored into the price in two steps (20% of x and 5% of the result). I currently have the flat discount as an absolute reference in a separate sheet, so the problem variable is the additional discount, which is located on the Outputs sheet. I have been experimenting with how to incorporate this additional discount into the final wholesale price of the product, but all of my attempts have the same result. Most of the cells in the Output page are formulas or references (except additional discount), so I can never properly sort/filter the Output page with the additional discount in the proper place. Putting the additional discount on the Input Page was an option, but we often like to play with the discount to evaluate potential negotiation opportunities, so it is much more sensible to have the additional discount on the Output sheet. I realize this is a somewhat complicated problem and may not make sense for those not involved in the business, but any input would be greatly appreciated.
Thanks,
Chris
Thanks,
Chris