Compute and compare own price elasticities for all brands

Assignment Help Marketing Management
Reference no: EM13985280

Question A:

Multichannel retailers are often interested in targeting customers with the right deal at the right time. Read the attached article titled, "Know What Your Customers Want Before They Do" for a background.

Assume you are the data scientist working at a multichannel retailer (who operates via physical stores, Internet and mobile channels) and that the retailer is interested in offering the "right deal" to its customers. Based on the article you read, answer the following questions.

1) What data (think ROWS and COLUMNS) do you need that will help you model what customers want so that you can target them with the right deal? Be very specific with respect to description of the data.

2) How can multichannel retailers target their customers with the right deal at the right time? Be specific. Explain with model formulation, if necessary.

Question B:

The data set for this exercise is contained in the file elasticity_brands.xls. Each file contains information on unit sales and price for four brands that are named as brand1, brand2, brand3 and brand4. The unit sales have been summed up across several stores, whereas marketing activity variables are weighted averages across those stores.

The data set contains the following variables:

Week = Week number (1 to 75)
Unitsj = Total units of brand "j" sold (j=1 to 4) across stores
Pricej = Shelf price of brand "j" (weighted average across stores)
Featj = Newspaper feature, (1 = brand "j" is featured, 0 = otherwise)
Dispj = Weighted average of in In-store display, (1 = there is an in-store display for brand "j" in a store, 0 = otherwise)
Brands
1 Tide
2 Wisk
3 Era
4 Surf

A) Formulate (Be very specific) and estimate models (log-log model or hybrid models only) to compute and compare own price elasticities for all the brands. Comment on the results.

B) Do the results have face validity (hint: look at summary statistics of the four brands)? Why? What are the managerial implications that one can infer from your results? Be specific.

C) Consider the best models (for Tide and Wisk only) from Part A. For these two focal brands, how can you improve the models to account for the cross price effect (which is the effect of price of a competing brand on the sales of a focal brand)? Formulate models (by extending the best fitting models from Question A) for Tide and Wisk that would allow you to estimate the "cross-price" effect of a competing brand.Explain how you will compute the cross-price elasticities for the two brands, Tide and Wisk. What are the managerial implications? Suggestion: Even if you cannot calculate cross-price elasticities, formulate models and explain the steps that you will undertake.

D) The above models are based on analysis of aggregate data. What are the advantages and limitations of working with aggregate data? From a marketing manager's perspective, elaborate on how disaggregate data can be useful in understanding the effect of a price cut on sales. Be specific. What are the advantages and limitations of working with disaggregate data?

Question C:

You are the CRM manager of a multi-channel retailer (also a direct marketer) of women's apparel, shoes and accessories. You are interested in understanding if customers who regularly shop via online or offline channel are more likely to continue shopping with the retailer. You are also interested in understanding if seasonality plays a role on sales. Provide a snapshot (in rows and columns) of how the data should look like for you to estimate a model that can help you solve this problem. Formulate a model and explain how you will estimate it.


Attachment:- elasticity_brands.xlsx

Verified Expert

Question is that all the three parts belong to cross elasticity of demand that is how change in price of one will effect demand of another and moreover what will be the managerial implications if there is change in cross elasticity of demand.The data needed by a multi channel retailer to target the customer by knowing their approximate demand.How a multi channel retailer target their customers with right deal at right time.

Reference no: EM13985280

Questions Cloud

Explain what type of data was collected for study : Explain what type of data was collected for this study: nominal, ordinal, interval, or ratio. Describe the sampling methods used to obtain the study sample
Problem regarding the accept-reject sampling : Here is a method called accept-reject sampling for drawing observa- tions from a distribution.
What is the meaning of impracticability within a contract : What is the meaning of impracticability within a contract?
What events would lead to the discharge of a contract : What events would lead to the discharge of a contract?
Compute and compare own price elasticities for all brands : Compute and compare own price elasticities for all the brands. Comment on the results - What are the managerial implications that one can infer from your results? Be specific.
Estimate the density of the ?rst variable : Get the data on fragments of glass collected in forensic work from the book website. Estimate the density of the ?rst variable (refractive in- dex) using a histogram and use a kernel density estimator.
Draw the independence graphs corresponding : Let X1,..., X4 be binary. Draw the independence graphs corresponding to the following log-linear models. Also, identify whether each is graphical and/or hierarchical (or neither).
Construct a joint distribution : Suppose that X ∈ R and that, for each subject i, Ci(x) = β1ix. Each subject has their own slope β1i. Construct a joint distribution on (β1,X) such that P(β1 > 0) = 1 but E(Y |X = x) is a decreasing function of x, where Y = C(X). Interpret.
A complete java program called reverser : Create, using NetBeans, a complete Java program called Reverser according to the following guidelines. The program prompts the user for two words (strings) from the command line and then prints the words in reverse order, using one or more for loops ..

Reviews

inf985280

3/8/2017 3:38:53 AM

Was surprisingly awesome rating considering how he completed my paper in 14 hours! Exceptionally content with his work :) Incredible work. Met short due date. Great correspondence. Comprehended the guidelines and tailed them well!

Write a Review

Marketing Management Questions & Answers

  Integrated marketing communication

Developing an IMC plan of Amazon that aims to create awareness and knowledge amongst Singaporean  consumers of the ethics involved in buying clothing made from Bangladeshi factories  .

  Multiple choice questions on e-commerce

The assignment in Computer Science or Information Technology is about multiple choice questions, particularly in e-commerce. Questions such as types of e-commerce websites, commercial websites, disintermediation, Platform for Piracy, the data that ca..

  Balanced scorecard for red lobster

The assignment in marketing is about Red Lobster, which is one US and Canada's most loved seafood restaurant. It has hundreds of outlets in US and Canada and it now wants to expand further. The approach adopted by Red Lobster has been discussed in fu..

  Marketing plan - marketing audit, swot and smart report

The assignment in marketing is about preparing a marketing plan. As part of marketing plan, the SWOT analysis, assessing the competitive position, identifying critical competitive issues, marketing objectives, strategy and actions have been suggested..

  Marketing plan

Marketing deals with preparing a marketing plan for either an existing product or a new product. Various aspects about launching a new product into the market are discussed ranging from the industry the product belongs to, goals and vision of the com..

  Yamato corporation analysis - harvard case study

Please refer to the PDF for the Case Study and questions.The case study from Harvard Business School is about Yamato Corporation, a parcel delivery company which provides door to door delivery in Japan.

  Marketing plan - create a new product

The assignment in marketing is about competitive analysis for a new product namely "heated insoles". These heated insoles can be put in shoes and they can protect the wearer's feet by keeping them warm during cold winters.

  Report on digital marketing strategy for a website

Promotion strategies of  the one's own developed website

  Integrated marketing campaign of mccafe

Integrated marketing campaign for McDonald's McCafe. McCafe has been launched in Canada. This is a case study which involves the use of digital marketing and social media marketing apart from regular marketing such as TV and radio. All these more are..

  New product development at adidas

In this paper, the researcher also determines the different kind of practices used by Adidas to manufacture shoes for its customers.

  Managing services in competitive environment

Services can be defined as separately identifiable, intangible activities which provide want-satisfaction when marketed to household consumers and/or industrial users.

  Prepare a marketing plan

A marketing plan is an essential tool for any marketer, providing direction for a brand, product or organization. A marketing plan describes the marketing environment, marketing objectives and marketing strategies.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd