Question: could anyone help answer this problem? A large e-commerce firm, which has a warehouse in Markham, ON is interested in devising a roster for its

could anyone help answer this problem?  could anyone help answer this problem? A large e-commerce firm, which
has a warehouse in Markham, ON is interested in devising a roster

A large e-commerce firm, which has a warehouse in Markham, ON is interested in devising a roster for its employees over the course of a week. The company uses data to estimate the average demand on any given day of the week, based on which it allocates employees to work on certain days. The minimum number of employees needed at the warehouse during each day of the week is given in Table 1. Day Mon Tue Wed Thu Fri Sat Sun Min Workers Required 140 130 150 160 190 180 110 Table 1: Number of employees required at the Warehouse during each of the seven days. Each employee works for five consecutive days of the week and then takes the remaining two days off. Further, each worker receives a weekly income of $500 (this is the total salary for the five days they work at the warehouse). Based on this information, construct a staffing plan that clearly outlines the number of employees who work during each five day shift. Assume that there is no limit on the number of workers that the company can hire. In fact, the manager has been told to assign the roster using the minimum number of workers possible and place the rest on standby. The following example illustrates how each worker's five-day shift functions. Example: Suppose that the firm decides to put 100 workers in the shift starting on Mon- day (Mon - Fri) and 70 workers in the shift starting on Wednesday (Wed - Sun) and zero everywhere else. According to this plan, the total number of workers at the warehouse on Wed. Thu, and Fri is 100+ 70 = 170. On the other hand, Saturday and Sunday only have 70 employees, whereas Monday and Tuesday, only 100. Therefore, while the plan meets the demand on Wednesday and Thursday, it is not sufficient for the others. In conclusion, we need to assign some employees to the other five shifts as well. To help you get started on this task, your manager has identified the following seven decision variables: - Number of employees whose five day shift begins on day i {i = 1: Monday, i = 2: Tuesday, i = 3: Wednesday, i = 4: Thursday, i = 5: Friday, i = 6: Saturday, i = 7: Sunday } (a) (5 points) Write a linear program to calculate the optimum staffing plan in order to minimize the total cost incurred for paying worker salaries. Your program must utilize the decision variables highlighted earlier and ensure that the number of workers available on each day of the week meets the demand during that day. State the optimum solution and the cost incurred. 6/9 Val Coffee . 094 10 9 Se Val RR ww ste MT Page : Semiticky Hepat Soe Polen Aething goes the statue Wit determine from the meet if the post deficio them for the patio splein all your () (2 points) Emped the day shift in Wien Sun) that desirable wheat folle in der wie working in the weekend. There comes firmadested to proide the code this shift anly with a we. What's the latest rather can be to the work without change the optimal sort Altheim wwerall cost of the these theme (c) (2 points) Unfortunately, the finitimated dem MA als of the purching to the thit at 100 w pied Monday to What is the wind cont de tot This website, you will (d) (2 points) What is the ideal candle the fifthew extra mile on Friday (1906 1907 An employees weich lary is $500 Give this fort, why is the colping and challe than () (2 points) Out of the word of the week the companied do the following day Fill leak and explain (1) (2 points) litum est that matt partially happy with the She lidt. As the age of the you've alte have to watch you were the policy, what A large e-commerce firm, which has a warehouse in Markham, ON is interested in devising a roster for its employees over the course of a week. The company uses data to estimate the average demand on any given day of the week, based on which it allocates employees to work on certain days. The minimum number of employees needed at the warehouse during each day of the week is given in Table 1. Day Mon Tue Wed Thu Fri Sat Sun Min Workers Required 140 130 150 160 190 180 110 Table 1: Number of employees required at the Warehouse during each of the seven days. Each employee works for five consecutive days of the week and then takes the remaining two days off. Further, each worker receives a weekly income of $500 (this is the total salary for the five days they work at the warehouse). Based on this information, construct a staffing plan that clearly outlines the number of employees who work during each five day shift. Assume that there is no limit on the number of workers that the company can hire. In fact, the manager has been told to assign the roster using the minimum number of workers possible and place the rest on standby. The following example illustrates how each worker's five-day shift functions. Example: Suppose that the firm decides to put 100 workers in the shift starting on Mon- day (Mon - Fri) and 70 workers in the shift starting on Wednesday (Wed - Sun) and zero everywhere else. According to this plan, the total number of workers at the warehouse on Wed. Thu, and Fri is 100+ 70 = 170. On the other hand, Saturday and Sunday only have 70 employees, whereas Monday and Tuesday, only 100. Therefore, while the plan meets the demand on Wednesday and Thursday, it is not sufficient for the others. In conclusion, we need to assign some employees to the other five shifts as well. To help you get started on this task, your manager has identified the following seven decision variables: - Number of employees whose five day shift begins on day i {i = 1: Monday, i = 2: Tuesday, i = 3: Wednesday, i = 4: Thursday, i = 5: Friday, i = 6: Saturday, i = 7: Sunday } (a) (5 points) Write a linear program to calculate the optimum staffing plan in order to minimize the total cost incurred for paying worker salaries. Your program must utilize the decision variables highlighted earlier and ensure that the number of workers available on each day of the week meets the demand during that day. State the optimum solution and the cost incurred. 6/9 Val Coffee . 094 10 9 Se Val RR ww ste MT Page : Semiticky Hepat Soe Polen Aething goes the statue Wit determine from the meet if the post deficio them for the patio splein all your () (2 points) Emped the day shift in Wien Sun) that desirable wheat folle in der wie working in the weekend. There comes firmadested to proide the code this shift anly with a we. What's the latest rather can be to the work without change the optimal sort Altheim wwerall cost of the these theme (c) (2 points) Unfortunately, the finitimated dem MA als of the purching to the thit at 100 w pied Monday to What is the wind cont de tot This website, you will (d) (2 points) What is the ideal candle the fifthew extra mile on Friday (1906 1907 An employees weich lary is $500 Give this fort, why is the colping and challe than () (2 points) Out of the word of the week the companied do the following day Fill leak and explain (1) (2 points) litum est that matt partially happy with the She lidt. As the age of the you've alte have to watch you were the policy, what

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!