
Completed
Posted
Paid on delivery
I need a dynamic spreadsheet that lets me compare three collection scenarios—running our own trucks, outsourcing to a logistics partner, or the mixed approach I currently favour—for 5 L, 10 L, 15 L and 20 L white plastic buckets picked up from cafés, restaurants and other food-service outlets and delivered to local recyclers. The model must calculate and contrast cost efficiency, speed of collection and environmental impact for each scenario so I can quickly see which route gives the best overall outcome. Please structure it so I can adjust volumes, run distances, fuel or labour rates, rental fees and gate-fees myself and have the headline numbers update automatically. A clear dashboard summary is essential; underlying assumptions and formulas should be transparent in separate tabs. Deliverables • Fully-linked Excel or Google Sheets file • Assumptions sheet with editable inputs • Scenario dashboard comparing the three approaches on the metrics above • Brief user guide explaining how to tweak inputs and read results If you have experience modelling logistics or waste-resource recovery systems, let me know—real-world data insights will help refine the inputs.
Project ID: 40455815
15 proposals
Remote project
Active 5 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

Greetings, A clear comparison model for your bucket collection system can turn operational choices into measurable cost, speed, and environmental outcomes across all three scenarios. 1 Dynamic spreadsheet comparing in-house trucks, outsourcing, and hybrid collection model 2 Automated calculations for cost efficiency, collection speed, and environmental impact across 5L, 10L, 15L, and 20L buckets 3 Fully editable assumptions sheet for fuel, labour, distance, rental, and gate-fees with real-time updates 4 Scenario dashboard presenting all three approaches side by side for quick decision-making clarity 5 Transparent formula structure with separate tabs for inputs, logic, and outputs for easy tracking With years of experience in logistics modelling and operational data systems, I work on building decision tools that convert real-world variables into clear, actionable insights. This is a placeholder bid, once project details are discussed we will align budget accordingly. Let’s connect for 10–15 seconds to align on data structure and workflow. Best Regards Neha K,
$200 AUD in 7 days
1.8
1.8
15 freelancers are bidding on average $36 AUD for this job

As a highly proficient and experienced freelancer, I offer a valuable skillset well-aligned with the requirements of your project. My proficiency in Data Analysis, Business Analysis, Excel, Financial Analysis, and Google Sheets is crucial for executing a task as complex as developing a dynamic spreadsheet that compares 3 different collection scenarios. I am adept at constructing comprehensive models that not only meet specific needs but also allow for straightforward input adjustments to suit evolving requirements. Drawing on my extensive experience with data-driven projects, I am confident in my ability to develop an interactive model that calculates and contrasts cost efficiency, speed of collection, and environmental impact for each of the scenarios you would like to explore. More importantly, my background liaising with logistic systems and knowledge of waste-resource recovery systems will ensure that your model will be built on real-world data insights, optimizing its value. Beyond my technical abilities, I offer a level of dedication and commitment that sets me apart. I understand the importance of transparency and clear communication in each step of a project; I would therefore ensure that your model is accompanied by an assumption sheet with editable inputs, a user guide for ease of use and understanding - all while providing unlimited revisions till you are thoroughly satisfied. Choose me to execute the project flawlessly as per your stipulated timeframe.
$20 AUD in 1 day
5.4
5.4

Hi, I can build a dynamic Excel/Google Sheets scenario model to compare your in-house, outsourced, and mixed collection approaches. I have strong experience in Excel financial modelling, logistics cost analysis, scenario dashboards, operational KPIs, and sustainability-style reporting. I’ll create editable assumption tabs for volumes, bucket sizes, distances, labour, fuel, rental fees, gate fees, and other key inputs, then link them to a clear dashboard comparing cost efficiency, collection speed, and environmental impact across all three options. The model will be transparent, easy to adjust, and structured so you can quickly see which collection strategy performs best overall. I’ll also include a short user guide explaining how to update inputs and interpret the results.
$30 AUD in 1 day
4.7
4.7

Hi, I’ve reviewed your project and can help you get it done quickly and accurately. I’m Sarim Ali Khan, a top-rated freelancer specializing in data automation, analysis, and workflow optimization. My clients hire me because I deliver on time, on budget, and with zero guesswork. I can start right away and share a quick sample if you’d like. Let’s chat about the details and get you results — fast. Best, Sarim
$30 AUD in 1 day
4.4
4.4

Hi, I’d be happy to build a dynamic spreadsheet model to compare your three collection scenarios across cost efficiency, collection speed, and environmental impact. I’m comfortable creating structured Excel/Google Sheets models. The model can include: ✔ Separate assumptions/input sheet ✔ Fully linked calculations and formulas ✔ Scenario comparison dashboard ✔ Adjustable variables (fuel, labour, distance, gate fees, rental costs, volumes, etc.) ✔ Clear visual summaries for quick evaluation ✔ Brief user guide for updating and interpreting results I understand the importance of keeping the model flexible and easy to maintain while still providing meaningful operational insights. Looking forward to working with you. Thank you. Best regards, Doris
$30 AUD in 2 days
0.0
0.0

Melbourne, Australia
Payment method verified
Member since Oct 13, 2023
$30-250 USD
$15-25 USD
₹750-1250 INR / hour
$15-25 USD / hour
₹12500-37500 INR
$2-8 CAD / hour
$250-750 USD
£250-750 GBP
$20000-50000 AUD
₹12500-37500 INR
€30-250 EUR
₹750-1250 INR / hour
₹12500-37500 INR
$250-750 NZD
$60-100 USD / hour
$25-50 USD / hour
$15-30 USD
£20-250 GBP
$750-1500 CAD
₹1500-12500 INR