Friday, May 31, 2013

Ubuntu-Tech Tool (Small Candy Business)



Dear Dad,    

     I wouldn’t recommend Ubuntu to corporations but I would recommend Ubuntu to mom and pop businesses for an operating system. A small business doesn’t have a big budget so why spend money on Windows. After downloading and researching Ubuntu, I would propose Ubuntu to the candy business (my father owns a small candy shop). There are several reasons why I recommend Ubuntu to the candy business: it’s a free operating system, easy installation and user-friendly for the average user.

    I can get an older computer from home and we can install Ubuntu. Ubuntu would help the business with the daily financials. You no longer have to keep track on paper for the daily transactions. After 45 years, you will have the visibility on the computer free of charge. Ubuntu Cal is a spreadsheet that keeps track of your daily figures and we can see the seasonal trends. Ubuntu Cal is useful to monitor the seasonal trends throughout the year. Also, you can create an invoice template using Ubuntu Cal. This would be positive for business owners and make things  efficient for the day-to-day business activity. You no longer need the hanging calendar on the wall for daily and weekly tasks. You can use Ubuntu's calendar as it this will make it easier for you to manage your daily tasks.

    Ubuntu’s impact would be positive for the Caramel Shop.  In my opinion, it gives small businesses an opportunity to grow. The open source feature allows you to customize the operating system as you grow. You don’t need all of the bells and whistles like Windows and Ubuntu is a perfect fit for small business.

   The free operating system makes it convenient for the average user like the candy shop. I was going to stop by the candy shop to discuss Ubuntu more in detail as this free operating system will help increase your candy business.


Bombardier - ERP Implementation

Key Problem

In the Bombardier study, Bombardier Aerospace is the third largest designer and manufacturing aircraft company in the world. Bombardier Aerospace reported to make $8.2 billion in revenues which is 55% of Bombardier Limited’s total revenue in 2007.  Bombardier is using a legacy system since the early 1990s known as the Bombardier Manufacturing Systems (BMS).  BMS is based on a MACPAC platform, which is starting to show its age as an insufficient solution. Bombardier has made several acquisitions throughout the years and the MACPAC platform is making it difficult for the future development of the company.  The Vice President of Operations and Project Sponsor is aware of the aging MACPAC platform and has a vision to make an efficient upgrade so Bombardier can be a ‘One Company’ philosophy. The key problem is Bombardier Aerospace needs to significantly improve their low visibility of inventory and lack of integration within the company.

ERP I - Implementation

            Bombardier Aerospace tried to make a significant technological improvement with an Enterprise Resource Planning (ERP) system. An ERP application provides one platform for inventory, purchasing, procurement, customer service and finance. The first attempt for the implementation of ERP system project was not successful.  The ERP project was discontinued in 2000 and spent a substantial amount of $130 million in sunk costs. There were several reasons why the ERP implementation was a failure: Inappropriate businesses process, outdated company vision, a weak sponsorship and insufficient involvement of employees. In my opinion, Bombardier didn’t have best practices for the ERP implementation as there was no structure, loyalty, organization and leadership for the IT project. The Bombardier Aerospace ERP best practices should have been developing the inventory management, integration, formal employee training, price consistency and a master supplier listing.     

