Document Sample
streamline Powered By Docstoc
					     Bridge to Success

Streamline ERP
         White Paper
       January 2006
Table of Contents

  1 Introduction……………………………………………………………………3

  2 User Interface & Access Controls………………………………………….4

  3 Benefits to Order Processing Dept…………………………………………7
    Style Management…………………………………………………………...7
    Order Management…………………………………………………………11
    Shipment Management…………………………………………………….11

  4 Benefits to Materials Management Dept. ………………………………15
    Automated Purchasing ………………………….…………………………16
    Demand Planning……………………………………………………………17
    Stock Level Optimization……………………………………………………19
    To Be Allocated Report……………………………………………………..20
    Receivable Materials Tracking…………………………………………….21
    Configurable Tax Profiles……………………………………………………22

  5 Benefits to Stores Management Dept. ……………………….………….23
    Visual Warehouse Management…………………………………………23
    Purchase linked GRN and Goods return………………………………..24
    Quarantine Area and Quality test Measurements……………………25
    Issues linked with Production Planning and Order Planning…………27

  6 Benefits to Production Planning Dept. …………………………………...28
    Graphical Production Planning with configurable workcenters……28
    Linkage to Order Planning and Materials Mgmt. and Stores………..30
    Semi Finished Material Transfers…………………………………………...32

  7 Task Manager…………………………………………………………………34

  8 Online Approvals…………………………………………………………….36

  9 Management Information Systems……………………………………….37

  10 Technology Benefits…………………………………………………………40

Chapter 1

Streamline ERP empowers the enterprise by serving as a digital nervous
system connecting all the parts of an organisation. This enables accurate
decision making based on live real time data.

Streamline is an affordable ERP solution that is also easy to implement and
helps mid-tier organisations compete with much larger companies by
improving speed of day to day business processes and making crisis
situations to become rare.

Streamline is built in a modular fashion where each part can be
configured to the requirement of the organisation. The flexibility of
Streamline ERP can be compared with that of SAP and Ramco. This helps
us to easily cater to growing organisations that serve diverse markets with
new product lines.

The following chapters describe how these benefits are achieved
department by department.

