Sherwin-Williams Company: Marketing Analytics Report Analysis

This report provides a detailed analysis of Sherwin-Williams, a major player in the paint and coatings industry. It examines the company's market presence, product portfolio, and financial performance, including an increase in current liabilities and its impact on liquidity. The report delves into the company's history, including its founding and the various segments it operates in, such as paint stores, consumer groups, and global coatings. It outlines Sherwin-Williams' product offerings, focusing on interior and exterior paints, along with aerosol products, providing details on pricing and specifications. Furthermore, the report analyzes the company's marketing strategies, including distribution channel evaluation and selection, and the modeling process used to assess different channel options. The report also touches on the company's brand power and concludes with references and appendices, offering a comprehensive overview of Sherwin-Williams' market position and strategies.

MARKETING ANALYTICS

Executive Summary
The Sherwin-Williams Company is seen as one of the main paint assembling and retailing
organizations in the US. Some of their key qualities are a solid market nearness, wide item
portfolio, and solid monetary execution. Increment in current liabilities Substantial increment in
current liabilities debilitated the organization's liquidity position. Its present liabilities were
US$2,063.94 million toward the finish of FY2010, a 48.09% expansion contrasted with the
earlier year. Be that as it may, its present resources recorded a peripheral increment of 25.07% -
from US$1,770.02 million toward the finish of FY2009 to US$2,213.72 million toward the finish
of FY2010. Following this, the organization's present proportion declined from 1.27 toward the
finish of the FY2009 to 1.07 toward the finish of FY2010. A lower current proportion
demonstrates that the organization is in a frail budgetary position, and it might think that it’s hard
to meet its everyday commitments.

Table of Contents
Introduction.............................................................................................................................................3
Data Preparation and Sources.................................................................................................................3
Modeling Process....................................................................................................................................7
Conclusion...............................................................................................................................................8
References...............................................................................................................................................8

Introduction
The company is founded by Mr. Henry Sherwin and Mr.Edward Williams in the place
Cleveland in the year 1866, the company helps in operating four different segment. One is the
paint Stores Group which is known as ‘Sherwin-Williams Stores, and the Consumer Group, it
also has the Latin America Coatings Group, and also Global Finishes Group. Sherwin-Williams
Paints, in America is the first company to be established. The Sherwin-Williams Automotive
Finishes portion creates, fabricates, and disseminates different engine vehicle complete, restore,
and touch-up items. The Sherwin-Williams Spray Source benefit focuses offer new hardware,
parts and embellishments, upkeep and repairs to rental programs. There are more than 100
administration focuses situated over the U.S. what's more, Puerto Rico. They have processing
plant prepared specialists that give support and repairs on paint sprayers, weight (cleaners)
washers, regular shower weapons, HVLP (High Volume Low Pressure) frameworks, plural-
segment gear from producers like EXCEL North America, Kremlin Rexson, Sames, Johnstone,
Graco, Titan/Speeflo, Spraytech/Wagner, Capspray, ITW Binks, AccuSpray, Mi-T-M, Pressure
Pro, and the sky is the limit from there. They give repairs like upkeep, crisis and guarantee,
phone investigating support, nearby exhibits, and preparing. Preceding 2008, the program is
called SherWorks.
Data Preparation and Sources
Sherwin-Williams have three products
1. Interior Paint & Coatings
2. Exterior Paint & Coatings
3. Painting Tools & Supplies
Under this products many types of sub products are found, the following two products are
taken.

Paint:
 It is highly durable. It has high quality coatings which is designed for the superior
performance when compared to all exterior substrates.
 It has many varieties
 Prices differs accordingly
 Offers will also be provided when compared to others.
 It provides the quality results.
 Customers can compare the product with other. Datasheet facility is also available.
The paint has improved coating formulae and helps to look beautiful and provides results
more than the customer’s expectation
• Emerald Urethane Trim Enamel
• HGTV HOME by Sherwin-Williams Ovation Interior Latex Paint
• super Paint Interior Acrylic Latex
• Emerald Interior Acrylic Latex Paint
• Duration Home Interior Acrylic Latex
• Cashmere Interior Acrylic Latex
• The above are the various paints that are available in Sherwin Williams.
Price
Some offers will be provided.
Example:
Save 10% of our money each and every Day with our Paint Perks
Price:
$85.49 - $101.49 / Gallon
Interior paint and coatings:

Aerosols:
With the collection of formulations, familiar package and extensive color palette, interior aerosol
products helps us to finish our project. There are several aerosol products in Sherwin-Williams.
Some of the products and their details and specifications and prices are listed below.
White pigmented shellac aerosol primer:
Price-11.09$
Details of the product:
It is utilized for both exterior as well as interior.
It dries quickly
It hides the odors and stains permanently from smoke, water and soot
Product: C26944000
Size of the container: twelve ounce
Sales number: 1344027
Base: white
PDS: PDS
EDS: EDS
GHS-SDS: GHS-SDS
Krylon professional primer:
Price: 7.19$
Details of the product:
It has the quick dry formula
It helps to fight against rust