ERP II -Implementation

            As you may know, the second ERP implementation was started in 2001 by a group of senior managers from Bombardier Aerospace’s Irish facilities. The senior managers developed the Bombardier Manufacturing Information System (BMIS). BMIS was a motivated realistic proposed plan to achieve project goals. The BMIS project was to have a wider ERP strategy and focus on the processes that support manufacturing, inventory, procurement, finance and engineer data. The main reason the ERP implementation failed the first time was not having a detailed management planning solution. Also, one of the BMIS objectives was to reduce the headcount for clerical roles since the processes are automated and not input manually. The ERP system would eliminate paper as most of the material would be automated.  Employees could focus on more analytical tasks rather than administrative tasks. The SAP enterprise system was chosen as the ERP system for Bombardier Aerospace. There was value for deciding to use the Mirabel plant as it is manufacturing plane site. The CRJ700 model plane is manufactured at this location and the jet plane is Bombardier Aerospace’s potential growth in the future.  The one site implementation approach is a more conservative approach which is needed for a large scale ERP implementation.  I agree that big bang theory is not the best approach and would be more challenging for the company. I commend that way the implementation was structured using the Mirabel site as pilot with integrating testing, training and Go-Live. Once SAP implementation was fully completed, the cost savings was extremely favorable within the year. There was a significant reduction in $1.2 billion in inventories within the first year of Go-Live. Employees’ attitudes changed for the better as the ERP system started to make their job easier and more efficient. In my opinion, the second ERP was successful but there is room for improvement for the third ERP implementation.  

ERP III – Implementation

            After reviewing a memo from an executive, I will identify the ERP SAP best practices and bring the necessary world class standard for the implementation project. The second ERP implementation was a success but I want to ensure the third implementation will be flawless. There are several action steps during the second ERP implementation that I would continue to support for the third ERP implementation: BMIS, One-Company (Integration) and less Consultants. 

  In my opinion, the BMIS functional strategy is one of your strongest assets to the development of the ERP implementation. I would continue to utilize the BMIS philosophy as it provides the right focus on the Bombardier’s functional processes. BMIS focuses on the functional processes, such as: inventory management, manufacturing, procurement and finance. BMIS shows a detailed analysis and structure to implement thoroughly and effectively. I do support the VP of Operations and Project Sponsor’s One-Company approach. It is necessary to have all checks under the Bombardier name and have an integrated system. I am in favor of less third party consultants and I do like the ratio of employees to consultant (1:10). Employees can get frustrated with too many consultants explaining the processes and can be challenged with a new ERP implementation. There will be a better working environment with fewer consultants.

            I would recommend 4 areas to make improvements so your team can learn from the mistakes from the second implementation: training, eliminating legacy systems, processing purchase orders and Finance. There were several opportunities to improve your training program. The third-party consultants didn’t provide the proper training material and the staff expressed dissatisfaction with the training program. At this point, I wouldn’t recommend training from a third-party consultant as the Mirabel plant is your training material. The BMIS team and the Mirabel plant users can provide a formal cross training program during the new ERP implementation. The Mirabel employees can provide feedback to the new users that the ERP system has saved them a significant amount of time.  Your employees will learn from each other, and it would boost morale.         

There were users after the Go-Live from the Mirabel plant that were using the current legacy systems. I would recommend discontinuing the ERP user from using the current legacy systems. In my opinion, the employee isn’t adding any value and this is not an effective way of learning a new system. The VP of Operations and Project Sponsor’s should send out an email to the managers and not give permission for users to use the legacy systems. I would encourage managers to send out a problem list to the BMIS project team so they can problem solve for any new issues in SAP. 

There were challenges with processing purchase orders during the Mirabel implementation. I encourage revamping the purchase order process as vendors are either receiving too many faxes or not receiving purchases orders.  SAP was automatically sending fax purchase orders to vendors, causing problems within the MRP engine. Suppliers were receiving too many faxes every time the MRP engine was being updated. At this point, ERP SAP has the capabilities to email purchase orders rather than faxing a PO to your vendor. It was unacceptable that the BMIS team was printing, stapling and mailing purchase orders to vendors for three weeks. Also, the BMIS team should create an IT audit to ensure vendors are receiving POs in a timely manner.         

Key Performance Indicators (KPIs)

