Find Jobs
Hire Freelancers

excel forcasting

$2-8 AUD / hour

Closed
Posted over 6 years ago

$2-8 AUD / hour

Trying to create a revenue forecast for a childrens day nursery. Each child has a booking pattern eg Alice Mon 10 hours, Tue 0, Wed 5 hours, Thurs 0, Fri 5 hours = 20 hours. The nursery is open 51 weeks a year, but also closes on public holidays. For 2018 these are 1st Jan, 30th Mar, 2nd Apr, 7th & 28th May, 27th Aug and it is shut 24th - 28th Dec. What is the best way to calculate the hours for each week for each child making sure that we don't include hours when the nursery is closed? So far I have created a calendar for the next 3 years with all the bank holidays highlighted in red - not sure if I am going down the right route with this. So what I need is to compute the range and give me number of hours booked for a child, keeping in mind the public holidays occurred in between. checked attachment if you fully understand project then bid plz. my budget is $10 A - afternoon M - morning D - Full day
Project ID: 15872285

About the project

14 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
14 freelancers are bidding on average $4 AUD/hour for this job
User Avatar
Hello, I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application -- Expert in ASP.NET,MVC -- JS,Google extensions and google scripts I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Abhinov
$5 AUD in 40 days
4.9 (63 reviews)
5.5
5.5
User Avatar
we are experts Developers team in developing E.r.p & Book Keeping & C.R.M Application we have lots of global clients from manufacturing , retail stores , wholesale business, schools , hospitals ,where we had completed all the modules according to customer requirements
$5 AUD in 40 days
5.0 (9 reviews)
4.5
4.5
User Avatar
Hi, I can work for you on this project. You can contact me at any time to get my services. I will give you good results with satisfaction guaranteed. Thanks.
$2 AUD in 1 day
4.9 (17 reviews)
4.5
4.5
User Avatar
Hi, I have understood your project requirement for revenue forecast for a childrens day nursery. I am interested to work with you.
$2 AUD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am good in data entry. I can work in your project graphic designing! I Am good in Ms Office and i can in photoshop to I also know about email hadnling dat extraction web searching web scrapping i am also good in VA Virtual Assiatance and video editing, video uploading.
$5 AUD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$2 AUD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Iiiiii
$5 AUD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello , I am Falguni Ahmed .I am very much interested on your project .I feel that I am the exact match for your requirements after thoroughly reviewing the job description and desired skills I experience in Data Entry, Data Processing, Excel, Visual Basic. Here I would like to mention that if you get enough time to give me a better feedback it would be very helpful for me..I would highly pleased if you consider my particulars yours obediently. So I hope your kind response. Regards Falguni Ahmed
$2 AUD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$5 AUD in 25 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am Ly. I have experience for excel. I can do this project. Pls contact me to discuss. I can help you. It need not pay money for me
$2 AUD in 40 days
5.0 (1 review)
0.0
0.0
User Avatar
I am a fast working and like to get the job done correctly. I have the skill to complete this job fast.
$5 AUD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi Based on the data provided by you, I have already prepared a sample sheet which fulfills your requirements and allows you to analyse your revenue on various parameters like per child, per week, per month, per quarter. It is automated such that you can add/ delete children and get the output. I could share my screen and explain my worksheet that i made based on dummy data. Post which you can accept my bid Regards Srikanth. S 7 3 3 7 2 0 0 1 8 5
$2 AUD in 40 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED ARAB EMIRATES
DUBAI, United Arab Emirates
5.0
2
Member since Jul 10, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.