A simple calculator needs to be created for calculating the cost of courier and logistics services. The implementation format can be any: Excel, Google Sheets, or a simple website (preferably Excel or Google Sheets for easy editing).
The calculator should be as simple, understandable, and convenient for daily use without the need to contact a programmer.
There should be two types of services in the system:
- Documents (up to 1 kg, simplified calculation)
- Parcels (over 1 kg, calculation considering weight and dimensions if necessary)
There must also be the ability to account for small volumes and a small number of orders (for example, when there are few orders), so that the system correctly calculates the cost even with low load. This means considering the total volume of orders (per day or per month) and distributing fixed costs over a smaller number of orders.
(documents as orders can be taken by couriers and drivers) but parcels cannot be taken by couriers!
There should be types of delivery (with the ability to edit):
- Express (a few hours)
- Within the day (6–8 working hours)
- Regular (2–3 days)
- Economy (up to 5 days)
Important: there must be the ability to change the names of delivery types, add new ones, or disable unnecessary ones.
The calculator should account for main expenses:
Fixed expenses:
- employee salaries
- office rent
- taxes
- administrative expenses
Variable expenses:
- fuel
- transport (depreciation)
- courier cost per order
- cost per kilometer (if used)
The calculation logic should consider:
- order type (document or parcel)
- distance (km) or zone
- delivery type
- order volume (to calculate cost with a small number of orders)
It is also desirable:
- the ability to set a minimum price
- the ability to set a markup (%)
- calculation of the final price
There should be the ability to work with zones:
- create several zones (for example, Zone 1, Zone 2, Zone 3, etc.) (by km)
- set coefficients or prices for each zone
- simple zone configuration
Very important:
It is necessary to implement the ability to automatically generate a document (Excel or PDF) with a commercial offer, which will include:
- company logo
- company name
- price table
- zones
- delivery types
The document should look neat and be suitable for sending to clients.
The interface should be simple:
- all main parameters should be editable
- preferably a separate section or sheet “Settings”
Additionally (if possible):
- automatic updating of all calculations when parameters change
Expected result: a ready tool that calculates costs, helps to form prices, and generates a commercial offer, while being easy to edit.
