2018/19 – Business & Financial ComputingCO1109/CO1909Assignment 215I. Objective Inspired by a real-life case, the students are introduced to a kind of a non-technicaltask that IT professionals often perform in practice. The assignment develops thestudents’ skills in problem solving, analysis and reporting.II. Important Dates:1. Starting date Thursday 28th February 20192. Submission Deadline 15th March 2019, 3 pmIII. Policy on Plagiarism: Department of Computer Science Rules The Department operates the principlethat both the plagiarised and the plagiariser are equally guilty. Students aretherefore responsible for ensuring that their work is not plagiarised, and note thatthis includes ensuring that any work stored on the departmental and/or universitycomputer systems is suitably protected. Note that the Department reserves the right to exact any penalties which are inaccordance with the Universitys code of practice on plagiarism. The Department has its own set of regulations concerning plagiarism which can befound in the Study Guide of any module. The Department takes this issue veryseriously, and students should note that on occasions in the past some very seriouspenalties have indeed been applied, including reduction of module mark to zero,and overall reduction of degree class. Additionally: Plagiarizing any part of the assignment will result in gettingZERO in the whole assignment.IV. Assignment #2Imagine that the company you work for is about to buy a software product for a newapplication. After researching the market, it has been decided that there are 2alternatives: a commercial product (Product A) and a cloud-based product (ProductB). Your manager has asked you to perform a comparative study of the 5-year costs ofthe 2 products, based on the variation of number of users that will have access to theapplication and prepare a power-point presentation that summarizes your findings andconclusions.122After contacting the products’ vendors, talking to your colleagues and researching themarket you have identified the following facts:Product AProduct A consists of 4 components (subproducts) that are all required for the newapplication, however, they are licensed independently: Component A1 that is licensed on a per user basis, costing ￡80 per User thatwill have access to the application. Component A2 that is licensed on a per user basis, costing ￡120 per User thatwill have access to the application. Component A3 that is licensed based on the number of CPUs that are installedon the application server that the product will run, costing ￡15000 per installedCPU. Component A4 that is licensed based on the number of CPUs that are installedon the application server that the product will run, costing ￡10000 per installedCPU.It is estimated that in order to be able to perform adequately in the productionenvironment, Product A requires 2 CPUs for up to 300 Users, 4 CPUs for 301 to 600Users and 8 CPUs for 601 to 1000 Users.Additionally, the new application will have a disaster recovery site for which the costfor product A is calculated as 40% of the price of the license for the production sitewhen, however, the production site license is calculated with no users accessing theproduct. Note that, given its purpose, the disaster site still needs to have theappropriate processing power in order to be able to accommodate the same number ofusers as the production site.Moreover, starting from the second year, for Product A, the bank will have to pay theproduct vendor an annual 20% maintenance fee over the final product license price(where the final price includes both the production and the disaster recovery sites).The implementation/customizations fee that the vendor will apply for Product A isfixed and equal to ￡80 000. Moreover, starting from the second year, the vendor willapply an annual 10% maintenance fee over the implementation/customizations fee.Product BThe cloud-based product (Product B) is subscription-based, starts from the firstyear and costs ￡15 000 per year, per CPU installed on the application server that theproduct will run.It is also estimated that in order to be able to perform adequately in the productionenvironment, Product B requires 4 CPUs for up to 400 Users, 6 CPUs for 401 to 600Users and 8 CPUs for 601 to 1000 Users. There is no cost for the disaster site forProduct B.The implementation, once-off, fee that the vendor will apply for Product A is fixedand equal to ￡60000. There is no annual maintenance fee over the implementation feefor Product B. 3Hardware CostsThe acquisition cost of each CPU that is installed on the application server in theproduction and disaster sites is ￡5000. The CPU cost has also a 12% annualmaintenance fee which starts from the second year.Based on the facts above and in order to prepare the presentation to your manager youshould perform the following tasks: Devise the mathematical formulas that calculate the 5-year costs for each of theproducts above (the 5-year costs should include elements such as the productionsite license costs, the disaster site license costs and the maintenance orsubscription costs) Based on the previous formulas and using MS Excel or by developing your ownapplication, implement the formulas you devised and also build the followingdiagrams/graphs:- The first diagram will show (in the same diagram) the 5-year costs of each ofthe products as a variation of the number of users, in other words the verticalaxis is the 5-year cost (in ￡) , whereas the horizontal axis is the number ofusers ranging from 50 to 1000, in intervals of 50 users.- The second diagram will show the 5-year cost difference of the two productsas a variation of the number of users, in other words the vertical axis is the 5year cost difference (in ￡) (Product A 5-year cost minus Product B 5-yearcost), whereas the horizontal axis is the number of users ranging from 50 to1000 in intervals of 50 users).-assuming that the usage of Product A will provide the bank an annual profitof ￡85 000, provide a graph in which the vertical axis is the Payback Periodfor the investment in Product A, whereas the horizontal axis is the number ofusers ranging from 50 to 1000, in intervals of 50 users. Note: in calculating thePP you should consider only the initial CAPEX investment for Product A, notthe 5-Year TCO.o Prepare a concise power point presentation to your manager (in a presentationform suitable for your manager). The slides of the presentation should include atleast the following:o the facts you have identified (already described above),o the graphs you have prepared (as defined above)o your own conclusions from this analysis you performed i.e. what does youranalysis show that your manager needs to be aware of e.g., which of the 2products is more cost-effective and in which cases? If you wish, you mayinclude other calculations in order to reach conclusions on the comparison(e.g. the 7-year or the 10-year costs of each product)o A list and brief explanations of additional cost factors (at least 4 of them)that you believe the previous analysis does not take into account, but shouldnevertheless be considered in order to be able to calculate with moreprecision the final total 5 year-cost of the application. For example, the costof telecommunication lines is an example of such factor.4Notes:1. If you use MS Excel to implement your formulas you may have to use the Excel“IF” function for which you can find several resources online (depending onwhich MS Excel version you will use). You would also need to create charts inExcel, a task for which you can also find several resources online.2. If you prefer not to use MS Excel, you may choose any widely applicableprogramming language (e.g. Java, C#) and user interface technology (e.g.browser-based or other) to implement the application (as long as it runs in aWindows XP or later OS and does not require any special additional software (oreven hardware)). Please ask if in doubt on what programing language to use.3. The assignment will be marked according to the following criteria:Criteria WeightFormulas Completeness and Correctness 30%Formulas and Graphs Implementation Quality, Completenessand Correctness (either in MS Excel or other)35%Quality of the Power Point report contents and presentationelements35%V. Submission Notes: Late submissions of the assignment report and project files (within 24 hours) willautomatically lose 50% of the mark. Late submissions (more than 24 hours) are not accepted. In case of emergency,illness, etc., late work may be accepted without penalty, provided that enoughsupporting documents are submitted. Submissions should be made electronically containing the following deliverables:1. The .xls file with the formulas implementation or the source code youhave developed in which case the “byte” code and the necessary scriptsand a file with instructions on how to set up and “run” it in a WindowsXP or later OS should also be included.2. The report (in .ppt format) that you would have delivered to yourmanager.All the above should be bundled in a .zip file that should be namedAssignment2.zip 本团队核心人员组成主要包括硅谷工程师、BAT一线工程师，精通德英语！我们主要业务范围是代做编程大作业、课程设计等等。我们的方向领域：window编程 数值算法 AI人工智能 金融统计 计量分析 大数据 网络编程 WEB编程 通讯编程 游戏编程多媒体linux 外挂编程 程序API图像处理 嵌入式/单片机 数据库编程 控制台 进程与线程 网络安全 汇编语言 硬件编程 软件设计 工程标准规等。其中代写编程、代写程序、代写留学生程序作业语言或工具包括但不限于以下范围:C/C++/C#代写Java代写IT代写Python代写辅导编程作业Matlab代写Haskell代写Processing代写Linux环境搭建Rust代写Data Structure Assginment 数据结构代写MIPS代写Machine Learning 作业 代写Oracle/SQL/PostgreSQL/Pig 数据库代写/代做/辅导Web开发、网站开发、网站作业ASP.NET网站开发Finance Insurace Statistics统计、回归、迭代Prolog代写Computer Computational method代做因为专业，所以值得信赖。如有需要，请加QQ：99515681 或邮箱：99515681@qq.com 微信：codehelp
网友评论