# break-even point,profit,loss - 19723

Solution Posted by

## studentlance

Rating : (5)F
Solution Detail
Price: \$30.00
• 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 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!

Attachments