Create Excel document to calculate how to price services to be Cheapest at All Times
$30-250 USD
Maksettu toimituksen yhteydessä
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.
Projektin tunnus: #9696851
Tietoa projektista
Myönnetty käyttäjälle:
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. Lisää
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] Lisää
13 freelanceria on tarjonnut keskimäärin $169 tähän työhön
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 rega Lisää
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.
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 e Lisää
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 pin Lisää
I am WebScraping, Wordpress, eCommerce, Articles, Blog, Photoshop, PhotoshopDesign, WebsiteDesign, DataEntry, DataProcessing, WebSearch, CustomerSupport, MicrosoftOffice, Excel, InternetMarketing, SocialMediaMarketing, Lisää
