Re: [SL] Trend analysis

[Dr E. W L. <el...@li...>]

Oinking from the boinking :-)-O

el


On Jun 6, 2008, at 16:13, Dieter Simader wrote:

> On Fri, 6 Jun 2008, 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
>
> You are still here, why?
>
> http://sourceforge.net/mailarchive/forum.php?thread_name=484435EA.7000309%40wildgooses.com&forum_name=ledger-smb-devel
>
>
> -------------------------------------------------------------------------
> 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
>