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
15 freelancers are bidding on average $20 for this job
Hi, I have over 7 years of experience in different industries like finance banking telecom. I am expert in excel with advanced function and formula (VBA, MACRO), ms word, ms PowerPoint.
I'understand the project [login to view URL] i can do so easy , i'm professional in Microsoft Excel works Please , contact me to discuss further details.
I have understood the instructions and file. Can easily complete the task. Relevant experience (of Excel) of approx 6 years. Hoping for positive feedback.