Date: Fri, 13 Jul 2007 17:26:01 +1000
Reply-To: David Birch <David.Birch@DISABILITY.QLD.GOV.AU>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: David Birch <David.Birch@DISABILITY.QLD.GOV.AU>
Subject: Re: Forecasting monthly sales by product
In-Reply-To: A<NIECJIJPHOLPKIFCPLHOEEPAJLAA.d@dkvj.biz>
Content-Type: text/plain; charset="us-ascii"
Fi,
Generally, you need to look at either the High-Performance Forecasting
solution or SAS/ETS (perhaps using Enterprise Guide as a front-end). Do
you have access to any of these? SAS/STAT is not sufficient for
forecasting.
What industry are you in? Retail or ?? What factors are currently
considered to influence demand? You mention 'monthly sales' and 'daily
budget' - what kind of seasonal/cyclic influences affect your products?
(Are daily, weekly or monthly fluctuations significant?).
A bit more information would help get better responses from the 'L.
HTH,
Dave.
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
David Johnson
Sent: Thursday, 12 July 2007 10:37 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: Forecasting monthly sales by product
I didn't see any replies here.
Can't you classify the products by the amount of data and use that in
your
model?
Intuitively I would expect new products may have some variation caused
by
leading edge and gadget buyers (surely the iPhone release is proof of
that
idea) so as the product matures we find it is less popular, or the
market
saturates and its sales fall.
Kind regards
David
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU]On Behalf Of
teddee
Sent: Wednesday, 11 July 2007 3:58 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Forecasting monthly sales by product
Hi
I need some help to forecast what the monthly sales will be, to use in
our daily budget update. We have several products that we would like
to track, however, some of these products have only been recently
introduced (ie there is less than a years worth of data). For older
products I have approximately 4 years of data by day.
Does anyone have advice about how to go about it?
Thanks
Fi
********************************* DISCLAIMER *********************************
The information contained in the above e-mail message or messages (which includes any attachments) is confidential and may be legally privileged. It is intended only for the use of the person or entity to which it is addressed. If you are not the addressee any form of disclosure, copying, modification, distribution or any action taken or omitted in reliance on the information is unauthorised. Opinions contained in the message(s) do not necessarily reflect the opinions of the Queensland Government and its authorities. If you received this communication in error, please notify the sender immediately and delete it from your computer system network.
