Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Modify the employee scheduling. Can someone help me out with this? I feel like i ' m doing this wrong, and i don't know what

Modify the employee scheduling. Can someone help me out with this? I feel like i'm doing this wrong, and i don't know what the next steps are for this assignment. Here are the instructions and what I've got so far: Part 1. Employees scheduling model. Modify the employee scheduling model below: A post office requires different numbers of full-time employees on different days of the week. The number of full-time employees required each day is given in Table 14.1. Union rules state that each full-time employee must work five consecutive days and then receive two days off. For example, an employee who works Monday to Friday must be off on Saturday and Sunday. The post office wants to meet its daily requirements using only full-time employees. Its objective is to minimize the number of full-time employees on its payroll. Table 14.1 Employee Requirements for Post Office Day of Week - Minimum Number of Employees Required Monday -17 Tuesday -13 Wednesday -15 Thursday -19 Friday -14 Saturday -16 Sunday -11 Important: DEFINE THE DECISION VARIABLES AS THE NUMBER OF EMPLOYEES WORKING EACH OF THE SEVEN POSSIBLE FIVE-DAY SHIFTS. Complete and modify the employee scheduling model so that employees are paid $ 10 per hour on weekdays and $ 15 per hour on weekends. You can assume that each employee works eight hours per day. a) Minimize the total amount paid to the employees per week. b) Report that amount and the number of employees on payroll. Your model should be optimized. The solution you found must be the best possible under the given specifications. Your model should be formatted so that it is easy to read and understand: All constrains are clearly stated in the spreadsheet. Use colors to improve readability: red cells are the variables cells blue cells contain the given information (input cells) gray cell is the objective cell (there must be a formula or a function that computes the value of the objective cell) yellow or no color = these sells contain the calculated data (there must be formulas or functions that compute the values in those cells) Use cell formats such as $,%, etc. whenever appropriate. Make an effective use of absolute and relative reference. The rule to live by is: If an absolute or mixed reference could be used, it must be used. - Make an effective use of excel built-in functions such as =SUM(),=SUMPRODUCT(), etc. (If an excel function can be used, it must be used!) Define range names. Use name ranges in the Solver.A B C E Employee scheduling model Range names used Employees_available =Model!$B$24:$H$24 Decision variables: number of employees starting their five-day shift on various days Employees_required = Model! $$$ 26: $ H $ 26 Thu Sat Sur Employees Starting
17
13
15
19
14
16
11
Wed Result of decisions: number of employees working on various days (along top) who started their shift on various days (along side) Mon Wed Thu Sri Sun Constraint on employee availabilities Employees available Employees required Hourly wages Total num. of Employees Total amount paid per week

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

The ABCs Of Property Management

Authors: Ken McElroy

1st Edition

9781937832537

More Books

Students also viewed these General Management questions

Question

Steps for LIFO cost assumtions

Answered: 1 week ago