Login to Your Account

Solution Posted by

- Requests: 0
- Solutions: 880

Solution Detail

Price: $30.00

- From: Business,
- Posted on: Fri 26 Jul, 2013
- Request id: None
- Purchased: 0 time(s)
- Average Rating: No rating

Request Description

** **

**Create a market analysis of salary levels of the software analysts.**

A linear correlation has been found between the number of trouble calls taken by software analysts and their salaries. The equation for this correlation is expressed as follows:

S = 545X + 36,400

Equation:

X number of trouble calls handled weekly

S is the annual salary of the software analyst.

Equation for annual income to offset the software analyst salary:

I = 2,340X

X is the number of trouble calls handled weekly by software analysts, and I is the annual income for subsidizing the software analyst salary.

Create a Microsoft Excel spreadsheet with single worksheet follow steps:

Create a table with 3 columns. Label the first column "Weekly Trouble Calls - X," the second column "Salary," and the third column "Income."

In the column labeled "Weekly Trouble Calls," enter numbers from 1 to 50, one number per row.

Create formulas for the Salary column and Income column to calculate the value of S and I based on the equations above for each of the 50 values of X. Format these 2 columns to be currency, rounded to whole dollars.

Create a line graph showing the two lines formed by both equations. Add a legend identifying the lines as Salary and Income. Format the axes, if necessary, to avoid a crammed look. For the horizontal axis, specify an interval unit of 5 and choose "Position Axis on Tick Marks."

Using text labels, indicate the following information on the graph:

· The break-even point

· The area that represents profit

· The area that represents loss

Solution Description

26$50,570.00#VALUE!

27$51,115.00#VALUE!