It is idea for masonry, metal, wood and drywall
Product: KO5874
Size of the container: seventeen ounce
Sales number: 1869759
Base: Ruddy brown
GHS-SDS: GHS-SDS
EDS: EDS
Multi-purpose oil based aerosol:
Price-7.99$
Details of the product:
It is formulated to isolate water stains, grease, pencil, odors and ink
After 1 hour it could be top coated
It act as a stain blocker as well as interior sealer
Product: C45000000
Size of the container: Twelve ounce
Sales number: 650171390
Base: white
PDS: PDS
EDS: EDS
GHS-SDS: GHS-SDS

Sherwin-Williams outperformed the $6 billion in deals without precedent for history. Three of
their four working fragments developed their deals and working benefits. Sherwin-Williams
confronted rising crude material expenses yet at the same time announced a 20 percent expansion
in quarterly profits payable to investors in 2004. In 2004, annualized yearly crude material
expenses for the business expanded more than whenever in the most recent decade. This brought
about weight on their combined gross edge. Sherwin-Williams has advanced endeavors to
counterbalance crude material cost increments through assembling efficiencies, higher settled
cost assimilation, elective innovations, tight cost control, and measured cost increments.
There were an expanded number of contractual worker deals and design paints alongside related
supplies. An expansion in Do-It-Yourself clients has additionally assisted with solid deals
development. The expansion in the Do-It-Yourself advertise brought about higher offers of
paints, wood mind items and airborne items. The administrations of expert painting temporary
workers were popular, and those clients shop at Sherwin-Williams paint stores. These clients
keep on shopping at the paint stores in view of Sherwin-Williams' quality items and
administrations which have made their business more effective. Net deals for their Paint Stores
section expanded by 14.6 percent over the previous years.

Modeling Process
The Distribution Channel (DC) Member Evaluation and Selection Analytics Model
("Demonstrate") format is intended to assess distinctive conceivable outcomes for expanding or
evolving conveyance channels. So as to pick up the most adaptability out of this model, it is best
to set up input tables that encourage to the 'Results Table'. In the event that planned legitimately,
with specific fields referencing an information table, you can adequately utilize the model to
assess 'Imagine a scenario in which' situations, for instance by. Modifying the weighting per
criteria or by adjusting the trait weighting at a more elevated amount, or even by changing
anticipated deals volumes or expenses. How might each adjustment in presumption influence the
prescribed DC?
The initial step is to decide the dispersion channel alternatives you will center on your
your circulation channel assessment. You should think about the items you will offer and the

long term objectives for the item and the sort of research you may need to lead. At that point you
have to choose which credits are important to the achievement of your item. Next is to figure out
what weight you will dole out inside the model to each of the traits and their sub-classes. The
entirety of the weights must total to 100%. Subsequent to performing research, it will be
essential to be steady with the rating framework that you use to 'review' the DC. There will be
some equivocalness, however as with any market look into, it is imperative to move past the
vulnerability and conquer any predispositions amid the procedure to concoct as goal a model as
could be expected under the circumstances. My Model will be utilized as a choice guide, with
assessment criteria and rating framework bringing about model yield of Expected Profit by
channel and total scores by channel for Client Acquisition (CA), Customer Retention (CR), and
Revenue Growth (RG) assessment factors, and a Grand Total score. Expected Profit by Channel
was examined by assessing the incomes and costs that would be related with each, in view of
(anecdotal) exchanges with the DC delegates and presumptions with respect to qualified
demographic and interest for the chose items. The rest of the criteria were resolved as rates and
after that weighted in like manner.
Conclusion
The brand power of the Sherwin-Williams is in the architectural paint brand, stain & protective
finish brand, Aerosol paint brand awareness, Auto specialty, painting tool brand, wood sealer
brand. SHW is a blue chip profit stock with a brilliant future and solid resilience. Be that as it
may, even as well as can be expected make poor speculations relying upon the market's
suggested desires. Until further notice, we accept there are other more appealing profit stocks
that offer a higher introductory yield, better than expected development prospects, and to some
degree bring down desires.

References
Chernev, A. (2007). Strategic marketing analysis. [Place of publication not identified]:
Brightstar Media.
Onkvisit, S., & Shaw, J. (2012). International marketing. London: Routledge.
Vitale, R., Giglierano, J., & Pfoertsch, W. (2011). Business-to-business marketing. Boston:
Prentice Hall.
Lehmann, D., & Winer, R. (2008). Analysis for marketing planning. Boston [u.a.]: McGraw-Hill.
Wiid, J., & Diggines, C. Marketing research.
Mortimer, R. (2012). Marketing for dummies. West Sussex, England: Wiley Pub.
Africa MVNO market and competitive analysis 2011. (2011). [Place of publication not
identified]: Mind Commerce Publishing, LLC.
WHITE, P. (2015). MARKET ANALYSIS. [S.l.]: FORGOTTEN BOOKS.
Scott, D. (2011). The new rules of marketing & PR. Hoboken, N.J.: John Wiley & Sons.
Stevens, R., Loudon, D., Ruddick, M., Wrenn, B. and Sherwood, P. (2012). The Marketing
Research Guide Second Edition. Hoboken: Taylor and Francis.
Strauss, R. (2008). Marketing planning by design. Chichester, England: Wiley.

Appendix 1: Market Sizing Research