Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I'm looking for a sales forecast template. | New Users to Excel | |||
Formula-Compound Sales Forecast | Excel Discussion (Misc queries) | |||
Sales Forecast | Excel Discussion (Misc queries) | |||
Sales Forecast Question - Need Help! | Excel Discussion (Misc queries) | |||
How do I set up a sales forecast to predict sales per hour, when . | Excel Discussion (Misc queries) |