Product Pricing and Specifications

Product Pricing and Specifications

 

This Excel application prices 10 different item types containing complex product option combinations. It dramatically increases the user's accuracy while tremendously reducing the time involved in preparing these quotes. Prior to this application the users had to wade through approximately 100 pages of product configuration options taking at a minimum several minutes to price. Now an always accurate price is generated in real time as options are added and configured. It also offers a pricing comparison feature to allow the user to graphically and numerically see at which quantity point the per unit pricing becomes favorable enough to order in the higher quantities.


Main Navigation MenuMain Navigation Menu

Main Navigation Menu

Main navigation page to access all of the product lines for configuration and pricing. This application includes a custom menu bar.

Product Specification and Pricing ScreenProduct Specification and Pricing Screen

Product Specification and Pricing Screen

An example of one of the product’s configuration pages where all specifications are entered and the product is automatically priced.


Pricing Comparison MatrixPricing Comparison Matrix

Pricing Comparison Matrix

The pricing comparison feature displaying the varying unit prices based on different input quantities for a specified configuration.

Custom Dialog BoxesCustom Dialog Boxes

Custom Dialog Boxes

One example of custom dialog boxes used in the application.