case_inventory.xlsx

	A	B	C	D	E	F	G	H	I	J
1	Want more tips about how to get consulting offers? Visit careerinconsulting.com
2	Case Book	Case Name	Profitability (revenue and/or costs)	Ind. Analysis	Mkt Expansion	Pricing	Investment / Aquisitions	Guesstimate	Miscelaneous	Comments

3	Chicago 2004-2005	Levin’s Strollers		x
4	Chicago 2004-2005	Elena’s Electronics – Growth and Profitability Case	x		x
5	Chicago 2004-2005	Linda’s Great Burgers Merger					x
6	Chicago 2004-2005	Schopin’s Glass Shop			x
7	Chicago 2004-2005	Vivian’s Video Rental	x
8	Chicago 2004-2005	Martin’s Media	x	x	x
9	Chicago 2004-2005	Eugene’s Famous Software	x
10	Chicago 2004-2005	Kenny’s Kapital Management							x	Operations
11	Chicago 2004-2005	Brinda’s Hair Styles	x	x			x
12	Chicago 2004-2005	Webb’s Bridge Building				x	x
13	Chicago 2004-2005	Hauffman’s Paper	x	x		x	x			Capacity increase economics
14	Chicago 2004-2005	Lola Lo Zoos (Net Present Value)				x				Dinossaur
15	Chicago 2004-2005	Wacky Wireless Company – Industry Analysis Case		x						Private equity
16	Chicago 2004-2005	Sankar’s Saucy Foods (Profitability):	x
17	Chicago 2004-2005	Kunal’s Auto Parts (Growth Opportunity Case):			x
18	Chicago 2004-2005	Samir and Sameer’s Clothes Manufacturing			x					Grow Sales
19	Chicago 2004-2005	Subramanyan-Sanafi Pharmaceuticals				x				New Drug
20	Chicago 2004-2005	Brenner’s Wireless License Bid		x			x
21	Chicago 2004-2005	Shah’s Stop and Save					x			RFID cost/benefit
22	AGSM 2002	CABLE TELEVISION COMPANY		x
23	AGSM 2002	CHILLED BEVERAGES	x	x						Business exit
24	AGSM 2002	DISTILLED SPIRITS	x
25	AGSM 2002	CHEWING GUM MARKET						x		w/ mkt sizing
26	AGSM 2002	FRENCH PIZZA MARKET		x				x		w/ mkt sizing
27	AGSM 2002	GOLFBALL MARKET ENTRY						x		w/ mkt sizing
28	AGSM 2002	OVERSEAS CONSTRUCTION		x	x
29	AGSM 2002	PACKAGING MATERIAL MANUFACTURER		x					x	very general
30	AGSM 2002	AIRLINE EXPANSION	x				x
31	AGSM 2002	HEALTH CARE COSTS	x
32	AGSM 2002	LOCAL BANKING DEMAND			x					4Ps
33	AGSM 2002	FROZEN DESSERTS	x
34	AGSM 2002	DIRECT MAIL RETAILER	x							Marketing economics
35	AGSM 2002	CHEMICAL SWEETENER MANUFACTURER	x							Patent expiration
36	AGSM 2002	TELECOMMUNICATIONS DIVERSIFICATION		x	x		x			Cost benefit
37	AGSM 2002	ALUMINUM CAN MANUFACTURER	x			x
38	AGSM 2002	FILM PROCESSING			x
39	AGSM 2002	CONCRETE MANUFACTURER					x
40	AGSM 2002	SHIPPING CONTAINER MANUFACTURER		x						very general
41	AGSM 2002	HEALTHCARE COMPANY GROWTH			x					Growth internal & external
42	AGSM 2002	REGIONAL GROCERY STORE CHAIN							x	operations
43	AGSM 2002	MAGAZINE DISTRIBUTION	x							Economics MR = MC
44	AGSM 2002	KNITTING MACHINE DEMAND						x		Market demand
45	AGSM 2002	CEMENT MANUFACTURER CAPACITY ADDITION					x			capacity increase
46	AGSM 2002	SNACK FOOD COMPANY	x
47	AGSM 2002	BEVERAGE COMPANY COST STRUCTURE	x	x						Cost Structure/Value Chain analysis
48	AGSM 2002	PERMANENT LIGHT BULBS		x						industry impact
49	AGSM 2002	AIRPLANE MANUFACTURER		x
50	AGSM 2002	OIL REFINING INDUSTRY						x		Market sizing/ market share
51	AGSM 2002	MYSTERIOUS AUDIO CASSETTE MARKET		x						analyse poor sales
52	AGSM 2002	WINDMILL		x		x				Pricing w/ Porter
53	AGSM 2002	AGRICULTURAL EQUIPMENT MANUFACTURING	x	x						Good for fast Q&A
54	AGSM 2002	BANK OF LUKE		x						very general and long
55	AGSM 2002	CANDY COMPANY	x		x					Growth & decrease in margin
56	AGSM 2002	CONSULTING FIRM (1)		x						IT services analysis
57	AGSM 2002	COSMETIC COMPANY IN EUROPE	x	x						Profitability w/ industry
58	AGSM 2002	SEMICONDUCTORS							x	Competition Regulation analysis
59	AGSM 2002	AIRLINE INDUSTRY		x
60	AGSM 2002	OIL TANKERS				x				Oil Tanker pricing
61	AGSM 2002	FERTILIZER	x							w/ market share decreasing
62	AGSM 2002	SCIENTIFIC INDUSTRY		x
63	AGSM 2002	RETAIL ADVERTISING PRICING				x
64	AGSM 2002	AUTOMOBILE INDUSTRY	x	x						Value chain
65	AGSM 2002	ALUMINUM INDUSTRY		x						very technical
66	AGSM 2002	INSURANCE COMPANY	x
67	AGSM 2002	MEAT PACKING INDUSTRY	x
68	AGSM 2002	PIANOTUNERS						x
69	AGSM 2002	CONSULTING FIRM STRATEGY		x
70	AGSM 2002	SKYSCRAPER							x	Economics
71	AGSM 2002	CORN FEED COMPANY							x	operations
72	AGSM 2002	SELECTIVE BINDING CASE					x			Cost benefit
73	AGSM 2002	VIDEO GAMES		x
74	AGSM 2002	CONSULTING FIRM (2)				x				Fair price of stock
75	AGSM 2002	STEAM BOILER HOSES	x							regain profitability
76	AGSM 2002	POTS & PANS							x	service level
77	AGSM 2002	MERGER CANDIDATE IN CHEMICAL INDUSTRY		x			x
78	AGSM 2002	DIAPERS						x
79	AGSM 2002	MACHINE-LOADING CASE	x	x
80	AGSM 2002	SUPER REGIONAL BANK		x			x			See impact on revenue, cost
81	AGSM 2002	CIGAR BAR						x		Bar valuation
82	AGSM 2002	NEW MAGAZINE			x
83	AGSM 2002	CASTOR MANUFACTURER	x
84	AGSM 2002	LOGGING COMPANY							x	analyze current operations
85	AGSM 2002	INFORMATION SERVICES COMPANY		x
86	AGSM 2002	PIPELINE COMPANY		x
87	AGSM 2002	AUTO MANUFACTURER			x
88	AGSM 2002	DELI MEAT PRODUCER		x						study decline in market share
89	Columbia 2006	Bank Increasing Market Share			x		x			increase sales force
90	Columbia 2006	Chinese Cars			x			x		market sizing & investment
91	Columbia 2006	Health Insurance	x
92	Columbia 2006	Italian Paper					x			increase capacity
93	Columbia 2006	Sugar Magnolia Hospital	x							profitability turnaround
94	Columbia 2006	Private Label Sales							x	scenario analysis-pros and cons
95	Columbia 2006	Piano Market Sizing						x
96	Columbia 2006	Gas Stations and Convenience Stores	x
97	Columbia 2006	Megabank Underpenetration			x					w/ mailing response rate analysis
98	Columbia 2006	Heartcorp				x
99	Columbia 2006	Credit/Debit Card Processor		x	x					how to keep growth
100	Columbia 2006	European Motorcycles			x