Re: [SL] Trend analysis

[Dieter S. <dsi...@sq...>]

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