Find Jobs
Hire Freelancers

Excel-Based Parking Lot Model

$30-250 USD

已完成
已发布超过 7 年前

$30-250 USD

货到付款
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: 12266321

关于此项目

18提案
远程项目
活跃7 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
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 在3天之内
5.0 (17条评论)
4.8
4.8
用户头像
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 在1天之内
5.0 (114条评论)
6.8
6.8
18威客以平均价$220 USD来参与此工作竞价
用户头像
A proposal has not yet been provided
$264 USD 在3天之内
5.0 (375条评论)
7.7
7.7
用户头像
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 在3天之内
4.8 (146条评论)
6.8
6.8
用户头像
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 在3天之内
5.0 (154条评论)
6.5
6.5
用户头像
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 在3天之内
4.9 (71条评论)
6.3
6.3
用户头像
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 在3天之内
4.9 (118条评论)
6.3
6.3
用户头像
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 在3天之内
4.9 (135条评论)
6.3
6.3
用户头像
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 在2天之内
5.0 (82条评论)
5.3
5.3
用户头像
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 在3天之内
5.0 (52条评论)
5.3
5.3
用户头像
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 在3天之内
5.0 (20条评论)
5.4
5.4
用户头像
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 在3天之内
4.8 (58条评论)
5.3
5.3
用户头像
A proposal has not yet been provided
$250 USD 在3天之内
4.9 (76条评论)
5.4
5.4
用户头像
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 在3天之内
4.9 (32条评论)
4.3
4.3
用户头像
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 在3天之内
5.0 (5条评论)
3.4
3.4

关于客户

UNITED STATES的国旗
Houston, United States
5.0
1
付款方式已验证
会员自1月 16, 2014起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。