spreadsheet aplications

SoccerBoss
Category:
Other
Price: $15 USD

Question description

Periodically, it is good business practice to perform a comparative analysis of select groups of employees against published or calculated norms of similar groups in the marketplace. This analysis can justify actions that will preserve employee satisfaction, promote productivity, and prevent attrition. The CEO has asked for a market analysis of the salary levels of the software analysts in the company. 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 In this equation, X is the number of trouble calls handled weekly by a software analyst, and S is the annual salary of the software analyst. The equation for the annual income to offset the software analyst salary is as follows: I = 2,340X In this equation, X is the number of trouble calls handled weekly by software analysts, and I is the annual income for subsidizing the software analyst salary. Assignment Part 1: Create a Microsoft Excel spreadsheet with any single worksheet, and perform the following steps: Name the worksheet FirstInitialLastName_Week3IPa (e.g., MRogers_Week3IPa.xls). 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" for Windows, and choose "Vertical Axis Crosses Between Categories" for Mac." Part 2: Using text labels, indicate the following information on the graph: The break-even point The area that represents profit The area that represents loss

Tutor Answer

(Top Tutor) Daniel C.
(997)
School: UC Berkeley
PREMIUM TUTOR
Studypool has helped 1,244,100 students
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1825 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors