I have an assignment that uses excel, but for the life of me, cannot get it to do what I need it to do. Ive asked my professor, googled and watche
I have an assignment that uses excel, but for the life of me, cannot get it to do what I need it to do. I’ve asked my professor, googled and watched YouTube videos, have asked tutors, and nothing!
1
Hannah Davidson
OL 325 Total Rewards
Professor Kearny
April 2, 2022
2
Internal Consistency
Benefits Manager Job Description
Job Summary: Under the direction of the Human Resources director, the benefits manager
manages all functions associated with the organization’s benefit program. They will design,
evaluate, and modify benefits programs and policies to ensure that they are current and in
compliance with legal requirements. The benefits manager must also administer, direct, and
review employee benefit programs.
Essential Job Duties:
• Developing and implementing new compensation and benefits programs, policies, and
procedures
• Ensuring all programs, policies, and procedures comply with current legislation.
• Communicating with third-party services to negotiate benefit plans and resolve benefit-related
issues
• Managing subordinate HR employees and daily operations related to compensation and
benefits activities
• Preparing budgets, reports, and presentations
Knowledge, skills, and abilities:
• HR software such as ADP Workforce Now, human resource information system (HRIS), or
human resource management software (HRMS)
• Enterprise resource planning (ERP) software such as Microsoft Dynamics GP, Oracle
Hyperion, or Oracle JD Enterprise One
3
• Experience with Federal and State employee benefit laws involving employee benefits (such as
COBRA, HIPAA, FMLA, OFLA, etc).
• Advanced knowledge of spreadsheet and database applications, data query tools, word
processing software, electronic mail and internet search tools.
Minimum qualifications: Bachelor’s degree from an accredited college or university in human
resources, business or public administration, or a related field. CEBS/GBA/SHRM/SPHR/GPHR
certification desirable.
4
Production Worker Job Description
Job Summary: Under the direction of the production manager, the production worker handles
various duties in the warehouse. They will assemble and prepare goods for shipment while
keeping a clean and safe workspace and complete quality assurance testing on products. Move
materials or completed products and packages to established locations while maintaining proper
storage and inventory.
Essential Job Duties:
• Performs work in compliance with standard operating procedures and rotates through various
stations on the lines, where needed, to ensure production needs are met
• Performs general manual labor tasks including packaging, labeling, lifting, moving, and
loading product
• Complies with safety policies, the safety program and is pro active with safety concerns
• Monitor and inspect products for defects to ensure quality standards are met
• Operate machinery to assist in the production process, set up and control
• Maintain a clean workspace as well ensuring that the equipment is operating properly
Knowledge, skills, and abilities:
• Able to push, lift, and pull products up to 50 pounds
• Able to stand up to 8 hours
• Technical and mechanical skills
• Experience operating a forklift
• Ability to detect potential problems with machinery
Minimum Qualifications: Highschool diploma/GED
5
Job Evaluation for Administrative Assistant
Degree 1 for education and technical skills is appropriate considering a high school diploma or
GED is sufficient for the administrative assistant. Simple tasks such as email and phone
communication, errand running, scheduling appointments, file organization, etc. are performed.
Problem solving and impact of job are degree 2, considering the administrative assistant works
close with managers and other employees.
Job Evaluation for Operations Analyst
Compensable Factor Weight Degree (1,2,3,4) Points
Skill (50%)
Education Level 25% 1 25
Technical Skills 25% 1 25
Responsibility (30%)
Scope of Control 10% 1 10
Impact of Job 20% 2 40
Effort (20%)
Problem Solving 10% 2 20
Task Complexity 10% 1 10
100% 130
Compensable Factor Weight Degree (1,2,3,4) Points
Skill (50%)
Education Level 25% 3 75
Technical Skills 25% 3 75
Responsibility (30%)
Scope of Control 10% 3 30
Impact of Job 20% 3 60
6
Bachelor’s degree is typically required for this role which give the education factor a degree 3.
“Operations research analysts use advanced mathematical and analytical methods to help solve
complex issues” (U.S. Bureau of Labor Statistics, 2021). Technical skills requires a degree 3 as
well, as these skills are essential in successfully performing tasks for this position.
Job Evaluation Production Worker
The position of the production worker requires physical ability and strength and a lot of technical
skill, so degree 3 is applied here. Production workers must lift heavy objects, move heavy
Effort (20%)
Problem Solving 10% 3 30
Task Complexity 10% 3 30
100% 300
Compensable Factor Weight Degree (1,2,3,4) Points
Compensable Factor Weight Degree (1,2,3,4) Points
Skill (50%)
Physical Ability 25% 3 75
Technical Skills 25% 3 75
Responsibility (30%)
Scope of Control 10% 2 20
Impact of Job 20% 3 60
Effort (20%)
Problem Solving 10% 3 30
Task Complexity 10% 2 20
100% 280
7
objects, operate assembly lines and forklifts, etc., so having experience/skill in this field is a
must. Impact of job and task complexity also is a degree 3 because the production worker is
fundamental in quality control and shipping/receiving products where little to no mistakes should
be made. Problem solving requires a degree 3 considering the production worker should know
how to look and potentially solve any issues with machinery.
Job Evaluation for Benefits Manager
Benefits managers ensures programs meet employee needs, comply with legal requirements, and
are cost effective while developing benefits communications and counseling employees on
benefits related issues (Salary, n.d.) A degree 4 is essential for responsibility and effort, as the
benefits manager is an essential position with strong responsibilities and complex tasks. A
Bachelor’s is required and some training and experience is also necessary, giving education and
technical skills a degree 3.
Compensable Factor Weight Degree (1,2,3,4) Points
Skill (50%)
Education Level 25% 3 75
Technical Skills 25% 3 75
Responsibility (30%)
Scope of Control 10% 4 40
Impact of Job 20% 4 80
Effort (20%)
Problem Solving 10% 4 40
Task Complexity 10% 4 40
100% 350
8
Job Families
Front desk receptionist and the HR administrative assistant both have office and administrative
duties, including but not limited to: file organization, phone and email communication,
maintaining office supplies, mail sorting and distributing, and scheduling appointments. We will
see the the HR administrative assistant again below, but the position is included in both families.
All these positions work strictly under human resources. The benefits manager routinely meet
with senior staff, managers of other human resources departments, and the financial officers of
their organization (U.S. Bureau of Labor Statistics, 2021).
Office & Admin Support
Front desk receptionist
HR administrative assistant
Human Resources
HR director
Benefits manager
HR generalist
HR administrative assistant
9
Operations
Director of regional operations
Operations analyst
Assistant to the director of operations
Production
Production manager
Lead production worker
Production worker
10
References
Salary. (n.d.). Benefits Manager Salary. Salary. Retrieved April 2, 2022, from https:// www.salary.com/research/salary/benchmark/benefits-manager-salary
U.S. Bureau of Labor Statistics. (2021, December 13). Operations Research Analysts : Occupational Outlook Handbook. U.S. Bureau of Labor Statistics. Retrieved April 2, 2022, from https://www.bls.gov/ooh/math/operations-research-analysts.htm
U.S. Bureau of Labor Statistics. (2021, December 14). Compensation and Benefits Managers : Occupational Outlook Handbook. U.S. Bureau of Labor Statistics. Retrieved April 2, 2022, from https://www.bls.gov/ooh/management/compensation-and-benefits- managers.htm#tab-2
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.