I have monthly sales figures for the first two months of the year:
<TABLE style="WIDTH: 53pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=71><COLGROUP><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2596" width=71><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 53pt; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl63 height=20 width=71>P1 34,651 </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl63 height=20>P2 20,665 </TD></TR></TBODY></TABLE>
I have used the run rate formula below to calculate where we will end the current month based on daily sales
=C3/C4*(EOMONTH(TODAY(),0)-EOMONTH(EDATE(TODAY(),-1),0))
Where C3 is my sales and C4 is the number of the days in the month as of today.
P3 26,323
What is the best formula to use to forecast/calculate the run rate for the next two months?
I have tried a couple of average formulas but of course they create the same average after the following months...
<TABLE style="WIDTH: 53pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=71><COLGROUP><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2596" width=71><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 53pt; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl63 height=20 width=71>P1 34,651 </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl63 height=20>P2 20,665 </TD></TR></TBODY></TABLE>
I have used the run rate formula below to calculate where we will end the current month based on daily sales
=C3/C4*(EOMONTH(TODAY(),0)-EOMONTH(EDATE(TODAY(),-1),0))
Where C3 is my sales and C4 is the number of the days in the month as of today.
P3 26,323
What is the best formula to use to forecast/calculate the run rate for the next two months?
I have tried a couple of average formulas but of course they create the same average after the following months...