Questionnaire

COMPANY NAME-.

Brief description of the targetted company.(Bharat seats ltd. is a joint venture of Maruti Suzuki
India Ltd. for manufacture of complete seating system and interior components for automotive.
Their major products are seats for cars and two wheelers, molded carpets and frames.)

Below questioners are based on the production process flow of Bharat seats Ltd.

1.1. INFORMATION GATHERING

Please select your management and operational requirements from the following list of
enterprise functionality (select "not applicable" if none apply).

Financial Accounting Cost Accounting

Benefits Budgeting

Cash Management Project Systems

Enterprise Asset Management Plant Maintenance

Fixed Assets Quality Management

Health and Safety Human Resources

Payroll Personal Management

Product Costing Service Management

Materials Management Production Planning

Sales and Distribution Time and Expense

Management

Transportation Workflow

Document Management System Plant Maintenance

Reports Others (Please Specify)

Please select your customer relationship, business analytics, and marketing
system requirements from the following list of functionality (select "not applicable" if
none apply).

Analytics Business Intelligence

Scorecards, Portals & Dashboards Extracts, transfer and Load

Others (Specify) Not Applicable

Please select your product lifecycle, manufacturing, and supply chain requirements from
the following list of functionality (select "not applicable" if none apply).

ATP – Available to Promise Barcode, RFID and Tracking

Demand Management Design Collaboration

ETO - Engineer to Order CRM

International trade logistics Inventory forecasting

Inventory management Procure To Pay

Order Management Price Management

Process batch control & reporting Product costing

PLM - Product Lifecycle Management Production and Supply

planning

Purchase Management Quality Management

Regulatory & Compliance Returned Goods handling

Risk Management Service Data Management

Service Parts planning Shop-floor Control

SRM – Supplier Relationship Management SCM - Supply Chain

Management

Technology transfer Transaction Management

Transportation Management Warehouse Management

Work order Management Order To Cash

Hire To Retire Not applicable

Please indicate the vertical segment or industry that most applies to your business
(select all that apply).

Aerospace & Defense Automotive

Banking Chemicals

Consumer Packaged Goods Electronics / High-Tech

Energy Engineering & Construction

Fabricated Metals Financial Institutions

Food and Beverage Furniture & Fixture

Hospitality Health Care

Higher Education IM&C (Manufacturing)

Insurance Medical devices and lab

equip.

Mining Oil and Gas

Paper Products Pharmaceuticals / Life

Science

Public Sector / Government Publishing / Media

Real Estate Retail

Rubber / Plastic Service Provider

Steel / Mill Products Telecommunication

Transportation Textiles, Apparel and

Footwear

Utilities Warehousing / Distribution

Others (Specify) Others (Specify)

Please indicate which of the following manufacturing environments most apply to your business
(select all that apply).

Assemble to Order Batch process

Configure to order Continuous Process

Engineer to order Flow / Lean Manufacturing

Make-to-order (MTO) Make-To-Stock

Mixed / Hybrid Manufacturing Non Manufacturing

Repetitive Other
Please indicate which one of the following enterprise size and organizational structures
most accurately represents your organization

Regional National

Multinational

 Organization Structure

 Number of Legal entity …………………1……………… (Companies having their

own books of accounts, preparing P & Loss, Balance Sheet. Statements)
 Number of Company codes………………………..
 Number of Operating concern……………………
 Number of Controlling area………………
 Number of Segments/Number of Business Areas……………..
 Number of Profit Centers………………..
 Number of Cost centers…………………..
 Number of Plants………………1………………………. (whether manufacturing)
 Number of Purchasing Organisations…………………….
 Number of Purchasing Groups………………………
 Number of Sales Organisations…………………………..
 Number of Distribution Channels………………….
 Number of Divisions……………………………….
 Number of Sales Offices………………………………………
 Number of Depots / Warehouses……………………..
 Number of shipping points………………………….
 Number of Storage Locations…………………………..
 Please list down your current major pain areas

 Home Grown Application

 Dual Data Entry
 Data Ambiguity
 Disconnected Systems (No Integrations)
 Customization
 Manual Product Costing
 Too much reliance on MS Office
 None of these
 Any other issues (Please Specify)

01.
02.

