Analysis of United Milk Commodities: Business Information Systems

This assignment analyzes the case study of United Milk Commodities (UMC), a milk processing company. It begins with an executive summary and table of contents, followed by an introduction outlining the report's objectives. Task A focuses on using Excel for business intelligence, including calculations and visualizations of sales and milk production data for week 32 over three years. Task B involves developing 'As-Is' and 'To-Be' swim lane diagrams to model and improve UMC's business processes. Part C addresses general questions about business process models, IT's role in business, and the promotion of a new ordering system using native and web apps. The report concludes with a reflection on the analysis and provides references. The Excel analysis includes calculations for equivalent liters, retail prices, and projected milk production. Swim lane diagrams visually represent the current and proposed processes. The general questions delve into BPM benefits, IT advantages, and the pros and cons of native versus web apps for the new ordering system, providing recommendations for UMC's operational and strategic improvements.