Project Two: Your Task

$$ Your first task for this project is to construct spreadsheets like the ones

we discussed in class that will illustrate the current and proposed

infrastructure costs for the HostPenny given this proposed virtualization

project.

$$ You should create $(1)$ a constants and shared variables spreadsheet, $(2)$ a

variables spreadsheet that includes all the variables defined in the

project, $(3)$ a current infrastructure cost spreadsheet, $(4)$ a virtualization

project cost spreadsheet, and $(5)$ a summary spreadsheet that highlights

the major costs and benefits of the project.

IMPORTANT $!!!$

You must create your spreadsheet using variables to identify the various costs that are

being tracked. In other words, don$$t hard code any numbers into the formulas in your

spreadsheets. The following page illustrates one of the variables pages in my

spreadsheet where I defined the variables used in current cost spreadsheets. You must

include a similar page$($s$)$ in your spreadsheet. Also see the template on WebCourses. Project Two: Your Task

$$ Once your spreadsheets are completed, you$$ll construct a $1$ page executive

summary report of your findings.

$$ This report should address the feasibility of the proposed project and its

financial impact on the HostPenny.

$$ Normally, an executive summary summarizes a more complete

accompanying report. You will not be preparing this more complete report

in this case, you will only be preparing the executive summary.

$$ If you have never prepared an executive summary before $($if you did project

Project Two: Your Task

$$ Note that an executive summary is different from an abstract$.$

$$ Abstracts tend to be most common in academic environments whereas

executive summaries are primarily confined to business environments.

$$ An abstract is a brief summarizing statement which is read by people who

are trying to decide whether or not to read the entire document.

$$ An executive summary is the document in miniature which can be read in

place of the longer document.

Project Two: Deliverables

$1.$ A spreadsheet $($similar to that we developed in the notes$)$ with

worksheets containing variable definitions, current cost

infrastructure, proposed project cost infrastructure, and a

summary worksheet. Feel free to use the spreadsheet template

on WebCourses as starting point for your project.

$2.$ A one page executive summary of your findings with respect to

the feasibility of this project for the HostPenny. This executive

summary should give an extremely brief overview of the

proposed project, a summary of your findings $($spreadsheet

analysis results$),$ and a recommendation of whether the project

should move forward or not.