03.

 Please select the range that most closely represents your organization's total
annual revenue.

< Rs. 10 Crore Rs. 10 to 20 Crore

Rs. 21 to 40 Crore Rs. 41 to 100 Crore

Rs. 100 to 200 Crore Rs. 201 to 400 Crore

> Rs. 401 Crore

 Which budget range would you like to apply as an estimate for implementing
the solution you seek?

< 20 Users 20 to 50 Users

51 to 100 Users > 100 Users

 Based on your budget requirements, which services do you require?

Based on actual business process Based on Business Best

Practice

Template Based Implementation

 Please select the range that represents the total number of people employed by
your company.

1 to 50 employees 51 to 200 employees

201 to 500 employees > 500 employees

 Please indicate your requirements for the vendor's level of presence and
localization capabilities (e.g., tax & regulatory compliance) within the following
regions (select all that apply).

Asia America

Australia Europe

Africa

 How soon do you need to start implementing your project?

1 Month 2 to 3 Months
4 to 6 Months > 6 Months

1.2. CUSTOMER SERVICE MANAGEMENT

1. How do you manage data with respect to your existing customers?

(manufacturer's serial number, replacement serial number, and all
service call history)
2. How do you track customer interaction data?
3. Do you have any service level agreements with your customers? How
do you manage data with respect to that?
4. Do you provide after sales support? If yes, how do you manage your
service contract data?
5. Do you have knowledge base system which can helps service reps
resolve problems and optimizes their performance?
6. How do you view and analyze data related to service contracts,
customer equipment, and service calls?

1.3. CUSTOMER RELATIONSHIP MANAGEMENT

1. How do you do customer list management? How you manage

marketing plans, initiatives, campaigns, and promotions?
2. Is there a system where you manage your leads? What kind of
systems are in place to gain quick visibility into lead and order status?
3. Is there a system in place to track, analyze, and optimize your sales
opportunities from start to finish?
4. Is there any system where you track customer engagement history to
handle inbound and outbound calls, create sales orders and up-sell and
cross-sell.?

1.4. TECHNICAL

Please indicate existing (present solution) Legacy business solution

TALLY MS Office

Customized s/w Others

Please indicate the server platforms you plan on using (select all that apply).

IBM iSeries (AS/400) IBM Mainframe

Linux Novell Netware

Unix Windows Server

Other

Please indicate the DBMS platforms you plan on using (select all that apply).

IBM DB2 Informix

Microsoft SQL Server Ingres

Oracle Sybase

Others

Please indicate which one of the following site / plant structures most accurately
represents your organization.

Single Site enterprises 2 to 10 Sites

11 to 20 Sites 21 to 40 Sites

> 40 Sites

Please indicate the vertical segment or industry that most applies to your business (select
all that apply).

Aerospace & Defense Automotive

Banking Chemicals

Consumer Packaged Goods Electronics / High-Tech

Energy Engineering & Construction

Fabricated Metals Warehousing / Distribution

IM&C (Manufacturing) Others (Specify)

Please indicate which of the following manufacturing environments most apply to your business
(select all that apply).

Assemble to Order Batch process

Configure to order Continuous Process

Engineer to order Flow / Lean Manufacturing

Make-to-order (MTO) Make-To-Stock (M.T.S)

Mixed / Hybrid Manufacturing Non Manufacturing

Repetitive Manufacturing Other

1.5. BUSINESS PROCESS RELATED

1. Transactions statistics

1. Average Purchase orders per day……………………………….

2. Average Goods Receipts per day………………………………..
3. Average Goods Issues per day…………………………………..
4. Average FI Vouchers per day…………………………………….
5. Average Sales Contracts per day………………………………..
6. Average Sales documents per day……………………………….
7. Average Production Orders ………………….
8. Average number of system users in following sections
i. Purchase department…………………………..
ii. Store department……………………………………..
iii. Planning department……………………………………
iv. Production / Shop-floor department……………………
v. Maintenance department……………………………………
vi. Marketing department……………………………………….
vii. Sales department…………………………………………….
viii. Accounts department……………………………………..
ix. Finance department ………………………………………
x. Sectional heads……………………………………………….
Top Management……………………………………………..

2. Master data

