Case Study- Chemist Service Group Chemist Service group is a chain of chemist stores. It employs more than 8,000 staff members distributed over 500 retail stores nationally and been growing at a rapid rate Chemist Service stores are selling health products in stores and online, and preparing medication prescribed for paticnts as well. Thcrcforc, the business deals with two types of customers: the customers who purchase products either in local stores or online, and another type is the patients who need prescribed medications cither occasionally or regularly. Thosc patients can only make purchase in a local store Each store is made up of two divisions as follows: 1. Serving patients by preparing medications; giving pharmacological information to multidisciplinary health care team; monitoring patient drug therapies. Those service staff are professional pharmacists. 2. Selling health products of different brands procured from different suppliers. Web users create an account, which stores their contact details and their nominated username and password for return visits. User login or account creation is required prior to mark orders. The online product orders are either arranged for local pick-up or delivered via courier at an additional fee. Customers can make their payment by cash, cheque and credit cards in local stores. However, online purchases must be paid by credit cards for delivery The management wants to add more features to its existing web site. The web site provides not only the onlinc ordering facilities utilising a typical shopping cart and checkout model, but also more sectors such as promotions, introduction of new products, and the news of classified products such as Baby, Beauty, Home Health, Health advice, and Wellness programs, etc. The membership registration sector should attract loyal customers by providing "Frequent buyers" program for awarding discount points and special offers Each store has a local operational database to capture their day-to-day business processes such as POS transactions and backend inventory database The managers check their local inventory database to see the balance of products daily and observe the hot selling products. The managers need to order the products from the central warehouse, receiving delivered products and updating the inventory database. Each order is associated with an order date, requested ship date, product quantity, sales rep, and a deal, etc A deal is an agreement between Chemist Service group and supplier for their goods related discount during a fixed period. The management needs to analyse the sales from different types of products for data analysis, forecasting demand, procurement and order decisions. They also need data for their expansion plan. The managers need to analysis customer bchaviours and location performance for better planning and promotion decisions. Chemist Service group needs to have an integrated information system to help their management for business intelligencc. They sce the need to increase their capacity a Case Study- Chemist Service Group Chemist Service group is a chain of chemist stores. It employs more than 8,000 staff members distributed over 500 retail stores nationally and been growing at a rapid rate Chemist Service stores are selling health products in stores and online, and preparing medication prescribed for paticnts as well. Thcrcforc, the business deals with two types of customers: the customers who purchase products either in local stores or online, and another type is the patients who need prescribed medications cither occasionally or regularly. Thosc patients can only make purchase in a local store Each store is made up of two divisions as follows: 1. Serving patients by preparing medications; giving pharmacological information to multidisciplinary health care team; monitoring patient drug therapies. Those service staff are professional pharmacists. 2. Selling health products of different brands procured from different suppliers. Web users create an account, which stores their contact details and their nominated username and password for return visits. User login or account creation is required prior to mark orders. The online product orders are either arranged for local pick-up or delivered via courier at an additional fee. Customers can make their payment by cash, cheque and credit cards in local stores. However, online purchases must be paid by credit cards for delivery The management wants to add more features to its existing web site. The web site provides not only the onlinc ordering facilities utilising a typical shopping cart and checkout model, but also more sectors such as promotions, introduction of new products, and the news of classified products such as Baby, Beauty, Home Health, Health advice, and Wellness programs, etc. The membership registration sector should attract loyal customers by providing "Frequent buyers" program for awarding discount points and special offers Each store has a local operational database to capture their day-to-day business processes such as POS transactions and backend inventory database The managers check their local inventory database to see the balance of products daily and observe the hot selling products. The managers need to order the products from the central warehouse, receiving delivered products and updating the inventory database. Each order is associated with an order date, requested ship date, product quantity, sales rep, and a deal, etc A deal is an agreement between Chemist Service group and supplier for their goods related discount during a fixed period. The management needs to analyse the sales from different types of products for data analysis, forecasting demand, procurement and order decisions. They also need data for their expansion plan. The managers need to analysis customer bchaviours and location performance for better planning and promotion decisions. Chemist Service group needs to have an integrated information system to help their management for business intelligencc. They sce the need to increase their capacity a