In my opinion, Key Performance Indicators (KPIs) are an excellent way to monitor your goals and improve your business. Once the third implementation of ERP SAP is installed, I would recommend utilizing KPIs on a monthly basis. ERP systems can provide a plethora of KPIs and you can choose what KPIs are most important to your department.  There is a significant amount of opportunity to improve your trade working capital (inventory + trade debtors – trade creditors). For example, Bombardier Aerospace has done an outstanding job with a one-time reduction of $219 million reduction in inventory costs. The reduction in inventory costs can lead to other financial opportunities for your company. Overall, KPIs give excellent visibility for achieving goals within your organization.  

Conclusion

            SAP is creating an effective and efficient solution for your inventory and integration problems. An ERP implementation can be successful with the proper vision and dedication to the system. Management needs to be confident in their product and encourages users there is a benefit to their daily workload. Bombardier Aerospace must emphasize that ERP systems give you an upgrade and an opportunity to grow the business. In my opinion, it’s time to eliminate the outdated legacy systems and look to the ERP system as a resource of future growth.  ERP systems provide the following services better than legacy systems in the following: organization, inventory visibility, purchasing, customer service, finance, employee morale and function control. The Mirabel ERP implementation contributed to a $1.2 billion cost saving reduction which is impeccable! This will give Bombardier additional cash flow, improve Bombardier’s balance sheet and make potential company acquisitions.  I would eliminate the legacy systems completely and replace them with the ERP SAP.

The ERP SAP system would be just as efficient as the design of your aircrafts. The CRJ700 jet plane needs an engine to fly with power and speed and the wings to bring control effectively to the aircraft. The ERP SAP system will bring a fast and powerful one platform solution and provide an effective solution with integration, inventory, purchasing, sales and finance.

           

Friday, May 24, 2013

iPads-Reflection


            I recommend iPads for the detailers (sales employees) when the laptop leases’ end. The laptop leases will expire in a year and half. This would be a sufficient amount of time to make the necessary functional requirements. New technology requires time and dedication to make a significant step on improving technology for the sales team.  I do like Bill’s enthusiasm regarding iPads, but there must be research, structure and organization to implementing a new technical product. There would be a timeline with three different phases of implementing new iPads (Development, Pilot and Production).

The functional development of iPads is to have security, accessibility, efficiency and convenience for the users. I would recommend purchasing Citrix Receiver software with iPads to make it compatible with your system. Citrix Receiver is an easy-to-install software client that lets you access your applications, desktops and data easily and securely from any device including smartphones, tablets, PCs and Macs. Working with a Citrix-enabled IT infrastructure, Receiver gives you the mobility, convenience and freedom you need to get your work done[1]. Citrix Receiver provides instant secure, single-sign on access to all Windows, SaaS, and internal web apps or entire Windows desktops for apps. not immediately accessible, you can kick off an automated workflow to get manager approval, quick access, and get back to work[2]. The Citrix Retriever is $3,200 for 15 users ($213/employee) and does provide 1 year of maintenance. In  my opinion, the cost is an immaterial amount for the iPad ($1,200/employee) and Citrix ($213/employee).
I like the idea to switch 2,500 sales representatives to iPads but I suggest using 1 out of the 4 regions as a pilot group. I would recommend 100 users in the Northeast region. The 100 users would be an excellent resource to see the return on investment (ROI).      
I believe it’s important to start small to see the pros and cons of iPads. There will be a learning curve for Amrahp employees when rolling out the iPads. The pilot region would take 3 months and they can provide feedback on iPads to the company on whether this is an efficient decision. Once the pilot group is doing well, I would present the iPads to the rest of the region. Each region would be a phase after a 3 month implementation program and the 2,500 sales employees will be on iPads within 1 year.        
There are several pros for the sales representative that will make it a beneficial function. I agree with Bill that it would be more convenient for detailers and iPads are lightweight. The iPad provides a quick and efficient process for the detailers with using a touch screen during the sales visit.   The detailers (sales representatives) can provide a demo to the doctors to see the value of iPads. iPads are less prone to viruses and malicious software compared to laptops. The iPads are also easy to upgrade compared to laptops.
There are several cons with iPads such as a learning curve, storage restrictions and the current infrastructure would need support. The 2,500 detailers will need training to learn how to use a touch screen. There is no external storage such as a standard USB and a battery isn’t easily replaceable. The current infrastructure needs support like Citrix Receiver.         
            The iPad pros outweigh the cons as iPads are the future for the medical field based on the convenience of bedside work.  There was a survey with small and medium-size medical offices. Of the small- and medium-sized medical and dental offices surveyed for the report, 76 percent said they intend to buy tablets over the next 12 months[3]. According to the report, most of those looking to buy tablets want an iPad, which is quickly becoming the eponym for a tablet computer, the way the iPhone has for smartphones and the iPod for digital music players[4]. The surveys are in favor for iPads in the medical field and I recommend them to replace the heavy duty laptop.
