...530 073 016 030 072 779 030 Md. Tareq Rahman Shubro Barua Sanjana Mehnaz M Mazharul Arefeen Bhuiyan Sumayia Hassan Background of IKEA IKEA is a privately held, international home products company that designs and sells ready-to-assemble furniture such as beds and desks, appliances and home accessories. The company is the world's largest furniture retailer. Founded in 1943 by 17-year-old Ingvar Kamprad in Sweden, the company is named as an acronym comprising the initials of the founder's name (Ingvar Kamprad), the farm where he grew up (Elmtaryd), and his home parish. IKEA has 300 home furnishing superstores in 35 Countries and was visited by some 583 million shoppers. IKEA’s low priced elegantly designed merchandise displayed in large warehouse stores, generated sales of $21.2 billion in 2008, up from 4.4 billion in 1994. The fledgling company sold fish, charismas magazine, and seeds from his family farm. His first business had been selling matches, the enterprise Kamprad purchased them wholesale in 100 box lots and then resold individually at a higher mark up. Before long, Kamprad had added ballpoint pens to his list and was selling his products via mail order. In 1948, Kamprad added furniture to his product...
Words: 9302 - Pages: 38
...Implementation of a Data Warehouse Prototype for the University of Nairobi within the Context of Relational Online Analytical Processing (Data Analysis) PRESENTED BY: 1. JORAM KIPLIMO D61/68960/2013 0724431978 . PRESENTED TO: Dr. Muranga Njihia Word count: 2752 ABSTRACT Data ware housing is a booming industry with many interesting research problem. The data warehouse is concentrated on only few aspects. The discussion here is about the data warehouse design and usage in the case of the University of Nairobi Environment. Data warehouse can be built using a top-down approach, bottom – down approach or a combination of both. In this research paper we are discussing about the data warehouse design process. Data Warehouse (DWH) systems are used by decision makers for performance measurement and decision support. Currently the main focus of the DWH research field is not as much on the interaction of the DWH with the organization, its context and the way it supports the organization’s strategic goals, as on database issues. The aim of the study is to emphasize and describe the relationship between the DWH and the organization with conceptual models, and to use this knowledge to support data interpretation with business metadata. KEYWORDS Data Warehouse (DWH) Data Mart Extraction, Transformation and Loading (ETL); Software that is used to extract data from a data source like a operational system or data warehouse, modify the data and...
Words: 2816 - Pages: 12
...Question: 1. When developing a successful data warehouse, what are the most important risks and issues to consider and potentially avoid? Data warehouse projects have many risks. Most of them are also found in other IT projects, but data warehousing risks are more serious because data warehouses are expensive, time-and-resource demanding, large-scale projects. Each risk should be assessed at the inception of the project. When developing a successful data warehouse, it is important to carefully consider various risks and avoid the following issues: • Starting with the wrong sponsorship chain. You need an executive sponsor who has influence over the necessary resources to support and invest in the data warehouse. You also need an executive project driver, someone who has earned the respect of other executives, has a healthy skepticism about technology, and is decisive but flexible. You also need an IS/IT manager to head up the project. • Setting expectations that you cannot meet. You do not want to frustrate executives at the moment of truth. Every data warehousing project has two phases: Phase 1 is the selling phase, in which you internally market the project by selling the benefits to those who have access to needed resources. Phase 2 is the struggle to meet the expectations described in Phase 1. For a mere $1 to $7 million, hopefully, you can deliver. • Engaging in politically naive behavior. Do not simply state that a data warehouse will help managers make better decisions. This...
Words: 2805 - Pages: 12
...THE COMPANY MGL was incorporated as a family corporation in 1980 with a paid-up capital of P400,000 in csh. It was organized by Mr. Carlos Montero and his wife's family. The Company was located in Pangasinan. To increase its capital structure, members of management accepted additional investments in the form of fixed assets in exchange for shares of common stock and established a policy of giving priority in employment with the company to anybody who would invest a minimum of P20,000 in common stock. Mr. Montero explained, "Our parents never borrowed nor mortgage any of their properties to lending institutions. They acquired them through hard work and frugality and the attachment for these family assets is very significant in their lives. I have made a list of probable projects to make our company more viable, considering the type of business we are in , the place and the selection and design of our projects in the vicinity." LIST OF PROPOSED PROJECTS 1. Grain drier, furnace and accessories 2. Electrification of rice mill building and warehouse (installation of electric motors, wiring, panel boards, control switches, etc.) 3. Palay storage boxes (10 units) 4. Repairs of warehouse and Rice Mill Building 5. Construction Concrete of Concrete Solar Driers The practice of keeping in the payroll a few extra hands to help " poor relatives" also led to financial difficulties. The majority of the company's present employees were daily-paid laborers. Daily bookkeeping...
Words: 1970 - Pages: 8
...Business Requirements Document Student’s Name Subject Title Instructor’s Name Submission Date 1. Introduction Data repository is a general term that is used simply to refer to the data storage points within an organization or system. This project seeks to put in place a more efficient and bugger repository to improve the performance of the existing information systems. This repository is aimed at making the organization grow relatively to greater heights in the next few years, probably by twenty percent annually. It is expected that the repository will put in place the current missing aspects of data properties that need to be included as important resources of the organization. The project seeks to take the minimum time possible, and to utilize the resources to the least standards to minimize on costs, and maximize on the net present value. 1. Project Evaluation This project will be evaluated using the financial aspects of the net present value. Using a discount rate of 20%, we expect that the discounted future values will be able to meet the user requirements. This evaluation will be done based on the forecasted future possible returns from the project activities, on a period of less than five years. The net present value method has been selected since it takes into account the time value of money. The needs resources required from the company to undertake the project will be deducted from the forecasted annual returns or yields expected from this project....
Words: 1279 - Pages: 6
...financial position and leader in the marketplace, Zara will withstand the initial interruption of business to allow implementation of new technology due to their current solid financial position and leadership. KPIs are implemented to provide efficiencies within manufacturing, the DCs and sales to enhance the successful unique business model. ISSUE IDENTIFICATION The following are a list of issues/problems that must be addressed: • DOS system is no longer supported by Microsoft • In-house applications created by vendor • Writing applications versus buying applications • Transparency between stores • Order processing time • No formal IT process for setting budget or deciding on specific technology, investments or projects • Store managers scope of responsibility is high versus no discretion for store layout • No performance measures • No forecasting, buy and respond “on the fly” • Not high end fashion • High capital costs for DCs, manufacturing, and factories • Small batch production ENVIRONMENTAL AND ROOT CAUSE ANALYSIS 1. DOS system is no longer supported by Microsoft since 2003. Zara chooses to write all their applications in house. This matches the philosophy for speed and decentralized decision making to ensure a stable, effective and easy roll out to each store and maintain. To support their in-house application writing process the IS department consists of 50 people and entails three groups – Store...
Words: 1742 - Pages: 7
...Website/User Friendly ASRS 3 Issues facing CanGo from week 3 Jack’s justification for the new system (ASRS) - Caromill Almanzar Jack feels that the company should go under a new system to increase efficiency for their warehouse and inventor. Liz is concerned that the investment for the (ASRS) may not yield the necessary return to justify the investment. Jack’s argument is, the (ASRS) will help tremendously with the pickup station operators, to an extent that the station will be gone. Currently operators pick about 45 books per hour, the new system has the capacity to pick 360 books per hour. Liz isn’t convinced with Jack, She’s has doubt with the expense. She is also concerned about the integration of the system, the website, and their discount system. The only benefit that she sees with the new system is the reduction of labor. Recommendation: The ASRS is generally applied in applications where high volumes of inventory are moved into and out of manufacturing or distribution operation. The ASRS system typically is considered an alternative to fork lifting, and manual material handling. The system also saves space and building cost. The issue with this system will be with the process stability, capital effectiveness, and the elimination of any non-value adding cost. Reviewing the warehouse layout and production capacity for CanGo, The Company will increase expenses such as: warehouse restructuring, retooling and increase maintenance. We feel that CanGo will...
Words: 2165 - Pages: 9
.......................................................................................................... 5 BI 3.0 ......................................................................................................................................................... 5 Opportunities ............................................................................................................................................ 6 Challenges ................................................................................................................................................. 7 Critical Success Factors (CSF) .................................................................................................................... 7 Return on Investment...
Words: 6695 - Pages: 27
...Overview In 1966-1967 General Foods Corporation was considering introducing a new product called the Super product. This product was “a new instant dessert based on flavored, water soluble, agglomerated powder” to both the United States and foreign markets. The capital investment was projected to be $200,000, and it would leverage the existing facilities used by the Jell-O manufacturing unit that had an available under-utilized capacity of its Jell-O agglomerate. A Nielsen market survey was done that showed a powered desert which would contribute to a significant growth market. The results projected that the product would capture 10% of the market share; 8% percent would be from new growth while 2% would come from the cannibalization of the current Jell-O-sales. The evaluation process to determine the investment opportunity for the Super Project was based on the incremental cash flow analysis. Crosby Samberg, a manager and financial analyst for General Food Corporation felt that this model was flawed and that a new more “accurate” model had to be used to examine the returns on the Super Project. The first assessment model was using the General Food acceptable practice of incremental analysis. The incremental anlaysis determined that Super Project have an attractive return of 63%. The second mythology was to add the facilities' costs, which examine the opportunity costs of leveraging the available pre-existing Jell-O equipment. This model determined that the Super Project would...
Words: 2778 - Pages: 12
...Situation Analysis: Tektronix (est.1946) was a maker of electronic test equipment. It has grown to be $1.3 billion manufacturer of electronic tools and services. The business was split into three divisions, namely Color Printing and Imaging Division (CPID), Measurement Business Division (MBD) and Video and Networking Division (VND). Tektronix was the leader in oscilloscope, television set, monitoring equipment and color printer with divisions based in US and international presence in nearly 60 countries. Problem Identification: As the CFO of Tektronix, Neun had seen many problems and implemented strategies to overcome them. In the initial days, he resorted to making decisions of selling off businesses, changing business processes and increasing visibility in operations. However, due to lack of integration, Tektronix was facing some issues- * The management and the information system lacked integration and suffered from uncoordinated evolution. * Financial performance of the company was suffering * One of the major issues faced was the IT infrastructure using different application systems and technologies around the world. The systems were not standardized globally and there was no visibility in the inventory system. * Architectural problems were engraved in the patch work of the legacy systems. It also created the need for a sales order to be entered multiple times in systems as it made its way through the order cycle. This slowed processing and led to...
Words: 1152 - Pages: 5
...Introduction This 1200 words report will compare the performance of Bravo LTD for the past 2 years (2007 and 2008) by means of simple ratio analysis. This will be used to express the relationships between different performance in the company in both 2007 and 2008. The later sections of this report will give results of the various ratios, reasons for using ratio analysis, description of the ratios, findings, analysis and recommendation for Bravo LTD, limitations to the use of ratio analysis in this report and limitations to the use of ratio analyses in general. Refer to appendix for all calculations and data. Method In order to compare the performance of Bravo LTD in 2007 and 2008, ratio analyses will be used. The reasons for using Ratio Analyses Feldman & Libman (2007) defined ratios as a way to express a mathematical relationship between two data, this can be in form of percentages, rate or proportions, and it can be used to compare the performance of a business within a period of time. Financial ratio analysis uses ratios and relationship between various financial statements as a means of comparison in terms of operational, financial and investing performance of companies. Gowthorpe (2005) introduced the following 5 categories of ratios. These are • Performance ratios – This is used to measure success or failure of business performance • Liquidity ratios – Extent at which business can cope with its liabilities • Efficiency ratios – How efficient the assets...
Words: 1592 - Pages: 7
...formats that threatens the growth of the business. The new competition entering the market forced Guillermo to evaluate his current operation and choose on of three alternatives that best suit him, that would allow him to remain competitive. Guillermo will need to decide if he wants to remain an independent manufacturer of his own furniture and continue his business operation as normal. His other options consist of investing in becoming a hi-tech manufacturer or becoming a broker and distributing furniture for other companies. A detailed analysis on all three of the options will be conducted. This analysis will allow the team to make a decision on which option will be the best for Guillermo’s business. The group will also present a justification for the final decision. Current Course Guillermo Navallez has made furniture for years in his home town of Sonora, Mexico. Sonora has a good supply of raw material and labor is relatively inexpensive. Beginning in the late 1990’s business started to weaken, globalization, mergers, and acquisitions in the worldwide furniture market, businesses, and operations need to change for Guillermo Furniture Company. The market brings together buyers and sellers in many forms (McConnell, Brue, & Flynn, 2009, p. 46). Some markets are local whereas others are national or international. For Guillermo, a new competitor has entered the furniture market. Their revolutionary high-tech approach is producing furniture to exact specification with...
Words: 1963 - Pages: 8
...ASCM 629 SUPPLY CHAIN LOGISTICS MANAGEMENT MID-TERM EXAMINATION Each essay answer for questions 1 through 10 is worth ten points. Please use a between 150 and 300 words per answer. Your answer may include content from text or readings, conference discussions, or relevant workplace examples. These must not be merely cut-and-pasted from other sources. Please do not contact a UMUC Reference Specialist in developing any answer, as discussed in the syllabus. The answer for question 11 covering the SCM Globe Simulation should be at least 500 words and will take as long as required to discuss and document your learnings during Weeks 1 through 6. This answer is worth 100 points and represents ten percent of your course grade. Please save the examination with answers as a Microsoft Word document under a new filename the includes your last name, section (either 9040 or 9041) and “midterm.” An example is \scheer9040midterm.doc . Please include your name and section number at the heading inside the document. Answers should appear in order, from one through ten. Please make sure you have an answer for each question before submitting it for grading. Completed exams are to be submitted in the mid-term examination assignments folder. These are due before Saturday, March 24, at 11:59 PM ET. Note that your assignments folder is locked after this time and the exam cannot be submitted. The test represents 30 percent of your total class grade, so please spend quality time in preparing answers. I estimate...
Words: 2892 - Pages: 12
...ENSURING MORE EFFICIENT MARKETING OF PETROLEUM PRODUCT; THE ROLE OF PHYSICAL DISTRIBUTION A Graduate Seminar Paper Submitted to the Department of Marketing Faculty of business administration University of Nigeria Enugu Campus In partial fulfillment of the requirements for the degree Master of Business Administration (MBA) Graduate seminar (MKT 803) By Onah Godfrey C. PG/MBA/12/62555 AUGUST 2014 APPROVAL PAGE This review by: GODFREY. C. ONAH Titled: Ensuring efficient marketing of petroleum product; the role of physical distribution Has been approved for meeting the research requirement for the award of Degree of master of Business Administration (MBA) in Marketing Prof. Ogwo E. Ogwo Date Approved SupervisorProf. Ugwuonah | Date Approved Head, Department of Marketing | INTRODUCTION The marketing of petroleum products in Nigeria has been inefficient and has faced a lot of problems over the years. Therefore this paper examines the role of physical distribution and how it can help to ensure greater efficiency in the marketing of petroleum products. We shall be reviewing the problems of inefficiency in the marketing of petroleum products in Nigeria, the essence or thrust of physical distribution...
Words: 5231 - Pages: 21
...Table of Contents Introduction 2 Assumptions 3 Data Availability 3 Overnight processing window 3 Business sponsor 4 Source system knowledge 4 Significance 5 Data warehouse 6 ETL: (Extract, Transform, Load) 6 Data Mining 6 Data Mining Techniques 7 Data Warehousing 8 Data Mining 8 Technology in Health Care 9 Diseases Analysis 9 Treatment strategies 9 Healthcare Resource Management 10 Customer Relationship Management 10 Recommended Solution 11 Corporate Solution 11 Technological Solution 11 Justification and Conclusion 12 References 14 Health Authority Data (Appendix A) 16 Data Warehousing Implementation (Appendix B) 19 Data Mining Implementation (Appendix B) 22 Technological Scenarios in Health Authorities (Appendix C) 26 Technology Tools 27 Data Management Technology Introduction The amount of information offered to us is literally astonishing, and the worthiness of data as an organizational asset is widely acknowledged. Nonetheless the failure to manage this enormous amount of data, and to swiftly acquire the information that is relevant to any particular question, as the volume of information rises, demonstrates to be a distraction and a liability, rather than an asset. This paradox energies the need for increasingly powerful and flexible data management systems. To achieve efficiency and a great level of productivity out of large and complex datasets, operators need have tools that streamline the tasks of managing...
Words: 8284 - Pages: 34