Ask Marketing Management Expert

Attempt all the problems.

Section-A

problem1) describe the following terms :

a) Distributed decision support systems and marketing information system

b) Functions of decision support system.

problem2) describe the international/multinational/global marketing information system model. Describe different problems inherent in the operation and coordination of a multinational /global marketing information system.

problem3) What is market Analytical system? List and describe different data mining tools and techniques used by this system for supporting marketing decisions.

problem4) “Marketing Intelligent System is not purely a computer-based system. It is a total system that incorporates human processes for interpreting and processing information into intelligence.” Comment on this statement.

Section-B

Case Study: BI Helps Allergan Monitor Sales Data

The 12-year-old Allergan India is the pharmaceutical which specializes in ophthalmic products. A joint venture between Allergan and Nicholas Piramal, Rs 100-crore company offers medication for conjunctivitis, dry eyes and glaucoma and has about 17 percent of Rs 430-crore Indian ophthalmic pharmaceutical market. Like other pharmaceutical business, Allergan knows significance of the extensive downstream strategy. It prides itself on having the largest reach in Indian ophthalmic industry with its network of 10,000 ophthalmologists. Company's primary points of sale are 18 clearing and forwarding agents (CFAs). From there products go to the distributor, and chain goes down a couple of tiers, to the wholesaler, retailer and chemist outlets. Between 900 and 1,200 distributors and about 1.2 lakh small distributors and stockiest constitute secondary sales.

This huge network creates plenty of scope for data inaccuracies. As the company grew, it became increasingly crucial to monitor parameters like DSO (Day Sales Outstanding), that is used to gauge performance of every division and DOH (the Day's On Hand), which is a measure of inventory. It was then that they realized there was the fair amount of inefficiency in the system. That's when we decided to introduce BI tracing the need for RUBIC (Re-usable Business Intelligent Components). The association with Rubik's cube is no accident. The cube represented the two things Allergan wanted from its IT team: a single version or block of truth and multiple sides to look at it.

Which is why like most companies, Allergan, choose to implement BI: to give business more actionable information. But, Allergan also required BI to create a platform that its executives can collectively work off. The year 2006 saw a decision to implement a BI solution that can throw up solutions to this problem. In 14 months, with Mindtree (who had helped build Empower) as their technology partner,

Rajan set up RUBIC. The tool had an SQL 2005 server at the backend and the extraction transformation loading (ETL) tool in the middle. ETL extracts and cleans data then coverts it into the standard format. It then puts data into the local ERP which feeds data warehouse. The warehouse is fed from various transactional level systems. A varietyof analytics, static and dynamic query capabilities were built on this. Reports are available through a presentation layer (on Windows Share Point), and allowed a comprehensive representation of various key business performance indicators.

His solution paid off in a big way. While the rest of the pharmaceutical industry grew between 5 and 6 percent in the last fiscal, Allergan India registered 20 percent growth. Rajan modestly acknowledged that some of that lead is thanks to RUBIC. It also improved company's day sales outstanding (DSO) and its inventory levels. Post-RUBIC, DSO levels dropped by 10 percent and Allergan achieved what few of its pharma peers have managed: it maintains an inventory of less than 20 days. The industry average, says Rajan, is about 45 days.

Figures aside, the biggest advantage RUBIC offers Allergan is the power of informed decision-making. "Earlier, a little bit of guesstimate and a little bit of gut feeling will have seen the decision through. Today, all decisions are data driven," Rajan says.

problem5) Case problems:

a) What are the different sources of data Allergan has? Why we could not use Marketing Information System for analyzing that data?

b) Describe how business warehouse can look at data from various dimensions, and generate as many reports as we want. Give an ex to support your answer.

c) What kind of various mining techniques could be used by Allergan to analyze sales data and what type of strategic decisions they could make.

Marketing Management, Management Studies

  • Category:- Marketing Management
  • Reference No.:- M93511

Have any Question?


Related Questions in Marketing Management

Question 1 application of conceptstime value of money2

Question: 1. Application of concepts/time value of money? 2. Which is more detrimental to a firm, pricing your product or service too high, or pricing your product or service too low? 3. Discuss the role of demographics ...

Question imagine that you are in the market for a new

Question: Imagine that you are in the market for a new career. How can the marketing research process apply to your career search? Think of a specific topic you need to learn more about that relates to your career as a o ...

Question strategic marketing planintroductionthis

Question: STRATEGIC MARKETING PLAN INTRODUCTION This assignment entails development of a comprehensive strategic marketing plan for a new product or service that is ready to "go to market". A Project Template is provided ...

Qestion ready set strive gen z is comingby janet adamy

Question: Ready, Set, Strive : Gen Z Is Coming By Janet Adamy | Sep 07, 2018 TOPICS: Consumer Behavior, External Marketing Environment, Targeting SUMMARY: About 17 million members of Generation Z are now adults and start ...

Question in your marketing plan you should1establish a

Question: In your Marketing Plan, you should: 1. Establish a Mission Statement and a Vision Statement for your new organization. 2. Briefly describe basic services it has been providing during the first six months of ope ...

Question 1review the terminal course objectives accessed by

Question: 1. Review the Terminal Course Objectives, accessed by clicking on the "Course Information" tab at the top of your screen, scrolling down to the "Course Objectives" and then selecting View class objectives. How ...

Question read the worddoc first and answer those following

Question: Read the word.doc first and answer those following question 1. Provide a list of at least five pieces of information that airlines have about their customers, and for each, explain how that information might he ...

In this unit you are asked to produce a public relations

In this unit you are asked to produce a Public Relations Campaign Proposal document and an essay that explains the theory behind your planned approach to the Proposal task. You may base your assessment on the suggested s ...

Question 1200 words on your favorite retailer and their

Question: 1200 words on your favorite retailer and their major competitor as discussed in class. This should focus on the different elements that make up the retail strategy of the companies and other factors that appeal ...

Question bulltype of paper assignmentbullsubject

Question: • Type of paper Assignment • Subject Other • Number of pages 1 • Format of citation Other • Number of cited resource s0 • Type of service Writing from scratch First, choose a piece of art from any genre (music, ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As