Once the sales team goes live for a year with iPads, Amrahp could eventually switch to iPads for the entire company as a long term IT goal...  

Accenture - Reflection

             After reviewing the Accenture alternatives, I would still recommend SAP and COBIT 5.  In my opinion, SAP provides as an excellent one-platform enterprise application and COBIT 5 provides an excellent tool for an IT governance application.

COBIT 5 principles will ensure that Accenture is receiving a high level of IT governance. COBIT’s 5 principals are: Meeting a stakeholder’s needs, covering the enterprise end-to-end, applying a single integrated framework, enabling a holistic approach and separating governance from management[1]. One of the key areas where you can improve, with the 5 principals is separating governance from management. COBIT 5 is a more formal process than the existing IT governance and provides a segregation of IT duties for management. For security reasons, there needs to be a separation of duties for management and they shouldn’t be auditing projects. There is too much manual input done by the sponsors and IT managers. There is too much time being invested at the IT management level and they don’t have the time. Exhibit 7 is an example where you can save time, money and get a high level of productivity from COBIT 5. COBIT 5 provides IT auditing, effective consulting, security and separation of duties within the IT infrastructure. COBIT is an affordable application and it can add value to management so they can focus on daily tasks.
COBIT 5 provides you with a new IT governance that will allow Accenture to be recognized as a world class organization!


[1] http://www.isaca.org/COBIT/Pages/default.aspx

Monday, May 20, 2013

Zara - Reflection


             I would still recommend my third alternative to upgrade the Point of Sale-POS terminals with the Microsoft OS-Operating System. There are too many pros to upgrading that it shouldn’t be a low priority: Increase revenue, better visibility with inventory and sales and better form of communication between stores.   Also, I would still recommend implementing purchases on the Internet. The Internet is an undiscovered resource for Zara and the upgrades will only increase revenue and boost employee morale.

The POS and OS IT upgrade can be a major financial investment for Zara’s business as well. As I mentioned in the earlier memo, you have an opportunity to increase your net profits by 11.8 million Euros in the 2003 year (15 million Euros in additional profits – 3.2 million Euros in additional expenses = 11.8 million Euros Gain)! The cost of hardware, software, and installation goes on your balance sheet financials as fixed assets.
Also, I would still recommend creating a new IT department. I believe the IT department would add value to Zara’s organization. There is a 1.2 million Euros  salary expense to go with this new department but you will see a substantial increase in your revenues. In my opinion, if there is no investment in staff and technology, there is going to be a lack of IT creativity. The lack of IT creativity will allow competition to take away business.       
Overall, the POS hardware and OS software upgrade accompanied with the Internet will only drive your business to grow efficiently and effectively. The set up time won’t require a significant amount of time to implement and the upgrade transition is not difficult. As it was indicated to me, Zara managers want to look up inventory balances in all stores in a timely way and the IT upgrade project would be an excellent idea to implement POS OS in their day-to-day operations.     

Friday, May 17, 2013

Zara - IT for Fast Fashion

 
Zara - IT for Fast Fashion
Key Problem

