Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 13th 08, 01:30 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2008
Posts: 8
Default How would I forecast something(sales) using excel

Can someone kindly help how to forecast. For and example lets say I ve got
sales data for the past 10 months. And I need to forecast sales for the next
two months. Also I was given the targeted amounts for the 2 months. I need to
fore cast sales by product to match the final target figure for the 2 months.
Is there a mathamatical way to do it using excel.

Help would be greatly appreciated.

THanks
--
kaushi

  #2   Report Post  
Old November 13th 08, 01:53 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2008
Posts: 83
Default How would I forecast something(sales) using excel

"Kaushi" wrote in message
...
Can someone kindly help how to forecast. For and example lets say I ve got
sales data for the past 10 months. And I need to forecast sales for the
next
two months. Also I was given the targeted amounts for the 2 months. I need
to
fore cast sales by product to match the final target figure for the 2
months.
Is there a mathamatical way to do it using excel.

Help would be greatly appreciated.


Sales forecasting is part mathematical and part intuition. Yes as you build
up data you can extrapolate, but 10 months only is not sufficient to do it
formulaically, especially if you have seasonal variations (like ice cream!)
in your products.
With just 10 months data the best I would suggest you can do (as a recently
retired Management Accountant) is a "best estimate".

  #3   Report Post  
Old November 13th 08, 02:13 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2008
Posts: 8
Default How would I forecast something(sales) using excel

THanks, I am new to the field, your advice is highly valuable to a beginner.
--
kaushi


"Kaushi" wrote:

Can someone kindly help how to forecast. For and example lets say I ve got
sales data for the past 10 months. And I need to forecast sales for the next
two months. Also I was given the targeted amounts for the 2 months. I need to
fore cast sales by product to match the final target figure for the 2 months.
Is there a mathamatical way to do it using excel.

Help would be greatly appreciated.

THanks
--
kaushi



Reply
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
I'm looking for a sales forecast template. EllenG New Users to Excel 1 January 7th 08 08:03 PM
Formula-Compound Sales Forecast GatorGirl Excel Discussion (Misc queries) 4 March 6th 07 06:04 PM
Sales Forecast marquin Excel Discussion (Misc queries) 2 October 22nd 06 07:57 AM
Sales Forecast Question - Need Help! cincode5 Excel Discussion (Misc queries) 2 March 14th 06 03:50 AM
How do I set up a sales forecast to predict sales per hour, when . Greg Excel Discussion (Misc queries) 4 April 17th 05 11:09 PM


All times are GMT +1. The time now is 12:31 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017