Case study: CompIT CompIT is a retailer selling computers and IT accessories directly to customers through retail outlets. For the past one month, the staff discovered that several backlogs of 1,000 customer orders have not been processed. In addition, duplicate customer orders and errors in the invoice items were also discovered. Currently, the pending orders are not shared among the departments and there is no centralized database to store the records. The staff are feeling increasingly stressed with the increased number of customer orders and must work overtime to process the pending orders. This situation has resulted in customer dissatisfaction and indirectly demotivates the staff. John, the Chief Executive Officer (CEO) of CompIT, has appointed your team to develop an online ordering system to solve the existing problems. Your team consists of a project manager, one senior team leader, two junior programmers, two system analysts and one database administrator. The budget allocated is RM200,000 and the project duration is 10 months. The objectives of the proposed online ordering system are listed below: Automate order processing requests Save customer and order records in a centralized database Eliminate errors using barcode readers to scan items code Allow information sharing among departments Generate invoice to customer Produce summary reports to management John has requested that the system is developed using C# language and MySQL database. He has emphasized on the need for information sharing among departments with security protection. You found that some of your team members are inexperienced and unfamiliar with web-based application development. During requirements gathering from departmental managers, the information collected are: customer order placement, stock checking, customer order processing, invoice issuance, items packaging and reporting. The departmental manager requested to improve the current customer order process workflow which includes taking orders, processing orders, packing ordered items for delivery and issuing invoice to the customers. Question 1 Answer the following questions based on the given ComplT case study: a) John would like to know the progress of the ordering system project. Currently the project is in the gth month of development where the actual cost has reached RM156,000. The planned value in the 8th month is RM164,000. Only 80% of the work has actually been completed and the budget at completion is RM200,000. Using earned value analysis, Calculate the earned value, schedule variance and cost variance for the project. You are required to show the steps in your calculation and round up your answer to 3 decimal places. Analyse the cost performance index (CPI) and schedule performance index (SPI) of the project. Which aspect is this project performing better? (7 marks)