Welcome to the home of the University of Michigan's School of Information on the Web.  To learn about the accessibility features of this site use accesskey 0 or use the following link: ACCESSIBILITY
| | | | Some of the links on this page may link to PDF files. Use this link to download Adobe Acrobat Reader →. Adobe also offers a free utility which can convert PDF files to text or HTML →. |
School of Information |
University of Michigan |

Connecting People, Information and Technology in More Valuable Ways
About SIAbout SI | ApplyingApplying | MSI DegreeMSI Degree | Ph.D.Ph.D. | PeoplePeople | ResearchResearch | CareersCareers | FieldworkFieldwork | Student LifeStudent Life |




Information For ...

Home > Fieldwork > PEP > Internship Portfolio Search > Internship Public Portfolio

Internship Portfolio

(<< return to list of Internship portfolios)

Controlling spreadsheet automatically generates forecasts across time and across product / therapy areas

Maurice G. Solomon


GlaxoSmithKline K.K.
Tokyo, Japan
Summer 2005
Email

GlaxoSmithKline K.K.is an international top-10 pharmaceutical maker.

Project Objectives

  • Provide sales forecasting and vendor inventory tracking in Excel
  • Analyze Sales Department budgets
  • Process mapping and interviews for ERP implementation project
  • Develop a centralized analysis database

Learning Objectives


  • Develop Excel, Access, VBA, and statistics software skills
  • Gain experience in researching the pharmaceutical industry, ABC for cost management, Japanese legal and regulatory environment
  • Build Japanese language skills
  • Learn to converse with finance and pharmaceutical specialists

Project Outcomes


While working at GlaxoSmithKline, I researched Japanese tax and securities law to support a capital structure reallocation proposal, saving the firm several billion yen annually. I also analyzed and critiqued department budgets, created counter-proposals, and collaborated with the sales department to understand and reduce travel and entertainment costs by a third over the next three years. I developed sophisticated sales and expense forecasting models, implemented department-wide forecast standardization and benchmarking, prepared a business case to suggest new decision support software, and oversaw its selection, implementation and training.
Model of GSK's Budget proposal / review / negotiation process
Home > Fieldwork > PEP > Internship Portfolio Search > Internship Public Portfolio
    Home | About SI | Applying | MSI Degree | Ph.D. |  People | Research | Careers | Fieldwork | Student Life  

|  CONTACT | SITE MAP | INTRANET | ACCESSIBILITY | SEARCH  

SI CONTACT INFORMATION | si.info@umich.edu
© 2009 Regents, University of Michigan