Create Excel document to calculate how to price services to be Cheapest at All Times

$30-250 USD

Ολοκληρώθηκε

Αναρτήθηκε

περίπου 8 χρόνια πριν

$30-250 USD

Πληρωμή κατά την παράδοση

We are TaxiService and want to adjust our taximeter prices to be CHEAPEST of all taxi companies in our area. We need an Excel-based Calculation Sheet which can open/read several Excel Documents, each containing competitors prices, and calculate what-if for all possible TimeOfDay/time/distance combinations and suggest how we should price our services so we are just a fraction below our competitors. The Excel documents containing competitors prices, have identical layout and data, and serves as input for calculation. One excel input document per competitor. Taximeter prices depend on DayOfWeek and TimeOfDay. FareCalculation depend on TypeOfBooking, DistanceTravelled and DurationOfTrip. MinimumFare is applied. The resulting Excel Document should open each of the InputDocuments and find the lowest fare for every combination 1-100km and 1-100minutes throughout the day and week, for 3 different types of bookings (Hailed Taxi, PhoneOrdered Taxi, PreBooked Taxi). The calculation Excel Document should then suggest how we should set our fares to ensure that we are "just a tiny bit" cheaper than the next one. Enclosed is a sample ExcelDocument containing fares for one taxi service. There will be 8-10 such documents being read. The end result should be a similar document for our fares... Please contact me on Chat if you have questions or need clarification.

Data Processing

Excel

Ταυτότητα εργασίας: 9696851

Σχετικά με την εργασία

13 προτάσεις

Απομακρυσμένη Εργασία

Ενεργός/ή 8 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Διεύθυνση Email

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα

Πληρώσου για τη δουλειά σου

Περίγραψε την πρόταση σου

Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν

Βραβεύτηκε στον/στην:

@bytessolution

Greetings. I specialize in provide solutions for Business Administration, Data Base management, Key Performance Indicators design, Supply Chain Planning and Project Management for commercial and industrial companies. I am also able to develop complex and automated Excel spreadsheets and Access databases, including formulas creation, pivot tables, pivot charts, data manipulation and macros. I guarantee that I'm able to bring the solution for your project, with the dedication, seriousness and professionalism that it deserves. My work will give you the confidence to initiate a long term relationship. Thank you for your time

$200 USD σε 1 ημέρα

3,6

(10 αξιολογήσεις)

3,3

@tomislav1975

HI, I have experience with such projects and I am very skilled in Excel and VBA coding. This should be interesting project and I would love to work on it. See my profile here and at [login to view URL]~013b83880630cfd653 With regards, Tomislav

$333 USD σε 7 ημέρες

4,9

(33 αξιολογήσεις)

5,1

13 freelancers δίνουν μια μέση προσφορά $169 USD για αυτή τη δουλειά

@elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards

$225 USD σε 3 ημέρες

5,0

(99 αξιολογήσεις)

6,1

@P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$250 USD σε 2 ημέρες

4,9

(65 αξιολογήσεις)

5,8

@annyann

Contact me for more info Dear employer: My name is Ana and I am interested in working with you. Efficiency, accuracy, adaptability, confidentiality and being always on time are my keys to success, which is exactly what I am willing to provide to you. I am fast learner and pay la lot of attention to details. I am fluent in English, French, Spanish and Romanian, and intermediate in German and Italian. I am working as paralegal since 2012, graduated from Law School in 2013 and was awarded many times for accounting and legal academic work, my studies being published. I have specialized myself in Civil, Administrative and Business Law so you can count on me for Legal writing (Academic, Contracts, Terms and Conditions), Legal research, Compliance and others on the Romanian and EU Legislation. I have also graduated from Business School in 2009, worked and I am still working as an accountant on my free time. I believe I can get you the results needed in the shortest time possible and in the most precise way, my received feed-backs being my testimony. If you believe we can work together, i am looking forward to hearing from you. Faithfully, Ana

$155 USD σε 3 ημέρες

5,0

(2 αξιολογήσεις)

3,2

@AndrewBelow14

This project sounds very interesting and something I would love the chance to work on! My job involves a lot of analysis of competitors within the construction industry and then working out what we need to charge for each hour we work on the project and each task we carry out in order to be cheaper but still meet our profit margins. I feel this makes me a very good candidate for your job, and I am an expert when it comes to excel so I would have all the required skills! If you have any questions feel free to message me and we can discuss this further.

$188 USD σε 3 ημέρες

5,0

(1 αξιολόγηση)

0,6

@AwaisChaudhry

Hi there! I have read what you exactly need, however I would like to ask you a few questions. I would call myself a master of what I do, I do work smart and do not rest until I get the job done. Please feel free to ping me anytime so we can have a detailed discussion. If I can deliver I will deliver in best possible way. Thanks

$150 USD σε 3 ημέρες

0,0

(0 αξιολογήσεις)

0,0

@ericmnjoroge

Hire me and you shall receive excellent, quality work done for you.

$250 USD σε 2 ημέρες

0,0

(1 αξιολόγηση)

0,0

@Muaaz9

I work as a data analyst /business at a utility. I have performed such tasks at work. However, my desired style of working is to take time but provide quality work. So in 14 days we would be connecting with each other and sharing files as per the milestones suggested. If you agree with the requirements I am willing to work. And even negotiate if you are willing to compromise more on time.

$140 USD σε 14 ημέρες

0,0

(0 αξιολογήσεις)

0,0

@joinmeakky

I am WebScraping, Wordpress, eCommerce, Articles, Blog, Photoshop, PhotoshopDesign, WebsiteDesign, DataEntry, DataProcessing, WebSearch, CustomerSupport, MicrosoftOffice, Excel, InternetMarketing, SocialMediaMarketing, GoogleAdwords, InternetResearch. I am very much professional in this work I am pretty sure that you cant find a best person for this job like me so I am ready to work on your project with low rate and high quality.

$30 USD σε 3 ημέρες