...10 Creating Charts and Graphics In this chapter, you will learn how to ✔ Create charts. ✔ Customize the appearance of charts. ✔ Find trends in your data. ✔ Summarize your data by using sparklines. ✔ Create dynamic charts by using PivotCharts. ✔ Create diagrams by using SmartArt. ✔ Create shapes and mathematical equations. When you enter data into a Microsoft Excel 2010 worksheet, you create a record of important events, whether they are individual sales, sales for an hour of a day, or the price of a product. What a list of values in cells can’t communicate easily, however, is the overall trends in the data. The best way to communicate trends in a large collection of data is by creating a chart, which summarizes data visually. In addition to the standard charts, with Excel 2010 you can create compact charts called sparklines, which summarize a data series using a graph contained within a single cell. You have a great deal of control over your charts’ appearance—you can change the color of any chart element, choose a different chart type to better summarize the underlying data, and change the display properties of text and numbers in a chart. If the data in the worksheet used to create a chart represents a progression through time, such as sales over several months, you can have Excel extrapolate future sales and add a trendline to the graph representing that prediction. Just as you can create a PivotTable dynamic view to reorganize your data dynamically, you can create...
Words: 8094 - Pages: 33
...3/29/2014 1 CIO Organization Memo Before you begin this assignment, be sure you have read the “Wobbly Wheels Case Study,” as well as Chapter 21, Service Management, and Chapter 22, Balancing IT’s Workload. You will also need to review any feedback you received on your IT Strategic Plan assignments. Purpose of this Assignment This assignment gives you the opportunity to apply the course concepts to address the organizational changes needed to evolve the information technology (IT) department into a true CIO organization to support the Wobbly Wheels Distribution Company (WW). This assignment specifically addresses the following course outcome to enable you to: explain the roles and responsibilities of an information technology department to support an organization’s IT strategy CIO Organization Memo For this assignment, you will assume the role of the Chief Information Officer (CIO) at WW (i.e., you are Carol). Since you are WW’s first CIO, the Chief Financial Officer (CFO) has asked you for a plan for the organizational changes you need to make. One of the first things you realize is that the organization that exists is just an ‘IT Department’ and you know that what WW needs, and has hired you to do, is to create an organization that fulfills the broad responsibilities of a Chief Information Officer. You know that your proposal needs to be convincing to the CFO in order for you to get the resources you need. Assignment You will develop a memorandum addressed to the CFO...
Words: 3089 - Pages: 13
...1/ ORGANIZATIONAL STRUCTURE• Job Descriptions • MEMBERSHIP AND VOLUNTEERS • Series 1 Relationships • ORGANIZATIONAL AUTHORITY • Structure • DEVELOPMENT Module 2 Organizational Structure MODULE Organizational Structure Introduction Types of organizational structures Organizational growth stages and their structural impact So you still want to change your organization’s structure Preparing a memorandum for structural change Remember ……. An organogram illustrates Jobs descriptions Organizational relationships Organizational types and functions Managing members and volunteers 1-2 3 6 8 9-10 1 1 12-16 17-19 20 21-22 Table, Figures and Exercises Figure 1: Figure 2: Figure 3: Figure 4: Figure 5: Figure 6: Exercise Figure 8: Structure of a traditional, hierarchial organization Team structure A network structure Characteristics of organizations at different stages of growth Growth structure Model organogram (consolidation or mature structure) Reviewing job descriptions … Formal and informal organizational relationships 3 4 5 7 1 1 12-18 1 7 18 v Introduction Every program manager should be concerned about organizational structure, but it is often the last thing on his or her mind. An effective structure facilitates management and clarifies relationships, roles and responsibilities, levels of authority, and supervisory or reporting lines. By reviewing an organization’s structure, a manager will be able to determine which human, financial, and technical resources are available...
Words: 6346 - Pages: 26
...Organizational Structures After reading this chapter, you should be able to discuss: ■ The differences between line and staff positions as shown on organization charts. ■ How an organization chart is structured showing the lines of authority. ■ The different types of organizational structures presently used by retailers. ■ The beginnings of organization structuring for large department stores and how they have changed to suit today’s companies. ■ Reasons why chain organizations conduct their businesses as centralized op- erations. ■ Why some chains have decentralized some of their functions. ■ Reasons for separating the buying and selling functions. Once the decision has been made to begin a retail venture, it is necessary to plan its organ- izational structure in a way that maximizes efficiency and profitability. All of the duties and responsibilities of those in the company must be identified, and lines of authority must be carefully delineated so that all members of the organization will understand what their job responsibilities are. By doing so, everyone knows who will report to whom, who the deci- sionmakers are, and which advisory personnel is on hand to assist in the decision-making process. No matter how large or small the operation, whether it is a major department store or single-unit boutique, each company must be structured in such a way that best serves its needs and makes the business a success. To clarify their organization’s structure so that all employees...
Words: 406 - Pages: 2
...eadBreadTalk Background In 2000, BreadTalk was founded and it has rapidly turned into a particular Singapore brand that has increased universal advance. It has set up its check on globally with its bread kitchen, eatery and nourishment chamber foot shaped impressions. Moreover, it has also opened nearly 1000 outlets with 7000 total employees around the globe such as Hong Kong, Middle East, Singapore and China. 1. Write the mission or purpose of the organisation is a few sentences. As stated in Company official site, their mission is “Leading a new lifestyle culture with new, innovative changes and creative differentiation to craft products with passion and vibrancy”(Breadtalk.com, 2015). Their mission clearly states that the company is always trying to bring and create new products. Hence, their main focus is on their products. 2. What are the specific tasks to be completed to accomplish the mission? BreadTalk may not seem like it has a complex or complicated business model; indeed, the company was designed to sell bread and pastries, and this is something that it has been doing with significant success in the Asian market for a number of years. However, there have been changes made recently, and the company is trying to take its business in a new direction (Breadtalk.com.sg , 2015). The company’s current tagline is “get talking” (Breadtalk.com.sg, 2015). George Quek, the Chairman of the BreadTalk group, writes “After 12 years and 3 generations on, Generation4...
Words: 1220 - Pages: 5
...questions can be directed to the course mentors at MBAOrgBehavior@wgu.edu. Thank you! A. Company Culture | | | | | (0) Unsatisfactory | (1) Does Not Meet Standard | (2) Minimally Competent | (3) Competent | (4) Highly Competent | The candidate does not provide a logical comparison of each company’s culture before the merger to the 4 types of organizational culture, using the Competing Values Framework. | The candidate provides a logical comparison, with no detail, of each company’s culture before the merger to the 4 types of organizational culture, using the Competing Values Framework. | The candidate provides a logical comparison, with limited detail, of each company’s culture before the merger to the 4 types of organizational culture, using the Competing Values Framework. | The candidate provides a logical comparison, with adequate detail, of each company’s culture before the merger to the 4 types of organizational culture, using the Competing Values Framework. | The candidate provides a logical comparison, with substantial detail, of each company’s culture before the merger to the 4 types of organizational culture, using the Competing Values Framework. | There are two components that should be included in your response to this prompt. First, you should categorize the symphony and the opera into one of the four cultures represented in the competing values framework (i.e. adhocracy, clan, market, hierarchy) and you should provide support from the case study...
Words: 3170 - Pages: 13
...Atha Coorporation’s Executive Plan Table of contents: Executive Summary……………………………………………………………………………………………….. 1 Description of functional area and purpose statement………………………………………….. 1 Goals and Activities…………………………………………………………………………………………………3 Organizational Structure………………………………………………………………………………........... 5 Interview Questions……………………………………………………………………………………………….. 6 Performance Standards………………………………………………………………………………………….. 6 Conclusion of Personal Insight………………………………………………………………………………… 7 Appendices…………………………………………………………………………………………………………….. 7 Human Resources SAW…………………………………………………………………………………………...7 Operations and Production SAW……………………………………………………………………………..12 Human Resources Organizational Chart…………………………………………………………………..17 Operations and Production Organizational Chart…………………………………………………….18 Executive summary: This project was organizing, planning, and developing both the HR functional area as well as the Operations and Production functional area. This consisted of revamping the Org chart to add the new employees, creating important interview questions for hiring new employees, and setting standards for each department. Along with these tasks, there was also creating a purpose for the department which is one of the most vital tasks of this project, without a purpose what is the department there to do? Description of the functional area and purpose statement. Human Resource As the Human Resource Department we strive to ensure that the Atha...
Words: 4590 - Pages: 19
...reorganize itself, including its legal or corporate structure to take advantage of existing or new tax regulations. A merger or acquisition of a company may result in a reorganization of the company ownership, equity structure, management, and operations to take advantage of the efficiencies of new management, new technologies, and new capital assets. Why It Matter Reorganization is an important step for a business since it has the potential to open up new opportunities, increase efficiencies and profits, and give legal and financial protection during difficult times. A company's organizational chart typically illustrates relations between people within an organization. Such relations might include managers to sub-workers, directors to managing directors, chief executive officer to various departments, and so forth. When an organization chart grows too large it can be split into smaller charts for separate departments within the organization.The different types of...
Words: 769 - Pages: 4
...thinks that the flow of their job would be natural and satisfying if the subordinates are not minding the positions of their bosses. The manager suggests that the Team Work must always be at the top and the organizational chart as a supplemental basis. Statement of the Problem Major problem: The major problem would be, Ms. Linda Ignacio and Mr. Johnny Ramos are not having the same perspective in running the company. Specific Problem.: 1. The president does not believe in the concept of the organizational chart. By that, the level of experience of each employee with a higher profile would be disregard. 2. Ms. Linda Ignacio does not completely obey the president’s mindset, that would result to an issue that could affect the business’ management. 3. The company is in the verge of collapsing due to having different point of view of the two sides. Objectives The objectives of putting Team Work at the top and Organizational Chart as a supplemental basis has its good and bad sides, here are those. 1. Team Work could give the employee their satisfactory and enjoyment in working. 2. It gives low profile employees to speak their opinions to the high profile ones. 3. Also, it makes the employees works in harmony and sync. 4. If the organizational charts are the priority, there would be an intimidation between co-workers. 5. z Areas of Consideration Mr. Johnny Ramos is compromising to the work of his employees while focusing on earning annual profit...
Words: 284 - Pages: 2
...check-in staff and engineers. Depending on how an airline is organized and on how much work it ‘contracts out’, it may also employ chefs, cleaners, telesales personnel, insurance experts and accountants. Some airline employees will spend nearly all of their time in offices, whilst others work in passenger terminals, cargo terminals or aircraft hangars. Somewhere behind the scenes there will also be a group of managers who make sure that the airline and its many operations run smoothly. All these people are of different nationalities. This case study shows how one large company, Singapore Airlines, organizes itself to make the most effective use of its resources, particularly its human and fiscal resources to achieve its organizational goals. Organizational Systems In the most efficient organizations, all employees should know and understand their role and how it fits into the work of the organization as a whole. They will also want to do the best that they can, not only in the interests of the organization that employs them, but also in their own interest. With such a large and diverse group of employees operating in widely differing working environments, giving each of them a sense of belonging to a community with a common goal is a...
Words: 2468 - Pages: 10
...are growth and expansion of their plants. Acne and Omega’s top managers have different opinion on how to achieve plants’ goals. President of Omega believe that; in order to reach efficient performance and high company profits, knowledge of employees for their responsibilities should be clear, and everyone should do their narrowly defined jobs following their organization charts and job descriptions. However, Omega’s president didn’t believe in charts because the organization was small enough for employees to communicate without written memos and etc. Moreover, he and his top management team believed that everyone should be familiar with activities throughout the organization so that interaction between the departments would increase. The goals of growth and expansion are to be achieved with different strategies. Acme will likely build embark on their expansion with a strategy that will put an emphasis on efficiency and specialization which will thus be in line with their “tight ship” philosophy. Omega strategy to achieving the goals will be one that puts great importance on innovation and their organizational structure allows for specialists freely flow within the organization this removing any barriers that may be encountered when they wish to collaborate with anyone in the organization. Part II. The organization Omega Electronics will produce better results. This is because Jim Rawls, President of Omega has an organic structure in which he his firms operates daily. This...
Words: 444 - Pages: 2
...Student Self-administered case study Organization structure changes at Body Shop 45-60 Case duration (Min): Organizational Behaviour (OB) Organization structure and design Worldwide Case summary: There are many work tasks to be done in a large organization and consequently the work must be divided up and allocated. In this case we consider what is meant by organization structure and design; consider why it is necessary to structure human resources, discuss how we should set about this enormous challenge and ask how we can make efficient and effective use of human resources in order to attain goals and derive a sustainable competitive advantage. In particular we consider issues associated with bureaucracy and hierarchy. Body Shop grew and with it came particular design challenges. Learning objectives: Define and discuss the nature of organization design. Outline the main structural choices available to organizations. Explain the limitations of the organizational chart in describing activity within an organization. Case problem: What is organizational structure and why do large organizations need continually to consider the designs of their organization? What may be the consequences of a good or bad design for a specific organization? Personal Products Company Body Shop www.thebodyshop.com Founded in 1976 by Anita Roddick, The Body Shop International plc, known as The Body Shop, has 2,400 stores in 61 countries, and is the second largest cosmetic franchise in the world...
Words: 4449 - Pages: 18
...quality can be seen in ancient civilization. Egyptian Pyramids and the Great Wall of China are the evidences from history. The concept of total quality was started back in 1920’s. In 1940, statistical techniques were used to check quality. In 1960 quality management became broader in meaning. In past decades quality management was limited to the production process but now quality control is concept taken as something to be applied in every line of business. Introduction: TQM is management approach to integrate all management activities or organizational function (engineering, finance, customer service, design, marketing, and production, etc.) to focus on meeting customer needs and organizational objectives by delivering high-quality products and services. TQM is a method in which management and employees work in the same line for continuous improvements in goods and services to meet customer expectation and to achieve organizational goals. The ultimate objective of TQM is to minimize defects. The Competition based on quality has grown up in recent years. Companies are focusing on quality improvement in every line of business in order to be more competitive. Companies who do not focus on quality will not survive. Companies took quality concept as a crucial to survive in the market. Features: 1-Customer Focus: The first and most important feature of TQM, on which it emphasis more is ‘Customer’. Company more focus on its customers. Customer focus means to focus on customer...
Words: 1853 - Pages: 8
...Controlling SAP ERP Course Overview ƒ FI Organizational Structure ƒ FI Master Data ƒ FI Processes ƒ FI Reporting ƒ Audit Trails SAP ERP Goal of Financial Accounting (FI) Financial Accounting is designed to collect the transactional data that provides a foundation for preparing the standard portfolio of reports. ƒ In general, these reports are primarily, but not exclusively, directed at external parties. Standard reports include: - Balance Sheet - Income Statement - Statement of Cash Flows SAP R/3 TYPICAL BUSINESS BLUEPRINT QTN VENDOR REQ FORECASTING PO CONTRACT GOODS RECEIPT INV VERIF AP BANK SALES PLANNING STOCKS MRP PL ANT MAINT. BOM WHAT TO DO GOODS ISSUE ASSET MGMT CASH FLOW COST CENTERS PAYROLL DEMAND MGMT ROUTINGS MASTER PLAN SCHEDULE CAPACITY HOW TO DO WHEN TO DO MANUF SHOP FLOOR FINAL INSP. STOCKS WORK CENTERS PRODUCT COST AR BANK GENERAL LEDGER SHIPPING MM FI CO CM AM SD PP PM HR BILLING PROFITABILITY ANALYSIS AV. CHK SALES ORDER AGREEMENT QTN CUSTOMER CR MGMT SAP ERP FI Organizational Structure ƒ epresents the legal and/or organizational views of an R enterprise Forms a framework that supports the activities of a business in the manner desired by management Permits the accurate and organized collection of business information Supports the development and presentation of relevant information in order to enable and support business decisions SAP ERP ƒ Client - FI Organizational Structure An independent environment in...
Words: 1247 - Pages: 5
...with cooperation with each department and proper data analysis and presentation, a spend analysis will be extremely beneficial in the long run. The following information describes what a spend analysis is, skills and tools needed for the data analysis, how a Six Sigma methodology will help with a spend analysis, and what makes up the analysis team who will work to create the spend analysis. What is a Spend Analysis Spend analysis is the application of quantitative techniques to purchasing data in an effort to better understand spending patterns and identify opportunities for improvement. This process involve collecting, cleansing, classifying, and analyzing the expenditures within an organization with the purpose of reducing procurement costs, improving organizational efficiency, and monitoring organizational compliance (Bozarth & Handfield, 2012). A spend analysis can be used to identify a number of different questions regarding where is the bulk of company spending, how much is the organization spending with their suppliers, and does the organization have certain spending patterns. The results of a spend analysis will allow an organization to have insight into where cost reductions can be made, where performance can be improved, and if there are need-compliance opportunities that the organization can take advantage of. Data Analysis Collecting the information for a spend analysis requires having a certain set of data analysis...
Words: 1298 - Pages: 6
