Find Jobs
Hire Freelancers

Excel-Based Parking Lot Model

$30-250 USD

Terminado
Publicado hace más de 7 años

$30-250 USD

Pagado a la entrega
I need to create an excel-based parking lot model to optimize $/hr pricing and pricing of monthly reserved spots. I have a parking lot with a fixed capacity. There are two main type of customers, those who pay on an hourly basis and those who pay on a monthly basis. The monthly subscribers have a reserved spot. Drive-ins are more profitable (their stay is rounded up to nearest hour), but since the parking lot is only full during the peak time of the day, it is beneficial to sell the reserved spots at a discount. I need to find the optimum pricing for the monthly fee and the per hour fee. The inputs are: 1-Capacity, 2-Potential drive-ins at varying prices and different time of day, 3-Potential subscribers at varying prices. The variables are: 1-Drive-in fee, 2-Subscription fee. The objective is to maximize revenue.
ID del proyecto: 12266321

Información sobre el proyecto

18 propuestas
Proyecto remoto
Activo hace 7 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
Hello Sir, I can work with you and can create an excel based tool to find the best possible combination to ensure maximum revenue. Thanks Aanvik
$250 USD en 3 días
5,0 (17 comentarios)
4,8
4,8
Avatar del usuario
Hello there. Just checked your "MArket Estimates" file. We can prepare an optimization model with default add-in in Excel (solver). Contact me to discuss and proceed. Thanks..
$235 USD en 1 día
5,0 (114 comentarios)
6,8
6,8
18 freelancers están ofertando un promedio de $220 USD por este trabajo
Avatar del usuario
A proposal has not yet been provided
$264 USD en 3 días
5,0 (375 comentarios)
7,7
7,7
Avatar del usuario
I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, macros (VBA scripts), pivots, filters, and other advanced tools. I've done a lot of similar work. Please see reviews on my profile. It would be my pleasure to do your project. Just FYI, I own a small business registered in the state of Illinois. I could bill you as an individual freelancer or as a business, whichever suits you better. Please have a look at some Excel projects I've done: https://www.freelancer.com/projects/Excel/Build-Excel-reports-dashboard/ https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/ https://www.freelancer.com/jobs/Excel-Mathematics/Convert-math-proofs-Excel-formulas/
$200 USD en 3 días
4,8 (146 comentarios)
6,8
6,8
Avatar del usuario
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
$200 USD en 3 días
5,0 (154 comentarios)
6,5
6,5
Avatar del usuario
Hello, My name is Chris. As you can see from my profile, I have 16+ years experience working with Excel/VBA and 13 years teaching them both (all levels). I can certainly do excellent work with your project. The solution I'm suggesting will include an input screen, to enter the data and variables, and an output sheet with the possible solution to maximize revenue. Please contact me to further discuss the details. Looking forward to hear from you, Kind regards, Chris (chriskerpini)
$200 USD en 3 días
4,9 (71 comentarios)
6,3
6,3
Avatar del usuario
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.
$200 USD en 3 días
4,9 (118 comentarios)
6,3
6,3
Avatar del usuario
Hi, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. Please send me more details so that I can estimate cost and time better. I have completed more than 290 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$200 USD en 3 días
4,9 (135 comentarios)
6,3
6,3
Avatar del usuario
Hello, I am proficient with Excel and VBA and I would love to help you with this project. It sounds interesting and I have some ideas how to solve it. Please contact me for more information.
$70 USD en 2 días
5,0 (82 comentarios)
5,3
5,3
Avatar del usuario
Hello there! I'd like to assist you in your project. It seems in your project that you need to play around data that will provide the most revenue for your payment system. This requires some math and playing around with formulas and provided data in excel. I can help you make the best pricing to benefit you out of the factors you mentioned. Feel free to message me. I can assist you in this project.
$235 USD en 3 días
5,0 (52 comentarios)
5,3
5,3
Avatar del usuario
Hello, My bid is open to negotiation, I am based in the US, I have over 20 years of development in many forms of languages including PHP, JavaScript, CSS, HTML, jQuery etc. I have also worked with many frameworks. I am very much interested in your project. Additionally i have server admin experience, I am capable of doing many admin tasks including migrating your website from one server to another if this is a requirement of yours. Thank you - Chris
$235 USD en 3 días
5,0 (20 comentarios)
5,4
5,4
Avatar del usuario
Hi, I have read the project and understand your requirement. I did many work with my financial and excel competency. I am a highly trained on Excel and VB Macros. I did any project regarding automated yahoo finance/forex stock update dashboard . I did many project related to KPI template using Excel and so on. I only take work for 5***** review. I will continue the work until you fully satisfied. I take your work for my own responsibility and this is not my automated proposal. Kind regards, Fatima
$235 USD en 3 días
4,8 (58 comentarios)
5,3
5,3
Avatar del usuario
A proposal has not yet been provided
$250 USD en 3 días
4,9 (76 comentarios)
5,4
5,4
Avatar del usuario
Hi, Experienced Excel VBA and VB.Net Programmer. I have read your instructions carefully. I have also expertise in exchanging data between sheets, advance formulas, critical programming, developing system for management and creating reports. I have excellent knowledge and experience of creating User Form and its elements button, combo, drop down, option buttons etc. in excel VBA. I have done mostly this type of job where data manipulation is required. Please check my portfolio to see my work. Ready to start please reply soon. Thanks, Virendra
$130 USD en 3 días
4,9 (32 comentarios)
4,3
4,3
Avatar del usuario
I am a doctoral research scholar who is good at both optimization techniques and VBA coding in MS Excel. I can undertake both evolutionary and other conventional optimization schemes. Please refer my paper in ASCE for my verification of my credentials.
$249 USD en 3 días
5,0 (5 comentarios)
3,4
3,4

Sobre este cliente

Bandera de UNITED STATES
Houston, United States
5,0
1
Forma de pago verificada
Miembro desde ene 16, 2014

Verificación del cliente

Otros trabajos de este cliente

Download Data from Website
$8-15 USD / hour
¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.