Chapter 2
User Interface and Access Controls

                   The applications and areas that are
                    accessible to a particular user can be
                    configured [refer to below screen shot]
                   Each application has specific areas that can
                    be assigned to each user. For example: Order
                    Planning application access is given Buyer
                    wise, Access to each store can be controlled
                    in Stores Management module.
                   The Screen layout always has a explorer like
                    tree structure from which the user can easily
                    go to any area that he has privilege to
                    access. For example he can access different
                    store’s information seamlessly by just
                    expanding the tree.
                   The user can also jump between applications
                    by clicking on the application button panel in
                    the bottom of the screen.
                   Therefore when the user logs in once he can
                    access all areas without logging in again.

                      Filtering and Sorting Tables

   All data tables in Streamline ERP have filtering and sorting
        o The user just has to type in the box above each column to
           filter the records according to their wish.
        o They can also sort the records in ascending or descending
           order by clicking on the heading button of the table.
        o This speeds up the day to day operations of the user by
           allowing them to conveniently get to the records that they
           are searching for.

   All data tables in Streamline ERP can be printed or saved in PDF
    format or even emailed as attachment [refer screen shot provided
        o For printing or saving the data the user just has to filter the
           data in the table to their needs and then press the print/save
           Table contents menu.
        o For emailing the user can provide the from: and to: email
           addresses and also give a subject line and the system will
           email the attachment as PDF file to the given email address.

Printing saving and emailing table data

Chapter 3
Benefits to Order Processing Dept. from
Streamline ERP

Style Management:

The style management module is built on a fully configurable system
where production processes are user defined, materials used are user
defined and formulas used to calculate the material requirement are also
user defined. The important features in style management are

      Style version numbers: Styles are maintained with version number for
       repeat orders for the same style where the buyer will ask for a slight
       alteration in the same style to be produced in a future shipment.

      Accessory colour and size can be matched with the garment
       colour and size to produce accurate material requirement

   Visual process sequence definition. [Refer screen images below].
   Streamline Style management can handle all types of styles with
    various production process sequences for example: T-Shirts, Woven
    Shirts, Printed, Yarn Dyed, Sweaters, Blankets, Gloves, Shoes,
    Jackets, Leather Garments, Jeans, Socks, Bed-Sheets, Towels,
    Curtains, Carpets etc.
   Can handle yarn->garment, fabric->garment, yarn-> fabric in single

   Production sequences for any material has to be entered only once
    and can be selected from a list in future style specifications.

   Style Costing can also be calculated once the processing and
    materials have been entered into the system
   The cost is estimated for each color and size of the garment.
   The cost is calculated using the purchasing cost of raw-materials
    added to production cost and other miscellaneous cost. The
    consumptions are obtained from the style information itself.

                         Purchased Materials Rates

                 Production Rates and Miscellaneous costs

                                  Product Cost

Order Management:

   Streamline allows for orders to have more than one style
   Styles that have been entered into the system for previous orders can
    be reused.
   All buyer contact information and shipping address information is
    called from masters.
   Export Documentation module uses the information entered in this
    module to generate the Packing list and Invoice.

Shipment Management:

   Shipments can be entered by choosing the required sizes and
    colors of particular style.
   Quantity can be entered as a ratio between the colors or the sizes
    or a total ratio.
   Quantity can be entered by first entering packs and then giving the
    number of packs in the shipment.
   If we choose to ship some percentage excess or shortage against
    the buyer order qty we can specify the percentage here.

   Process shedule for the shipment is automatically generated from a
    master list of the number of days from shipment by which each
    process should be completed. Once the shipment is entered the
    process information is taken from the style data and the shipment
    date is taken and using the master data the process start dates and
    finish dates are calculated. These dates can be manually altered
    by the user. These dates are used for making sure that raw-material
    arrives into the stores before the process is to be started and also
    used as a guide line by the production planners.

   Once the shipment data is entered and saved into the system the
    program report is generated. This report gives the following
        o Materials to be purchased with quantities.
        o Intermediate Materials to be produced after each process
           along with the quantites of the inputs to be used.
        o Allowances used in the calculation
        o Instructions for production department to follow.

                       Once we have generated the Bill of Materials we can follow the
                        status of the raw materials and accessories through the Material
                        Status Drill down report.
                           o We can select all the shipments of a buyer order and view
                               the total material status of that order.
Type     Desc      Size/Width       Colour   Buyer    Excess   Total      Total       NR          Stock       Receivable   Issued   Returned   Balance
                                             Order    Qty      Required   Allocated   Allocated   Allocated   Qty          Qty      Qty        to issue
                                             A        B        (A+B)      C+D+E       C           D           A-(D+E)      E        F          A-E
Carton   5 Ply     L 47.5XW         -        219.14   2.2      221.94     222         100         122         97.74        10       0          209.14
         Printed   29.5X H29

                                o       Buyer Order Qty: Exact Required Qty
                                o       Excess Qty: Allowance Qty
                                o       Total Required: Total to be purchased / Allocated
                                o       Total Allocated: Material already purchased / allocated from
                                        stock available in the stores
                                o       NR Allocated: Material allocated but not yet received from
                                        the supplier into the stores
                                o       Stock Allocated: Material allocated and already received
                                        into the stores
                                o       Receivable: Total material still required to arrive into the stores
                                o       Issued: Total issued for production
                                o       Returned: Total defective returned from production
                                o       Balance to be issue: Balance to be issued to production.
                                o       The user can drill down through the material number and
                                        view the shipment-wise allocation details for a material.

                       If the user has to add a new material or process he can make the
                        change to the style data and this change will be automatically be
                        made to those shipments that are attached to that style version.
                        Here the user can choose which are the shipments to be modified.

                       When the user modifies the style specification after allocation of
                        material or production has started for some shipments that are using
                        that style, the system will check if any material requirement has
                        been reduced or removed by the user in the style specification and
                        this material will be de-allocated from the shipment and released to
                        available stocks so that it can be used for other shipments requiring
                        the material.

Chapter 4
Benefits to Materials Management Dept.
Streamline ERP tightly controls the material purchasing. Excess
purchases against any shipment is not allowed and system also makes
sure available free stock is utilized before new material is purchased.

      Purchase orders are prepared from the bill of material
       requirement. This information is provided automatically from
       order processing module. The system will restrict excess

Automated Purchasing:

   Once the Bill of material is generated by the Order Processing
    department the materials required to be purchased are listed in the
    purchase workbench
   From here the user can choose the materials to be purchased and
    click Make PO to generate the purchase order.
   The purchase order is generated according the master data that
    defines the default supplier and the default rate already specified
    by the purchasing department.
   In order to use the purchase automation functionality the user has
    to feed in the relevant supplier information as shown in the below
    screen shot.

 When the user clicks Make PO. The system will first check if there is
    already material available in stock or in other bulk purchase orders
    placed earlier. If available material is there then system will allocate
    from that and then only the remaining qty is purchased.

   If the material purchased for a particular shipment is diverted to
    another shipment then the system will display the first shipment

    material requirement again in the purchase workbench. So the
    only thing the purchasing department has to do is to make sure that
    entries in the purchasing workbench are cleared before the
    deadline. [Refer Make PO Screen shot above]

Demand Planning:

   The demand planning work bench allows the user maximum flexibility
    in planning the allocation of materials from purchase orders or stocks.
   It displays all the relevant purchase orders and shows the qty available
    for allocation against these purchase orders.
   It shows all the quantities available in all the stores for a particular
   It also shows the different shipments that already have the same
    material allocated to them from either the purchase orders or the
   From here the user easily view if there is material available or he has to
    de-allocate from another shipment that is not urgent and allocate to
    an urgent shipment.
   This module allows the materials management team to quickly resolve
    any crisis arising from a supplier not supplying the material on time for a
    particular shipment.
   This module allows the materials management department to
    purchase materials in bulk in advance based on a buyer forecast.
   Once the actual order is confirmed and the bill of materials has been
    generated then using this module the user can allocate the materials
    from the bulk purchase orders that have been placed in advance.
   It also allows for prioritization of which order will receive the material
    first and which one will get it second from the same bulk purchase
    order. The user can adjust the priority by using the up and down arrow
    buttons near the “De-allocate Not Received” table.

Stock Optimizer:

   The main aim of the stock optimizer is to reduce the inventory level of
    materials in the company. Thereby saving waste of working capital.
   The user has to make sure that the balance column in the first table
    should always be zero.
   If the balance column is a high positive qty that means we have much
    more material available than the actual total demand for the
    shipments. This means we need to cancel some purchase orders.
   If the balance column is a high negative qty that means we have
    much less material available than the total demand for delivering the
    shipments. This means we need to purchase more material.
   This screen also shows the details of how much material is needed for
    each shipment and how much is already allocated.

   It also shows all the purchase orders and stores which have
    unallocated material.
   Using this module the material management can easily control the
    inventory level in the company and reduce the investment of working

Pending Allocation Report:

   Pending allocation report shows the user which are the shipments
    which still need material to be allocated.
   Using this report the materials management team can ensure that no
    shipment is delayed because of want of raw material.
   This report can be viewed style wise and buyer order wise.

Receivable Materials Tracking:

     The receivables report is there to facilitate the tracking of material
      deliveries from the supplier.
     Using this report the materials management team can see which
      are the deliveries that are delayed beyond the due date and follow
      up with the supplier or arrange alternate solutions.
     This report is viewable Order wise and Style wise.

Configurable Tax Profiles:

   Multiple tax profiles can be associated with a supplier
   Tax based on final amount.
   Tax based on another tax amount.
   Tax based on final amount plus another tax.

Chapter 5
Benefits to Stores Management
Visual Warehouse Management:

   3D visual model of warehouse enables the user to view the exact
    picture of the warehouse stocks through the software.
   Stores people can easily locate materials that they need to issue.
    There will be no time wasted in searching for the material thorough
    the stores.
   Stock verification can be done shelf by shelf. This will make it
    impossible to lose any materials in the stores.

   Each Package or roll is tracked through the system from receipt to
    stock to issues. Therefore there is a physical link between what is
    presented in the software and what is in the store.

Purchase Linked GRN and Goods Return:

       GRN is entered against the purchase order to a supplier. All the
        material information is fetched from purchase module.
       The stock value of the goods is calculated using the rate
        specified in the purchase order.
       The tax amount specified in the purchase order is also included
        into the stock value
       The GRN is designed to be entered quickly by the user so as to
        reduce delay in printing out a receipt and giving to the supplier.

       The GRN can be corrected for any mistakes in roll numbers or
        package details and quantities.
       Against the GRN the QC measurements and tests are done.

Quarantine Area and Quality Test Measurements:

   After the GRN is entered into the system. The material qty is not
    directly added to the stock. There is a stage in the middle for
    quality measurement tests and defects entry.
   Only after these tests are done and quality is passed can the
    user add the packages into the stock.
   The quality measurements and tests are fully configurable.

   The system allows for custom tests and measurements to be
    configured through masters
   After the GRN is entered. For those packages measurements should
    be taken for all the packages and quality tests can be taken for
    any sample size chosen by the user.
   These measurements and tests can be done any number of times
    for the same GRN
   Comprehensive Report of the quality tests will be available for every
    package belonging to the particular GRN.
   From here the user can choose to return some packages or all
    packages back to the supplier.
   Once the packages have passed the quality tests then only they
    can be stocked into the store in the system.

Issues linked to Production Planning and Order Planning:

     Issues in stores are controlled by the jobs added in the
      production planning module.
     Every issue to production is made against a job planned by the
      planning department
     The deadline by which the stores department has to issue the
      materials in order for a production job to complete is provided
     The raw materials and their quantities required are automatically
      obtained from order planning module
     The stores department cannot issue more than the required
      material to the particular job unless defective raw materials are
      returned into the stores.

Chapter 6
Benefits to Production Planning Department
Graphical Production Planning & configurable work centers:

 Production planning is fully graphical. This helps the planner quickly
  understand the schedule rather than reading excel file numbers
  which require more mathematical thinking to process.
 The system provides three types of information about the
  production work center schedules.
 The planned schedule of jobs as it was originally set by the planner
  during initial scheduling
 The actual time taken by the jobs to complete based on live
  production monitoring data entered in separate screen.
 The system also takes into consideration the qty received into the
  stores after the production. This is given more importance than the
  qty entered via the production monitoring screens. For job work the
  qty received into the stores after production will be more accurate
  than the estimate that is entered into production monitoring

 The progress bar or the predicted time for the completion of the job is
  based on the previous jobs completion speed rather than the
  theoretical speed of the work center.
 The capacity of the work center is fully configurable.
 In the configuration stage of the ERP we can setup custom formulas
  with variables for calculation of the capacity of the work center.
 When the work center is created [refer screen shot above] we can
  specify the value for the formula variables and this is used in the
  calculation of the capacity.

 In cases where the speed also depends on the specification of the
    material that we are producing we can specify the value of any speed
    factors Example: SMV of a style for sewing process. This is to be
    entered in the Capacity Factor 1 and Capacity Factor 2 columns in
    the last table in the above screen.
   These values will be automatically called into the formula calculation
    when calculating the time taken for a particular job to be completed.
   We can also specify the shift timings and the break timings. These will
    also be taken into consideration when calculating the time taken for a
    job to be completed. The user can also specify any holidays,
    machine breakdown times or other irregular down times.
   When the user moves a job from a higher speed work center to a
    slower work center the job length will become longer.
   The length of the job on the screen is proportional to the time it takes
    indicated by the date bar on the top of the screen.
   We can zoom in to see a particular week or day schedule using the
    expand button and we can zoom out to see a whole months schedule
    using the shrink button.

    Linkage to Order Planning and Materials Management and

 The planning application is fully integrated with the Order Planning and
  Materials Management module and the stores module [Refer screen
  shot below]
 The requirement for production is pulled from the Order Planning
  module. The user can club the same material requirement of more
  than one shipment into a single job provided the recipe (process
  name, input materials and consumption) specified for them in the
  Order Planning module are the same.
 This means the requirement of more than one shipment can be
  produced in one work center there by improving efficiency of the
  production plants.
 This system also validates that excess qty not authorized by order
  processing department cannot be scheduled to be produced against
  any shipment.

 Only when the job is scheduled here can the stores issue materials into
  production. The system also calculates the raw material quantities
  required to produce a particular job qty. The stores is only allowed to
  issue this qty against the job.
 The planning application also checks if the raw materials have arrived
  into the store for a particular job before it begins. If the material has
  not arrived on time then it is indicated to the planner that the schedule
  cannot be executed and the planner has to allocate the raw material
  from other shipments or he has to re-schedule the job for a later date.
 The system will also highlight when a particular job is going to cross the
  shipment date there by the planner can schedule part of the quantity
  into additional work centers in order to complete the production on
  time and send the goods to the buyer.

Semi Finished Material Transfers:

 Through the planning application the user is also allowed to transfer
    intermediate materials from one shipment to another for the purpose
    of meeting a shipment date
   The system validates throughout the chain that the user is not
    allocated more material than necessary to meet the order
   The user can also swap the full chain of production quantities for the
    same materials of two shipments. For example if two shipments are
    using the same fabric and one of them is ahead in the production
    process and has a later shipment date than the other. Then the user
    can swap the quantities so that the shipment with earlier date goes
    through on time. During the swap only the required material is
    transferred, remaining stays with the original shipment.
   On the whole the planning application helps the planner to optimize
    the use of the production capacity in a plant.
   It helps to predict any shipment delays in advance and take corrective
    action immediately.
   Any changes in production schedules are communicated to the stores
    department so that they can make the necessary material available
    for issue to production.
   Production schedules can be printed out and provided to the
    respective departments to follow.
   Work center efficiency analysis reports can be produced since we
    know the theoretical capacity of the machine and the actual
    productions speeds.
   Using this information the production department can find out what
    are the bottlenecks that are slowing down the production and
    improve running efficiency.

Chapter 7
Task Manager

     The Task Manager is used to remind the merchandisers about the
        follow up activities that they have to perform for each shipment.
       The system can be configured to trigger default tasks according
        to the Buyer of the shipment.
       The system can also be configured to trigger default tasks based
        on particular material types contained in the bill of material of
        the shipment
       The number of days prior to the shipment date that the task has
        to be completed is given into the master
       From this data the system automatically computes the deadline
        for the particular task

 The merchandiser can also specify his own tasks for each
    shipment along with a deadline date.
   The system will show a reminder popup at the time of log in to
    remind the user of the tasks that are nearing the deadline.
   The user needs to select the completed tasks and save to stop
    them from reappearing again.
   The system also produces a Gantt chart of the planned deadline
    and the actual completion of the tasks
   This chart can be used by management to track the follow up
    activities of the merchandisers.

Chapter 8
Online Approvals

   Streamline ERP allows any transaction to be integrated with an
    online approval.
   The transaction will save only after the approval is obtained
   This is already integrated with Style approval and PO approval
   Multiple levels of approval can be setup
   The levels of approval and the users who are to approve can be
    altered as the organization structure is changing
   The approver can also modify the transaction and then approve
    to save time.
   Reminders will be sent to the approver once a transaction is
    waiting for approval
   A transaction can be rejected and the modified and re-
    submitted for approval

Chapter 9
Management Information Systems
Streamline ERP is equipped with a state of the art reporting system.
Custom Drill down reports can be generated within hours of getting
the user requirement. The drill down structure can be easily viewed
by the user in order to find information.

More than 100 drill down reports have been developed in order for
the user to be able to get any information that he chooses within 3
clicks of the mouse.

   Every page of the streamline drill down report begins with a sort
    select table that allows the user to filter the data that they want.
    Each stage of the drill down can be saved or printed.

   While view each report the user can choose which columns to print
    page total and grand total

   The user can choose to group by any particular column in the data
    and also give sub total columns.

   Every page of the drill down report can also be used in different
    charts for analysis. Refer examples given below.

     Chapter 10
     Technology Benefits
     Streamline ERP is built on Java Technology. Java brings the following
     advantages to the table
          Robust and Reliable no random run-time errors
          Runs on most operating systems – Windows, Linux, Solaris, Aix etc.
          RMI technology in Java connects application client to the
           application server over the internet using IP
          All Visual Basic applications cannot be run across the internet
           except for Reports
          Streamline is full accessible to the user over the internet – Both
           application as well as reports.

                                                           Client-4             Client-5


         Streamline uses a 3 tier architechture. 1-Client, 2-Server, 3-
          Database. This has higher performance as the client is only sending
          requests and taking care of displaying data to the user
         All the processing is done on the server side. The communication
          between the server layer and the database layer is done on the
          same computer so it is very fast. The company only needs to invest
          in a high end server and can make do with lower end client
         In Visual Basic applications there are only two layers the Client and
          the database. Therefore there will be perfomance problems as the
          data queries are running over the network and there will be high
          network traffic and delays in response.