Cost and Logistics Calculator
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.
-
468
7 days70 USD7 days70 USDHello, I can create a convenient calculator.
1. Where is it more convenient to implement: Google Sheets or Excel?
2. Is there currently a structure or do we create the logic from scratch?
3. Should we consider different cities, countries, or just one region?
4. What is the deadline?
You can write to me on Telegram: Rohovska_Anna
-
2 days165 USD2 days165 USD
I will create a ready-made Excel tool: with a settings sheet, a cost calculator, and a commercial proposal sheet that can be immediately edited for the company. At the same time, I will include editable areas, types of delivery, markup, minimum price, and accounting for small order volumes.
I will make it so that it can be used without a programmer: everything editable will be moved to the settings, and the calculations will be on a separate worksheet.
-
30 days200 USD30 days200 USD
I will create a Google Sheets calculator with a distinction between "courier/driver" logic and automatic margin recalculation through Apps Script for generating branded PDF offers. I will apply my experience in automating complex systems (30+ Python scripts) to create a secure architecture where variable costs do not overlap with the settings database. For distributing fixed costs at low volumes, we will use a planned break-even threshold or tie it to the actual load from the previous month for real-time price adjustments.
Budget and deadlines will be discussed in private correspondence.
-
3 days3500 USD3 days3500 USD
I will create a calculator in Google Sheets with two tabs: Documents and Packages. The logic will use named ranges and the SUMPRODUCT formula, so you can change the rates yourself. The protection of cells with formulas will leave only the input fields editable. Question: what parameters affect the cost calculation for Packages, as the description text is cut off?
-
3 days70 USD
264 3 days70 USDGood day!
I am ready to develop a cost calculator for courier and logistics services in Excel or Google Sheets (your choice).
I will implement a convenient and flexible structure that will allow easy modification of all parameters without a programmer.
What will be implemented:
- calculation for 2 types of services (documents and parcels)
- consideration of weight, distance, and delivery zones
… - flexible delivery types with the ability to edit/add/disable
- distribution of fixed costs per number of orders (important for low workload)
- accounting for variable costs (fuel, courier, depreciation, etc.)
- setting minimum price and markup (%)
- automatic calculation of the final price
Additionally:
- a separate sheet "Settings" for all parameters
- a zone system with coefficients or fixed prices
- automatic updating of all calculations when data changes
As a bonus (if possible):
- generation of a commercial proposal (Excel/PDF) with a logo, zones, and a tariff table, ready to be sent to clients
I will complete the work in a structured manner, focusing on ease of use and further independent editing.
Deadline: 3–5 days.
I look forward to collaborating!
-
4 days80 USD
543 1 0 4 days80 USDHello.
The task is clear - you need not just a calculator, but a tool that accurately calculates the cost price taking into account the load and distributes fixed costs based on different order volumes.
I suggest implementing this in Google Sheets with a simple structure:
- a separate sheet "Settings" (expenses, zones, delivery types)
- calculation of the cost price considering: • order type (document / parcel) • distance / zones • order volume (redistribution of fixed costs)
- calculation of the final price with markup
- a convenient form for quick use
It is also possible to create a separate sheet for generating a commercial proposal with a price table and basic formatting.
I suggest starting with a basic version (main calculation logic), and then adding document generation and additional functions.
… Please clarify: - how is the cost price currently calculated (is there an example)? - is it more important to prioritize calculation accuracy or document formatting?
I am ready to discuss the details and get started.
-
1 day100 USD
133 1 day100 USDGood day! I can help you with this task! I have done something similar for my own online store, so I have an understanding.
-
10 days200 USD
812 15 0 10 days200 USDI will do it, feel free to contact me.
-
2 days100 USD
322 2 days100 USDReady to create a cost and logistics calculator in Google Sheets or Excel format — with convenient logic and the ability to edit all parameters without a developer.
5 sheets:
Settings — everything is editable: company, expenses, region, delivery features, weight, markups.
Calculator — calculation of cost and price for orders with a warning about low capacity.
Price list — automatic price table for all zones and types of delivery.
Commercial proposal — ready document for clients (export to PDF via File → Export)
Reference — instructions.
-
2 days400 USD
172 1 1 2 days400 USDGood day. I am ready to complete this project and have extensive experience in developing various applications.
-
3 days145 USD
2578 57 1 1 3 days145 USDI work as a financial analyst in a large international company. I have experience in creating similar files. Write to me, I will do it.
-
6 days6000 USD
417 2 0 6 days6000 USDHello!
I will create in Google Sheets (or Excel) — everything in one place: Settings (expenses, markup, minimum), Types of delivery, Zones by km, Calculation for documents and parcels with the rule "parcel — only drivers" and fair distribution of fixed costs based on order volume. Plus a separate sheet for the commercial proposal with a logo and export to PDF.
Why me — I do it so that you can edit it yourself without a programmer, not a "black box with formulas." I have relevant experience with logistics data.
-
10 days275 USD
1825 52 0 10 days275 USDGood day. I can write a desktop application for Windows for all necessary calculations.
-
5 days150 USD
393 5 days150 USDGood day, I have familiarized myself with your technical specifications. I propose implementation in Google Sheets using Apps Script and formulas. I suggest discussing the details in private messages. This work will cost 150-200 USD. I will be happy for our collaboration!
-
6 days100 USD
465 24 7 6 days100 USDHello! I will create a simple and convenient calculator for calculating the cost of courier and logistics services. The format will be Excel or Google Sheets, so it can be easily edited and used every day without a programmer.
The calculator will include: two types of orders - documents (up to 1 kg) and parcels (over 1 kg, only for vehicles); different types of delivery (express, same-day, regular, economy) with the ability to change and add your own; accounting for fixed and variable costs; calculation of the final price with minimum cost and markup; working with zones (for example, Zone 1, Zone 2, etc.); automatic generation of a commercial proposal (Excel or PDF) with a logo and price table.
Deadline - 6 days.
Cost - from 200 USD. Result - a ready-made tool that calculates the cost, helps to form prices, and automatically prepares a commercial proposal for clients. Everything is simple and convenient for daily use.
-
2 days90 USD
2187 13 1 2 days90 USDHello!
I read the project brief — and I have good news. I have already done almost what you describe: a cost calculator for a courier service with documents up to 1 kg, packages over 1 kg, distribution of fixed costs based on monthly volume, editable zones, delivery types, and a quote generator in PDF.
A live working prototype is ready to be shown in the working area right after the start — you can manipulate it, check that the logic calculates correctly for your economy.
What’s inside:
• Two types of orders: document (courier or driver) and package (only driver, taking weight into account).
… • 5 zones with coefficients per km — editable, can be added or removed.
• 4 types of delivery (express, same-day, regular, economy) — can be renamed, disabled.
• Settings: salary, rent, taxes, admin; fuel/km, depreciation, payment to the performer, surcharge for weight.
• Markup %, minimum price, automatic price matrix.
• Quote generator with your logo, name, and contacts — one button "save PDF".
• Live recalculation: change any parameter — everything updates.
I made it as a web tool (HTML + JS, without backend): it opens via a link or locally, editable without a programmer. It’s more convenient than Excel: beautiful interface, one button — the quote is ready, works on mobile.
To adapt it for you, it will take 2 days: zones for your region, your fixed and variable costs, logo in the quote, and if desired — history of calculations and client saving.
Cost: 3500 UAH, deadline 2 working days, including 2 weeks of revisions after delivery.
Bonus: I will send a basic draft with your figures to the working area 1 day after the start — you will see how it looks for your economy. If something doesn’t work out — you owe nothing.
What I need from you: a list of zones with ranges per km, approximate fixed costs per month (can be approximate), logo, and company name. Ready to start today.
-
5 days99 USD
138 5 days99 USDHello! I have carefully studied the technical specifications — I fully understand the task.
I will implement it in Google Sheets + Apps Script:
— Two types of services with the correct logic: couriers only for documents, drivers for both
— Distribution of fixed costs even with a small number of orders
— Zones by km with flexible coefficient settings
— Delivery types — editing, adding, disabling
— "Settings" sheet — everything changes without a programmer
— Automatic generation of a commercial proposal (PDF) with a logo and price table
…
I am ready to start today. Write to me — we will discuss the details.
-
5 days95 USD
871 10 0 5 days95 USDGood day!
I have reviewed the technical specifications — I understand the task. I propose to implement the solution in the format of Google Sheets + Apps Script (a mix of formulas and automation).
The main logic of the calculations will be implemented in the spreadsheets (so you can easily edit expenses, zones, types of deliveries, and coefficients without a programmer).
More complex tasks and automation will be handled in scripts:
— generation of a commercial proposal (PDF/Excel with logo, prices, zones)
— a button for quick calculation
— processing complex logic (types of orders, restrictions, delivery scenarios)
As a result, you will receive an easy-to-use tool that automatically recalculates the cost and generates a ready document for the client.
-
5 days100 USD
1510 10 0 5 days100 USDHello! We have experience in creating tools for logistics calculations. We implement this through Google Sheets or Excel — convenient, transparent, without unnecessary elements. Formulas, validation, support for structure — we will consider everything. We can add templates for different delivery scenarios.
-
5 days639 USD
475 2 0 5 days639 USDready to help you out
will share previous work in chat - to make sure we match
----------------------------------------------------------------------
-
3 days150 USD
556 1 0 3 days150 USDHello!
I am ready to create a cost and logistics calculator in Google Sheets or Excel format — with convenient logic and the ability to edit all parameters without a developer.
I understand the task: this is not just a table, but a tool that will be used daily — therefore, the key focus is on simplicity, clarity, and accurate calculations even with a small number of orders.
Regarding implementation:
— structure of several sheets:
… • “Calculator” (data input and result)
• “Settings” (all parameters: expenses, zones, delivery types)
• “Calculations” (hidden logic)
— calculation logic:
• division into “documents” and “parcels”
• accounting for distance or zones
• delivery types (editable)
• distribution of fixed costs over order volume
• accounting for variable costs (fuel, km, courier, etc.)
— flexible settings:
• adding/disabling delivery types
• setting up zones (coefficients/prices)
• minimum price
• markup (%)
• automatic recalculation
— generation of proposals:
• generation of a neat document (PDF/Excel)
• logo, company name
• price table, zones, delivery types
• ready to be sent to the client
I will ensure that all key parameters can be changed in one place without the risk of “breaking” the formulas.
Deadline: 3 days
Cost: $150
I have a couple of questions:
Do you plan to work in Excel or Google Sheets?
Do you need to create several templates for different types of clients?
After completion, I will add a bonus: I will show how to scale the calculator (for example, for new cities or pricing models).
I look forward to collaborating!
Current freelance projects in the category Accounting Services
Filing a zero final declaration for a US LLC
71 USD
Hello, it is necessary to submit a final declaration for 2025 based on the template of the previous zero declaration for 2024 in order to officially close the company. Regarding payment, the cost is final, as the company has zero activity and I cannot incur any more expenses… Accounting Services, Consulting ∙ 1 day 1 hour back ∙ 7 proposals |
Building financial models (P&L + Cash Flow)We are looking for a qualified specialist who can help organize our business finances. We need to develop and implement two key reporting forms: P&L (profit and loss statement) and Cash Flow (cash flow statement). Please provide your work experience, what you have worked on,… Accounting Services, Data Processing ∙ 4 days 10 hours back ∙ 17 proposals |
Develop a dynamic financial model (in Excel/Google Sheets) for a network of autonomous fitness pods.
223 USD
Input parameters (Drivers): The ability to manually change the cost of 1 pod (CAPEX), the cost of rental per hour (399 UAH), the dollar exchange rate, the cost of land rental, and the loading percentage. Three scenarios: Pessimistic (20% loading), Realistic (30-35%),… Accounting Services, Consulting ∙ 4 days 12 hours back ∙ 22 proposals |
Need consultation from an accountant - Import VAT, duties, pricing, tax credit -Looking for a practicing accountant for import + VAT for a one-time consultation (~40 minutes). Topics: pricing and margin on imported goods, customs clearance (duty according to UKTZED, import VAT 20%, tax credit), choice of sales scheme — with VAT / without, wholesale and… Accounting Services ∙ 6 days 2 hours back ∙ 5 proposals |
Grant manager for veteran business
334 USD
Need to find grants and apply for grants for veteran-owned business - freight transportation. Successful collaboration will lead to partnership with an NGO. Accounting Services, Project Management ∙ 6 days 12 hours back ∙ 9 proposals |
Баку