In the Zara case study, Zara relies on time to make clothes for young and hip fashion-conscious city dwellers. Zara needs to respond quickly to their clothing product as fashion changes rapidly, so time is an extremely important to the unique clothing line. Zara is Inditex’s largest chain store and they use point-of-sale (POS) terminals with a Microsoft disk operating system (MS-DOS). A major weakness of Zara is the speed of implementing a new technological system.  Zara has continued to use an outdated Microsoft DOS – disk operating system compared to Microsoft OS - operating system. Microsoft launched OS in 1985 and 18 years later Zara is still using DOS. The key problem is Zara needs to upgrade their applications and add functionality, and networking capability.  

Assessment of the Three Alternatives

            The first alternative is to remain using the POS terminals with DOS. As this was mentioned to me during a sales call, “If POS is not broken-why do we need to fix it?” Microsoft does not support DOS and Microsoft launched OS in 1985. The type of technology is outdated.  Microsoft doesn’t support DOS so there is a major concern since this is obsolete.  

            The second alternative is to upgrade the POS terminals but not replace DOS. There would be a major problem if the upgrade was POS hardware only. The upgraded POS terminals are not compatible with DOS so this isn’t a practical solution. The results in delaying any new stores without the proper hardware/software would be a negative effect on Zara’s image.    

            The third alternative is to upgrade the POS terminals with Microsoft OS-Operating System. The upgraded hardware accompanied with OS is the most practical IT solution. This would be the most efficient solution and it can increase productivity. Also, you don’t have to carry a floppy disk for daily sales and would save time for management. Microsoft doesn’t support DOS therefore it’s imperative to move to the new technology.    

Recommendation

            After reviewing the three Zara alternatives, I would recommend installing new POS terminals (hardware) with Miscrosoft –OS throughout the company. It’s unacceptable that DOS is currently being used, as Zara has done minimal to upgrade their IT solution. There are several advantages of upgrading to OS: 1) Easy transition, 2) Better visibility with inventory, 3) IT Processing Speed and 4) Boosts employee morale. The hardware POS vendors make it aware that an upgrade would be an easy transition. There was a theory that Xan Salgado; the head of IT stated “95% of inventory is pretty good and you don’t need to be more accurate” is absolutely incorrect. Salgado is sending the wrong message as there leaves room for theft, errors and lost revenue. The new PO OS application allows monitoring inventory more efficiently, thus making Salgado’s theory archaic. There would be fewer phone calls from each store, as the Internet gives access to each store’s inventory. For example, the high speed Internet connection would be added and the dial up would be eliminated. This helps staff and management with quick decision making. The new POS and OS applications boost employee morale. Store managers are looking for an upgrade, as this was mentioned to me, an upgrade can assist managers in making their jobs easier. For example, the floppy disk DOS would be replaced by the OS –no more carrying floppy disks around.             

In my opinion, I would terminate Xan Salgado, the head of IT and Bruno Sanchez technical lead for the POS system for Inditex. It’s unfortunate, but Inditex needs leaders who can implement the new POS terminals with OS. There should be no confusion at this point in Salgado/Sanchez’ career.  Inditex needs an aggressive and technology savvy department that is willing to take control of this outdated program. It starts at the top with the CIO. Zara would have significant increases in expenses: in salaries, benefits and consulting fees.  There would be a significant amount of investment in the new headcount, adding value to Zara’s business to grow and increase revenue. Here is what I recommend for staffing as there needs to be a new IT rĂ©gime in place for a new effective solution.   

