Apex Footwear Limited PDF

Preview

Summary

assignment on ERP Apex Footwear Limited...

Description

APEX FOOTWEAR LIMITED Assignment on EMIS-546, ERP; Section-B

Submitted to Dr. Md. Rakibul Hoque Submitted by Nusrat Yasmin Date: 28, July 2018 ID-6173629016

Co Cont nt nte ent ntss Organizational overview: ................................................................................................................. 1 ERP description overview: ............................................................................................................... 1 History .............................................................................................................................................. 2 Sales and Marketing module: .......................................................................................................... 3 Different steps for this module:................................................................................................... 3 1.

Order multiplication process ........................................................................................... 3

2.

Accessories work order file .............................................................................................. 3

3.

Order detailed form ......................................................................................................... 4

4.

Testing bill submit to the audit ........................................................................................ 4

5.

PI order............................................................................................................................. 5

6.

MO sheet.......................................................................................................................... 5

The Problem before ERP in Apex: .................................................................................................... 6 Benefit after ERP in Apex: ................................................................................................................ 6 Position of Apex before ERP: ........................................................................................................... 6 Process flow after the implementation of ORACLE ERP: ................................................................. 7

Organizational overview: Apex Footwear Ltd. (AFL) commenced its business on January 04, 1990. The Company is an export-oriented leather shoe and components manufacturer, producing and selling leather shoes, other leather products and accessories (socks to bags to shoe care products) in the international market, mainly in the European market. It also sells its products in the local market through its own outlets in the name and style of “Apex”. It has nine in-house brands, namely Venturini, Apex Men’s, Sprint, Maverick, Moochie, Nino Rossi, Sandra Rosa, Twinkler and School Smart and one famous German therapeutic footwear brand Dr. Mauch as well as different accessories. The Company’s factory situated at Chandra, Kaliakoir in Gazipur with total 1,49,000 sft. of factory area complied with Global Standards of Footwear Production. The Company imports machinery from Germany, Italy, and Taiwan. The Company uses leather from its own tannery (leased from Apex Tannery) and other materials like Shoe Lace and Welt are imported. On an average, 70% of its total revenue generated from export sales mainly from Germany, Italy, France, Switzerland, Austria/Slovenia, Czech Republic, Spain, Sweden, Netherlands, UK, Japan, USA etc. “APEX” means the peak or the zenith. Since 1975 we have strived to live up to our name.

ERP description overview: Vendor

Oracle EBusiness Suite

Module

1. Oracle CRM 2. Oracle Financial 3. Oracle Human Resource Management System (HRMS) 4. Oracle Logistics 5. Oracle Supply Chain Applications 6. Sales and Marketing module 7. Oracle Transportation Management 8. Oracle Warehouse Management System

Open source/ commercial Cloud/ on premises Open source: ApplTop Solutions’ software Cloud: ORACLE cloud

Price

12K-350K

software

ORACLE

1

History                                         

