We are engaged in the production of advertising signs.
We have an Excel file in which we calculate the production cost of advertising signs.
For internal team use, it is necessary to create a simple online calculator (a website that can be accessed via login/password) where we can calculate the cost of advertising signs, record all necessary data, and track the price calculations of signs in a separate table (history of requests).
We want to transfer the price calculation from the file on the computer to Online
In general terms, how it works now:
The salesperson enters the Excel table and inputs data for a specific sign.
There are several types of products, materials used for production (different prices, types), and some conditions that are added to a specific product.
After entering the parameters of the sign, the price is issued.
It is necessary to transfer this formula and add some visual changes + new functions (saving the price of each calculation in a separate table, adding new products for calculation as needed, changing prices for materials, etc.)
What functions should be included?
1. What needs to be done? What products/services do we offer?
Products:
Neon sign
Backlighting
Acrylic sign
Wooden sign
Services:
Milling
Laser Cutting
2. The calculation for each option is different; after selecting an option, a separate calculation window opens.
3. Data for price calculation is entered (they are different for each option) – the price is calculated – the calculation goes into the Price Calculation History (table)
4. History of price calculations for signs – a table/database that stores information for each sign.
This table can be worked with in two modes – Data Viewing and Data Editing
5. Connection of statistics/data visualization (possible solution PowerBI)
- Number of signs by categories
- Number of calculations
- Total amount of calculations by categories and by time (Year/quarter/month/week/day)
Ready to hear proposals on price and implementation terms.
