Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Skill level by work task Employee Tasks Employee Number of Tasks Skills level Data Entry | Inventory | ReportWriting | Budgeting | Training| Unassigned

image text in transcribed
Skill level by work task Employee Tasks " Employee Number of Tasks Skills level Data Entry | Inventory | ReportWriting | Budgeting | Training| Unassigned |Data Entry| Inventory | Report Writing | Budgeting | Training Unassigned Zmployee 1 10 10 10 7 8 0 0 0 Zmployee 2 9 9 7 7 6 0 0 0 Zmployee 3 8 9 7 7 9 0 0 0 Zmployee 4 6 9 10 8 8 0 0 0 Zmployee 5 7 10 9 9 8 0 0 0 Imployee 6 10 9 9 6 8 0 0 0 lotal Assignment 0 skills level Total Constraints As the Human Resources Manager, you need to identify the most effective way to assign 6 new employees to 5 positions within the organization. You have a shortage of open positions and must determine which employee will be unassigned for the week. This employee will be sent to skillstraining instead. You are given ratings for the employees based on a trial week rating from managers in the respective departments. The ratingsareon a 1-10 scale with 10 being the best score. Employees will be assigned to one unique position since all work happens simultaneously. Your goal is to maximize skill level as you assign the work tasks. Zomplete the model above by adding necessary formulas and populate the constraints table. Create a solver model that prescribes best employee assignments based on skills and determines which employee will be sent for skills training due to the shortagein positions this week

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Linear Algebra A Modern Introduction

Authors: David Poole

3rd edition

9781133169574 , 978-0538735452

Students also viewed these General Management questions

Question

What are the degrees of freedom associated with ????e.

Answered: 1 week ago