Re: [SL] Trend analysis

[Ed W <li...@wi...>]

C. Duncan Hudson wrote:
> What kind of trends are you looking for?  For sales analysis I wrote a 
> little Perl script that is cron'd to run on the 5th day of each month 
> (gives me a couple of days to fix any month end issues).  The script 
> summarizes each sales person's sales and receivables for the month.  It 
> also provides a delta of the month over the previous month and the month 
> over the same month one year ago.  Finally, it builds a nice little 
> (electric company bill style) 13 month bar graph.  The script then 
> emails the personalized report to the salesperson and their manager.
>
> For inventory analysis I have a Perl script that  is cron'd hourly.  My 
> reorder points (minimum), and EOQ are recalculated each time the script 
> runs.  When ever any of the stocked items falls below their minimum an 
> email is fired off to the person who does the parts ordering.  The 
> script also does Pareto Analysis (ABC) and labels each item as such 
> along with its percentage of both sales and revenue.
>   

Can we see the scripts?

Ed W