1. The working system in a hospital is divided into 8 time periods, each of which is 3 hours, as in the table below. If the doctor who starts working in any time period works for 5 time periods, that is 15 hours, he/she gets 300$ per day, if he/she works for 3 time periods, he/she gets 200$. There is no other working schedule other than 9 hours or 15 hours. The minimum number of doctors required for each time period is given in the table. Write a model to minimize the total salary for doctors. (The doctor who starts working in last periods he/she is going on working with the period 1 of the other day. For example 7-8-1-2-3 periods can be chosen for a doctor to work.) Time Period Doctor Need Hours 06.00-09.00 1 3 2 09.00-12.00 6 3 12.00-15.00 7 4 15.00-18.00 5 5 18.00-21.00 4 6 21.00-00.00 3 7 00.00-03.00 2 8 03.00-06.00 2

1. The working system in a hospital is divided into 8 time periods, each of which is 3 hours, as in the table below. If the doctor who starts working in any time period works for 5 time periods, that is 15 hours, he/she gets 300$ per day, if he/she works for 3 time periods, he/she gets 200$. There is no other working schedule other than 9 hours or 15 hours. The minimum number of doctors required for each time period is given in the table. Write a model to minimize the total salary for doctors. (The doctor who starts working in last periods he/she is going on working with the period 1 of the other day. For example 7-8-1-2-3 periods can be chosen for a doctor to work.) Time Period Doctor Need Hours 06.00-09.00 1 3 2 09.00-12.00 6 3 12.00-15.00 7 4 15.00-18.00 5 5 18.00-21.00 4 6 21.00-00.00 3 7 00.00-03.00 2 8 03.00-06.00 2

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

b. The Healthy Food Restaurant, a 24-hour restaurant, faces changing requirements from hour tohour. More workers are needed for peak hours, and fewer are needed in between. The followingTable 6 (below) shows the worker requirement for the first 12 hours in the restaurant:Table 6. Staff Requirement at the Healthy Food RestaurantTime Period 10AM11AM12PM1PM2PM3PM4PM5PM6PM7PM8PM9PMRequirement 8 10 12 12 9 7 6 7 9 10 12 8AssignedOn DutyOverstaffed8(i) You are required to apply the first-hour principle to staff each hour with the required number ofcafeteria staff, showing how many staff are on duty each given hour, the number of staffyou have assigned to work each hour and any overstaffing for each hour. i. Schedule the staff to work in 8-hour shifts.
Chapter 5. (M/M/s/K Model). Leia is responsible for 13 data units in the IT offices in a small business called DataWish. Each data unit 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 data unit 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 (ρ) % Performance Measures P0 (probability that sytem is empty) % L (average units in system) units Lq (average units waiting in queue) units W (average time in the system) weeks Wq (average time in the queue) weeks c. If we assign a cost of waiting as $400 per week per data unit and $800 per…
Chapter 5. (M/M/s/K Model). Leia is responsible for 8 computers in the IT offices in a small business called DataWish. Each computer 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 computer 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 units system) La (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 $500 per week per computer and $800 per week of hiring Leia, what is the Total Time Cost per week cost of servicing the…
Chapter 5. (M/M/s/K Model). Leia is responsible for 8 computers in the IT offices in a small business called DataWish. Each computer 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 computer for service and an exponential distribution to the actual service provided, answer the following questions: a. The arrival rate would bel 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 c. If we assign a cost of waiting as $500 per week per computer and $800 per week of hiring Leia, what is the Total Time Cost per week cost of servicing the machines? PO (probability that sytem is empty) % dollars L (average units in system) units d. If DataWish decides to hire another individual to help Leia, what would the new Total Time Cost per…
Chapter 5. (M/M/s/K Model). Leia is responsible for 12 computers in the IT offices in a small business called DataWish. Each computer runs on an average for 4 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 computer 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 (ρ) % Performance Measures P0 (probability that sytem is empty) % L (average units in system) units Lq (average units waiting in queue) units W (average time in the system) weeks Wq (average time in the queue) weeks c. If we assign a cost of waiting as $750 per week per computer and $800 per week of…
.A team of 10 unloaders is employed in good reception bay of a large warehouse. During an 8 hour day 40 lorries arrive and it takes the team 10 minutes to unload each lorry. Each team member is paid RM3 per hour and it costs RM10 per hour to keep lorries waiting. Studies show that increasing the team to 14 men would reduce the unloading time to 7 minutes. Would it be worthwhile increasing the team to 14?
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…
Given the following for a retail property: This property is occupied by a single tenant: Net Rentable Space 10,000 sq. ft. Lease Rate $18.00 per sq. ft. per year Real Estate Taxes $ 1.75 per sq. ft. per year Operating Expenses $ 0.55 per sq. ft. per year Insurance $ 0.06 per sq. Ii. per year Actual Gross Sales $2,200,000 Base Sales as per Lease $2,000,000 Percentage Lease Clause 4.0% What is the amount of rent due on a per sq. ft. basis (per year) ifthe tenant has a "net net"_ (NN)Jease and a "percentage lease clause" in the lease? Please provide proper keystrokes for the BAii Plus and Gualifier Plus IIIfx calculators. Thank you!
The table below shows the time stamps of 10 customers who visited a local bank branch from 9:00 a.m. to 9:45 a.m. What is the flow time of customers? Customer 1 2 3 4 5 6 7 8 9 10 Time in 9:2 9:5 9:6 9:8 9:8 9:10 9:12 9:15 9:18 9:19 Time out 9:7 9:10 9:17 9:23 9:36 9:21 9:41 9:41 9:28 9:42 Instruction: Round your answer to 1 decimal place. Flow time of customers 3.5 minutes
The management of Hartman Company is trying to determine the amount of each of two products to produce over the coming planning period. The following information concerns labor availability, labor utilization, and product profitability: Labor-Hours Required Department A B с (hours/unit) Product 1 Product 2 Hours Available Production 1.00 0.30 Profit contribution/unit $30.00 0.20 38.27 0.35 0.20 0.50 $15.00 (a) Develop a linear programming model of the Hartman Company problem. Solve the model to determine the optimal production quantities of products 1 and 2. If required, round your answer to two decimal places. Product 1 Product 2 69.77 M 95 72.09 38 50 (b) In computing the profit contribution per unit, management does not deduct labor costs because they are considered fixed for the upcoming planning period. However, suppose that overtime can be scheduled in some of the departments. Which departments would you recommend scheduling for overtime? Dept A What is the upper limit of what…
a. How many nurses should be working each month to most closely match patient forecasts?b. Suppose the hospital does not want to change its policy of not increasing the nursing staff size by more than 10 percent in any month. Suggest a schedule of nurse staffing over the four months that meets this requirement and also meets the need for nurses each month.
1. Crispy chips company operates in two shifts every day. Each shift is for a duration of 8 hours. During the shift workers get a break of 1 hour. Following are the steps involved in chips manufacturing: Set Up Time (in mins) Run Time (in mins) Steps Peeling Cutting Blanching Dewatering Frying and Deoiling Flavoring & Packing 5 2 10 3 15 2 4 2 20 2 Chips are produced in batches of 100 and are packed in packets of 20. Identify the bottleneck process and determine the capacity of Crispy chips in terms of number of bags of chips.