Some Fuzzy Logic --Dickeson

Multiply the Assigned Weight by the Pricing Weight for the "Weight Extension" column. Divide the sum of the "Weight Extension" column by the sum of the "Pricing Weight" column to get the ratio. Divide the "Average Price" in the table header by the ratio just determined and you have your "Target Selling Price."