Excel programming for business reporting and forecasting
$30-250 AUD
Paid on delivery
I run a small accommodation business with 3 Airbnb properties and I want a set of Excel spreadsheet templates setup so that I can enter the daily rate paid for the accommodation and it will feed into a dashboard that shows a range of outcomes. Basically I want to track profit, turnover on a daily, weekly and monthly basis and the also provide forecasts based on 80% occupancy. I also want weekly and monthly profit targets set so that after each day's actual rate paid is entered it automatically updates suggested rates for the week and the month so that I know what I need to charge to ensure I am making $200 profit per week. The dashboard should show weekly profit, cleaning costs, laundry costs
Project ID: #8278923
About the project
30 freelancers are bidding on average $142 for this job
Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am th More
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 regard More
Hello Sir Im Excel VBA macro and formula Expert :) i can do anything in excel :) please give me a chance for doing your job and im able to start doing your job right now :) Thank You Sincerely Prameswara :)
Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.
Hi! excel automation is my masterpiece in my accounting field. Pleasure if you choose me to work with your project. Thank you.
I have the expertise in Excel to build dashboard and forecasting tools as you have described. Please share more details and specifics. Ready to start work immediately
Dear Client, I have a lot of experience with VBA and Excel. I can make what you requested. Send me a message for more information. Kind Regards, Rens Slenders SlenDATA
Professional Data Scientist. Expert in predictive modelling and forecasting. More than 5 years of Experience in forecasting market size for technology market. Can finish this job in hours time
Hi, I have created several dashboards before. I can send some sample file to you if you want. Please send a message so we can discuss before agreeing on anything. Also, I have a question regarding your forecast, More
Hello, I am able to Complete this task with 100% accuracy. Please message me for my interview. I have 2.5 years experience in vb,vba and vb.net development. I have worked with VB6.0 as Front-end VBA Script EXC More
Hi, I am an experienced in business modelling and forecasting. The project you describe sounds particularly interesting and I think we could do a lot with it. I have worked in a large occupancy based business in More
i been work on excel since 2012 so it will be a piece of cake for me to make your spread sheet in excel looking for your response