So the designers prices and surcharges would go in the product dimension as they are fixed im sure when the product is created. But would pull the the retailers prices and surcharges through into the orders fact table when an order is placed as this is in effect the actual price of the product.

this would then give you visibility of both the designers prices and retailers prices. Yes?