Oracle E-Business Suite started life as Oracle Financials in 1987. August 1987: Oracle founds its Applications division, building business-management software closely integrated with its database software. Oracle Corporation acquires TCI for its project management software. October 1987: Oracle Applications Release 1 Sometime in August 1988, they released their first ERP application called accounting system that has only general Ledger functionality enabled. This is one of the reasons of having General ledger application_id is 101. November 1988: Release 3 January 1989: Release 4 May 1989: Release 5 October 1989: Release 6 May 1990: Release 7 November 1990: Release 8 June 1992: Release 9 1995: Release 10 Release 10 Subversions are 10.7NCA, 10.7.16.1, 10.7 April 1998: Release 11 Release 11 subversions are 11.0, 11.0.1, 11.0.2, 11.0.3, 11.0.28 July 16, 1998: First combined production installation of Oracle Applications Release 10.7 NCA at Leeson Electric Corporation. May 1999: Release 11.0.3 11i Sub Versions are 11.5, 11.5.1, 11.5.2, 11.5.3, 11.5.4, 11.5.5, 11.5.6, 11.5.7, 11.5.8, 11.5.9, 11.5.10.0, 11.5.10.1, 11.5.10.2. May 2000: Release 11.5.1 Oct 2000: Release 11.5.2 Jan 2001: Release 11.5.3 Jun 2001: Release 11.5.4 Sep 2001: Release 11.5.5 Jan 2002: Release 11.5.6 May 2002: Release 11.5.7 Nov 2002: Release 11.5.8 Jun 2003: Release 11.5.9 Nov 2004: Release 11.5.10 Feb 2006: Release 11.5.10.2 R12 Sub Versions are 12.0.0, 12.0.1, 12.0.2, 12.0.3, 12.0.4, 12.0.5, 12.0.6, 12.0.7, 12.1, 12.1.1, 12.1.2, 12.1.3 and latest version is R12.2.4 31 Jan 2007: Release R12.0.0 26th Apr 2007: R12.0.1 Released 18th Jul 2007: R12.0.2 Released 16th Oct 2007: R12.0.3 Released 15th Jan 2008: R12.0.4 Released 7th Nov 2008: R12.0.6 Released 4th May 2009: R12.1.1 Released 17th Dec 2009: R12.1.2 Released 20th Aug 2010: R12.1.3 Released 19th Sep 2013: R12.2 (R12.2.1) Released 20th Sep 2013: R12.2.2 Released

2

    

16th Dec 2013: R12.2.3 Released 08th Aug 2014: R12.2.4 Released 16th Oct 2015: R12.2.5 Released 15th Sep 2016: R12.2.6 Released 15th Sep 2016: R12.2.6 Released

Sales and Marketing module: Different steps for this module: 1. Order multiplication process In this step, order no. and quantity of the product is inserted.

2. Accessories work order file Here garment accessories are ordered and PDF of this form is sent to the suppliers.

3

3. Order detailed form In this form, the garments order which is received from the buyer is placed. Thus, different departments of the factory like production, inventory control, Finishing and Packaging, audit Process etc. can check the order any time by entering the system.

4. Testing bill submit to the audit Here the garments testing bill is inserted to submit to the audit. Besides, the accounts can also check the bill from here.

4

5. PI order This is the Proforma Invoice. This is for the payment to the supplier. Here PI no. is inserted which is obtained from different suppliers. Then, its hard copy is submitted to process for the payment.

6. MO sheet MO form is the move order. Production team uses this MO sheet and after the approval, the material is issued to the requester.

5

The Problem before ERP in Apex: Before the ERP system, there was a flow of information in different departments but the integration was missing. There was no connection between the different operational areas of the organization. The sales and marketing department didn’t have proper information about the product or manufacturing department. Again, the manufacturing department didn’t know which raw material is supplied by which supplier and if any defect is found out, they didn’t know who to blame. Thus, instead of the streaming of information, there was a huge gap between the different functional areas.

Benefit after ERP in Apex:    

All the information available is accurate and obtained in real time Productivity increased, labor cost and overtime work is reduced Transparency in the flow of information among the functional areas ORACLE focuses more on quality, new design and comfort of the footwear

Position of Apex before ERP: Before ERP, the organization was in Q1 position. That means, it had a small gap, ‘small r’ in the gap analysis process. Hence, it needed a small change in the software as well as in the business process. Thus, it was a good fit for the ERP implementation.

6

Process flow after the implementation of ORACLE ERP: 





 

 

Effective project planning and forecasting: ORACLE helps managers to count what amount of shoes to be manufactured and the date to stock out. Thus, it helps in the effective planning of the manufacturing process. Document of indent: Indent is a request document to procure material for manufacturing. The team goes to purchase the material when it is approved by the store manager. Quotation request: ORACLE sends a request for quotations to various approved supplier and finally the best supplier is selected considering cost, time, shipment, quality etc. Making PO: The purchasing department makes purchase order (PO) while the quotation is finalized. This PO is then forwarded to the finance department. Receive and delivery of the material: The ordered material is received, examined and delivered to the store. The receipt is generated in ORACLE to ensure the successful delivery. MO request: the material is issued by the move order (MO) request. After the approval of the MO request, the materials are finally issued. Invoice: invoice is created by ORACLE and sent to the finance department for the entries in the general ledger (GL).

7...