| P&G / Walgreens Case - ILLUSTRATIVE LAYOUT |
| INFORMATION PROVIDED | Value | Source | | INFORMATION PROVIDED | Value | Source |
| Walgreens | | | | Gallup "early-bird" warning system |
| Total store locations in 2010 | 7,000 | Provided, pg ? | | Compensation per school per month | $ 1,000 | Provided, pg ? |
| New store openings each year | 425 | Provided, pg ? | | etc. | | etc. |
| etc. | | etc. | | etc. | | etc. |
| etc. | | etc. | | etc. | | etc. |
| etc. | | etc. | | etc. | | etc. |
| etc. | | etc. | | etc. | | etc. |
| etc. | | etc. | | etc. | $ - 0 | Computed |
| etc. | $ - 0 | Computed |
| etc. | | etc. |
| Procter & Gamble |
| Annual sales for 2009 | $ 79,000,000,000 | Provided, pg ? |
| etc. | | etc. | | P&G actions and terms |
| etc. | | etc. | | Days in advance of season P&G to ship product to McKesson | 30 | Provided, pg ? |
| etc. | | etc. | | etc. | | etc. |
| | | | | etc. | | etc. |
| Cold Remedy Market | | | | etc. | | etc. |
| Percentage of consumers… | 51.00% | Provided, pg ? |
| etc. | | Computed | | Walgreens info and required action |
| Previous year sales growth | 21.00% | Provided, pg ? | | What do we want Walgreens to do? Specifics below. (e.g., # of displays, # of months, # of stores, etc) | | Provided, ??? |
| etc. | | etc. |
| etc. | | etc. | | etc. | | etc. |
| | | | | etc. | | etc. |
| Cold and Flu Product Market Competitors | | | | etc. | | etc. |
| NyQuil from Richardson-Vicks | | | | etc. | | etc. |
| etc. | | etc. |
| etc. | | etc. | | Special display |
| etc. | | etc. | | What does the special display look like by product and cost, etc. | | Provided, pg. 12 |
| LIST COMPETITORS, $, Share, etc. in this section | | etc. |
| etc. | | etc. | | NyQuil (10 oz) |
| etc. | | etc. | | NyQuil (10 oz) sugested retail price (= to per/unit revenue to Walgreens) | $ 6.99 | Provided, pg 12 |
| etc. | | etc. | | etc. | | etc. | |
| etc. | | etc. | | etc. | | etc. |
| etc. | | etc. | | etc. | | etc. |
| etc. | | etc. | | etc. | | etc. |
| etc. | | etc. | | etc. | | etc. |
| etc. | | etc. | | etc. | | etc. |
| etc. | | etc. | | etc. | | etc. |
| etc. | | etc. | | etc. | | etc. |
| etc. | | etc. | | etc. | | etc. |
| etc. | | etc. | | etc. | | etc. |
| etc. | | etc. | | etc. | | etc. |
| etc. | | etc. | | etc. | | etc. |
| etc. | | etc. | | etc. | | etc. |
| etc. | | etc. | | etc. | | etc. |
| etc. | | etc. | | etc. | | etc. |
| etc. | | etc. | | etc. | | etc. |
| etc. | | etc. | | etc. | | etc. |
| etc. | | etc. | | etc. | | etc. |
| etc. | | etc. | | etc. | | etc. |
| etc. | | etc. | | etc. | | etc. |
| etc. | | etc. | | etc. | | etc. |
| | | | | etc. | | etc. |
| | | | | etc. | | etc. |
| | | | | etc. | | etc. |
| | | | | etc. | | etc. |
| | | | | etc. | | etc. |
| | | | | etc. | | etc. |
| | | | | etc. | | etc. |
| | | | | etc. | | etc. |
| | | | | etc. | | etc. |
| | | | | etc. | | etc. |
| | | | | etc. | | etc. |
| | | | | etc. | | etc. |
| | | | | etc. | | etc. |
liuchang
PGWalgreensAnalyticsExamplep1.xlsx
