Closed

Excel expert for forecasting -- 2

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

Skills: Data Entry, Data Processing, Excel, Statistics, Visual Basic

See more: hire excel expert for 2 hours, buy excel expert, freelance statistician excel expert, excel expert service, excel expert job, excel expert finance job, excel expert independent contractor bid, excel expert salary, need excel expert, vba excel expert, money excel expert, excel demand forecasting template, excel expert financial models, microsoft excel expert montreal, toronto excel expert job

About the Employer:
( 2 reviews ) DUBAI, United Arab Emirates

Project ID: #15872363

20 freelancers are bidding on average $4/hour for this job

$5 AUD / hour
(69 Reviews)
8.4
andriphone0

Hello, Please refer to your PM, I Will provide a sample for you to prove Our ability before awarding, I will follow all instructions and If you have any question related to budget, deadline of work and any other iss More

$5 AUD / hour
(59 Reviews)
5.5
ashrafnauman

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 / hour
(7 Reviews)
3.9
jonna88

Hello there, hope you are doing fine. I am very interested in doing this project and can start working on it after having discussed and awarded. Hoping to hear from you and may you have a great day ahead. Thank you.

$5 AUD / hour
(6 Reviews)
3.7
Pmshah1985

I am Chartered Accountant by profession having experience of more than 6 years in a reputed MNC, worked as financial analyst .Proficient in accounting, bookkeeping. Very hardworking and good communication skills Servi More

$6 AUD / hour
(13 Reviews)
3.6
spcvalente

You'll have a sound result. I will get you a flexible solution, with everything you specify. I am new here, that's why I am proposing a low rate.

$5 AUD / hour
(1 Review)
3.0
Joni058

Let me do this project please :)

$2 AUD / hour
(4 Reviews)
2.3
androaiad

Hello dear, I'm a M.Sc. engineer. I am expert in Excel so I can help you for sure in your task. Thanks

$2 AUD / hour
(4 Reviews)
2.8
reachankitbnsal

A proposal has not yet been provided

$6 AUD / hour
(0 Reviews)
0.0
$2 AUD / hour
(0 Reviews)
0.0
ramrati

A proposal has not yet been provided

$5 AUD / hour
(0 Reviews)
0.0
gaurav1986gupta

I'm very good @ advance excel. Please give me a chance to prove. I don't mind if you'll not pay me. I'm ready to work for some good reviews. Relevant Skills and Experience Request you to give me a chance

$2 AUD / hour
(0 Reviews)
0.0
$5 AUD / hour
(0 Reviews)
0.0
ArifulIslam12345

A proposal has not yet been provided

$8 AUD / hour
(0 Reviews)
0.0
zephyr81

From your explanation you need a basic forecast of each child’s hours and then their total, average and eventually work up to the nursery’s income. I can’t see any attachment (since I’m on the App at the moment) but I More

$7 AUD / hour
(0 Reviews)
0.0
wifizoneit910

Hello I saw your project and read its details I want to do it because I am sure I can do it and I have skills that your project needs. I promise accuracy and quality of work. please response me. Check your attachment More

$2 AUD / hour
(0 Reviews)
0.0
$4 AUD / hour
(0 Reviews)
0.0
ujjwalkesarwani

I will complete your work in best way

$6 AUD / hour
(0 Reviews)
0.0
AdminKC

WE CAN START YOUR PROJECT IMMEDIATELY. Hello, I gone through your project description which you have given and Our team is very much comfortable in such project. Our organization is a pioneer in the field of Web A More

$5 AUD / hour
(0 Reviews)
0.0
$3 AUD / hour
(0 Reviews)
0.0