Supplier Cost Comparison Spreadsheet Tender

£20-250 GBP

Completed

Posted 30 days ago

£20-250 GBP

Paid on delivery

I’m gathering quotations from roughly a dozen food-service suppliers and need a clean, reliable Excel file that lets me and you plug each quote in and instantly see where we can save money. Structure I have in mind • One master workbook with a dedicated tab for every supplier (expect 10–12). • A dynamic summary tab that automatically identifies the best supplier overall for every line item, taking into account weight and pack-size differences. possible colour coded • Built-in calculations for total costs per supplier, potential savings against a current baseline, and any weight/pack-size conversions so we’re always comparing like with like. Presentation requirements • On the final tab I want a clear “best supplier overall” view, plus space to discuss bundle scenarios if time allows. • Simple visual aids — a few well-chosen charts that highlight total spend and headline savings — will help me make the case to my client. Timing Quotes will arrive over the next ten days; and i can forward these as they come in . I have a couple to ensure that the set up is correct and then i will simply forward these to you . I need the finished, fully-tested sheet on or before 30 April so I have room for final checks and ready to present Excel know-how with formulas such as INDEX/MATCH or XLOOKUP, data validation, and charting will be essential. If you can set the file up so I can then send to you each suppliers information to enter and drop each new supplier price list in without breaking anything, that’s perfect. There are 140 sku reviewing , but the suppliers will be sending information over in the same format , so it should be simple , but it will need to be reviewed to ensure it does match

Project ID: 40380935

About the project

33 proposals

Remote project

Active 22 days ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@freelancerabdu34

£0 GBP in 1 day

5.0

(392 reviews)

7.2

33 freelancers are bidding on average £156 GBP for this job

@techplusintl

Hi, To create a reliable Excel file for your supplier quotes, I'll set up a master workbook with dedicated tabs for each supplier and a dynamic summary tab. This will include: - A master workbook with 10-12 supplier tabs. - A summary tab that highlights the best supplier for each line item. - Built-in calculations for total costs and potential savings. - Simple visual aids like charts for total spend and savings. I'll ensure the setup allows you to easily input new supplier data without issues. I'll use Excel formulas like INDEX/MATCH and XLOOKUP to make the calculations efficient. Ready to start once you provide the first set of quotes. Thanks!

£350 GBP in 10 days

4.7

(19 reviews)

5.7

@chraheelbhatti

As an expert in data analysis and visualization, with strong Excel skills, I am ideally suited for your Supplier Cost Comparison project. Throughout my 10+ years in the field, I've developed a deep understanding of the power Excel holds when harnessed for complex needs such as yours. I can efficiently develop a master workbook with dynamic summary tabs to streamline your quotation process and help you make informed decisions on the best supplier overall for every line item. Lastly, being a senior machine learning engineer, you can trust that my work is thoroughly tested and values accuracy. To elevate your reporting capabilities, I'll include a suite of clear visual aids that not only showcase total spend per supplier but also highlight eye-catching headline savings using simple yet compelling charts. My commitment to quality, combined with timely completion à la a PhD researcher's discipline ensures you receive a reliable and polished final product by 30th April. Let's harness the power of AI/machine learning to simplify this process while maximizing saving potential!

£20 GBP in 5 days

4.9

(24 reviews)

5.3

@TDRWork

Hi, I am a certified and experienced Excel expert. Your Excel formulas applying and comparison request is perfectly matching with the specialize service offering in my profile. Please feel free to ask any questions if you have. Thanks!

£135 GBP in 7 days

4.9

(14 reviews)

4.4

@nareshk44

With my strong background in data analysis and proficiency in Excel's advanced functions, I am confident that I am the best fit for your project. I have extensive experience with INDEX/MATCH and XLOOKUP formulas, data validation, and charting, which are essential for creating a clean, reliable and dynamic cost comparison spreadsheet like you need. My knowledge with these tools will ensure that the file can be easily managed as you provide quotes from different suppliers without any disruption. Not only do I bring technical skills to the table, but also an understanding of the importance of clear data presentation. Designing simple visual aids like charts to trace total spend and highlight headline savings is one of my key strengths. This will help you make a powerful case to your client and save precious time on calculations. Meeting deadlines is always critical, therefore I will deliver a fully-tested and functional sheet well within your provided timeframe. I offer unlimited revisions because my focus is on giving you 100% satisfaction with final product. Let me show you just how much impact a well-built supplier cost comparison can have on your business' bottom line! Contact me now to get started.

£100 GBP in 1 day