1. Total number of GL Master Data……………………………….

2. Total number of Asset Items / Material Master Data ……………………………….
3. Total number of employees ………………………………………
4. Total number of equipment …………………………………….
5. Total number of Items / Material Master Data (FG)……………………………….
6. Total number of Items / Material Master Data (SFG)……………………………….
7. Total number of Items / Material Master Data (RM)……………………………….
8. Total number of BOMs ……………more than 60……………………..
9. No of Operations involved in Manufacturing Finished Products 4-5 operations
10. Total number of Customer Master Data ……………………………….
11. Total number of Vendor Master Data ……………………………….

3. Type of valuation

1. Raw Materials and consumables……………………………..

2. Semi Finished and Finished Goods …………………………..
3. Other (specify) ………………………………………………………..

4. Business Transaction

1. What are the name(s) of the person or group of people responsible for maintaining
the data in your work center(s)? (e.g. Shop in-charge) Mr. Mukesh and Mr. V.K.Jain
2. What capacity categories are maintained at your work center(s)? (e.g., machine,
labor, setup) Machine / Labour
3. If you are using Work Centers, select what business function(s) apply at your
organization.

Costing

Scheduling

Capacity Planning

Printing Shop Floor Paper

Shop Floor Control

Confirmations

4. Select what default value(s) you plan to maintain for your work center(s). (Default
values help to simplify the maintenance of work centers.)

Basic Data (General data)

Default operation

Scheduling

Capacity data
5. What application areas are your BOMs linked to (for example, materials
management, MRP, costing, etc.)? MRP
6. List the name(s) of people or groups of people responsible for planning capacity at
your company.
7. Select the BOM types you maintain in your organization with associated units of
measure. (i.e., pieces, each, die, etc.)

Material BOM

Equipment BOM

Functional location BOM

Document structure

Sales Order BOM

8. Do you maintain your BOMs using a CAD system? (If yes, explain) NO
9. Please select in what area(s) your BOMs will be maintained. (BOM usage)

Production

Engineering

Universal

Plant maintenance

Sales and Distribution

Costing
10. How is Planned Independent Requirements (PIRs) generated by you?

11. How many production order types are used on shop-floor, e.g production order,
repair/rework order, etc.?
12. Whether using any Forecasting models for generation of PIRs?
13. Is there approval procedure before releasing your production orders?
14. Are you monitoring Production order costing in your system?
15. How you are generating Raw materials and Consumables demand? Projection is
received from Maruti company and based on that they generate requirement.
16. How is forecast/demand management handled?
17. Is there any external procurement of the semi-finished or finished products during the
production process?
18. What type of planning strategies are used for e.g Make to Order, Make to Stock,
repetitive manufacturing, MRP?
19. Are you using Material Requirement Planning and Forecasting in your system?
20. Are you maintaining safety stocks in your system?
21. Are you carrying out quality inspection in your shop floor?
22. Are you carrying out quality inspection before goods issues to customers?
23. Are you taking Quality Certificate from your existing system?
24. If material rejected in your inspection, what you will do?
25. Are you preparing and using engineering / specification drawings for your semi-
finished and finished goods?
26. How is the costing done (methodology)?
27. What are the various reports being generated currently from the system?

1. Summary of Material Movement with date and time

2. Production order summary having status of whether they are closed or still open.

