An application which allows to enforcing budgets of dealer points and consolidating them on levels of the concession, the country and the entire group. Similar functionality to excel application, apart from model calculations which are inscribed on a permanent basis.
The project was divided in two phases. First phase present the engine and implements the first tables for entering data. Second phase optimizes the speed of action and adding bookmarks consolidating all calculations.
Types of the service users
The data capture was divided in 4 levels:
- Dealer point.
This is the lowest point, it represent the car showroom in which cars are being sold. Users of this level can input data and watch its consolidation only for this car showroom. - The concession.
This level groups a few salons, mostly from the same city. Users can enter this level, and consolidate its own data and data belonging to the points included in the concession. - Country.
This level groups all the concessions in the country . Users of this level can consolidate data for country and all lower levels. - Group.
At this level, it is possible to edit all the tables at all levels and make the consolidation of all entities included in the service. The Group is only one.
For each dealer point / concession / country or group may have multiple users, each with its own password, but having the same rights.
Clicking on any other field automatically saves the field currently being edited. Pressing the Enter key triggers a recalculation of all values. For higher-level tabs, this can take several seconds, which is why calculation does not happen automatically after every value change. If an invalid number is entered, the field is reverted to its previous state. In one of the tables, the option to add an unlimited number of rows has been included. Each row represents a single investment for a given unit. At higher levels, investments from lower levels are displayed, grouped by origin, along with regular rows for entering investments at the given level.
Budget consolidation
Consolidation is performed by selecting the units subject to consolidation and choosing the consolidating tab. All units subordinate to the unit the user is logged into are selected by default.
In addition to data entry, some of the tabs also display a consolidation of selected data from lower-level tabs.
Multilingualism
Since the application will be used throughout Europe, it was important for it to also be usable by people who do not speak English and/or French. To this end, the back office includes a module that allows the labels used throughout the platform to be translated into any language, as well as the ability to add and remove individual languages. Each user has an assigned language, and after logging in, they see the interface and tables in the language appropriate for them.
Export & Printing
Each tab can be exported separately to Excel files and printed. It is also possible to export all tabs for a given level, or for units subordinate to a given unit.
Exported files include a header specifying which units were included in the export. This makes it possible to create partial summaries.
Please fill in the required fields.
Message sent.