# Record functions for healthcare 2 - 20674

Solution Posted by

## studentlance

Rating : (5)F
Solution Detail
Price: \$15.00
• Posted on: Tue 30 Jul, 2013
• Request id: None
• Purchased: 0 time(s)
• Average Rating: No rating
Request Description

Record functions for healthcare 2

reate 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 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

2\$37,490.00\$4,680.00

3\$38,035.00\$7,020.00

4\$38,580.00\$9,360.00

5\$39,125.00\$11,700.

Attachments