Calculate the total salary for remaining employees

Assignment Help Management Information Sys
Reference no: EM131868308

You are the Chief Technology Officer (CTO) for a medium sized organization with approximately 1500 employees. Due to problems within the industry, the company's sales force needs to be reduced by at least 25%.

As the head of the Technology department, you must review the performance of all the technical sales people and determine who will be kept and who will be laid off. At present, all of the sales force employees are earning a salary between $50,000 and $100,000.

The employees each had to complete a product knowledge exam and have been rated by their managers. Both the exam scores and the manager evaluations were based out of 100 points.

The scores and evaluations are provided in the spreadsheet. One employee earned a perfect score (100) on the product knowledge exam. Your decisions on who to layoff will be based primarily on their overall score. Click here to download the spreadsheet for this assignment.

Review the provided spreadsheet to ensure the accuracy of the current data and correct any errors that you identify. These could be typos or errors in functions or formulas.

Complete the remaining analysis and format the spreadsheet to include the following:

Someone made an error when inputting the employees ID numbers and formatted them with decimals. These should be formatted like a Social Security Number.

Calculate the Overall Score for each employee out of 100 points. The Product Knowledge Exam is worth 30% of their score and the manager's evaluation is worth 70%.

In the "Layoff?" column, use a VLOOKUP function to identify those employees who will be laid off based on their Overall Score that was calculated and using the provided Table Array found on Sheet 2. Use an absolute reference where appropriate.

Format the fonts - colors, sizes, and types to be both professional and visually appealing

Format the rows and columns to appropriate heights or widths for the data

Choose a company name and replace "Company Name" in cell A1 with the new name.

Add a company logo that will correspond with the organization's name. Assure that the logo you choose or design is not copyright protected.

Sort the data based on the "Layoff?" column so that the employees who are recommended to be laid off are shown first.

Create a line chart that shows the employee names, product knowledge exam scores, and manager ratings. The chart must be on a separate sheet within the file.

Make a recommendation to the CEO under the "RECOMMENDATION" cell. You must recommend at least 25% of the employees for layoff. Use the criteria provided for the "Layoff?" column to assist with your recommendation. For any employees recommended for layoff who do not fall below the minimum 70 overall score (indicated in the table on Sheet2), you must justify your reasoning for not keeping the employee.

Use a function or formula that uses cell references to calculate the total annual cost savings for the company after your recommended layoffs.

Calculate the total salary for remaining employees based on total salary and the savings due to laid off employees that was calculated previously.

Attachment:- Unit_4 data.xlsx

Reference no: EM131868308

Questions Cloud

Measure and assess effectiveness of a production capability : 1. How would you measure and assess effectiveness of a production capability?
How would managers use the materials in managerial decisions : How would managers use the materials in chapters 12, 13, and 14 in managerial decisions. Provide one practical example to support your discussion.
Definition of risk management in healthcare : Definition of Risk management in healthcare? Risk Management role in Nursing?
Approaches to defective decision-making : How are Harvey and Janis approaches to defective decision-making similar? How do they differ in relation to the factors described in the article?
Calculate the total salary for remaining employees : Calculate the total salary for remaining employees based on total salary and the savings due to laid off employees that was calculated previously.
Community in providing services : Besides, I need ways and ideas to measure the success of my project and the kind of controls I can put in place to help the organisation
Respective financial positions can be drawn : What conclusions concerning the companies’ respective financial positions can be drawn?
What can be the pros-cons of the use of work cells : What can be the pros/cons of the use of work cells? Pick two of the cons you list and discuss the possible solution.
Responsible for a variety of tasks and responsibilities : Project managers are responsible for a variety of tasks and responsibilities. However, the challenges presented with health informatics

Reviews

Write a Review

Management Information Sys Questions & Answers

  Information technology and the changing fabric

Illustrations of concepts from organizational structure, organizational power and politics and organizational culture.

  Case study: software-as-a-service goes mainstream

Explain the questions based on case study. case study - salesforce.com: software-as-a-service goes mainstream

  Research proposal on cloud computing

The usage and influence of outsourcing and cloud computing on Management Information Systems is the proposed topic of the research project.

  Host an e-commerce site for a small start-up company

This paper will help develop internet skills in commercial services for hosting an e-commerce site for a small start-up company.

  How are internet technologies affecting the structure

How are Internet technologies affecting the structure and work roles of modern organizations?

  Segregation of duties in the personal computing environment

Why is inadequate segregation of duties a problem in the personal computing environment?

  Social media strategy implementation and evaluation

Social media strategy implementation and evaluation

  Problems in the personal computing environment

What is the basic purpose behind segregation of duties a problem in the personal computing environment?

  Role of it/is in an organisation

Prepare a presentation on Information Systems and Organizational changes

  Perky pies

Information systems to adequately manage supply both up and down stream.

  Mark the equilibrium price and quantity

The demand schedule for computer chips.

  Visit and analyze the company-specific web-site

Visit and analyze the Company-specific web-site with respect to E-Commerce issues

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd