INF10003 Introduction to Business Information Systems (Semester 2, 2019) Assignment 2 : Business Design and Development Weighting : 40% Due Date : 22nd November 2019 (Friday, 11.59 pm) Group Contribution Form T The purpose of this form is to provide each group member an opportunity to express their individual contribution to the assignment and for the marker to determine the contribution made by each group member. All group members MUST discuss this form, fill this form, sign this form upon agreement and attach it with the assignment. This form will be used by the marker to determine each of the group member's final marks for the assignment. Each group is required to submit a signed copy of this form together with the assignment. You are asked to assess the percentage (%) contribution of each group member to this assignment. The total percentage should equal to 100% (or almost). If every member of the group contributes equally, the figure entered in the % contribution column should be 25% against each member (in a four-member group). If your group has three members then the figure would be 33% for each member. Individual marks for the assignment will be based on an adjusted group mark where the adjustment is based on any value below an equal share value. Group No. Signature % Contribution (Leader) (Member) (Member) (Member) Date:
INF10003 Introduction to Business Information Systems (Semester 2, 2019) Purpose of Assignment T: he primary aim of this assessment is to understand the effect and impact that business processes, competing and/or complimentary technologies and information systems have on an organization. This means that you need to discuss how the organization within a hypothetical case study will use your proposed solutions to gain an additional advantage over its competitors. There is an expectation that your submission will be analytical and will draw on theory to frame responses to tasks. The assignment contains Four Parts. Part A: EXCEL for Business Intelligence Problem Description GLM is one of the few major egg producers and manufacturers in Kuching, Sarawak. Their business involves producing and supplying fresh farm eggs for Prinzen local hypermarket, supermarkets and grocery stores. With about 50 employees, the company's net sales exceeded two million ringgits in 2018. GLM was experiencing exponential growth in its business operations, but it was unable to accurately forecast fluctuating sales orders. As a result, the company could Figure 1: Egg Grading Machine not accurately plan its resources and production schedules. The company's existing information systems lacked data integration and business analytics capabilities, which prevented it from acquiring the necessary insights to forecast customer demand. Egg producers are always at risk of incurring inventory problems: either out-of-stock or excess inventory. Both conditions are costly. As a result, they constantly strike to prepare for fluctuations in order volume. To address this problem, GLM wants to evaluate the sales statistics for the past year and the current year to predict future sales. The general manager knows enough about Excel to realise it could be