5 Replies Latest reply on May 10, 2010 5:54 PM by comment_1

    Efficiency Management

    dbinfo

      Title

      Efficiency Management

      Post

      Can someone please point me in the right direction?  I'm looking for a solution that will:

       

       

      1. track date and time for events (A, B, C ... Z) by customer 
      2. calculate elapsed time between events (A to B, A to C, B to Q, E to F, A to Z...) for each customer
      3. document output values for events (A = 200, B = 3,000, Z = 6,000,000...) for each customer
      4. generate reports that will aggregate and disaggregate data from all fields
      For example...
      If I were in the pizza delivery business, I would need a solution that could track:
      • what time a customer placed an order
      • how long did it take to place the order
      • how long did it take to prepare the pizza
      • how long did it take to bake it
      • how long did it take to deliver it
      • how much time elapsed between placing the order and delivery
      • what was the pizza's temperature when it left the oven
      • what was the pizza's temperature when it was delivered
      • how much did the pizza weigh at the time of delivery
      I need a solution that can show a relation between the delivery temperature and the elapsed time from oven to customer, and a relation between the rate of temperature change and it's mass/weight.
      FYI... we don't actually deliver pizzas.  We are an ancillary medical provider that processes biological specimens. I just thought more people could relate to pizza delivery.
      We're a small company, so we would like to be able to work with something off the shelf (meaning... inexpensive).  We need a solution that will work on a Mac.  Any ideas?
      I appreciate any help you can offer.

       

        • 1. Re: Efficiency Management
          philmodjunk

          Are you looking for a ready made solution or help in creating your own?

          • 2. Re: Efficiency Management
            dbinfo

            It would be more cost-efficient if we could find something that's ready-made.  Thanks!

            • 3. Re: Efficiency Management
              comment_1

              I doubt you will find an off-the-shelf solution for something so specialized. But it doesn't sound too complex to make from scratch - at least not the parts you have bulleted (I am not sure what exactly "aggregate and disaggregate data" means). I suppose you'd want to eventually export the results into a statistics application (Filemaker has only rudimentary statistical functions).

              Will you be entering the data from notes, or do you want to track the events "live" as they happen?

              • 4. Re: Efficiency Management
                dbinfo

                Thanks for the reply.  We want to be able to break down and analyze the data by hour, by a range of hours, by date or by a range of dates.  The info will be input from notes rather than real-time.  If this is something that has to be created from scratch, can anyone give me an idea of what something like this would cost?  Ballpark?

                • 5. Re: Efficiency Management
                  comment_1

                  Can you provide an example of input and the desired result/s?

                  It would also help to know how many events a sample has, and how many samples do you expect to have in total.