Coppell Services contracts with outsourcing partners to handle various customer service functions. Based on a study of call volumes provided by one of the firm's partners, the minimum number of staff needed for each hour of the day is as follows: Hour 8-9 9-10 10 10-11 12 11-noon 10 noon-1 8 16 15 20 15 1-2 2-3 3-4 4-5 Mr. Coppell hires 6 permanent employees and wants to staff the remaining requirements using part- time employees who work 4-hour shifts (four consecutive hours starting as early as 8 A.M. or as late as 1 P.M.). What is the minimum number of total part-time employees needed across all the 4-hour shifts to ensure meeting the staffing requirements? 222 2 Ⓒ20 Minimum Staff Required 16 24 28

Coppell Services contracts with outsourcing partners to handle various customer service functions. Based on a study of call volumes provided by one of the firm's partners, the minimum number of staff needed for each hour of the day is as follows: Hour 8-9 9-10 10 10-11 12 11-noon 10 noon-1 8 16 15 20 15 1-2 2-3 3-4 4-5 Mr. Coppell hires 6 permanent employees and wants to staff the remaining requirements using part- time employees who work 4-hour shifts (four consecutive hours starting as early as 8 A.M. or as late as 1 P.M.). What is the minimum number of total part-time employees needed across all the 4-hour shifts to ensure meeting the staffing requirements? 222 2 Ⓒ20 Minimum Staff Required 16 24 28

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

