Reference no: EM13746985
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
|
What is their average tax rate and effective tax rate
: Scot and Vidia, married taxpayers, earn $240,000 in taxable income and $5,000 in interest from an investment in City of Tampa bonds. Using the U.S. tax rate schedule for married filing jointly, how much federal tax will they owe? What is their averag..
|
|
Evaluation of the new organization
: Propose and describe two graphs and/or charts that you might find useful to prepare in the evaluation of the new organization. Summarize the purpose of each graph and the information that would be presented. Attach a sample to your response
|
|
Demonstrate selected perceptions
: Students will choose a company of their liking and use any of the 2 (qualitative or quantitative) research and analysis methods to demonstrate selected perceptions (approved by the faculty) of the company. This project requires you to research, re..
|
|
Identify a potential aspect of the project
: Given the purpose of the project and 6-month timeframe, devise a project plan, with objectives, activities, time-scales and deliverables, for your project.
|
|
Create a market analysis of salary levels
: 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
|
|
Costing method for the material component of raw materials
: On January 31, 2011, we elected to change our costing method for the material component of raw materials, work in process, and finished goods inventory to the lower of cost or market using the first-in first-out (“FIFO”) method, from the lower of cos..
|
|
Hypertonic or hypotoni
: Hypertonic, or hypotonic? Would water move into or out of the red blood cells (RBC) to maintain equilibrium?
|
|
Write a book review of an american soldier in world war i
: write a book review of An American Soldier in World War I. In the Book Review, you must identify the authors' thesis and evaluate how effectively theysupport it.
|
|
Genes are transferred from the parent organisms
: During reproduction, genes are transferred from the parent organisms to the offspring, whether they are tomato seeds or baby walruses. Scientists have learned how to isolate genes and insert them into cells without using the parents. Genes may now be..
|