Enhancing and Automating Bill of Material

In most automotive companies they maintain the stock details in Excel sheet, that’s not secure for all transactions. Here the E-excel bills of materials are computerized and an easy viewing and tracking of all bill details are done. The bills here contain both the material needed and the primary design of BIW (Body in white) for reference, if any material is to be added or removed from bill or in case of any change in design the bill is updated (i.e) revised. Since bill contain the primary design and the material used which might be needed by other company to produce a better product or to attract customer to produce the same product with some change in design for low cost. This leads to concern in security so a new technique for securing bill of material is introduced in proposed system to provide higher security from hacker like third party hacker, employee leak data to another company. This primarily concerns when unauthorized remote computer break-ins through communication networks such as the Internet, but also includes those who debug or fix security problems, and the morally ambiguous. A secured environment for billing of material is provided using data leakage detection, IDS, IP synchronization. The system is tested for its effectives, flexibility, accuracy and user friendly. The proposed system is found to be delightfully running under the web application system.