I'm talking to family about possibly looking after their children and they want to be able to pay the same amount each month. I'm trying to work out any possible holidays I'll be taking over the next 12 months and deducting bank holidays (because I don't charge for either). I'm getting really muddled with the numbers. I can't find my calculator either so I'm having to work it out the old-fashioned way!!!
Surely there's got to be an easier way? Pluck a number out of thin air and x by 2?! That sounds much simpler to me!!!!!
Anyone else ever do this for families or does their fee vary each week?
You just need the number of weeks you'll be charging for, X fee X 2 divide by 52. Er I think anyway. I had to work out my childcare costs for WTC last week and it took me ages to work out how to do it!
Actually I forgot the bank holiday part so maybe you'd be better off working it out daily to start (or ignoring me because maths never has been my strong point)
So, work out your charges per day X 2 for two children. Then work out how many days you won't be having them, weekends, weeks off and bank holidays. Take that number from 365. Whatever you have left multiply by charge per day and then divide that number by 12 to get charge per month.
Et voila, you either have the monthly charge, or it'll be totaly wrong and you should have ignored me
Hadn't thought of usuing pc, thanks! (although, it'll prob take me ages to figure how to find it!!)
MW - the children are pre-school and school age so I need to work out a term time figure and a school holidays figure then I need to work out whether my holidays are going to be during term-time or the school holidays. Also, I'm trying to work out when the bank holidays fall (term-time or sch hols) and whether I've already accounted for them in my time off!!!
Yes!!! If I knew how to do spreadsheets I'm sure it'd make perfect sence!! When I have a spare few hours I'll learn all about spreadsheets then future fee-calculations will be much easier!! Or, maybe I'll get my step-dad over (retired accountant) he LOVES spreadsheets!!!!!
Navy - Thanks, that's very kind of you to offer! I think I've got a figure now that seems reasonable, I just needed a bit of peace and quiet in my house to be able to concentrate (probably shouldn't have chosen the weekend to sort it out!!), also would have been helpful if my calculator was where I left it!!!!!