Reference no: EM131286138
Topic: excel
Detailed Question: Informatics with Excel #1 - determine a cost / benefit analysis
Your company wishes to invest $675,000 into a new web accelerator product. Your company believes this product will increase online sales as web response time for its users will be significantly better.
You will create a spreadsheet to determine whether the benefit received will outweigh the cost of the product.
For each month your spreadsheet will compute costs and benefits of the system. The analysis should include 3 years of figures.
After the initial purchase price of $675,000 there is a decreasing scale maintenance contract beginning in the second month. The maintenance contact begins at $15,000 and decreases 5.25% per month. (Although this value is subject to change at any time.)
The benefit is realized in increased sales from the company's website. There is a $26,000 sales increase (over the base) in the first month followed by a measurable but declining sales increase each month. The initial projection is that the $26,000 sales increase will decline by 2.75% per month. (Although this value is subject to change at any time.)
Do not hardcode data values in the body of the spreadsheet; use formulas with cell references only.
Create a spreadsheet that will allow your manager to play a "what if" scenario by changing the values via the click of a button, especially for the percentage monthly decrease in the maintenance contract and the monthly decrease in additional sales. (Of course, all values should be changeable by the user.) The user should be able to easily determine the total cost/benefit for the entire time and at the end of any month.
You will determine the layout and formatting of the spreadsheet, along with the correct formulas to solve the problem. Be sure to apply the heuristics of good spreadsheet design. Be sure the user can quickly and easily identify the input and output area. Be sure that the spreadsheet is formatted well.
Use conditional formatting along with the IF function to display a message in the output error indicating "GO" (in green) when benefits exceed cost and "STOP" in red when costs exceed benefits.
I am purposefully not providing you with a design layout for the spreadsheet. Your job is to determine a meaningful presentation of this problem using an Excel workbook.
[This spreadsheet is not realistic as it does not include a discount factor putting the figures into today's values.]
There are many different layouts and designs that can solve this problem well. However, no two spreadsheets submitted by students should be identical as this would indicate plagiarism.
|
What is the distinction between the resume and the cv
: What is the distinction between the resume and the CV?
|
|
Form of an analytic research paper
: The research work should documented in the form of an analytic research paper. The research project should review the literature, distill the primary issues, discuss the various possible solutions to the issues raised, identify "trends," and formu..
|
|
How does one ensure ones self-interest
: How does one ensure one's self-interest when one has to compromise with another to achieve the goal? David Gauthier proposes that it is possible, offering the Prisoner's Dilemma as an example.
|
|
Application and database services
: Please read this in its entirety before answering. Please provide references also. Many organizations are using cloud services to provide application and database services to their users and their customers.
|
|
Determine the layout and formatting of the spreadsheet
: Create a spreadsheet that will allow your manager to play a "what if" scenario by changing the values via the click of a button, especially for the percentage monthly decrease in the maintenance contract and the monthly decrease in additional sale..
|
|
What does a relaxation oscillator do
: If a rectangular pulse drives a differentiator, what kind of output can we expect?
|
|
Consumer sensitive data is adequately protected
: What methods can be put into place to ensure a consumer's sensitive data is adequately protected? Regarding freedom of expression, which types are protected and which types are not?
|
|
Write a cover letter to a prospective employer
: Determine if you will pursue graduate school or employment upon graduation. Note choices that seem to apply to you and why.
|
|
Building a payroll program for a large organization
: Application Architecture Due Week 8 and worth 50 points You have been tasked with building a payroll program for a large organization with offices spread across the United States. The company has one larger data center that each office connects to..
|