Vollmer Manufacturing makes three components for sale to refrigeration companies. The components are processed on two machines: a shaper and a grinder. The times (in minutes) required on each machine are as follows: Machine Component Shaper Grinder 1 6 4 2 4 5 3 4 2 The shaper is available for 120 hours, and the grinder is available for 110 hours. No more than 200 units of component 3 can be sold, but up to 900 units of each of the other components can be sold. In fact, the company already has orders for 600 units of component 1 that must be satisfied. The profit contributions for components 1, 2, and 3 are $8, $6, and $9, respectively. (a) Formulate and solve for the recommended production quantities. component 1 unitscomponent 2 unitscomponent 3 units (b) What are the objective coefficient ranges for the three components? (If there is no upper or lower limit, enter NO LIMIT. Round your answers to the nearest integer.) component 1 to unitscomponent 2 to…
Vollmer Manufacturing makes three components for sale to refrigeration companies. The components are processed on two machines: a shaper and a grinder. The times (in minutes) required on each machine are as follows: Machine Component Shaper Grinder 1 6 4 2 4 5 3 4 2 The shaper is available for 120 hours, and the grinder is available for 110 hours. No more than 200 units of component 3 can be sold, but up to 800 units of each of the other components can be sold. In fact, the company already has orders for 600 units of component 1 that must be satisfied. The profit contributions for components 1, 2, and 3 are $8, $6, and $9, respectively. (a) Formulate and solve for the recommended production quantities. component 1 unitscomponent 2 unitscomponent 3 units (b) What are the objective coefficient ranges for the three components? (If there is no upper or lower limit, enter NO LIMIT. Round your answers to the nearest integer.) component 1 blank to blank units…
Four doctors work in a hospital emergency room thathandles three types of patients. The time a doctor spends with each type of patient is exponentially distributed, witha mean of 15 minutes. Interarrival times for each customertype are exponential, with the average number of arrivalsper hour for each patient type being as follows: type 1, 3patients; type 2, 5 patients; type 3, 3 patients. Assume thattype 1 patients have the highest priority, and type 3 patientshave the lowest priority (no preemption is allowed). What isthe average length of time that each type of patient mustwait before seeing a doctor?
One possible solution method for the machine-tojob assignment problem is the following heuristic procedure. Assign the machine to job 1 that completes job 1 quickest. Then assign the machine to job 2 that, among all machines that still have some capacity, completes job 2 quickest. Keep going until a machine has been assigned to all jobs. Does this heuristic-procedure yield the optimal solution for this problem? If it does, see whether you can change the job times so that the heuristic does not yield the optimal-solution.
Vollmer Manufacturing makes three components for sale to refrigeration companies. The components are processed on two machines: a shaper and a grinder. The times (in minutes) required on each machine are as follows: Machine Component Shaper Grinder 1 7 5 2 5 5 3 5 2 The shaper is available for 125 hours, and the grinder is available for 95 hours. No more than 170 units of component 3 can be sold, but up to 1050 units of each of the other components can be sold. In fact, the company already has orders for 625 units of component 1 that must be satisfied. The profit contributions for components 1, 2, and 3 are $8, $6, and $9, respectively. If more time could be made available on the grinder, how much would it be worth? If required, round your answers to two decimal places.$ _____ per minute, since the dual value is _____ on the grinder at the optimal solution.
Five workers are available to perform four jobs. Thetime it takes each worker to perform each job is given inTable 65. The goal is to assign workers to jobs so as tominimize the total time required to perform the four jobs.Use the Hungarian method to solve the problem.
At a manufacturing assembly line, 30 jobs arrive perhour. Each job must pass through two production stages:stage 1 and stage 2. Stage 1 takes an average of 1 minute tocomplete, and 1 worker is available to perform stage 1.After completing stage 1, the job immediately passes tostage 2. Stage 2 takes an average of 2 minutes to complete,and 2 workers are available to work on stage 2. Aftercompleting stage 2, each job is inspected. Inspection takesan average of 3 minutes, and 3 workers are available toperform inspection. After inspection, 10% of the jobs mustbe returned to stage 1, and they then repeat both stages 1and 2. After inspection, 20% of all jobs return to stage 2 andrepeat stage 2. Assume that interarrival times and servicetimes are exponential.a What is the average time a job spends in the systemfrom arrival to completion?b What percentage of the time is each worker busy?
A local bank has generated the following metrics: an arrival rate of 18 customers per hour with a service time of 3 minutes per customer, and wait times Wq = 0.45 hours for s = 1, Wq = 0.0127 hours for s = 2, and Wq = 0.0017 hours for s = 3. The goal is to solve the following argument: argmin $7s + $49Lq. What is the optimal service level?
Green Vehicle Inc. manufactures electric cars and small delivery trucks. It has just opened a new factory where the C1 car and the T1 truck can both be manufactured. To make either vehicle, processing in the assembly shop and in the paint shop are required. It takes 1/40 of a day and 1/60 of a day to paint a truck of type T1 and a car of type C1 in the paint shop, respectively. It takes 1/50 of a day to assemble either type of vehicle in the assembly shop. A T1 truck and a C1 car yield profits of $300 and $220, respectively, per vehicle sold. a) Define the objective function and constraint equations. b) Graph the feasible region. c) What is a maximum-profit daily production plan at the new factory? d) How much profit will such a plan yield, assuming whatever is produced is sold?
A car wash offers two different types of wash services, deluxe wash and standard wash. The deluxe wash require(s) three steps: pre-wash, wash and dry. The standard wash only require(s) two steps: wash and dry. The pre-wash step has a capacity of 7 cars per hour. The wash step has a capacity of 11 cars per hour. The dry step has a capacity of 10 cars per hour. The demand for deluxe wash is 7 cars per hour and the demand for standard wash is 11 cars per hour. Instruction: Round to the nearest integer percentage. What is the implied utilization of the bottleneck resource?
A catering company must have the following number of clean napkins available at the beginning of each of the next four days: day 1: 15, day 2: 12, day 3: 18, and day 4: 6. After being used, a napkin can be cleaned by one of two methods: fast service or slow service. Fast service costs $0.10 per napkin, and a napkin cleaned via fast service is available for use the day after it is last used. Slow service costs $0.06 per napkin, and a napkin cleaned via slow service is available two days after they were last used. New napkins can be purchased for a cost of $0.20 per napkin. Part A: Formulate the problem as a minimum cost transportation problem.
A catering company must have the following number of clean napkins available at the beginning of each of the next four days: day 1: 15, day 2: 12, day 3: 18, and day 4: 6. After being used, a napkin can be cleaned by one of two methods: fast service or slow service. Fast service costs $0.10 per napkin, and a napkin cleaned via fast service is available for use the day after it is last used. Slow service costs $0.06 per napkin, and a napkin cleaned via slow service is available two days after they were last used. New napkins can be purchased for a cost of $0.20 per napkin. Part A: Formulate the problem as a minimum cost transportation problem. Part B: Solve the problem (provide exact values for all variables and the optimal objective function).