...Advertisement 6Surf Excel’s Advertisement(Brother & Sister Duo) Hindustan Unilever Limited introduced Surf in 1959, introducing the first detergent powder into the country. At the time, housewives used laundry soap bars to washclothes. Surf offered them significantly better clean, with much less effort. The promise of ‘superlative whiteness’ – the articulation of a great clean at the time, connected with consumers and helped to establish the brand. Surf was the first national detergent brand on TV; the brand used TV to effectively educate their consumers on how to use detergent powders in a bucket for a better wash. Surf Excel made a big “splash” with their “Daag Achhe Hain” advertising campaign. The following is an analysis of the first such commercial. The advertisement features a brother and sister duo walking home from school, when the little girl falls into a puddle of mud. Crying, she looks to her brother for help. Her brother gets an idea and starts “beating up” the puddle of mud, demanding an apology. After a time and a lot of mud on his uniform, he stands up and says, “Sorrybola.” The narrator then removes all apprehensions of dirt and stains and says, “Daag Acche Hain.”This advertisement is universally well-loved. This is so because it does a lot of things right. It makes use of children’s appeal to get the advertising message across.The advertisement does what seldom others do cater to the emotions and sentiments of the viewers – and succeeds with it. Not...
Words: 599 - Pages: 3
...Hossain |2009-2-10-344 | |Md. Towhidur Rahman |2009-1-10-152 | Principles of Management Course Code: Mgt101 SUBMISSION DATE: 11August, 2010 East West University Transmittal Message 16 August 2010 Course Instructor, Dr. Nazrul Islam, MGT-101, Sec-2, Principles of Management East West University. Subject: Letter of Transmittal. Dear Sir, With great pleasure we submit our project report on “Analysis of Planning for Surf Excel in Bangladesh” that you have assigned to us as an important requirement of the MGT-101 course. We have found the study to be quite interesting, beneficial and insightful. We have tried our level best to prepare an effective and creditable report. We honestly hope that our analysis will help to give idea of management planning of a business in the real world. We hope you will find this report worth all the labor we have put in it. Yours Sincerely, Md. Towhidur Rahman Jaheda Sultana Md. Tanvir Hossain Table of contents: Acknowledgement …………………………………………………….5 Executive summery……………………………………………………6 Introduction……………………………………………………………7 Objectives……………………………………………………………...8 Research...
Words: 4674 - Pages: 19
...Party Plates Database Integration Proposal As Party Plates continues to experience unprecedented growth, we realized that we must maximize the efficiency of our operation. In an effort to deliver the highest level of customer service, and remain competitive in the retail market, Party Plates sales and accounting team conducted an efficiency study of the operation and the systems that support it. As a result of this analysis, we found that there was a need to upgrade our current sales and inventory tracking system. We are proposing that we transition from our current Microsoft Excel database to relational database software, Microsoft Access. Additionally, we will need to integrate collaborative software such as Microsoft SharePoint in the near future to best maximize the effectiveness of our new database. As you know, we currently use Microsoft Excel to track our inventory and sales. Excel has been an effective management tool in the past; our current needs demand a management system that can manage multiple tasks with multiple users. Currently, we have many spreadsheets that in general do not merge or allow us to produce appropriate reports and can only be used by one person at a time. As our business grows, so will our staff and we will need to have a system that is multifunctional for many users. Microsoft Access is a relational database system, which is capable of managing customers, suppliers, products and orders. It also will also allow us to create a variety of forms...
Words: 734 - Pages: 3
...a key parameter in the Capital Asset Pricing Model (CAPM) which is most commonly used asset pricing model for the estimation of required rate of returns on a share (i.e. cost of equity=rE). This assignment consists of two parts. Part I directs you to work with real financial data in Excel and aims to take you through the basic exercise of estimating a company beta and computing statistics which can be evaluated as part of investment decision-making process. Part II requires you to write a report based on interpretations of the outputs obtained from the first part. In this manual, you will also find out how to download historical share price, market index data and interest rates from the web portal. ➢ Details of Questions PART 1 [30 marks] To successfully complete PART 1, please read each section carefully. You must read “Format and printing requirement” before you produce any outputs. I also encourage you to read the entire manual before you choose your companies for analysis. If you have read “Format and printing requirement”, then proceed. Provide your answers (or outputs) for the following questions. All the calculations and computations are required to be produced in Excel (This manual has been designed for you to do this assignment using...
Words: 3262 - Pages: 14
...Spreadsheet Modeling Assignment 1. Objectives The purpose of this assignment is to use some of the more advanced tools that Excel provides to develop a model of a complex business problem. In particular, you will use the following Excel features: 1. Importing data from text files 2. Sorting data 3. Database functions 4. Pivot Tables 5. Data Tables 6. Goal Seeking 2. What You Will Need 1. Access to a computer with a printer and Excel 2007. 2. Note that the instructions in this handout are written for Excel 2007. There are significant differences in user interface between Excel 2007 and 2003. 3. Download the following three files: Mymodel.xls, labor.txt, and demand.txt. 3. What You Will Hand In 1. a CD containing the model your group develops - on the outer label, write the course number, group number, the name of each group member 2. two full-page charts (with your course number and group number as a footer) 3. four worksheet printouts (with your course number and group number as a footer) 4. Make sure your CD is free of any computer virus. A contaminated CD will result in a 50% penalty in grade! 4. Due Date Check the course syllabus for assignment due date. A penalty will be assessed against assignments handed in late (including during class). 5. Background You work for the NOVA Corporation, a mid-tier supplier of hoses and hose assemblies...
Words: 4251 - Pages: 18
...COMM 491 Summer 2015 Team Presentation 1 Industry Analysis Presentation Due: Wednesday, July 29, 8:30am; submitted via email to bernie.maroney@sauder.ubc.ca , and presented in class Format: Presentation: 10 minute in-class presentation of your industry analysis; I would recommend no more than 15 slides (aside from the opening slide and a “thank you/ questions” slide). Each member of your team must be present and must contribute to the presentation, unless other circumstances prevent. Worth 10% of your final grade. Please, no “Presi,” we’re all sick of it, and it isn’t “cool” anymore. Filename protocol: In order to distinguish your file from every other groups, you must name your submitted file as such: COMM491-VSP_Summer2015_IndustryAnalysis_Cohort#_Team# , where Cohort# is either Cohort4 or Cohort 5; and Team# is your team number, such as Team2. Topic: Each team must perform an industry analysis on one of the following industries: * Craft or micro-breweries in B.C. * Food trucks in Vancouver * The cleantech industry in Canada * Private tourism agencies in Canada catering to Chinese tourists. Thus you have different geographic areas to also consider; you must choose your topic and post it on the discussion forum on Connect no later than 1700hrs on Sunday, July 26. No more than three teams in each cohort may choose the same topic. Assignment: Suppose that your team is thinking of starting a new business in the industry chosen. Using Porter’s Five...
Words: 1010 - Pages: 5
...we discussed the power of wireless devices, delved further into information systems, discussed protection of information assets, and probed some of the functions of Microsoft Excel as an office automation tool. We utilized two sources of readings from chapters in Introduction to Information Systems and Microsoft® Office 2010. We also participated in peer to peer discussions to evaluate our understanding of the subject matter. Wireless Technology Many of the wireless technologies today are well known and understood from an operator standpoint. That comes from the common necessity of technology in our daily lives. What are not so well known are the associated security concerns that come with operating on a wireless platform? This week we touched on the threats that encompass these technologies. Information Systems We briefly touched on and broad stroked information systems in week one. This week we began a more in-depth review of some of these systems. In particular we examined Transaction Processing systems and Expert Systems which utilizes artificial intelligence to assist in the decision making process within the functional areas of an company. We also read and discussed data mining and data analysis. That discussion facilitated our understanding of when it is best to utilize Microsoft Excel and when to opt for Microsoft Access. Protecting Information Assets This week in our technology review we discussed actions that could be taken to protect our information...
Words: 466 - Pages: 2
...ME Analysis Project #2 Christian Seymour Due Date: December 12, 2013 Abstract: The diameter for my shaft design was hand calculated to be 0.8756” for a factor of safety or 2. This factor of safety was expected to be the outcome in FEA SolidWorks and it was not. The reason for this is simply SolidWorks is not the best tool to use for complex designs and loads as ours was. It worked great for the simple beam deflection in the last project. Many times hand calculations are the long way of doing things. In this case, it took much longer to figure out the correct way of adding fixtures, load, and connections in SolidWorks. Many of the material properties in SolidWorks are also not the same as they are in our book. Simply said, choosing which method to use is the hardest decision to make. Sometimes FEA analysis is better, and in some cases, hand calculations are the easiest. Background: We have been given the task to design a shaft to specific guidelines using inch size pillow blocks. We will perform appropriate calculations using modeling techniques and verify the design in SolidWorks FEA program. The problem is 7-5 in the book and is shown below: The problem statement: A geared industrial roll shown in the figure is driven at 300 rev/ min by force F acting on a 3-in-diamter pitch circle as shown. The roll exerts a normal force of 30 lbf/in of roll length on the material being pulled through. The material passes under the roll. Design a shaft for the situation...
Words: 856 - Pages: 4
...Instructions- 1. There are 2 deliverables for this assignment- a) An excel file with the necessary computations. b) A word doc with the corresponding explanations. (For the question involving macro, a separate file could be submitted. However, a single excel file is preferred). 2. Solve each question in a separate sheet in one excel file. 3. You’re required to state all your assumptions in the first sheet of the excel file. These assumptions should be written for all the sub-parts separately, however in the same sheet, wherever applicable. 4. Maintain uniformity in structure and formatting. The assignment would be penalized for lack of hygiene. 5. Name all your sheets appropriately. 6. Naming Convention for the file Name_Roll_No_Section.doc/.xls. Example- Hermione_Granger_91023_G.xls Assignment- i) Use column V to create a new character variable of length 10- ABCDEFGHIJ where AB=Region, CD=Province, E=Product Category, FG=Customer Segment, H=Ship Mode, I=Order Priority, J=Product Container. (You’re free to use your own nomenclature. Specify the same in the assumptions sheet. Eg- Use initial 1(or 2) characters of the corresponding variable.) ii) Summarize the data using a pivot table by region and province. Subsequently, find the province with highest profit per shipment and highest profit per Unit. iii) Create a pivot table where you provide a summary of sales, cost and profit statistics. How will you summarize? State the variables used...
Words: 607 - Pages: 3
...set for the study is a sample of a survey conducted on the population of the American Intellectual Union (AIU). It is available via the following link: Excel 2007 DataSet with DataSet Key which contains the following nine sections of data that will be used throughout our course: Gender Age Department Position Tenure Overall Job Satisfaction Intrinsic Job Satisfaction—Satisfaction with the actual performance of the job Extrinsic Job Satisfaction—external to the job, for example, office location, your work colleagues, your own office (cubicle/hard walled office, etc), Benefits—Health insurance, pension plan, vacation, sick days, etc. In the first assignment you are to complete the following: You will need to examine two of the nine sections of data: one section of qualitative data (choose either Gender or Position) one section of quantitative data (choose either Intrinsic or Extrinsic) Each section should include all data points listed in the column for the variable. The requirements include: Identify the data you selected. Explain why the data was selected. Explain what was learned by examining these sets of data. Your analysis should include using Microsoft Excel to obtain information about the data through the use of three measures of central tendency (mean, median, mode). Your analysis should also include the use of two measures of variability (standard deviation and variance). Some measures are appropriate for qualitative data, and some...
Words: 708 - Pages: 3
...questions. The sample technique was stratified random sample. Total 100 respondents from Dhaka city where taken for this research. Based on their answers the analysis has been made. The sample size is divided in to five (5) sub-categories namely student, housewives, working class, agency personnel, and lastly the Robi employees. Microsoft excel 2003 software was used for all sorts of calculation and graphical representation for the research. Based on the calculation all sorts interpretation and recommendation was given at the end. Each of the questions has its own calculation and diagram in this research paper. The literature review part was full of secondary information about the research. The terminological definition, explanations of the terms and detail of the departments are clearly described in this part of the research. In addition, company background part is added just for the readers to know more about the company and also the detail of the department of PR & communication. There are mainly nine activities that are taken care by the PR & communication department. Each of the categories are explained and ranked based on their importance after analyzing the questionnaire. Activities like TV, outdoor, press & publications are the most talked about in this research. Least but not the last, based on the analysis recommendations are suggested for the PR...
Words: 326 - Pages: 2
...Database Analysis Lance Washington CIS/207 October 17, 2011 Andrew Nash Database Analysis A group of logically related files that stores data and the association among them is called database. To be able to analysis these files, software must be provided. For an operation management major, they must be allowed to access organizational data to determine optimum inventory, knowledge of scheduling their employees, access to ordering product for the store needs, and access to reports to obtain labor and cost control (Rainer Jr. 2011). There are many organizations that use database to operate their business. Microsoft, Access, DB2, and Oracle are a few database applications available to effectively absorb data. Microsoft is user friendly. It provides the user with the necessary tools to run a successful business. One organization that uses Microsoft is Arby’s. The operational manager at Arby’s organization is responsible for many positions in this company. They must be able to make a schedule, order product, provide reports, and control operations. With Microsoft application, the operational manager is capable of performing his or her duties. Microsoft provide applications for Arby’s organization called menu link and aloha. Menu link is an application to help the operational manager provide cost and labor reports. The labor management uses POS data to store sales in order to make a schedule. The operation manager inputs the amount of sales use for each day to receive...
Words: 469 - Pages: 2
...Kudler Fine Foods is a company that has grown since the initial opening in 1998, and to manage with the growth Kudler selected Microsoft Access as the database to help track inventory, sales, orders, employees, and customers. Kudler’s inventory consist of perishable products, therefore inventory needs be accurately tracked. This paper will evaluate the design elements of the data tables from an accounting perspective, create an entity relationship diagram including a pivot table, recommend improvements to the data tables, and explain how the new diagrams will improve Kudler’s decision making for management. Table Analysis The data table analysis is vital to Kudler’s success. The data is organized into general ledger codes, inventory item, summary line item, and the total amount of the item’s transaction. The data provided in the analysis table, which are viewed by the users, shows how much money is spent on what product and which store. The description of the data table gives the total amount and quantity on hand for an item and calculating average price for an item. From an accounting perspective, the data tables are simple and easy to read. There are four headings. They include the GL Code, inventory item, summary line item and the amount. The GL Code helps to identify which store the item is located. For example, 12 stands for La Jolla, 13 identify the store in Del Mar, and 14 identify the Encinitas store. The inventory items identify what items are in the inventory. At...
Words: 567 - Pages: 3
...1 Microsoft Excel 2010 Tutorial Excel is a spreadsheet program in the Microsoft Office system. You can use Excel to create and format workbooks (a collection of spreadsheets) in order to analyze data and make more informed business decisions. Specifically, you can use Excel to track data, build models for analyzing data, write formulas to perform calculations on that data, pivot the data in numerous ways, and present data in a variety of professional looking charts. The Ribbon Understanding the Ribbon is a great way to help understand the changes between Microsoft 2003 to Microsoft 2010. The ribbon holds all of the information in previous versions of Microsoft Office in a more visual stream line manner through a series of tabs that include an immense variety of program features. Home Tab This is the most used tab; it incorporates all text and cell formatting features such as font and paragraph changes. The Home Tab also includes basic spreadsheet formatting elements such as text wrap, merging cells and cell style. Insert Tab This tab allows you to insert a variety of items into a document from pictures, clip art, and headers and footers. Page Layout Tab This tab has commands to adjust page such as margins, orientation and themes. Created By: Amy Beauchemin Source: office.microsoft.com 1/13/11 2 Formulas Tab This tab has commands to use when creating Formulas. This tab holds an immense function library which can assist when creating any formula or function...
Words: 7496 - Pages: 30
...BSA375 July 31, 2014 Daniel D'Urso Riordan Mfg. SR-rm-002 Riordan Manufacturing has an established computer system which was installed in 1992 and is more of a financial system. This system keeps track of personal information, pay rate, tax exemptions, hire dates, seniority dates, organizational information, and vacation hours for the employee. Conducting interviews to get a better understanding of operations and establish objectives for the human resource system to implement. Questionnaires and surveys can be sent to several individuals to assist with the research and observation process. With the lack of an automated HR system, employee changes are submitted in writing to their manager and then manually entered by a clerk. The use of excel spreadsheets is good, but a more sophisticated system is needed in place for office efficiency and time saving efforts to allow for job focus. Riordan Manufacturing has an outsourced workers’ compensation third party which keeps its own records. The current system lacks a central employee database the managers that are keeping their employee records locked in their offices is not taking advantage of the current IT tools and systems available. Riordan Manufacturing project goals should include a Human Resource Information System with some training of the new system for HR members and interview to discuss what is needed and would work for them to better customize the new program. The technical feasibility would not be difficult to acquire...
Words: 303 - Pages: 2