Aurora Textile Company

In: Business and Management

Submitted By pusky
Words 1590
Pages 7
MANAGERIAL DATA ANALYSIS – CASE STUDY

SUBJECT ANALYSED: THE RELATIONSHIP BETWEEN GROSS DOMESTIC PRODUCT AND HUMAN DEVELOPMENT INDEX in 41 COUNTRIES

MIHAILA MIOARA 25% PETRE ALEXANDRA 25% SIMION LAURENTIU 25% TARIUC MONICA 25%

MANAGEMENT of INTERNATIONAL PROJECTS
ASE 2009

Case Study

Record 40 – 60 data for two statistical variables (X and Y) at your choice.

I. For each of the two variables:

a) Calculate and interpret the average, standard deviation and the coefficient of variation for row data. Interpret the results. Is the data series homogenous?
b) Summarize the data in an appropriate number of classes. Construct the frequency distribution.
c) Calculate and interpret for the frequency distribution the average, standard deviation and coefficient of variance. Compare with the results from point a). Explain the differences.
d) Construct a histogram and describe the shape of the distribution based on the histogram.
e) In which interval is expected that about 95% of the data will fall? Is this assumption true for this data?

II. Using the “Pivot Table Wizard” in EXCEL, build a pivot table on your spreadsheet (using also the second variable). You may have to change the order of the rows (You should define the intervals first using VLookup function.

III. Calculate the regression line and interpret and test the regression coefficients, coefficient of determination and coefficient of correlation. Interpret the results.

Introduction:

We chose for analysis a sample of 41 countries, considering the relationship between the following two variables: the Human Development Index(HDI) and the Gross Product per Capita (GDP)[1]. The values…...

Similar Documents

Aurora Textile

...EXECUTIVE SUMMARY Aurora Textiles has historically been one of the premier textile companies in the United States and now has a decision to make.   With the opportunity to invest in equipment that could help cure our slumping financials, we must carefully explore whether this investment is appropriate for a company with such an uncertain future.   With that in mind we believe that the Zinser 351 is the perfect investment to pull us out of this slump.   As a company that has been able to deliver a premium product for the consumers, the Zinser 351 will allow us to continue to do that while also begin relieving some of the financial stress that we have been under.   Our analysis shows that the Zinser 351 project will yield a Net Present Value of $6,474,082.14 million and a discounted payback period of 5.6 years.   This project not only brings a big enough payoff as demonstrated by the NPV, but also fits our timeline.   The discounted payback period indicates that our investment will be realized before our company is not able to recover from our current financial struggles.   The Zinser 351 is a project that this company must undertake if it wants to begin to bring value back to the shareholders who have become more and more impatient with us in recent times.   This is an opportunity for Aurora to turn around its fortunes and once again prove that it is the premier textile company in the United States. ANALYSIS When deciding whether the Zinser is a worthwhile investment or...

Words: 596 - Pages: 3

Textiles Company Network Disaster Plan

...123 Textiles Company Network Disaster Plan Keith A Manley IT240/ Sorrells 11/30/2012 The 123 Textile Corporation has several solvable issues that we will address in this network updating proposal. They have been exposed to inclement weather and as of late a break in resulting in the companies sever and all pertinent data for sales, production, human resources. This proposal will lay out all necessary hardware upgrades as well as the software upgrades needed to maintain the new hardware. It will also look at off-site back up as a potential resolution to being in an area that may be more susceptible to break-ins resulting in equipment loss and or damage. The proposal will also address the issues of inclement weather and possible protection from natural disasters. Hardware and equipment proposal; A required designated space for the new computer equipment should be around 50 square feet with through wall ventilation but no window or exterior access points. In addition a cable line for modem connection and power source will be required. Power source should be of 20 amp circuit and non GFI, number of circuits at primary location in room to be four. In consideration of power outages that could result in loss of data a recommended solution will be the installation of an online UPS battery backup unit which provides continuous power while plugged in through the unit’s battery allowing for smoother and quicker power transition. This unit......

Words: 1340 - Pages: 6

Aurora

...Recommendation: Team E did a great job explaining the situation. It was well summarized and presented. However, we felt that they could have described a more in depth and detailed marketing campaign. We agree that it would be a good move instead of trying to compete with Viagra it would be better to use the beat strategy by positioning Cialis differently. Team E explained the Cialis positioning well, but unfortunately they didn’t explain Viagra’s position. Viagra at the time was more about the masculinity and they were using older celebrities to promote the drug, while Cialis as team E mentioned was supposed to be about relationship. This approach was also more in line with Eli Lilly’s overall company mission. They wanted to be perceived as first or best in class, stand for quality of life and believed in marketing directly to the consumer. To achieve this goal, they established a global marketing sales as well as geographically distinct affiliates. Pfizer on the other hand had the largest sale force in the industry and spent in 2001 alone $108 Mio on direct-to-consumer marketing for Viagra. We feel that this information would have been also important to support the positioning and marketing strategy for Cialis. This information together with all the market research team E presented would explain why a pull strategy would be the favorable strategy. All this information will lead to a more pull strategy, which would also be positively supported by the research. ...

Words: 271 - Pages: 2

Aurora Case

...Q.1 The Textile-Mill Industry is a term associated with industries that are primarily concerned with the design and manufacturing of clothing as well as the distribution and use of textiles. The industry can be split up into three stages: Cotton stage, industrial revolution, and post industrial revolution. In the early parts of the Textile-Mill Industry, known as the cotton stage, products were produced at home using wool, cotton, or flax depending on the area and location. The excess material was sold to merchants called clothiers who would visit the villages and buy large amounts of excess cloth from local producers. The process for making cloth involved three steps which included preparation of fibers for spinning, spinning, and weaving or knitting. In the early days everything was very labor intensive and the market was limited to local towns and passing clothiers. The second stage of the Textile-Mill Industry is known as the industrial revolution stage. During this period mass production of clothing became a mainstream industry which resulted in a growth of the entire Textile-Mill Industry. The spinning and weaving process became mechanized with several new machines introduced to the industry with the majority of the power coming from water wheels. Additionally, the industries market began to expand as exports of textiles began to rise. Presently the Textile-Mill Industry is situated at the third stage known as the post industrial revolution stage. In...

Words: 1442 - Pages: 6

Aurora Textile Company Case

...Aurora Textile Company Case Abstract In January 2003, Michael Pogonowski, the chief financial officer of Aurora Textile Company, was questioning whether the company should install a new ring-spinning machine, the Zinser 351, in the Hunter production facility. This new machine has ability to produce a finer-quality yarn that would be used for higher-quality and higher-margin products. In deciding whether or not to invest this new machine, NPV and the payback period are critical factors. Firstly, we need to forecast the cash flows that the Zinser 351 will generate in the future. After calculation, the ten-year NPV will be $3, 172,582. Secondly, we use the payback period to analyze the acceptance of this project. Based on this analysis, Aurora Textile Company should invest this new machine because of the positive NPV and relatively small payback period, which we will analyze in the following discussion. Analysis In this analysis, we determined that NPV is the critical factor determining whether the company should invest or reject that new project. Secondly, we established that the payback period is another contributing force in our decision. The payback period tells us whether we can earn some money in the set period of time but this model has a few drawbacks, such as ignoring timing of cash flows and the positive cash flow after the payback period. In both calculations, NPV and payback period, we forecasted future cash flows. Cash flow from investing in the......

Words: 940 - Pages: 4

Textile Company

...Beauregard Textile Company By D. Srinivas, Greatlakes , Chennai 8098663752 1 Market Share Analysis Quarter 1988 1st 2nd 3rd 4th 1989 1st 2nd 3rd 4th 1990 1st 2nd 3rd 4th Price 3 3 3 3 3 3 3 3 4 4 4 4 B Volume Price 124870 126016 125426 198863 575175 127201 125277 126124 125302 503904 74860 77216 75000 3 3 3 4 3 3 3 3 3 3 3 C&P Volume Total Vol 100000 224870 100000 226016 100000 225426 25000 223863 325000 900175 100000 227201 100000 225277 100000 226124 100000 225302 400000 903904 150000 224860 150000 227216 150000 225000 M/share B C&P 55.5% 44.5% 55.8% 44.2% 55.6% 44.4% 88.8% 11.2% 63.9% 36.1% 56.0% 44.0% 55.6% 44.4% 55.8% 44.2% 55.6% 44.4% 55.7% 44.3% 33.3% 66.7% 34.0% 66.0% 33.3% 66.7% market shrinkage 180000 100107 79893 2 Profit Analysis if B alone increase the price Quarter 1988 1st 2nd 3rd 4th 1989 1st 2nd 3rd 4th 1990 1st 2nd 3rd 4th Price 3 3 3 3 3 3 3 3 4 4 4 4 Beauregard Volume cost profit Price 124870 3.31 -38709.7 126016 3.31 -39065 125426 3.31 -38882.1 198863 3.102 -20284 -136941 127201 3.31 -39432.3 125277 3.31 -38835.9 126124 3.31 -39098.4 125302 3.31 -38843.6 -156210 74860 3.96 2994.4 77216 3.96 3088.64 75000 3.96 3000 75000 3.96 3000 12083.04 3 3 3 4 3 3 3 3 3 3 3 3 0 C&P Volume cost 100000 100000 100000 25000 100000 100000 100000 100000 150000 150000 150000 150000 0 0 Profit -57400 -57400 -57400 -71525 -243725 -57400 -57400 -57400 -57400 -229600 -20400 -20400 -20400 -20400 -81600 3.574 3.574 3.574 6.861 3.574 3.574 3.574 3.574......

Words: 677 - Pages: 3

Aurora Textile Company

...Case Study 4 Stephanie M. Clark Capella University Aurora Textile Company was established in the early 1900s as a yarn manufacturer. The company focused on four major customer segments, which were hosiery, knitted outerwear, woven and industrial and specialty products. Aurora Textile Company grew to become the leader in the textile-mill industry. In more recent years, changes in the market led to significant declines in financial performance for both Aurora and the U.S. textile industry over the last four years. The globalization of the textile market and the lure of cheaper production costs overseas led manufacturers to relocate to Asia. Also, the strength of the U.S. dollar made foreign produced textiles more affordable than domestically produced textiles. Additionally, the World Trade Organization (WTO) banned its members from using quotas, which further opened the market for competition. The negative financial impact of these changes in the textile industry required Aurora’s leadership to analyze the competitive strategy of the organization and to make recommendations to improve its financial performance. Aurora’s leadership identified the purchase of a new, ring-spinning machine, the Zinser 351, as one solution to improve its current financial performance and competitive position (Bruner et al., 2014). This purpose of this paper is to make a recommendation either to upgrade or to not upgrade the ring-spinning machine. First, this paper will analyze the impact of......

Words: 1210 - Pages: 5

Aurora

...strategies as well as acquisitions and mergers to become the number one global pharmaceutical company. The organization’s SWOT analysis (Thompson & Strickland, 2013) showed its strength in being innovative, opportunities to create more products, weakness in its dependence on successful products, and threats in generic competition and regulatory laws. The company’s corporate culture, strategic innovative through the top-down leadership approach, a unified tagline “OWN IT!” (Pfizer, 2013), and a strategy map demonstrates that all employees are ultimately responsible for their individual roles to drive success throughout the organization. Additionally, this paper will present a student created strategy map identifying areas the organization reports on annually. Theory Definitions Thompson and Strickland (2013) define that growth strategies arise when an organization utilizes its strength, weakness, opportunities, and threat (SWOT) to create a competitive advantage with customers, products and location. Pfizer’s SWOT analysis shows strong ground for continued growth with customers and products thus minimizing competition. However, with patent expirations and government regulations preventing the release of new products, the organization faces challenges to timely capture the market. Pfizer’s SWOT Analysis (Pfizer, 2013) Innovation theory define when new or existing, large or small companies, individuals or groups identify, create and market new or existing products......

Words: 4579 - Pages: 19

Auroa Textile

...– both expenses • SG&A Exppenses o Net sales * 7% (given) • Depreciation & Amortization o Cost of the new machine 852,000,000 / 10 years o 825,000 • Operating profit o Gross margin – expenses- dep & amort • Income Tax Provision o EBiT * 36% tax bracket • Net Income o (Operating profit- income tax) + dep Recommendations The U.S. textile industry is going through a tumultuous time, and most companies are experiencing losses. However, as the industry evolves Aurora Textile Company needs to innovate to stay competitive. The industry is moving toward demand for a higher quality product, and Aurora cannot afford to fall behind. The Zinser machine will help Aurora meet this demand. Taking all of this into consideration Aurora should invest in the project. In addition to accepting this project, falling spot prices for cotton could be beneficial to Aurora Textile Company in the future. However, the company also needs to implement other strategies to improve their profit margins, including reducing operating costs and appropriately managing inventory and account receivables. These changes will help Aurora move in the right direction to ensure that they are not forced to shut down operations in the foreseeable future...

Words: 486 - Pages: 2

Aurora Textile Company

...CASE 21: AURORA TEXTILE COMPANY Q1. How has Aurora Textile performed over the past four years? Be prepared to provide financial ratios that clear present a clear picture of Aurora’s financial condition? A- From 1999 – 2002, Aurora Textiles Company’s financial performance was unappealing and disheartening. Like many of its competitors, Aurora had been struggling financially. The company had not responded quickly to the deteriorating business environment, and had suffered consecutive losses for the past four years. Figure 1: Net Earnings of Aurora Textile Company (1999-2002) The graph above shows the net earnings of the company from 1999-2002. As we see, throughout the years, the net earnings have declined and resulted in a loss, especially in 2001. This could be attributed to the business risks that arose from the intense competition that characterized the industry in which Aurora operates. Moreover in January 2005, the US textile industry experienced intense competition when the WTO lifted the ban on quotas, which worsened Aurora’s financial condition and its credit rating of BB. The main reason for the decline in net earnings was due to the textile industry facing difficult circumstances. Figure 2: Financial ratios (1999-2002) The above table shows the financial ratios of the company from 1999-2000. Measures of probability have worsened during these years as ROA and ROE have been declining. Net sales have been steadily declining which led to management’s...

Words: 1661 - Pages: 7

Aurora

...Case Questions 1. How has Aurora Textile performed over the past four years? Be prepared to provide financial ratios that present a clear picture of Aurora’s financial condition. From 1999 through 2002, the financial performance of Aurora was unattractive and disheartening. This could be attributed to the business risks that arose from the intense competition that characterizes the industry in which Aurora operates. Absent an industry benchmark or comparable with which to gauge the performance of Aurora, we utilized a trend analysis of the period 1999 through 2002. With 1999 as a reference point, we noticed that all measures of profitability have worsened. On a cumulative annual basis, net sales have been declining by 15%, while profit margins and ROA were always in the negative (see exhibit 1). While raw material cost as a percentage of net sales have been declining, the cost of conversion is escalating and affecting the bottom-line (see exhibit 1). It is obvious that Aurora needs to manage its expenses to generate profits from sales. While on the surface, the liquidity measures have improved (see exhibit 1), it is doubtful that the company has the ability to meet its current obligations with just cash and cash equivalents on hand. This is partially due to the fact that many of the firm’s current assets are predominantly account receivables and inventories. While it is true that the firm, its competitors, and the industry are continuing to lose money, an effective......

Words: 1937 - Pages: 8

Aurora Textile

... Aurora Textile is a problem where they only have two option, which is to buy the Zinser 351 or to use the older generation machine from past decade. The problem is much more severe when faced with the fact that Aurora have been on loss for four years now, coupled with more and more textile industry moving their operation to overseas. 1. If Aurora Decided to stick with their old machinery If Aurora decided to stick to their old machinery, First off they current book value of the machine is $ 800,000 (from data given). Taken into account the sales growth (2%) and volume (1%) next year, combined with the current selling price of $ 1.0235 per pound means annually the old machine will produce $ 511,750 (not taking account returned goods), while for the next four years consequently it will produce $ 516, 867.5, $ 522,036.175, and $ 527, 256.537. The current book value of machine of $800,000, coupled with $200,000 for the remaining of four years of usage (then it will be free of depreciation), means taking NPV of Hunter Plant is estimated to be $ 8.9 million. 2. If Aurora Decided to Invest in Zinser 351 Machine If Aurora decided to invest in new machine, at first they will need an initial investment of $8.25 million (from total capitalized cost), plus, Aurora have spent $ 5,000 on engineering test, $ 15,000 market research, and additional $50,000 for one time employee training. The effect on investing on Zinser, is that they will be reduction in conversion cost of Hunter......

Words: 405 - Pages: 2

Textiles

... It   drives  every  aspect  of  our  business  -­‐  from  leading  innovative   technologies,  to  developing  path-­‐breaking  products,  to  fostering   sustainability.     Business  Scenario     As  you  are  all  aware,  India  has  emerged  as  a  significant  player  in  the   textiles  sector,  and  is  currently  ranked  as  the  second  largest  exporter  of   textile  products  behind  China.  As  I  mentioned  in  my  last  year’s  address,   certain  structural  changes  are  taking  place  in  the  industry,  which  are   helping  India  improve  its  competitiveness  and  market  share  in  the   global  arena.  We  are  thus  seeing  more  and  more  clients  increase  their   sourcing  pie  of  textile  and  apparel  from  India.  In  home  textiles,  the  India   advantage  has  been  even  more  prominent  and  I  believe,  things  are  only   going  to  get  better  in  the  coming  years  for  the  industry.     At  Welspun,  we  continue  to  be  a  supplier  of  choice  for  our  clients  as   evidenced ......

Words: 3333 - Pages: 14

Aurora Textile Company

...AURORA TEXTILE COMPANY KEUANGAN PERUSAHAAN LANJUTAN Tugas Disusun oleh Audrya Puspita (1306415024) Joddy Eka Negara (1306395350) Richie Wibisono (1306408675) FAKULTAS EKONOMI DAN BISNIS UNIVESITAS INDONESIA Depok 2016 AURORA TEXTILE COMPANY Aurora Textile Company merupakan sebuah perusahaan tekstil yang memproduksi benang yang telah berdiri lama sejak awal 1900-an di Ameika Serikat. Pada Tahun 2003, Michael Pogonowski sebagai CFO Aurora Textile Company mempertimbangkan tentang pengadaan mesin baru ring-spinning Zinser 351 untuk menggantikan mesin lama yang telah ada sejak tahun 1997 di Hunter. Penggantian mesin baru tersebut diperkirakan dapat memberikan banyak kemajuan bagi perusahaan karena selain mesin tersebut dapat membuat produktivitas meningkat, keberadaan mesin tersebut juga dapat memberikan hasil produksi benang yang lebih berkualitas. Dengan meningkatnya kualitas produksi, maka akan menyebabkan harga benang yang dijual akan naik sebesar 10%, yaitu $1.0235 per pon. Selain itu, mesin tersebut juga mampu membuat biaya operasi dalam produksi menjadi lebih efisien karena adanya penurunan biaya operasi seperti penurunan konsumsi tenaga pembangkit dan biaya perawatan karena perusahaan menggunakan mesin rotor-spinning dan ring-spinning. Pengambilan keputusan untuk melakukan investasi pada mesin Zinster 351 berdampak pada jumlah penjualan yang akan turun sebesar 5% dari pasar tahun berjalan. Selain itu, hal tersebut juga akan berdampak pada kemungkinan terjadinya......

Words: 898 - Pages: 4

Aurora

...Case #16 The Boeing 7E7 Synopsis and Objectives In 2003, the Boeing Company announced plans to build a new “super-efficient” commercial jet called the “7E7” or “Dreamliner.” This was a “bet the farm” gamble by Boeing, similar in magnitude to its earlier introductions of the 747 and 777 airliners. The technological superiority of the new airframe, as well as the fact that it would penetrate a rapidly growing market segment, were arguments for approval of the project. On the other hand, the current market for commercial airplanes was depressed because of terrorism risks, war, and SARS, a contagious illness that resulted in global travel warnings. Boeing’s board of directors would need to weigh those considerations before granting final approval to proceed with the project. The task is to evaluate the 7E7 project against a financial standard, the investors’ required returns. The case gives internal rates of return (IRR) for the 7E7 project under base-case and alternative forecasts. We must estimate a weighted-average cost of capital (WACC) for Boeing’s commercial-aircraft business segment in order to evaluate the IRRs. As a result of that analysis, we will identify the key value drivers and distinguish, on a qualitative basis, the key gambles that Boeing is making. The need to estimate a segment WACC draws out our abilities to critique different estimates of beta and to manipulate the levered-beta formulas. Boeing competes in both the commercial......

Words: 448 - Pages: 2

SAFARICOM (4) | education is important - 277 Words | Gorgeous