how do work out daily usage

[kazza125]

Hi if the start read is 0.10 and end read is 3419 the usage is 3419 how do you work out average daily usage?

Also i need to write of 5 months standing charge which is 0.7070


[FONT=Calibri,sans-serif] [/FONT]
[FONT=Calibri,sans-serif]Further to my email re. Mrs Field, we need to take a similar approach to Mr Mullane at 77 George House. Can you please raise a ‘reconciled’ bill for his usage from move in to the end of Feb.[/FONT]
[FONT=Calibri,sans-serif] [/FONT]
[FONT=Calibri,sans-serif]His start date:[FONT=Tahoma,sans-serif] [/FONT][FONT=Tahoma,sans-serif]2012-05-14[/FONT][/FONT]
[FONT=Calibri,sans-serif] [/FONT]
[FONT=Calibri,sans-serif]Start Read (handover): 0.010[/FONT]
[FONT=Calibri,sans-serif]New Read: 3.419 for 1[SIZE=-1]^st Feb 2014[/SIZE][/FONT]
[FONT=Calibri,sans-serif] [/FONT]
[FONT=Calibri,sans-serif]For the months Sep, Oct, Nov, Dec, Jan we need to write off his standing charge and usage. In order to work out the appropriate ‘usage’ figure, please can you use his daily average usage.[/FONT]
[FONT=Calibri,sans-serif] [/FONT]
[FONT=Calibri,sans-serif]Thanks,[/FONT]



how do i do this?

 

[HallsofIvy]

This goes over a period of a year and a half. Why are you only referring to "Sept, Oct., Nov., Dec., and Jan."? To find the (average) usage per day, calculate the usage (3.419- 0.100= 3.319) and divide by the number of days.

Since this bill start on May 14, 2012, there are 31- 14= 17 days left in May. There are then 30 days in June, September, and November, 31 days in July, August, October, and December so 30(3)+ 31(4)= 234 days left in 2012. There are 365 days in 2013 and then 31 days in January.

 

[kazza125]

This goes over a period of a year and a half. Why are you only referring to "Sept, Oct., Nov., Dec., and Jan."? To find the (average) usage per day, calculate the usage (3.419- 0.100= 3.319) and divide by the number of days.

Since this bill start on May 14, 2012, there are 31- 14= 17 days left in May. There are then 30 days in June, September, and November, 31 days in July, August, October, and December so 30(3)+ 31(4)= 234 days left in 2012. There are 365 days in 2013 and then 31 days in January.

Thank you,
Sep 13-Jan 14 are the days I need to write off. could we chat pvt? you have been very helpful

I need to work out the average so i can credit the customer bill and i am at a lost.