New IT Department:

            1) Hire a CIO – Chief Information Officer

            2) Hire an Infrastructure Manager

            3) Hire 2 Business Analysts

            4) Hire 2 IT Computer Support Specialists

            5) Hire 2 Internet IT Specialists

            6) Hire an IT administrative assistant 

            7) Create an IT Committee Team (long term goal)                    

           8) Reduce and eliminate Salgado/Sanchez positions in the IT department                                                                               
 Also, I encourage Zara to incorporate the Internet into their business model for purchasing clothes on the web. The Internet is major player in purchasing in today’s market and this gives Zara another opportunity to increase revenues. The Internet is a marketing “business partner” and Zara can build on the future with the Internet.  I recommend to pilot Spain as the first country to buy on the Internet as this is home base for Inditex. You can learn from a pilot country before going live for all countries. Spain will give you an opportunity to learn about the Internet business and give you enough time to open it to all the countries around the world. 

Profit/Loss and Balance Sheet - Financials:

            IT expenses would significantly increase due to creating an IT department with salary, benefits and computer depreciation expense by 3.2 million Euros in the first year. There would be approximately 1.2 million Euros in employee salary/expenses and 2  million Euros IT computer equipment depreciation expenses (10 million Euros divided by 60 months -5 year depreciation in computer equipment).  The 3.2 million Euros is an extraordinary amount but there is opportunity in revenues.

There are an endless amount of opportunities to increase revenues.  The Internet would contribute the increase revenues substantially. The Internet allows purchases on-line and this would be an unbelievable milestone to have Zara go into this new line of business (2003 Guesstimate 10 million Euros). The other increase in revenue is inventory. Also, there would be better inventory visibility so managers can to look up other stores to make transfers and this requires less time on the phone (2003 Guesstimate 5 million Euros).   
                                                                                                                       2003 Budget (Revenues - Expenses) with new IT applications only:   
                                                                                                                                                    15 million Euros (additional profits) - 3.2 million Euros (additional expenses)  =  11.8 million Euros Gain!!!
   
IT can make a significant impact in the balance sheet in total assets (Property Plant and Equipment & Cash and Cash Equivalents). Inditex has “too much cash” on hand at 525.9 million Euros in  the 2002 financials listed in Cash and Cash Equivalents (See Exhibit 5). It’s an outstanding to have 525.9 million Euros in positive cash but it’s better to make an investment with cash in order for Zara to increase net income. There has been no major investment throughout the years in technology and IT spending wouldn’t be a bad thing. In my opinion, if there is an increase in technology (Software/Hardware –IT Assets) with the proper strategy and planning, there will be an opportunity to increase revenues and net income. I recommend spending cash funds on IT capital as Property, Plant and Equipment (PPE) would increase. Also, I prepared a financial analysis for Zara, it would cost approximately 10 million Euros in the POS OS upgrade. Overall, cash would reduce by 10 million Euros, PPE would increase by 10 million Euros with IT fixed assets but total assets would remain the same.  See Exhibits Below:   
Exhibit - Inditex Financials (millions of Euro)/2003 Budget
Year
2003 Budget
2002
Comments
Inventories
383
382
Better tracking inventory stagnant
Accounts Receivable
280
238
Increase in sales due to better IT
Cash and Cash Equivalents
516
526
Decrease due to IT fixed assets
Total Current Assets
1,159
1,146

Property, Plant, Equipment
1,423
1,413
Increase due to IT fixed assets PO OS
Other Non Current Assets
495
455

Total Assets
3,097
3,014
PPE/Cash Offset



PPE: Fixed Assets
2003 Budget


POS Terminals -Hardware


PO OS -Software


 Installation/Training


IT PO OS Implementation
10


Final Thoughts

            I am excited about the opportunity to look for improvements in technology. There is a plethora of IT improvements that can be made in Zara’s technology and upgrading to POS OS would help contribute to increasing your growth, revenues, net income and net margin. The recommendations will not require a complex solution, as its necessary to upgrade to the POS OS and the addition of purchasing clothes on the Internet is manageable with additional IT staffing.  Zara must identify an IT leader (CIO) in order to make a commitment to implementing the POS OS software/hardware. I understand that time is a major requirement for fashion and upgrading POS terminals with OS can fit the speed for IT processing. I don’t want Zara to be fashionably late in today’s technology.