About Price Modeling
Price Modeling gives you amazing spreadsheet ability for modeling pricing and profitability. You can analyze past, initial, and proposed price models. Like its predecessor (SG) [J], you can use this new application to measure the profitability of past sales as compared to initial pricing. Using these actual sales statistics, you can create new pricing models and directly compare the results against initial and historical pricing models. You can apply numerous filters to past sales journals, contracts, and inventory files to target a very specific item or customer sales history.
Price Modeling is built on our new EBS technology. The on-screen display is very flexible so you can choose what fields and types of totals display. Information is displayed in an Excel-style grid with columns that can be fully customized. You can customize the grid, rearrange columns, and re-sort the columns. See Figure 1. Once a satisfactory price model is created, the on-screen end results can be saved as a new contract or exported to an Excel® file. You can also save the price model for future reference.
Note: You must import sales journals to SQL if you plan to use this new application to analyze past sales. You do this using the EBS SQL Import Panel. You can use the Import Sales Journal function to import data from sales journal files to the SalesOrderJournal SQL Table and the SalesOrderArchive SQL Table. The SalesOrderJournal contains your most recent sales. You must specify the number of months to store in this table. All sales that are older than the specified number of months can be imported to the SalesOrderArchive during the same procedure. After the initial import, the system automatically adds new completed sales to the SalesOrderJournal file. It also moves past sales that are no longer within the specified number of months to the SalesOrderArchive table. Before using any EBS program for the first time, you must import your existing data to the new SQL database. For more information, see Using the EBS SQL Import Panel handout on our website at www.ddms.com. Due to changes in the software in version 8.16, you must import your SQL data. If you previously installed version 8.16, you do not need to import your data again.
Price Modeling has unparalleled printing capabilities. You have complete font control and header text options. You can use your regular network printer. Because it’s built on .NET technology, your price modeling information is fully portable. You can export your data to Adobe .pdf, HTML, text, Excel .xls, and rich text .rtf formats. You can also save to a C1PrintDocument to use with Reporting.
Note: Some of the boxes in this document may not appear if you are not using Advanced Price Plans. Advanced Price Plans requires authorization. For more information, contact ECi sales.
You can password protect your information in Price Modeling to prevent unauthorized use. For instructions, see Price Modeling General Configuration Parameters.
See also: