Answered step by step
Verified Expert Solution
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 im 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 Employees scheduling model. Modify the employee scheduling model below: A post office requires different numbers of fulltime employees on different days of the week. The number of fulltime employees required each day is given in Table Union rules state that each fulltime 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 fulltime employees. Its objective is to minimize the number of fulltime employees on its payroll. Table Employee Requirements for Post Office Day of Week Minimum Number of Employees Required Monday Tuesday Wednesday Thursday Friday Saturday Sunday Important: DEFINE THE DECISION VARIABLES AS THE NUMBER OF EMPLOYEES WORKING EACH OF THE SEVEN POSSIBLE FIVEDAY SHIFTS. Complete and modify the employee scheduling model so that employees are paid $ per hour on weekdays and $ 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 builtin functions such as SUMSUMPRODUCT 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 Employeesavailable Model!$B$:$H$ Decision variables: number of employees starting their fiveday shift on various days Employeesrequired Model! $$$ : $ H $ Thu Sat Sur Employees Starting
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started