LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
MIVELD
 
Posts: n/a
Default FORECASTING SALES (please let this be a worksheet function)


Hi I have recently been given the task by my boss to forecast one of our
key customers monthly usage until monthly until end of 2006,

I am starting with this customers indidual branches monthly usage for
the past 3 years, Some branches will have opened and closed during this
time, And i am looking to be able to predict monthly usage for the next
18 months

Has anyone got any idea's on the best way to forcast within excel, I am
currently using trend (fomulae given to me on this sight) but people are
saying this is not the best way

Exponentionally has been mentioned by a few of my collegues but i have
no idea of the difference between that and linear.

Thanks

Al


--
MIVELD
------------------------------------------------------------------------
MIVELD's Profile: http://www.excelforum.com/member.php...o&userid=24562
View this thread: http://www.excelforum.com/showthread...hreadid=381536

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
FAO Conrad Calberg (Excel Sales Forecasting...) [email protected] Excel Discussion (Misc queries) 7 April 28th 05 05:18 AM
Search/Match between 2 x separate Worksheets and populate result in third worksheet Alan Bartley Excel Discussion (Misc queries) 1 April 11th 05 05:21 AM
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 05:37 AM
AUTOMATICALLY REFERENCE SALES INFO FROM WORKSHEET #1 INTO INDIVID. GeorgeF. Excel Worksheet Functions 1 December 2nd 04 11:01 PM
Can Sales Listing from Worksheet #1 go to individual worksheets? GeorgeF. Excel Worksheet Functions 2 December 2nd 04 08:49 PM


All times are GMT +1. The time now is 10:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"