Bucket Collection Financial Model Build
Summary
Freelancer Client is hiring: Bucket Collection Financial Model Build.
Location: Remote
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.
Fully-linked Excel or Google Sheets file
Assumptions sheet with editable inputs
Scenario dashboard comparing the three approaches on the metrics above
Skills: Visual Basic, Excel, Logistics, Business Analysis, Financial Analysis, Data Analysis, Google Sheets, Financial Modeling
Budget: $10–$30 USD
Source: Freelancer Client via Remote / Online. Apply on the source website.
Original
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.
Location & Details
Apply on source →About this listing
This remote opportunity was imported from Freelancer and is shown here for discovery. To apply, follow the link to the original posting.