i need the answer quickly 46. During each four-hour period, the Smalltown policeforce requires the following number of on-duty policeofficers: four from midnight to 4 A.M.; four from 4 A.M.to 8 A.M.; seven from 8 A.M. to noon; seven from noonto 4 P.M.; eight from 4 P.M. to 8 P.M.; and ten from8 P.M. to midnight. Each police officer works twoconsecutive four-hour shifts.a. Determine how to minimize the number of police of-ficers needed to meet Smalltown's daily requirements.b. Use SolverTable to see how the number of policeofficers changes as the number of officers neededfrom 8 A.M. to noon varies from 4 to 10.Show Transcribed TextA1 Police force scheduling35 Number starting6Number available7 each 4-hour period89 Number required1011 Total employedCcBCDEFGM-4AStarting 4 hours of 8-hour shift4A-8AN-4P8A-NShow Transcribed Text4P-8P8P-MPlease use the same format in Excel and answer usingSolver and SolverTable. Thank you!

Find the Given details below:Given details:Starting 4 hours of 8-hour shiftMidnight - 4 AM4 AM to 8…

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; seven from noon to 4 P.M.; eight from 4 P.M. to 8 P.M.; and ten from 8 P.M. to midnight. Each police officer works two consecutive four-hour shifts.

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; seven from noon to 4 P.M.; eight from 4 P.M. to 8 P.M.; and ten from 8 P.M. to midnight. Each police officer works two consecutive four-hour shifts.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Fatema, Mariam, and Layan are three dental hygienists who work for Dr. Amnah at Family Dentistry. All three hygienists do pretty much the same thing every day. On an average, they see 12 people every day for regular teeth cleaning which involves cleaning, flossing, and normal checkup. Dr. Amnah, on the other hand, has quite unpredictable job. She has to respond to all types of teeth-related emergencies including having to do surgeries. All three hygienists always try to help each other out, have a very good attitude in general toward each other, and keep each other informed about matters that are relevant to them and to Dr. Amnah. Fatema specifically takes on the role of attending all community-related voluntary meetings and functions where Family Dentistry may have a stake or are asked for involvement. On her own time, she keeps up on all dental regulations and business-related news that may have an impact on the firm. Mariam speaks up and offers constructive suggestions regarding…
Your company has a very complex conveyor system in the warehouse. The conveyors take product from a receiving dock and route them to one of ten different shipping points on the shipping dock. The conveyors are controlled by computers. You need to find an employee maintain this computer system on the night shift. Your assignment recruit an employee to fill this position. How would find a qualified candidate?
What are the advantages and disadvantages of queueing analysis versussimulation?
A series of thefts from your pharmacy area have occurred in the last six weeks. The director of security and the head of pharmacy services now require all persons working in the pharmacy department with access to drugs to clock out after their shifts and then go through a security check before leaving the building. Several employees have complained that they should be paid for this time because the security check is for the employer’s benefit. The director of security and the head of pharmacy services have responded that this security check is for the benefit of the employees to ensure that no one is unjustly accused. Is either party correct? If so, which one and why?
Chapter 5. (M/M/s/K Model). Leia is responsible for 12 dataunits in the IT offices in a small business called DataWish. Each dataunit runs on an average for 3 weeks and requires an average of ½ or 0.5 weeks to get reset by Leia before it can start up again. If we assign the Poisson distribution to the "arrival" of each dataunit for service and an exponential distribution to the actual service provided, answer the following questions: a. The arrival rate would be units per week and the service rate would be units per week. b. Calculate the following operating characteristics for the M/M/S/K system: Utilization Factor (p) % Performance Measures PO (probability that sytem is empty) % L (average units in system) units Lq (average units waiting in queue) units W (average time in the weeks system) Wq (average time in the queue) weeks c. If we assign a cost of waiting as $400 per week per dataunit and $800 per week of hiring Leia, what is the Total Time Cost per week cost of servicing the…
Richard has been a highly regarded employee of the Brier Corporation for almost 20 years. Her loyalty to the company is reflected in her dedication to her job as general accounting clerk from which she has not taken a vacation in almost 12 years. Because of her dedication and long tenure, she has acquired many related responsibilities, which has allowed the Brier Corp to reduce its work force through attrition, control salary expenses and become more efficient and competitive. The following describes Richard’s responsibilities. Richard receives copies of credit sales orders from the sales department. From these documents she accesses the AR subsidiary ledger from her office computer and records the AR. She then records the sale in the sales journal and posts the transactions to the general ledger accounts. Cash receipts in payment of customer AR come directly to her office. She records the cash receipts in the GL cash and AR accounts and updates the AR subsidiary ledger. She then…
What are several psychological alternatives to queue management, and why does a boss like to employ them?
In queueing theory, how is the exponential distribution the most relevant probability distribution?
state whether or not each situation would be considered “compensable time” (and why or why not). Toby works as Call Center Representative. He works from 7am – 4:30am, Monday – Friday with 30minutes for lunch. He also typically takes several “mini-breaks” during the day to smoke. These breakstypically range from 5-10 minutes in length and he would typically take at least, one in the morning andone in the afternoon. Toby prefers to eat his lunch at his desk, however he also tends to answerquestions from his manager and even his co-workers throughout his lunch, because he is the seniorrepresentative on that team. This occurred for at least a year. Toby recently was let go because due toa downsizing in the department. Toby called his former manager, Kelly and stated that he was owed 30minutes of pay for the past year because technically he was doing work while eating. Kelly stated thatthis was not correct, he was on a lunch break and answering questions was completely voluntary. Shewent on…
Office Equipment, Inc. (OEI) leases automatic mailing machines to business customers in Fort Wayne, Indiana. The company built its success on a reputation of providing timely maintenance and repair service. Each OEI service contract states that a service technician will arrive at a customer's business site within an average of three hours from when the customer notifies OEI of an equipment problem. Currently, OEI has ten customers with service contracts. One service technician is responsible for handling all service calls. A statistical analysis of historical service records indicates that a customer requests a service call at an average rate of one call per 50 hours of operation. Suppose the service technician is available when a customer calls for service. In that case, it takes the technician an average of 1 hour of travel time to reach the customer's office and an average of 1.5 hours to complete the repair service. However, if the service technician is busy with another customer…
Staffing is a critical component of organizational success, encompassing the identification, recruitment, selection, and retention of qualified individuals to fill various roles within a company. A well-executed staffing strategy ensures that an organization has the right people in the right positions, contributing to overall productivity and achievement of goals. Effective staffing involves understanding the organization's needs, forecasting future requirements, and implementing strategies to attract and retain top talent. Additionally, it requires a thorough assessment of candidates' skills, qualifications, and cultural fit to ensure a cohesive and productive work environment. In essence, staffing is a dynamic process that demands constant adaptation to changing business landscapes and evolving workforce trends. Question: How can organizations strike a balance between recruiting for immediate needs and planning for future staffing requirements to ensure long-term success?
Explain in a queueing analysis what are the most typical measurements of system performance?