Reference no: EM13875162
Mini-Case Study
Upton, Martin, Ulysses, & Clapper (UMUC) is a medium-sized financial analysis firm specializing in conducting independent economic and market assessments for banks, insurance companies, mortgage lenders, and government regulatory agencies. UMUC also provides independent verification and validation (IV&V) services for assessments and reports that were developed internally by these entities. The firm is highly respected for its unbiased, politics neutral, objective, accurate financial and economic products and services.
You are a Senior IT Specialist & Systems Analyst at UMUC. One of your responsibilities is to identify and recommend computer equipment for technology refreshes and new initiatives. The Senior Manager, Revolving Debt Analysis (RDA) has come to you because it is time for a technology refresh and there is a new initiative to conduct more complex, national-level analysis of credit card fraud, default, and write-off data. Specifically, banks, credit card companies, and some law enforcement entities want to see if this analysis will assist in targeting identity thieves.
The Senior Manager explains that RDA will need to refresh 35 desktop personal computers (PC). The new PCs will need to run complex calculations based on statistical models that use large amounts of data. Due to the unique nature of the datasets, data models, queries, formulas and equations and the individuality of the financial analysts and economists (many hold a PhD), the actual compute power needs to be in the desktop machine. Your task is to assess and identify the hardware needed that will allow the financial analysts and economists (collectively the users) to complete their work. The Senior Manager, RDA provided a table of requirements (see below), which shows the activities and software the PC hardware needs to support.
Table of Requirements
|
ID
|
Attribute
|
Type
|
Comments
|
|
RDA001
|
Windows 8.1 Professional(64bit)
|
Software
|
Used as standard operating system
|
|
RDA002
|
MS Office Professional Plus 2013
|
Software
|
Used to create documents, presentations, complex workbooks/spreadsheets, and to develop local datasets and databases. Daily activities involve using:
|
|
RDA003
|
Adobe Acrobat X Suite
|
Software
|
Used to create PDF documents; combine audio, video, and presentation slide; develop media from multiple types of input; and create interactive documents and presentations.
|
|
RDA004
|
SAS 9.4
|
Software
|
Used for financial, fraud, and related data analytics work.
|
|
RDA005
|
MatLab R2014b
|
Software
|
User for programming and algorithm development, data analysis and visualization, and numeric computations.
|
|
RDA006
|
Stata 13 (Stata/MP) for Windows
|
Software
|
Used for forecast, multiple mixed-effect and linear models, linear and non-linear combinations, generalized predictions, and statistical and data tests.
|
|
RDA007
|
R for Windows
|
Software
|
Used for data manipulation, calculation and graphical display.
|
|
RDA008
|
MS Outlook 2013
|
Software
|
Used to connect with MS Exchange for emails, calendar, contact lists, address books, and reminders.
|
|
RDA009
|
McAfee Endpoint Protection - Advanced Suite
|
Software
|
Used for antivirus, firewall, email and data protection.
|
|
RDA010
|
Connect to network data marts, data warehouse, databases, and datasets
|
Activity
|
Analysts and economists need to conduct data mining, compile and analyze data, and produce complex reports.
|
|
RDA011
|
Participate in online, real time conferences and training
|
Activity
|
Used for professional development and gather information on market trends.
|
|
RDA012
|
Write complex queries to run jobs and calculations on local and server based datasets and databases
|
Activity
|
This is a regular and normal work activity for this organization's users.
Once started, some jobs may take hours to complete.
|
|
RDA013
|
Create, edit, and manage audio and video files
|
Activity
|
This is a regular and normal work activity for this organization's users.
|
|
RDA014
|
Import, edit and manage digital photos
|
Activity
|
This is a regular and normal work activity for this organization's users.
|
|
RDA015
|
Create local datasets and databases
|
Activity
|
This is a regular and normal work activity for this organization's users.
|
|
RDA016
|
Develop and manage complex multi-media documents, spreadsheets, and presentations
|
Activity
|
This is a regular and normal work activity for this organization's users.
|
|
RDA017
|
Consolidate complex multi-media documents, spreadsheets, and presentations to develop interactive Web-based reports
|
Activity
|
This is a regular and normal work activity for this organization's users.
|
The Assignment& Deliverable
This is an individual assignment. You must work on your own.
The assignment is to analyze the mini-case and table of requirements to assess and identify the hardware needed that will allow the financial analysts and economists (collectively the users) to complete their work. The focus must be on the internal hardware components (motherboard, CPU, RAM, bus, hard drive, connectors & ports, etc.). Do not simply visit a PC/Workstation manufacturer's site (Dell, HP, etc.) and select a machine. This will not be successful. You must identify each component; determine its size, capacity, speed, etc.; and show how each requirement will be met.
The deliverable is an MS Word document based on the template embedded in this document. The audience for the deliverable is the Senior Manager, RDA; other RDA managers and supervisors; and selected RDA users. The expectation is RDA will be able use the report and work with Procurement to develop a Request for Quotation (RFQ).
|
Calculate the break-even after-tax yearly lease payment
: If the after-tax present value of buying equipment and using it for six years is $125,000, calculate the break-even after-tax yearly lease payment (seven payments) using a 8% real discount rate. (Assume that lease payments are made at the beginning o..
|
|
What is the call premium of the bond
: You own a bond with a 6.3 percent coupon rate and a yield to call of 7.2 percent. The bond currently sells for $1,105. If the bond is callable in five years, what is the call premium of the bond?
|
|
Vidalia company reported revenues
: For the current year, Vidalia Company reported revenues of $250,000 and expenses of $225,000.
|
|
What is the discounted payback period for these cash flows
: An investment project has annual cash inflows of $4,300, $4,000, $5,200, and $4,400, and a discount rate of 13 percent. What is the discounted payback period for these cash flows if the initial cost is $7,900?
|
|
Identify hardware needed that will allow financial analysts
: The assignment is to analyze the mini-case and table of requirements to assess and identify the hardware needed that will allow the financial analysts and economists (collectively the users) to complete their work
|
|
Effects of an increase in the demand for labor in both model
: Using labor supply and demand graphs for both the Keynesian and classical models show that involuntary unemployment may exist in one model but not the other. What contributes to involuntary unemployment?On separate graphs, please show the effects of ..
|
|
Suppose that the index model for stocks
: Suppose that the index model for stocks A and B is estimated from excess returns with the following results: RA = 1.6% + 0.70RM + eA RB = –1.8% + 0.9RM + eB σM = 22%; R-squareA = 0.20; R-square B = 0.15
|
|
Discuss the federal reserve act
: Discuss the Federal Reserve Act of 1913; what exactly the act did, what the FED was supposed to do, and why it was passed. Did the FED act as anticipated in the stock market crash of 1929. If not, what did it not do that it should have?
|
|
Difference between commercial banks and investment banks
: Explain the difference between commercial banks and investment banks. Discuss their roles in our financial system, how each facilitates capital raising by firms, and how each earns profits. Discuss the potential conflict of interest when these two en..
|