View the step-by-step solution to:

ISEM 500 1 2 Wire Harness Co .

I have attached a case study on which the following question is based: "What approach would you take to address the business culture and old school mentality of company executives?" Please answer the question and let me know.



ISEM 500
1 2 Wire Harness Co . Exercise
1/5 / 2019
Your team has been hired as a consultant for a small wire harness manufacturer to outline som
recommendations relative to their IS IT capabilities and to guide them in establishing a IT Strategic Plan
What you know
Company executives ( CEO , CFO , and coo ) have shared the following
The company has a defined a business strategic plan that will grow and transform
company 's earnings from a $75M to $150 M , a 100 - percent revenue growth projection
over the next 3 years
From an Information systems perspective , the company's strategic plan outlines
initiatives and investments addressing new computers , server , and expansion of
10 Base 2 Infrastructure
The company will be expanding its wire harness production for three existing product
lines from 5 000 units per day to 15 000 units per day in the next 8 months to meet new
and existing customer demands
The company will offer a new services to supply electrical control box assembly units
within the next 18 months
he company will be expanding to a two shift operation increasing their total employee
headcount from 100 to 150 ( 2 - shop supervisors , 1 - production manager , 1 - engineer , 1 -
quality control specialist , and 45 laborers )
There is no full time ( 10 or IT Manager ; but there is a consultant that comes In once a
month charging $75 / hour
0 Bottlenecks in engineering , inventory , sales , and production
Concerned about keeping up with customer demands and ability to transform with the
rapid growth of the business
CFO concerned about the inefficiencies and accuracy of inventor
of inventories , sales , production ,
and purchasing systems
CEO and COO are old school when it comes
to technology whereas the CFO believes
investments should be made in an En
nts should be made in an Enterprise Resource Planning System with integrated
Supply chain management ( SCM ) , sales
sales , production , payroll , and financials
CFO , company managers , and long time by
time business partner has expressed his concerns to
CEO regarding the capabilities , reliability , scalability , and security of their information
Business Processes & Information Systems Environments
Main server located in center of business office hallway under table
10 Base - 2 Ethernet cabling and repeaters hanging in offices , shop floor , hallways
No central IT computer room
Company has a web page , not updated in last two years
Corporate web email and internet access through local ISP
Workstations running Windows 98 and XP each with individual copies of virus
protection , Main Server running Window Server 2003


ISEM 500 XYZ Wire Harness Co. Exercise 1/5/2019 0 Engineers have CAD software, no plotter, using color printer, printing 8.5" X 11"
engineering diagrams for board layouts and connector pin assembly diagrams 0 Using Quickbooks for accounting and payroll; print checks, invoices, 0n laser printer 0 Each manager, supervisor, executive, and support staff have a desktop computer and dedicated color printer 0 Using spreadsheets to track raw materials and finished product inventories 0 Using spreadsheets to manage and track raw materials purchases 0 Using spreadsheets to manage work orders for daily production runs using manual run
sheets at each manufacturing work station leg, wire cutters, wire harness assembly,
CIA/Testing, Connector Assembly, molding, and braiding) 0 Wiring harness boards are set up manually by engineers, requires 3-hours set-up time
per board for new wire harness production and 1-hour for modifying existing wire
harness. Use wooden boards and electrical tape to layout boards. 0 Computer Aided Design (CAD) engineering diagrams linked to product number5 tr BCkEd
in spreadsheet 0 Inventory management is manual process, using storage bins and label maker with part
numbers. Inventory manager and stock clerk align work orders, parts purchase orders rework, damaged parts, and manual part counts to maintain inventory. Raw materials
are put on carts and supplied to production workstations throughout the day. 0 Customer orders are taken via phone and fax machine (manual paper process) then
entered and tracked” In sale order spreadsheet from which customer order reports then . _ ahdlt ’_‘l $1,991 tfi'ccounting, inventory, production, and engineering maria Update their-respective department spreadsheets. ~_,__-.‘.,_. . - 0 Material purchases are made via phone using daily material purchase request listings printed from the inventory tracking spreadsheet: purchase orders and Invoices are
emailed or faxed to purchase manager who provides a copy to accounting and inventory
manager. Purchasing manager tracks all material purchases via spreadsheet by vendor. 89$;

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.


Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question