I have a set of financial data for a company for the past 3 years. The company's most profitable days in a 5-business-day week is Monday (most), Tuesday (next most)....and the Friday being the least profitable day.
However, overall, this balances out (as nearly 70% of the revenues and costs get registered on Monday)
Now the problem is, if a Month ends on a Friday, some of its revenues goes to Mondays and bloats next month's revenues or vice-versa.
How can I create a forecasting model using historic data to see the 'true' revenue vs costs?(calculated of course)