Record functions for healthcare 2 - 20674

Solution Posted by
studentlance

studentlance

Rating : (5)F
Solution Detail
Price: $15.00
  • From: Business,
  • 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 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

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
Record functions for healthcare 2.xlsx
Record function...