Automotive Industry IT Requirements

Automotive Industry IT Requirements full(a) court of possessionObjective The objective of this analysis report is to study and analyse the interpret IT studys of the phoner and compare the economic benefits obtained when the connection shifts to cloud effect as compared to the traditional On precede IT configuration apparatus. The high society chosen for this analysis is XYZ from the automotive industry.Company DescriptionXYZ is a global auto manufacturing party and is a sub division of the Indian high society ABCD. The exclusively toldiance is cognise for its luxurious automobiles, b riding habits, motorcycles and trucks. The headquarters of the company is in Dublin, Ireland. The company root off gained its reputation back in 1990 and traces its origin to the founders of the company AB and CD. XYZ was first financed by PQR in the sign days. The first automobile launched by XYZ was regarded as the first CNG powered automobile. The slogan for XYZ is Just the best. Since 1998 XYZ is the top growing check off with the growth rate of 20%. Son of AB joined XYZ in 2001 after completing his MBA from a very reputed university in the UK and has been bringing a unique approach to branding and creativity in form invariably so since, which in turn has helped XYZ in achieving great heights in the individual industry.A Chinese automobile entrepreneur, DEF who worked with a Chinese automobile company created the trademark for XYZ in 1991 and the first automobile by XYZ was named after him which had a power of 30 hp. The first XYZ brand name luxurious fomite was produced during 1992 with the merger of AB and CD. Throughout the 1990s XYZ produced a car named XYZ 123 which was purportedly the best luxurious car in those days and was apply by the Queen of the UK. XYZ 123 was known for its exquisite design and bullet proof windshield. former(a) similar models were sold to private buyers entirely at auctions in the initial days. By 1995, the automotive division of XYZ was in financial difficulties beca go for of the internal conflicts among the dialog box of XYZ. It was during this period a shareholder meeting was held to decide whether to find an secondary to the issues or to go into liquidation. It was thusly decided to carry on, by stressful to get funds from the current economy booming cars and it exploited so successfully that it as soundly as got the rights to manufacture the German car The FGH. aft(prenominal) fewer modifications to the motorcycle engine XYZ started manufacturing mini cars as well. The success of these mini cars was suitable to get XYZ back on its feet.Today, XYZ is a leading automobile company which also deals with cars in Formula 1. XYZ produces supercars under the XYZ supercar subdivision and motorcycles under the XYZ moto sub-division. The company has got everyplace 20 showrooms in Europe with over five hundred0 employees. The purpose of the company is to deliver luxurious engineering to its c ustomers. Thus, they make the customers feel better than they ever thought they crumb be. Customers are the heart of XYZs business and they have make it a point to provide exceptional customer care. Today, about 40% of the shareholder of XYZ is the Gerrard family of UK while the rest is in public float. By 1996, XYZ acquired the JKL company of Italy. JKL was briefly batched with the brand of XYZ until it was completely absorbed in a eld time. The reason XYZ purchased JKL was that it was interested in the development of JKL in the overhead camshaft in automobile applications. The factory thus obtained from JKL was outmoded and XYZs immediate gain was, a stock of highly qualified engineers and other personnel. JKL continued manufacturing their existing cars for a short period of time with the front and rear axles of XYZ till was nearly incorporated into XYZ. In 1994, XZY acquired a large stake in the European based industrial design studio The Classic Designs, which they fully acqu ired by 1995. Also, by 1997 XYZ acquired the RALF group and owned it for some 3 years and then sold it when it was incurring huge loss in the automotive industry.After serving on the design team of XYZ for 7 years Mr. Lampard announced his departure from XYZ. He was replaced by Mr. Cole. Mr. Cole was known for his radical design contribution such as the XYZ 456 and XYZ 789. In 2001 production rights of the Mourinho Motorcycles was purchased by XYZ for 20 million euros.The company brings great value to their customers in a lap of ways like including promotions throughout the year, expert car care and upkeep advice and 4 points per 100 with their famous ADVANTAGE CARD. The customer can also subscribe to for extra benefits such as more treat for over 40 schemes by XYZ.On infix ITAs the company is evolving as a big brand day by day in the European automotive market, they need to have a proper IT apparatus too. As of now, the company has an on premise IT setup with its main self-con fidence in Dublin 1, Ireland. Being an automotive company, there are non much departments in XYZ that need the waiters or software. The servers are required only for attractning SQL databases to store all the company data related to the customers, inventory, employees, gross sales and purchases. Tape entrepot system is used for the backup purpose. To have the replicated copies of the data, XYZ makes use of RAID 10. Currently, XYZ is using a 25 Mbps bandwidth connection to connect all the servers and to ease out the networking. It includes hubs, switches and bridges for providing seamless networking.The hardware and the software configurations and other aspects related to the on premise IT setup of XYZ are as mentioned at a lower placeOn Premise HardwareIntel Xeon Processor The company chose the Intel Xeon Processor to run and support the business applications and also to reduce the response time of the servers.dell functionEdge R910 Dell PowerEdge is a tower server having Int el E 7510 chipset. This chipset is popularly known for its key features like reliability, data protection and to improve the business productivity. It contains 16 GB ram with SATA connected to 8 TB storage.On Premise bundleMicrosoft SQL server XYZ is presently using SQL server for maintaining its database and keeping all the records of the customers, employees, sales and purchase, inventory wariness etc.Kaspersky AntivirusOperating System Windows 10 is running on the front-end computers of the company while Ubuntu 16.04.01 server edition is used for servers. terminusCurrently, the company has 8 TB storage for storing its data. For backups, the company makes use of tape storage backup system.IT support TeamCurrently XYZ has a small team dedicated to IT support. This team is in charge of configuring, administering and treatment the IT systems present in the company. Also, the support team is responsible for managing the centralized server as well as to en sure as shooting that the complete data of XYZ is organism properly managed and secured.As XYZ is expanding its business gradually, the current IT setup of the company is not enabling them to scale up. To scale up, they must increase their current on premise setup by adding more moment of servers and increasing the storage space to incorporate the large amount of data onto the systems. With the increasing number of customers, there is a need for XYZ to have proper databases as well as additional softwares like ERP, CRM, Security Suite, LogMeln etc. Thus, the company is feel forward to opening new offices within Dublin. Also, there is a need for the company to increase the storage from 8 TB to 500 TB for data storage and backup purposes. Hence, the company also wants to eliminate the tape storage system, as it seems to be a constitutely option. The company thus, inescapably to take steps towards the IT sector and keep increasing it with the growth of business, so that it becomes easy to manage the daily and continuous needs of the company and the employees as well.Thus, this case study is to provide XYZ with the best economical solution for them to setup their new IT office in Dublin by making sure to cover all their needs and eliminating all the problems the company is currently cladding and also, reducing the expenses as much as possible.On Premise personify Analysis no. of innkeepersNo. of Cores ProcessorNo. of processor per ServerRAM (GB)Power (kW)Unit CostUnits (U)Unit Discount % be Cost of 16 units81621284.57227163045,530Total Server Hardware Cost45,530Server Hardware upkeep 34,148Cost for 5 years( 15 %/year)Total Server hardware + tutelage 79,678Total Peak Power consumed in kW 4.5 kW standpoint Infrastructure CostAssuming 1 thrust can adapt 42 units XYZ would require 1 rack.Rack Chassis with PDU hail *4000 per rack3590PDUs, dual 280V per rack bell *620 each, 2 per rack for higher availability 1240Top of Rack Switch (48 port 10/100/1G, 2 per Rack for higher availabi lity, 6000 each) 12000Development Cost of Rack and Server* 350 per server 2800Total Rack Infrastructure Cost 19630Total Cost ( Racks + Hardware) 99,308Software be for ServerBeing an automotive company XYZ uses Microsoft Dynamics GP software as their ERP software, Microsoft Dynamics CRM as their customer relationship management software and Microsoft SQL as their database software solution.Microsoft SQL Server3717Microsoft SQL Server Licence, 2000 per core 16000 for 8 core processorsKaspersky Antivirus 725 per user = 18,125 per userTotal Server Software follow 37,842Total Server Hardware Software Installation, maintenance and updating cost 22,500TOTAL SERVER COSTS (HARDWARE + SOFTWARE) FOR 5 YEARS 159,400On Premise Facilities CostTotal Power Consumed by Servers4.5 kWMetered Cost per kWh0.19Estimated Power cost/month589Total monthly facilities cost2173Total facilities cost for 5 years130,380Storage CostSAN type storage 500TBXYZ currently is in need of about the raw capacity requir ement of 500 TB memory HDD. Also, XYZ currently makes use of RAID 10 with SQL servers for backup. bare-ass Storage (GB)Remaining Storage after OS recognized (7%)Usable Storage on RAID 10 configuration (GB) get price per raw GB after 50% discount last SAN storage price512000 GB476,160 GB238,080 GB1.94991,232Storage funding CostAmount of Storage to be backed up (GB) rest period Window Time (Hours)Backup Window Processed TBs per driveNo. of tape drives required for backup window (*0.83 tape required for 1 TB)Cost of tape library per driveBackup cost for 5 years (Cost of tape drive * no of required tapes)512000 GB83.852621584415,008Number of Racks required to host storage 1 (Single rack can be used to 1000TB)Operating Rack periodical Cost 1320Total data center space, power, cooling costs for 5 years 79,200Hence, count storage costs for 5 years would be-Total Storage Cost = Raw Capacity cost + Backup Cost + command overhead Cost + Final Cost= 991,232 + 415,008 + 79,200Total Storage C ost = 2,476,672Bandwidth CostsSize of Network PipePeak per Average RatioOn Premise Bandwidth Cost per MbpsBandwidth Cost per monthTotal Bandwidth cost for 5 years25 Mbps39754500Total Bandwidth Cost 4500IT Labour CostNETWORK ADMINSTORAGE ADMIN2 ADMIN ON 1 SERVER% total admin effort10%80%400%Monthly Salary2500400050005 Year Salary150,000240,0001,200,000Total IT salary cost 1,590,000