Analytics_Report Ch
.docx
keyboard_arrow_up
School
University Of Arizona *
*We aren’t endorsed by this school
Course
276
Subject
Marketing
Date
Apr 3, 2024
Type
docx
Pages
3
Uploaded by DrBear3077
ANALYTICS REPORT
TO: WALMART PRICING DEPARTMENT
FROM: SHAYNAH MERILAN
SUBJECT: ANALYSIS OF ONLINE WOMEN’S SHOE PRICES DATE:
07 FEBRUARY 2024
Introduction
In this analytics report, we utilized a pivot table to identify Walmart's competitors, focusing on companies selling a minimum of 100 shoes at lower prices. Our selection criteria led us to three competitors whose pricing closely aligns with Walmart's. These chosen companies will be the basis for our comparative analysis, shedding light on Walmart's performance in the market.
Data Analysis
How We Determined Walmart’s Competitors
In our analytics report, we employed a pivot table to pinpoint Walmart's competitors. We focused on companies selling a minimum of 100 shoes at lower prices, ultimately narrowing down our selection to the three closest competitors in terms of pricing. These chosen companies will serve as the basis for comparing Walmart's performance in the market.
ANOVA
H
0
: None of the average shoe price is different across the 4 merchants (Walmart, Amazon, Overstock, and Sears).
H
A
: At least one average shoe price is different across the 4 merchants (Walmart, Amazon, Overstock, and Sears).
Because the p-value = 4.66E-16 is less than the significance level of 0.05, we can reject the null hypothesis and conclude that at least one average shoe price is different across the 4 merchants.
To determine which merchants, have different prices and by how much, we will use Fisher’s Confidence Intervals.
Walmart vs Amazon
H
0
: Walmart and Amazon do not have different average prices. H
A
: Walmart and Amazon have different average prices. (
63.95
−
71.63
)
±
1.9602
√
2697.65
(
1
8183
+
1
192
)
[-15.12, -0.25]
Since zero is not included in the interval, we can reject the null hypothesis and conclude that Walmart and Amazon have different average prices. Since the interval was set up as Walmart
minus Amazon and is entirely negative, we can say Walmart has lower prices by somewhere $0.25 and $15.12.
Walmart vs Overstock
H
0
: Walmart and Overstock do not have different average prices. H
A
: Walmart and Overstock have different average prices. (
63.95
−
67.27
)
±
1.9602
√
2697.65
(
1
8183
+
1
17951
)
[-4.68, -1.96]
Since zero is not included in the interval, we can reject the null hypothesis and conclude that Walmart and Overstock have different average prices. Since the interval was set up as Walmart minus Overstock and is entirely negative, we can say Walmart has lower prices by somewhere $1.96 and $4.68.
Walmart vs Sears
H
0
: Walmart and Sears do not have different average prices. H
A
: Walmart and Sears have different average prices. (
63.95
−
80.58
)
±
1.9602
√
2697.65
(
1
8183
+
1
669
)
[-20.61, -12.65]
Since zero is not included in the interval, we can reject the null hypothesis and conclude that Walmart and Sears have different average prices. Since the interval was set up as Walmart minus
Sears and is entirely negative, we can say Walmart has lower prices by somewhere $12.65 and $20.61.
Recommendation
Based on the statistical analyses, it can be concluded that Walmart's average shoe prices are significantly different from those of its competitors (Amazon, Overstock, and Sears). Walmart consistently offers lower prices, providing a competitive advantage. Therefore, the recommendation is for Walmart to maintain its current pricing strategy to remain competitive in the women's shoe market. The results suggest that Walmart is successfully offering more affordable options compared to its major competitors.
Conclusion
By conducting ANOVA and comparing the average shoe prices of Walmart, Amazon, Overstock, and Sears, we identified meaningful variations. Specifically, Walmart stands out as the most budget-friendly choice among these three key competitors. The thorough analysis indicates that Walmart's current pricing approach effectively positions it as the most economical option. Hence, the suggestion is to uphold the current pricing strategy, aligning with Walmart's aim of providing cost-effective products to its customers. Reach out for more details or questions
shaynahm@arizona.edu. Thank you for your time.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
Understanding Pricing Strategies
Question Content Area
INTRODUCTION: How do companies price their products and services? Do they compare their prices with competitors? Do they offer discounted prices or premium prices? There are many angles to pricing strategies.
Question Content Area
INSTRUCTIONS: You will agree with some of these statements and disagree with others. You may find it hard to make a decision, but you should go ahead and make a choice. Record your answers next to the statement according to the following scale: Strongly Disagree (1), Disagree (2), Agree (3), or Strongly Agree (4).
Strongly Disagree
Disagree
Agree
Strongly Agree
Question
1. A marketer does not need to be aware of the prices charged for competing brands.
2. It is not unusual for a business to charge different buyers different prices for the same quality and quantity of products.
3. Customers typically pay the list price on a car.…
arrow_forward
Question 8
Discuss the key strategies that can be used to enhance profits in markets with intense price competition. Use a local example of a company
that is has employed at least 2 of these strategies.
arrow_forward
Question 1) True or false
A- Experienced marketers hope to emulate entrepreneurs with a strong intuition for pricing without using financial tools. True False
B- A marketer has assembled costs related to the cost of goods sold, the selling and marketing costs, and the costs of keeping the buildings running effectively. He or she is now ready to set the price of the product. True False
C- Temporary market conditions can affect pricing, and this has become a defense of the practice of price discrimination. True False
arrow_forward
QUESTION 1
Due to the fluctuation in the US dollar currency, the prices for commodities in Namibia are changing too because most of the goods are imported and the means of payment is US dollar.
This has affected many businesses because they have to change their prices too, but if one changes prices anyhow, they may lose clients or make losses.
Assuming that you are a business person and this trend is affecting you; explain 5 pricing strategies you may use to price your goods.
QUESTION 2
Royd Joe is an entrepreneur, to do proper planning for his business, he has to take into account of both economic and business factors into considerations. Using Economic and Business forecasting, he should be able to predict trends in his business both in the near future and long run.
Differentiate between business forecasting and economic forecasting.
arrow_forward
Recommendation on how Nestle can increase market share to 10 % through pricing strategies on cereal and coffee sales by the sixth month of the major competitor’s entry into the market.
arrow_forward
Question 11
Describe the following pricing strategies and give an example each:
a) Two-part pricing
b) Peak-Load pricing
c) Commodity bundling
d) Block pricing
e) Versioning
arrow_forward
Mr. Mohammed is appointed as a Sales Executive of Tiles selling section of Danube Home. He has been assigned the task of selling the floor tiles through personal selling mode. He was given on the job training for three months by a senior executive of floor tiles regarding finding sales sources, creating good relationship with the prospect, making effective presentation, presentation techniques etc. As he is new to the job, he is finding very difficult to understand and find the sources of good prospects.
Q- Discuss 8 sources of finding good prospects according to his sales requirements.
(200 words)
arrow_forward
Q: Write the methods for determining pricing of new products?
arrow_forward
Groups
Explain your answer in no more than five (5) but no less than three (3) sentences.
1. Enumerate three (3) effects of the company's selling prices on the business. Briefly discuss each.
2. How important is their selling price regarding the company's long-term sustainability?
3. In your opinion, how can they further improve their business?
arrow_forward
10. Questionable business practices according to antitrust agencies
Complete the following table by matching each of the scenarios to the concept of resale price maintenance, predatory pricing, or bundling.
Resale Price
Maintenance
Predatory
Pricing
Scenario
SnapFace is a firm that manufactures polaroid cameras. Suppose SnapFace sells its polaroid
cameras to online retailers for $166 each and requires those online retailers to charge at least
$176 to shoppers for each polaroid camera.
Warm Winds is the only firm producing space heaters. It costs $1,500 to produce one space
heater, and Warm Winds sells each space heater for $2,100. After Breezy Hut, a new firm with
the same costs as Warm Winds, enters the market for space heaters, Warm Winds starts selling
its space heaters for a price of $800.
Hynes sells a wide variety of condiments to retail grocery stores. Hynes recently developed two
new condiments: a popular barbacuffalo and a much less popular green ketchup. Hynes
requires…
arrow_forward
Current Marketing Mix (4Ps) for WALMART
Pricing Strategy
How is your product or service priced today? Consider:
· How does this compare to competitors?
· How sensitive are your customers to changes in price?
Place: Distribution Strategy
What is your current distribution strategy? Consider:
· How does the product get to market?
· What intermediaries are involved in the distribution network?
arrow_forward
Mr. Mohammed is appointed as a Sales Executive of Tiles selling section of Danube Home. He has been assigned the task of selling the floor tiles through personal selling mode. He was given on the job training for three months by a senior executive of floor tiles regarding finding sales sources, creating good relationship with the prospect, making effective presentation, presentation techniques etc. As he is new to the job, he is finding very difficult to understand and find the sources of good prospects.
Q- Describe the type of sales presentation that will be suitable to Mr. Mohammed according to the business and steps to be followed in the presentation.
arrow_forward
Question related to Fundamental of Marketing
TCS is a Pakistani courier and logistic provider. It is the market leader in courier and logistic services. They have launched an app that delivers food throughout the Pakistan (such as FoodPanda). This app allows customers to browse through a variety of restaurants, cuisines, check menus and prices. To order through this app, customer can locate any restaurant in city. The app offers two payment options, i.e., through card and cash on delivery. As a marketing expert, answer the following questions for TCS.
Suggest the name for the app by using your concepts learned in branding.
How the AIDA model will be useful for you to make an advertisement for TCS?
What kind of advertisement will you prefer for TCS (informative, persuasive, reminder, or comparative) and why?
arrow_forward
Multiple choice:
1.when a company sets a price for the first time because of:
A. Acquires new products, goods or services from an existing company locally or abroad
B. Cost and competitors prices
C. Maintain old price of a while to gain a strong foothold in a market
D. Due to inflation and peso devaluation
2. Key pricing decisions except:
A. Merchandise or gift
B. Product sample
C. An experience
D. Price incentives
arrow_forward
Introduction script for presentation pricing power of Samsung
Note:-
Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism.
Answer completely.
You will get up vote for sure.
arrow_forward
Why is it so difficult for buyers and sellers to agree on a price for a business?
arrow_forward
Question 2)Commercial television channels depend on one thing for survival - advertisement revenue. Naturally they have to come up with programs to attract the most number of people to watch their channels. Assuming that you are a television strategist (say for C9) and you have acquired some knowledge of market segmentation. You are to analyse the television market of C2 (ABC), SBS ,C7 ,C9 ,C10 based on the following questions.a) What do you think would be the most popular program that will be seen by the majority of the people in all these channels? How do you know that?
arrow_forward
Question 2)Commercial television channels depend on one thing for survival - advertisement revenue. Naturally they have to come up with programs to attract the most number of people to watch their channels. Assuming that you are a television strategist (say for C9) and you have acquired some knowledge of market segmentation. You are to analyse the television market of C2 (ABC), SBS ,C7 ,C9 ,C10 based on the following questions.a) What do you think would be the most popular program that will be seen by the majority of the people in all these channels? How do you know that?
b)What type of people do you think will watch "Deal or no Deal"?
c)Who would watch “The Bold and Beautiful” on C10 in the afternoon? d)f) In what ways can Australian soap operas like " Home and Away" compete with American sit -com programs like “The Big Bang Theory”.
arrow_forward
Assessment Task for TOURISM PRICING
ONLINE EXERCISES
You are going on a three-day business trip for your company to Pittsburgh, Pennsylvania. You have up to $300 a day to spend on lodging and food. If you do not spend the money you save money for your company; you do not get to keep the unspent money. You will check in on October 18 and check out on October 21. Choose the hotel where you would stay; what Web site would you use to pick the hotel? What did your search process involve? How many Web sites did you use to make your selection? What criteria did you make in choosing the hotel? (note: look up the hotel rates, but please do not make an actual reservation.)
arrow_forward
Pick a brand from the hospitality and tourism sector of your choice.
Answer ALL the questions.
Question 1. Analyze the competitive positioning of the chosen brand. A SWOT analysis
(presented in Table format) is required to meet this objective.
Question 2.
a. Suggest 5 recommendations for the brand to improve its current positioning based on
your own research. Your 5 recommendations must include (1) a product/service strategy, (2)
a pricing strategy, (3) a distribution strategy, (4) a marketing communications strategy and
(5) a global marketing strategy.
b. Evidence of relevant research.
arrow_forward
Question 1
What are the major pricing strategies that can be used at a restaurant ? 300 words minimum
Question 2
What are the price adjustment strategies that can be used by a restaurant? 400 words minimum
Question 3
Identify how a restaurant can modify its place and promotion during a crisis period. 500 words minimum.
arrow_forward
Please help me answer this, thank you in advance! Note: Please provide a specific company like nestle, unilever, zesto or any company will do.
arrow_forward
QUESTION S
Why is a fitness studio more likely to price discriminate than a grocery store?
OA service cannot be resold, whereas food can be resold
O A fitness studio does not have market power, but a grocery store is likely to have market power
O A fitness studio has more fixed costs and fewer variable costs, whereas a grocery store has fewer fixed costs and more variable costs
A fitness studio cannot find characteristics of consumers that correspond with their willingness to pay, but a grocery store can
QUESTION 6
A patent is an example of
O a unique cost advantage
O a government created barrier to entry
O customer lock in
O entry deterrence
arrow_forward
V1
Target market what is the income for the people to get a car Range rover? and what is the gender?
the location; what country's a company for the car range rovers they targeted and why?
arrow_forward
QUESTION 3
Describe market segmentation and how does a company decide on its target markets and market segments?Using any small medium enterprise(SME) as an example,justify your answer.
arrow_forward
5. There are four different approaches to setting an approximate price level for a product. Identify theone likely selected for STEM Player when it launched. Briefly explain your choice using appropriateterminology and facts from the case.
Approach
Explanation
arrow_forward
Various studies have found that airlines utilize very interesting pricing techniques for their flights.
Ticket prices are lower when purchased far in advance in order to encourage early sales. Ticket prices are also cheaper if a person is willing to fly at odd hours. Additionally, weekend flights are cheaper while weekday flights (when business travelers fly) tend to be more expensive. Student discounts are not a commonly used pricing technique.
a. What do these interesting pricing strategies attempt to achieve?
They base group discounts on easy-to-change characteristics.
They separate groups based on how their supply decisions differ.
They induce customers to sort themselves into groups reveal their reservation price.
They segment the market using group pricing.
b. Why do you think student discounts are not offered frequently?
Students are a target segment that airlines need to distinguish.
An airline cannot prevent a student from…
arrow_forward
Q3) Pricing in practice are influenced by the following, except
a.
customer demand
b.
competitor's action
c.
predatory pricing
d.
discretionary pricing
arrow_forward
Question 2Events and experiences such as the FIFA world cup competitions attract sponsors who put in substantial amounts of money.Assess the wisdom of being a headline sponsor at the FIFA world cup event.
arrow_forward
Price Analysis:
market-driven pricing models
1. Describe the process of market-driven analysis and explain when it would be a useful tool.
2.Describe life cycle costs and the value of the life cycle cost method?
Cost analysis:
3.Define the major types of cost?
4.What is breakeven analysis?
5. Define target pricing and describe when to use such a tool.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Principles Of Marketing
Marketing
ISBN:9780134492513
Author:Kotler, Philip, Armstrong, Gary (gary M.)
Publisher:Pearson Higher Education,
Marketing
Marketing
ISBN:9781259924040
Author:Roger A. Kerin, Steven W. Hartley
Publisher:McGraw-Hill Education
Foundations of Business (MindTap Course List)
Marketing
ISBN:9781337386920
Author:William M. Pride, Robert J. Hughes, Jack R. Kapoor
Publisher:Cengage Learning
Marketing: An Introduction (13th Edition)
Marketing
ISBN:9780134149530
Author:Gary Armstrong, Philip Kotler
Publisher:PEARSON
Contemporary Marketing
Marketing
ISBN:9780357033777
Author:Louis E. Boone, David L. Kurtz
Publisher:Cengage Learning
Related Questions
- Understanding Pricing Strategies Question Content Area INTRODUCTION: How do companies price their products and services? Do they compare their prices with competitors? Do they offer discounted prices or premium prices? There are many angles to pricing strategies. Question Content Area INSTRUCTIONS: You will agree with some of these statements and disagree with others. You may find it hard to make a decision, but you should go ahead and make a choice. Record your answers next to the statement according to the following scale: Strongly Disagree (1), Disagree (2), Agree (3), or Strongly Agree (4). Strongly Disagree Disagree Agree Strongly Agree Question 1. A marketer does not need to be aware of the prices charged for competing brands. 2. It is not unusual for a business to charge different buyers different prices for the same quality and quantity of products. 3. Customers typically pay the list price on a car.…arrow_forwardQuestion 8 Discuss the key strategies that can be used to enhance profits in markets with intense price competition. Use a local example of a company that is has employed at least 2 of these strategies.arrow_forwardQuestion 1) True or false A- Experienced marketers hope to emulate entrepreneurs with a strong intuition for pricing without using financial tools. True False B- A marketer has assembled costs related to the cost of goods sold, the selling and marketing costs, and the costs of keeping the buildings running effectively. He or she is now ready to set the price of the product. True False C- Temporary market conditions can affect pricing, and this has become a defense of the practice of price discrimination. True Falsearrow_forward
- QUESTION 1 Due to the fluctuation in the US dollar currency, the prices for commodities in Namibia are changing too because most of the goods are imported and the means of payment is US dollar. This has affected many businesses because they have to change their prices too, but if one changes prices anyhow, they may lose clients or make losses. Assuming that you are a business person and this trend is affecting you; explain 5 pricing strategies you may use to price your goods. QUESTION 2 Royd Joe is an entrepreneur, to do proper planning for his business, he has to take into account of both economic and business factors into considerations. Using Economic and Business forecasting, he should be able to predict trends in his business both in the near future and long run. Differentiate between business forecasting and economic forecasting.arrow_forwardRecommendation on how Nestle can increase market share to 10 % through pricing strategies on cereal and coffee sales by the sixth month of the major competitor’s entry into the market.arrow_forwardQuestion 11 Describe the following pricing strategies and give an example each: a) Two-part pricing b) Peak-Load pricing c) Commodity bundling d) Block pricing e) Versioningarrow_forward
- Mr. Mohammed is appointed as a Sales Executive of Tiles selling section of Danube Home. He has been assigned the task of selling the floor tiles through personal selling mode. He was given on the job training for three months by a senior executive of floor tiles regarding finding sales sources, creating good relationship with the prospect, making effective presentation, presentation techniques etc. As he is new to the job, he is finding very difficult to understand and find the sources of good prospects. Q- Discuss 8 sources of finding good prospects according to his sales requirements. (200 words)arrow_forwardQ: Write the methods for determining pricing of new products?arrow_forwardGroups Explain your answer in no more than five (5) but no less than three (3) sentences. 1. Enumerate three (3) effects of the company's selling prices on the business. Briefly discuss each. 2. How important is their selling price regarding the company's long-term sustainability? 3. In your opinion, how can they further improve their business?arrow_forward
- 10. Questionable business practices according to antitrust agencies Complete the following table by matching each of the scenarios to the concept of resale price maintenance, predatory pricing, or bundling. Resale Price Maintenance Predatory Pricing Scenario SnapFace is a firm that manufactures polaroid cameras. Suppose SnapFace sells its polaroid cameras to online retailers for $166 each and requires those online retailers to charge at least $176 to shoppers for each polaroid camera. Warm Winds is the only firm producing space heaters. It costs $1,500 to produce one space heater, and Warm Winds sells each space heater for $2,100. After Breezy Hut, a new firm with the same costs as Warm Winds, enters the market for space heaters, Warm Winds starts selling its space heaters for a price of $800. Hynes sells a wide variety of condiments to retail grocery stores. Hynes recently developed two new condiments: a popular barbacuffalo and a much less popular green ketchup. Hynes requires…arrow_forwardCurrent Marketing Mix (4Ps) for WALMART Pricing Strategy How is your product or service priced today? Consider: · How does this compare to competitors? · How sensitive are your customers to changes in price? Place: Distribution Strategy What is your current distribution strategy? Consider: · How does the product get to market? · What intermediaries are involved in the distribution network?arrow_forwardMr. Mohammed is appointed as a Sales Executive of Tiles selling section of Danube Home. He has been assigned the task of selling the floor tiles through personal selling mode. He was given on the job training for three months by a senior executive of floor tiles regarding finding sales sources, creating good relationship with the prospect, making effective presentation, presentation techniques etc. As he is new to the job, he is finding very difficult to understand and find the sources of good prospects. Q- Describe the type of sales presentation that will be suitable to Mr. Mohammed according to the business and steps to be followed in the presentation.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Principles Of MarketingMarketingISBN:9780134492513Author:Kotler, Philip, Armstrong, Gary (gary M.)Publisher:Pearson Higher Education,MarketingMarketingISBN:9781259924040Author:Roger A. Kerin, Steven W. HartleyPublisher:McGraw-Hill EducationFoundations of Business (MindTap Course List)MarketingISBN:9781337386920Author:William M. Pride, Robert J. Hughes, Jack R. KapoorPublisher:Cengage Learning
- Marketing: An Introduction (13th Edition)MarketingISBN:9780134149530Author:Gary Armstrong, Philip KotlerPublisher:PEARSONContemporary MarketingMarketingISBN:9780357033777Author:Louis E. Boone, David L. KurtzPublisher:Cengage Learning
Principles Of Marketing
Marketing
ISBN:9780134492513
Author:Kotler, Philip, Armstrong, Gary (gary M.)
Publisher:Pearson Higher Education,
Marketing
Marketing
ISBN:9781259924040
Author:Roger A. Kerin, Steven W. Hartley
Publisher:McGraw-Hill Education
Foundations of Business (MindTap Course List)
Marketing
ISBN:9781337386920
Author:William M. Pride, Robert J. Hughes, Jack R. Kapoor
Publisher:Cengage Learning
Marketing: An Introduction (13th Edition)
Marketing
ISBN:9780134149530
Author:Gary Armstrong, Philip Kotler
Publisher:PEARSON
Contemporary Marketing
Marketing
ISBN:9780357033777
Author:Louis E. Boone, David L. Kurtz
Publisher:Cengage Learning