Compute for total computed salary

Assignment Help Computer Engineering

Reference no: EM133218607

Question

Employees in an organization can be "part-time" or "full-time" employees as the STATUS. The organization keeps the EMPLOYEE-ID, LASTNAME, FIRSTNAME, MI, AGE and GENDER of each employee. In addition, for each employee, the organization keeps the employee's DATE-OF-EMPLOYMENT and YEARS-OF-SERVICE, EMPLOYMENT-STATUS (Probationary, Regular), RATE-PER-DAY. Each employee occupies one position which is identified by a POSITION-NO with POSITION DESCRIPTION (Clerk, Production Worker, Manager) and is in one DEPARTMENT (Accounting, I.T., Finance, Operation, Personnel). The NO-OF-DAYS-WORK of the employees in a MONTH as their attendance are also recorded. Computer for the SALARY as NO-OF-DAYS-WORK by RATE-PER-DAY.

Compute for Total Computed Salary, find the Youngest and Oldest Employee. Retrieve Position and Department from a table using VLOOKUP. An employee who work more than 40 hours is considered REGULAR. Provide at least 5 different records.

Reference no: EM133218607

Questions Cloud

Lifecycle stages within continual service improvement stage : What are other roles of other lifecycle stages within (CSI) continual service improvement stage.

Determine an impact on total quality management : From the perspective of hotel management, determine which aspect of managing employees has an impact on Total Quality Management.

Describe during which stage of the software implementation : Describe during which stage of the software implementation are these detailed design specifications likely to be implemented. Explain reasons

Analysis to affect or create competitive advantage : Briefly Describe how the company can use this analysis to affect or create competitive advantage.

Compute for total computed salary : Compute for Total Computed Salary, find the Youngest and Oldest Employee. Retrieve Position and Department from a table using VLOOKUP. An employee

Identify at least three musical characteristics : Musical Characteristics - Identify at least three musical characteristics that were essential to early African American music

Prepare a risk management plan to address issues : Prepare a risk management plan to address issues, concerns and threats related to the marketing program using Template 4.

Discuss primary components of the security policy : Discuss the primary components of the security policy with respect to the security requirements described within the is Identification and Authentication

Explain the specific evaluation design you plan to utilize : Explain the specific evaluation design you plan to utilize for your type of program evaluation, such as a pre-test/post-test, or post-test only design

User Account

All Pages