28. Do you have any inquiry and Quotation process for Sales?
29. How you are capturing Customer Purchase Order details in your legacy
system?
30. Before accepting customer PO, are you checking stock availability?
31. Are you using Picking, packing and Transportation mechanism in your
finished goods?
32. How fast you are generating Sales Billing document after delivery of
goods?
33. Are you using a threshold (credit) limit on Customers outstanding
amount?
34. How you will convert Customer Purchase order into your production
orders?
35. Have you check machine occupancy?
36. What kind of planning strategies you are using for your production?
37. Is there approval procedure before releasing your production orders?
38. Are you issuing Raw Material specific to Production orders?
39. How your production order will move from one department to another
department in your shop floor?
40. How you are confirming your Production order yield in your system?
41. Are you monitoring Production order costing in your system?
42. Are you accounting work in progress inventory in your book of accounts?
43. How rejection is handled in between two departments?
44. How you are generating Raw materials and Consumables demand?
45. What are the different procurement processes you are using?
46. Based on what criteria’s you are selecting your vendors?
47. Are you storing the information about Material Vendor combination?
48. Are you using contracts and scheduling agreements in your system?
49. Are you maintaining your negotiated terms and conditions in your existing
legacy system?
50. How frequently you are reviewing your negotiated terms and conditions?
51. At the time of placing your purchase order, are you referring your
negotiated terms and conditions?
52. Are you using electronic approval for your PO’s from your existing system?
53. Are you monitoring your purchase orders?
54. Are you sending any reminders to vendors? If so, how frequently?
55. Are you using vendor’s consignments in your process?
56. Are you using Sub-contract process in your systems?
57. Are you using Stock transfer process in your systems?
58. Are you using Material Requirement Planning and Forecasting in your
system?
59. Are you using any pre-alert mechanism before goods receipts from
vendors?
60. Are you using gate entry / security entry in your premises?
61. Based on what document, you are going goods receipts?
62. Are you accepting goods without purchase order? If so…under what
circumstances?
63. Are you carrying out quality inspection for all goods…if not for which
material groups?
64. How you are counting Physical inventory in your system?
65. Are you maintaining safety stocks in your system?
66. How you’re managing invoice verification in your system?
67. What are the inventory reports you are having in your system?
68. How you are managing Free Goods and Discounts relevant to goods in
your procurement process?
69. Are you carrying out quality inspection in your shop floor?
70. Are you carrying out quality inspection before goods issues to customers?
71. Are you taking Quality Certificate from your existing system?
72. Are you analyzing route causes for your quality issues?
73. How you are tracking customer returns?
74. Based on which criteria you are carrying out your quality goods?
75. If material rejected in your inspection, what you will do?
76. Are you accepting your materials based on usage decision?
77. On what basis, you are carrying out your bill passing?
78. Are you releasing your payments (automatically) based on your agreed
payment terms?
79. Are you availing and using CENVAT (Sales Tax, Excise) and Service Tax
credit based on your goods receipts?
80. Are you using any bidding engine for your operation procurement?
81. Are you using Shopping cart in your procurement process?
82. Are you monitoring your internal projects with respect to activities and
cost?
83. Are you preparing and using engineering / specification drawings for your
semi-finished and finished goods?
84. How periodically you are carrying out Profit and Loss analysis statement?
85. Are you doing monthly budget cost center / Departmental wise?
86. Are you carrying out any Group consolidation from your different legal
entities?
87. Are you maintaining your assets separately?
88. Are you calculating depreciation automatically?
89. Are you using Electronic Bill Payment (fund transfers)?
90. Do you have any practice to send reminders to your customers for due
payments?
91. Are you using automatic Bank Reconciliation Statement?
92. Are you analyzing your profitability analysis on following areas?
i. How profitable (Profitable analysis)?
ii. In which area (Profit center wise)?
iii. Where (Cost centers)?
iv. For what (Product cost controlling)?
v. What costs (Cost element accounting)?
vi. Standard cost estimate
93. Are you scrutinizing application (HR) data?
94. Are you carrying out Personnel Management and Development?
95. Are you carrying out Training and Event Management?
96. Are you carrying out Time Management?
97. Are you carrying out on-line performance appraisals?
98. Are you processing Payroll?
99. Are you carrying out Personnel cost planning?
100. Are you interested in Employee Self-Service?
101. Are you interested in Manager Self Service?
102. What types of maintenance activities you will carry out in your existing
system?
103. Are you interested to for preventive and breakdown maintenance with
schedules?
104. Are you able to analyze spare costs and Labor costs each maintenance
activity?
105. Are you interested in Analytics Reports for your Marketing and Financial?
106. Are you above to see web based reports from your existing system?
107. Are you above to carry out Asset Acquisition / addition and deletion in
your system?
108. Are you above to carry out Automatic depreciation as per Company’s
and Income Tax act?
109. Are you above to block assets and revaluation?
110. Are you above to track all assets?
111. Are you above to take care all statutory (CENVAT, VAT, Sale tax
registers, Sale Tax Forms Tracking) requirements in your existing system?
112. Total number of current MIS Reports with descriptions.