Re: [SL] Trend analysis

[C. D. H. <du...@du...>]

Sorry, I've been out of the loop for awhile.  Send me a message off list 
and I'll send you a copy of the script.

Dunc

Ed W wrote:
> 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
>
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://sourceforge.net/services/buy/index.php
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>