Unit 5 [GB513| Business Analytics]1 Assignment Case # 1 – Final ProjectShown below are sales figures for 2009 for personal soaps sold throughout Europe. You will note that each of these soaps is produced by 4 manufacturers - Unilever, Proctor & Gamble, Dial, and Colgate - Palmolive.SoapManufacturerSales ($ millions)DoveUnilever271DialDial193Lever 2000Unilever138Irish SpringColgate-Palmolive121ZestProctor & Gamble115IvoryProctor & Gamble94CaressUnilever93OlayProctor & Gamble69SafeguardProctor & Gamble48CoastDial44
Unit 5 [GB513| Business Analytics]2 In 1983, the market share for soap were:Proctor & Gamble = 37.1%Unilever = 24%Dial = 15%Colgate-Palmolive = 6.5%All others = 17.4% By 1991, the market shares were:Unilever = 31. 5%Proctor & Gamble = 30.5%Dial = 19%Colgate – Palmolive = 8%All others = 11%Question:Produce an Executive Summary to the CEO of Proctor&-Gamble either in Power Point or in a Word Doc that includes:a. A pie chart showing the market shares for 1983 and 1991.b. A third pie chart which shows the market share for 2009. Assume that the ‘All others’ total is $119 M.c. Indicate to the CEO of Proctor & – Gamble your observations about the market shares of the various companies by studying the charts. Also, relate to the CEO specifically how Proctor &-Gamble is performing relative to previous years.
Slide 1 Final Project Case Study 1 Seyra Hughes GB513-Business Analytics * Market Shares by Manufacturer in 1983 Based on the information provided in 1983 it is apparent that Proctor and Gamble hold the greatest percent of the market share. * Chart1 Proctor & GambleProctor & Gamble UnileverUnilever DialDial Colgate-PalmoliveColgate-Palmolive All othersAll others 1983 Marketshare 1991 Marketshare 0.371 0.305 0.24 0.315 0.15 0.19 0.065 0.08 0.174 0.11 Sheet1 Manufacturer1983 Marketshare1991 Marketshare Proctor & Gamble37.10%30.50% Unilever24%31.50% Dial15%19% Colgate-Palmolive6.50%8% All others17.40%11% To resize chart data range, drag lower right corner of range. Market Shares by Manufacturer in 1991 Based on the data collected for the 1991 Market share Proctor & Gamble have the second largest share in the market. When comparing this to the 1983 market share, there is a reduction in the overall market share by 6.6%. Unilever increased their market share by 7.5% over the same time period resulting in the greatest market share in 1991. * Chart1 Proctor & Gamble Unilever Dial Colgate-Palmolive All others 1991 Marketshare 0.305 0.315 0.19 0.08 0.11 Sheet1 Manufacturer1991 Marketshare Proctor & Gamble30.50% Unilever31.50% Dial19% Colgate-Palmolive8% All others11% To resize chart data range, drag lower right corner of range. LS430: Managed Care and Insurance Issues Unit 5 [GB513| Business Analytics] 1 Assignment Case # 1 – Final Project Shown below are sales figures for 2009 for personal soaps sold throughout Europe. You will note that each of these soaps is produced by 4 manufacturers - Unilever, Proctor & Gamble, Dial, and Colgate - Palmolive. Soap Manufacturer Sales ($ millions) Dove Unilever 271 Dial Dial 193 Lever 2000 Unilever 138 Irish Spring Colgate-Palmolive 121 Zest Proctor & Gamble 115 Ivory Proctor & Gamble 94 Caress Unilever 93 Olay Proctor & Gamble 69 Safeguard Proctor & Gamble 48 Coast Dial 44 Unit 5 [GB513| Business Analytics] 2 In 1983, the market share for soap were: Proctor & Gamble = 37.1% Unilever = 24% Dial = 15% Colgate-Palmolive = 6.5% All others = 17.4% By 1991, the market shares were: Unilever = 31. 5% Proctor & Gamble = 30.5% Dial = 19% Colgate – Palmolive = 8% All others = 11% Question: Produce an Executive Summary to the CEO of Proctor&-Gamble either in Power Point or in a Word Doc that includes: a. A pie chart showing the market shares for 1983 and 1991. b. A third pie chart which shows the market share for 2009. Assume that the ‘All others’ total is $119 M. c. Indicate to the CEO of Proctor & – Gamble your observations about the market shares of the various companies by studying the charts. Also, relate to the CEO specifically how Proctor &-Gamble is performing relative to previous years. Case 1 Soap Manufacturer Sales ($ millions) Manufacturer 1983 Marketshare1991 Marketshare2009 Dove Unilever 271Proctor & Gamble 37.10%30.50% Dial Dial 193Unilever 24%31.50% Lever 2000 Unilever 138Dial 15%19% Irish Spring Colgate-Palmolive 121Colgate-Palmolive 6.50%8% Zest Proctor & Gamble 115All others 17.40%11% Ivory Proctor & Gamble 94 Caress Unilever 93 Olay Proctor & Gamble 69 Safeguard Proctor & Gamble 48 Coast Dial 44 Market Shares by Manufacturer in 1983 Proctor & Gamble Unilever Dial Colgate-Palmolive All others 0.3710.240.150.0650.174 Marketshare by Manufacturer in 1991 1991 MarketshareProctor & Gamble Unilever Dial Colgate-Palmolive All others 0.3050.3150.190.080.111983 MarketshareProctor & Gamble Unilever Dial Colgate-Palmolive All others 0.3710.240.150.0650.174 Case 2 200.1Column1 199.9 200.2Mean200.118 200.2Standard Error0.059225615 200.0Median200.15 200.1Mode200.2 200.9Standard Deviation0.4187883397 200.1Sample Variance0.1753836735 200.3Kurtosis-0.1409596079 200.5Skewness0.036654797 199.7Range1.9 200.4Minimum199.2 200.3Maximum201.1 199.8Sum10005.9 199.3Count50 200.1Largest(1)201.1 199.4Smallest(1)199.2 199.6Confidence Level(95.0%)0.1190183293 199.2 200.2 200.4 199.8 199.9 200.2 199.6 199.6 200.4 200.4 200.6 200.6 200.1 200.8 199.9 200.0 199.9 200.3 200.5 199.9 201.1 199.7 200.2 200.5 200.2 199.7 200.9 200.2 199.5 200.6 200.3 199.8 Case 3 Cumulative Hours of Training Productivity (lbs. /week) SUMMARY OUTPUT 070,000 10070,350Regression Statistics 25070,500Multiple R0.9881351392 37572,600R Square0.9764110533 52574,000Adjusted R Square0.9749367441 75076,500Standard Error195.0963712591 87577,000Observations18 1,10077,400 1,30077,900ANOVA 1,45077,200dfSSMSFSignificance F 1,66078,900Regression125208238.772522325208238.7725223662.28378235480 1,90081,000Residual16609001.50525549238062.5940784682 2,30082,500Total1725817240.2777778 2,60084,000 2,85086,500CoefficientsStandard Errort StatP-valueLower 95%Upper 95%Lower 95.0%Upper 95.0% 3,15087,000Intercept-13550.1213714552590.2457681825-22.9567446340-14801.3865032682-12298.8562396422-14801.3865032682-12298.8562396422 3,50088,600Productivity (lbs. /week) 0.19169955670.007449018425.734874826900.17590834310.20749077040.17590834310.2074907704 4,00090,000 RESIDUAL OUTPUTPROBABILITY OUTPUT ObservationPredicted Cumulative Hours of Training ResidualsStandard ResidualsPercentileCumulative Hours of Training 1-131.152400652131.1524006520.69293344292.77777777780 2-64.057555798164.0575557980.86678525458.3333333333100 3-35.3026222892285.30262228921.507374072813.8888888889250 4367.26644683497.73355316510.040859622819.4444444444375 5635.645826251-110.645826251-0.584588562225525 61114.8947180654-364.8947180654-1.927892680830.5555555556750 71210.7444964283-335.7444964283-1.773879766536.1111111111875 81287.4243191186-187.4243191186-0.990241719441.66666666671100 91383.2740974815-83.2740974815-0.439972175847.22222222221300 101249.0844077734200.91559222661.061521804952.77777777781450 111574.973654207285.02634579280.449230042658.33333333331660 121977.5427233313-77.5427233313-0.409690909163.88888888891900 132265.092058419934.907941580.184433376969.44444444442300 142552.641393508647.35860649140.2502154904752600 153031.890285323-181.890285323-0.961003085180.55555555562850 163127.740063685922.25993631410.117608631186.11111111113150 173434.459354447165.54064555290.346278870691.66666666673500 183702.8387338632297.16126613681.570028289497.22222222224000 Normal Probability Plot 2.7777777777777778.33333333333333213.8888888888888919.4444444444444425.030.5555555555555636.1111111111111141.6666666666666647.2222222222222252.7777777777777858.3333333333333463.8888888888888969.4444444444444274.9999999999999880.5555555555555486.111111111111191.6666666666666597.222222222222210.0100.0250.0375.0525.0750.0875.01100.01300.01450.01660.01900.02300.02600.02850.03150.03500.04000.0Sample Percentile Cumulative Hours of Training Productivity (lbs. /week) Line Fit Plot Cumulative Hours of Training 70000.070350.070500.072600.074000.076500.077000.077400.077900.077200.078900.081000.082500.084000.086500.087000.088600.090000.00.0100.0250.0375.0525.0750.0875.01100.01300.01450.01660.01900.02300.02600.02850.03150.03500.04000.0Predicted Cumulative Hours of Training 70000.070350.070500.072600.074000.076500.077000.077400.077900.077200.078900.081000.082500.084000.086500.087000.088600.090000.0-131.1524006520431-64.05755579802644-35.30262228916217367.2664468349321635.64582625099681114.8947180653961210.7444964282751287.424319118581383.2740974814591249.0844077734271574.9736542072191977.5427233313152265.0920584199542552.6413935085943031.8902853229923127.7400636858733434.4593544470883702.838733863151Productivity (lbs. /week) Cumulative Hours of Training Productivity (lbs. /week) Residual Plot 70000.070350.070500.072600.074000.076500.077000.077400.077900.077200.078900.081000.082500.084000.086500.087000.088600.090000.0131.1524006520431164.0575557980264285.30262228916217.73355316506786-110.6458262509968-364.8947180653959-335.7444964282749-187.4243191185797-83.27409748145874200.915592226572785.02634579278129-77.5427233313148434.907941580046147.35860649140523-181.89028532299222.2599363141271265.54064555291188297.161266136849Productivity (lbs. /week) Residuals