subject:System analysis and design

2) Based on Figure 1, answer the following questions. Benefitsa Increased sales Improved customer service Reduced inventory costs Total benefits 500,000 70,000 68,000 638,000 Development costs 2 servers @ $125,000 Printer Software licenses Server software Development labor Total development costs 250,000 100,000 34,825 10,945 1,236,525 1,632,295 Operational costs Hardware Software Operational labor Total operational costs 54,000 20,000 111,788 185,788 Total costs 1,818,083 . An important yet intangible benefit will be the ability to offer ser- vices that our competitors currently offer. Customer service numbers have been based on reduced costs for customer complaint phone calls. Assumptions: The greater customer service will decrease the number of customer complaints by 10% each year over 3 years and that $200,000 is spent on phone charges and phone operators who handle complaints call. a) Develop a spreadsheet using Microsoft Excel that calculate the project's cash flow analysis for Computerized Mail Addressing system of Clothes Rack Sdn Bhd. b) Determine Return On Investment (ROI). 2) Based on Figure 1, answer the following questions. Benefitsa Increased sales Improved customer service Reduced inventory costs Total benefits 500,000 70,000 68,000 638,000 Development costs 2 servers @ $125,000 Printer Software licenses Server software Development labor Total development costs 250,000 100,000 34,825 10,945 1,236,525 1,632,295 Operational costs Hardware Software Operational labor Total operational costs 54,000 20,000 111,788 185,788 Total costs 1,818,083 . An important yet intangible benefit will be the ability to offer ser- vices that our competitors currently offer. Customer service numbers have been based on reduced costs for customer complaint phone calls. Assumptions: The greater customer service will decrease the number of customer complaints by 10% each year over 3 years and that $200,000 is spent on phone charges and phone operators who handle complaints call. a) Develop a spreadsheet using Microsoft Excel that calculate the project's cash flow analysis for Computerized Mail Addressing system of Clothes Rack Sdn Bhd. b) Determine Return On Investment (ROI)