troubleshooting Question

Data Forecasting

Avatar of Shanan212
Shanan212Flag for Canada asked on
Math / Science
4 Comments3 Solutions319 ViewsLast Modified:
Hi,

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)
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 3 Answers and 4 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros