I have a project that needs a product configurator, I have an excel sheet that does exactly what we need but this needs transferring in to a web based version.
If you see below you will see the logic of what the configurator needs to achieve.
The user should be presented with the options in a dropdown box (with the exception of cable length and quantity which will be text fields)
There is also some selections which will need to be disabled, for example if a certain cable type is selected then not all options will be available.
Pre-Term Configurator Variables And Costs
Current User Options
- Cable Type
- Distribution End
- Connector End A
- Fibre Count
- Fibre Type
- Connector End B
- Jacket Type
- Cable Length
- Quantity
Total Cost Decided by
- Connector A
- Connector B
- Cable
- Breakout A
- Breakout B
Pricing of elements decided by...
Connector A/B
- 14 base choices
- Dependent on SINGLE MODE or MULTI MODE (Decided by FIBRE TYPE)
- Multiplied by the FIBRE COUNT
- One either end
Cable
- 7 base choices
- Combination of FIBRE TYPE AND FIBRE COUNT AND JACKET TYPE
- Multiplied by CABLE LENGTH
Breakout A/B
- Combination of CABLE TYPE AND FIBRE COUNT
- One either end
Price Banding
- Markup/Percentage of TOTAL COST dependent on Customer Group
- Wanted for the future - Markup/Percentage of individual elements - e.g. 10% on Connectors, 20% on Cable, 30% on Breakout varies dependent on Customer Group.