Question

In: Operations Management

The daily requirements for patrol officers are: Monday:4 officers Tuesday:5 officers Wednesday:6 officers Thursday:7 Officer Friday:10...

The daily requirements for patrol officers are: Monday:4 officers Tuesday:5 officers Wednesday:6 officers Thursday:7 Officer Friday:10 Officers Saturday:9 officers Sunday:9 officers Question: Each officer works 5 days a week and must have 2 consecutive days off. You are scheduling officers to work the appropriate days of the week. The second officer you schedule is to work which days of the week?

Solutions

Expert Solution

We will excel solver to find the schedule of work -

Below is the screenshot of the LP table -

Below is the screenshot of the formula applied -

Below is the screenshot of the solver -

Below is the screenshot of the result -

First 2 employees will start work on Tuesday.

Next 4 employees will start work on Wednesday

Next 2 employees will start work on Thursday

Next 2 employees will start work on Friday

Next 1 employees will start work on Sunday


Related Solutions

The table below shows the price of petrol for a week. Day Monday Tuesday Wednesday Thursday...
The table below shows the price of petrol for a week. Day Monday Tuesday Wednesday Thursday Friday Saturday Sunday Price of Petrol (per Liter) 1.57 1.85 1.86 1.94 1.49 1.66 1.69 a) Using a 4-day Moving Average to forecast the petrol price on Saturday, and calculate the forecast error. b) Given the exponential smoothing constant ? = 0.3, the petrol price on Saturday, and the forecast petrol price on Saturday (from (a)), forecast the petrol price on Sunday by using...
A store sold 12 stereos on Monday, 17 on Tuesday, 28 on Wednesday, 17 on Thursday...
A store sold 12 stereos on Monday, 17 on Tuesday, 28 on Wednesday, 17 on Thursday and 26 on Friday. AT the .01 level, test if there is a difference in the number of stereos sold on each weekday. State the hypotheses and identify the claim, find the critical value(s), compute the test value, make the decision and summarize the results. Show all work and formulas - sample question that I don't get.
The daily requirements for patrol officers are: M T W TH F SA SU 4 5...
The daily requirements for patrol officers are: M T W TH F SA SU 4 5 6 7 10 9 9 Question: Each officer works 5 days a week and must have 2 consecutive days off. You are scheduling officers to work the appropriate days of the week. The second officer you schedule is to work which days of the week?
9. The daily requirements for campus patrol officers at the University for the week are: Day...
9. The daily requirements for campus patrol officers at the University for the week are: Day M T W TH F S SU Requirement 4 5 6 7 10 9 9 Each officer works five days a week and must have two consecutive days off.  You are scheduling officers to work the appropriate days of the week.  The second officer you schedule is to work which days of the week?
3, 7, 8, 5, 6, 4, 9, 10, 7, 8, 6, 5 Using the previous question...
3, 7, 8, 5, 6, 4, 9, 10, 7, 8, 6, 5 Using the previous question 's scores, If three points were added to every score in this distribution, what would be the new mean? If three points were added to every score in this distribution, what would be the new standard deviation. Remember, you have already calculated population standard deviation in a previous problem. This problem requires two answers.
Q (actual): 4 6 7 10 13 Q*: 5 6 6 8 10 From the above...
Q (actual): 4 6 7 10 13 Q*: 5 6 6 8 10 From the above table, What is SSE? What is TSS? What is R-squared?
Rate is 10/hour. We have 5 employees. They work 40 hours a week (Monday-Friday). We pay...
Rate is 10/hour. We have 5 employees. They work 40 hours a week (Monday-Friday). We pay every 14 days on Friday. Payday fall this Friday on 12/28/x1; and 1/11/x2. Book JE for 12/28; 12/31 and 1/11 – ignoring payroll taxes.   
[4 5 5 2 4 4 6 3 3 7 5 3 6 3 4 4...
[4 5 5 2 4 4 6 3 3 7 5 3 6 3 4 4 6 5 4 5 3 7 5 5 4 2 6 5 6 6] This is my dataset Find mean, median, mode, variance, standard deviation, coefficient of variation, range, 70th percentile, 3rdquartile of the data and skewness and define what each of these statistics measure. For example, mean is a measure of the central tendency, what about the rest? Use Chebyshev’s rule to find...
[4 5 5 2 4 4 6 3 3 7 5 3 6 3 4 4...
[4 5 5 2 4 4 6 3 3 7 5 3 6 3 4 4 6 5 4 5 3 7 5 5 4 2 6 5 6 6] This is my dataset Split the dataset in two equal parts. You have 30 datavalues. If you split the data in two equal parts each part will contain 15 data values.  Call the first part Y and second part X.Draw scatter plot of the 2 datasets, X being on the horizontal...
(9) Diagonalizing 4 0 1 -7 -5 5. -12 -6 7
(9) Diagonalizing 4 0 1 -7 -5 5. -12 -6 7
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT