During each 6-hour period of the day, the Bloomington Police Department needs at least the number of policemen shown in the following table. Policemen can be hired to work either 12 consecutive hours or 18 consecutive hours. Policemen are paid $15 per hour for each of the first 12 hours a day they work and are paid $22.5 per hour for each of the next 6 hours they work in a day. Formulate an LP that can be used to minimize the cost of meeting Bloomington’s daily police requirements and solve it via Excel. Time Period Number of required policemen 12:00AM----6:00AM 12 6:00AM----12:00PM 8 12:00PM----6:00PM 6 6:00PM----12:00AM 15
Amount paid to the policemen for working 12 consecutive hours=$15 /hour
Amount paid to the policemen for working 18 consecutive hours=$22.5 /hour
We have to minimize the cost of Bloomington Police Department.
It is given that policemen can be hired to work either for 12 consecutive hours or 18 consecutive hours.
Possibility 1
Number of policemen working from 12:00 am to 6:00 am=12
So, there must be 12 policemen working from 6:00 am to 12:00 PM.
Minimum total cost bear by Bloomington Police Department for first 12 hours(12:00 AM-12:00 PM) for an hour of work will be
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps
- A bus system needs to be set up from Village of Westmont to Hinsdale (2.5 miles), then continues to Berwyn (8.5 miles), and finally terminates its run to Cicero (1 mile). The operating time is 55 minutes, the policy headway is 30 minutes, and the minimum terminal time is 19 minutes (including 6 minutes terminal time at each location of Clarendon Hills and Berwyn, and 7 minutes at Cicero). It has been established that the peak-hour demand is 500 passengers per hour and 50-seater buses are available, which can safely accommodate 25 standees. Assume the load factor is 0.8. Design the bus systemarrow_forwardAn inventor has developed a system that allows visitors to museums, zoos, and other attractions to get information at the touch of a digital code. For example, zoo patrons can listen to an announcement (recorded on a microchip) about each animal they see. It is anticipated that the device would rent for $3.00 each. The installation cost for the complete system is expected to be about $400,000. The Milwaukee Zoo is interested in having the system installed, but management is uncertain about whether to take the risk. A financial analysis of the problem indicates that if more than 10% of the Zoo visitors rent the system the zoo will make a profit. To help make the decision, a sample of 400 zoo visitors is given details of the system’s capabilities and cost. Forty eight people say they would rent the device. c). Estimate the actual percentage of the visitors who would rent the system using a 98% confidence interval using Minitab.arrow_forwardIf move time, inspection time, rework time & other nonvalue added time are added together, the result will be equal to Select one: a. Cycle time b. Manufacturing time c. Waste time d. Process timearrow_forward
- A real estate investment trust (REIT) owns first-class office properties in selected markets. According to its website, the occupancy rates last year for its holdings in four major cities are available below. Complete parts a through c below.arrow_forwardA researcher believed that the number of rental cars in service by a car rental company would have an impact on the total annual revenue for that car rental company. Five small car rental companies were surveyed, with the number of Cars in service recorded in units of 1000 (so if a car rental company had 54000 cars in service, a 54 would be recorded) and Annual Revenue measured in millions of dollars (so an Annual Revenue of $10,000,000 would be recorded as 10). The data follows: Cars (1,000s) Annual Revenue ($ millions)11.5 118 10.0 135 9.0 100 5.5 37 3.3 32 Part of the Excel-generated Simple Linear Regression output is provided below: ANOVA df SS MS F Significance F Regression 1 7891.863897 7891.863897 22.91180151 0.017339231 Residual 3 1033.336103 344.4453677 Total 4 8925.2 Coefficients Standard Error t Stat P-value Intercept -19.12490108 23.1658578…arrow_forwardA wireless carrier offers the following plans that a person is considering. The Family Plan: $ 95 monthly fee, unlimited talk and text on up to 5 lines, and data charges of $ 47 for each device for up to 2 GB of data per device. The Mobile Share Plan: $ 180 monthly fee for up to 10 devices, unlimited talk and text for all the lines, and data charges of $ 30 for each device up to a shared total of 10 GB of data. Use P for the number of devices that need data plans as part of their cost. Find the model of the total cost of the Family Plan $ Find the model of the total cost of the Mobile Sharearrow_forward
- Advanced Engineering MathematicsAdvanced MathISBN:9780470458365Author:Erwin KreyszigPublisher:Wiley, John & Sons, IncorporatedNumerical Methods for EngineersAdvanced MathISBN:9780073397924Author:Steven C. Chapra Dr., Raymond P. CanalePublisher:McGraw-Hill EducationIntroductory Mathematics for Engineering Applicat...Advanced MathISBN:9781118141809Author:Nathan KlingbeilPublisher:WILEY
- Mathematics For Machine TechnologyAdvanced MathISBN:9781337798310Author:Peterson, John.Publisher:Cengage Learning,