Question: Please use solver tool with variables/constraints and show them. Problem 4 During each three-hour period of a day, the Smalltown police force requires the following

Please use solver tool with variables/constraints

Please use solver tool with variables/constraints and show them.

Problem 4 During each three-hour period of a day, the Smalltown police force requires the following number of on-duty police officers: seven from midnight (i.e., 12 A.M.) to 3 A.M.; eight from 3 A.M. to 6 A.M.; five from 6 A.M. to 9 A.M.; six from 9A.M. to noon (i.e., 12 P.M.); five from noon to 3 P.M.; seven from 3 P.M. to 6 P.M.; and five from 6 P.M. to 9 P.M.; eight from 9 P.M. to midnight. Each police officer works nine consecutive hours (i.e., three consecutive shifts). Use Excel to determine how to minimize the number of police officers needed to meet Smalltown's daily requirements

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 General Management Questions!

Put all of your work in a single Excel file. Use a separate worksheet for each problem. Label the worksheet tabs. (Sensitivity reports will automatically be generated and labelled on their own...

problem #2 only please!!! thfull-time pertime moleso very day from PROBLEMS Group A 4-hour daily Gro the post office example, suppose that each time quirement of 17 workers may be viewed as a...

# 1. formulate the following problem as a linear program but do not solve. My diet requires that all the food i eat come from one of the four "basic food group" ( chocolate cake, ice cream, soda, and...

hello, I need help solving the following problems using excel (Linear solution with solver): 1)In the post office example, suppose that each full-time employee works 8 hours per day. Thus, Mondays...

Please solve the following problem as a linear program. During each 4-hour period, the Smalltown police force requires the following number of on-duty police officers: 12midnight to 4 A.M.8; 4 to 8...

During each four-hour period, the Small-town police force requires the following number of on-duty police officers: four from midnight to 4 a.m.; four from 4 a.m. to 8 a.m.; seven from 8 a.m. to...

46. During each four- hour period, the Smalltown police force requires the following number of on-duty police officers: four from midnight to 4 A.M.; four from 4 A.M. to 8 A.M.; seven from 8 A.M. to...

Using the attached template is required During each four-hour period, the Smalltown police force requires the following number of on-duty police officers: four from midnight to 4 a.m.; four from 4...

1. [35 points] During each 4-hour period, the Smalltown police force requires the following number of on-duty police officers: 8 officers from 12 midnight to 4am; 7 officers from 4am to 8am; 6...

During each four-hour period, the Smalltown police force requires the following number of on-duty police officers: four from midnight to 4 A.M.; four from 4 A.M. to 8 A.M.; seven from 8 A.M. to noon;...

Larkspur Inc. incurred a net operating loss of $520,000 in 2020. Combined income for 2018 and 2019 was $364,000. The tax rate for all years is 20%. Larkspur elects the carryback option. Prepare the...

Fix the following loop: i = 10 while i>0: print(float(i)) if i%2==0: i = 1/2 else: 5.0 6.0 3.0 4.0 2.0 1.0 i=i-1 to provide the following output: 10.0

Gordon is a self - employed electrician who employs two - part time assistants. He registered for VAT on 1 January 2 0 1 9 and has asked for help in preparing his first VAT return for the quarter to...

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...