Helio Glass Company manufactures windshields for cars and trucks. It sells both to wholesale customers and to retail customers.
To its retail customers, Helio prices windshields based on the dimension of the sheet of glass according to the formula 3 currency units * Width * Height * Thickness Factor.
The following table shows the thickness factors:
< 5 mm
5 mm – 10 mm
> 10 mm
e.g. for glass with 7mm thinkness, width=10 and height =10 ;
unit price calculation= 3*10*10*.15=45
Helio need to map above requirements using Oracle advance Pricing. (with the use of formula and factor-based pricing)