ding benefits, and a temporary operator is paid $50 per day. The company watns to know the number of permanent and temporary operators to hire to minimize costs. Formulate an interger Programming model. Using the solver function in excel the following solution is obtained:
Q: Machinists who work at a tool-and-die plant must check out tools from a tool center. An average of…
A:
Q: The Dahlia Medical Center has 30 labor rooms, 16 combination labor and delivery rooms, and 2…
A: From the above given information, Labor room capacity can be calculated as, 30 rooms×3×24 per day…
Q: During the campus Spring Fling, the bumper car amusement attraction has a problem of cars becoming…
A: Consider the given information: Hiring cost = $20 per hour Repair Time for one personnel = 30…
Q: Decorum, Inc., manufactures high-end ceiling fans. Their sales are seasonal with higher demand in…
A: Regular production cost$300Over time production cost$350Selling price$500Holding cost$20Beginning…
Q: A call center employs 1,425 agents. Every month 57 employees leave the company and 57 new employees…
A:
Q: How many doctors should be on duty during each period to maintain the level of patient care…
A: A Poisson distribution refers to a probability distribution, which shows the number of times an…
Q: (Requires the use of a spreadsheet or LINGO) USAirlines receives an average of 500 calls per hour…
A: Given data, Average = 500 calls per hour Average minutes = 3 minutes Ticket contribute = $100…
Q: A car wash offers two different types of wash services, deluxe wash and standard wash. The deluxe…
A: Implied utilization is the proportion between total demand of a task and the capacity of the…
Q: You are asked to assess the current service model for a manufacturing line featuring 8 machines.…
A: Given that, Number of machines = 8Likelihood of downtime for machines = 20%Number of workers =…
Q: There is an upstream Picking department that feeds two downstream Packing departments: Pack Singles…
A: We have to pack 47880 units in Multis which is accounted for 60% of the volume. Hence, Overall…
Q: CPU-on-Demand (CPUD) offers real-time high-performance computing services. CPUD owns 1 supercomputer…
A:
Q: Instruction: Round to the nearest integer percentage. What is the implied utilization of the…
A: Implied Utilization = Demand or Workload/Capacity
Q: Approximately 40 percent of a medical clinic’s weekly incoming calls for doctors’ appointments occur…
A: For part b, the pros and cons are analyzed and a generalized answer is provided.The design,…
Q: Management would like to identify a better way to handle these gas tanks. How can the handling…
A: Handling operation: A company tries to improve its handling operation in order to reduce cost,…
Q: The Dahlia Medical Center has 33 labor rooms, 18 combination labor and delivery rooms, and 3…
A: Given data: Labour room = 33 Combination labour = 18 Delivery rooms = 3 Average time = 24 hrs…
Q: What advice would you give to Jan?
A: Information analysis is the process of examining and interpreting data or information to draw…
Q: A manufacturing facility stores spare parts for maintenance in a storage facility. Throughout the…
A: Find the Calculation methods below: Single Server: L = Lq + λμLq = λ2(μ(μ-λ))System Cost = Cw*L + Cs…
Q: Joan has a small design and tailoring shop making custom outfits for women. She has two employees.…
A: In order to evaluate and enhance the effectiveness and performance of systems containing waiting…
Q: esponsiv
A: The major concerns of the service providers are to reduce the negative effects of waiting. The…
Q: The manager of a large group of employees must decideif she needs another photocopying machine. The…
A: Assume that the administrator can't pay more than $8 to the staff who is holding up in the line to…
Q: The combination labor and delivery rooms labor rooms had the highest utilization rate of delivery…
A: For each situation, I will determine the utilization rate, Next, I will find a specific option with…
Q: he Dahlia Medical Center has 35 labor rooms, 18 combination labor and delivery rooms, and 2…
A: Total Capacity of Labor room = 35 rooms x 3 days x 24 hours = 2,520 hoursActual Utilization of Labor…
Q: The Fly-Right Airplane Company builds small jet airplanes to sell to corporations for use by their…
A:
Q: ABC Apple Juice Company produces and markets fresh fruit juice. During the apple harvest season,…
A: From 7 AM to 10 AM, the inventory comes in at a rate of three ,000 kgs per hours and gets…
Q: Manning Systems is a commercial software vendor that sells billing and other financial software to…
A: Answer) (a) We will use the following steps to determine the allocation to each of the divisions…
Q: The first station can process a unit in 10 minutes First Station capacity = 60/10 = 6 units per…
A: Given that: First Station capacity = 6 units per hour Second Station Capacity = 10 units per hour…
Q: The Cove is a midsized furniture store. Sales staff are assigned standard shifts (1st shift usually…
A:
Q: Discuss how the principle of queues can be used when designing queueing schemes to reduce overall…
A: Introduction: The term Business refers to an exchange of goods and services between the buyer and…
Q: An emergency room (ER) at a Prisma Health Hospital has 10 total beds it can hold patients, i.e., the…
A: Given data:Total beds = 10Arrival rate (λ) = 5 patients per hourService rate (μ) = = 2.5 patients…
Q: During an eight-hour shift, 750 non-defective parts are desired as a result of a manufacturing…
A: Given, Requirement of non-defective parts = 750 parts Actual operation time = 20 minutes Lost parts…
Northwoods Backpackers is a retail catalog store in Vermont that specializes in outdoor clothing and camping equiptment. Phone orders are taken each day by a large pool of computer operators, some of whom are permanent and some temporary. A permanent operator can process an average of 76 orders per day, whereas a temporary operator can process an average of 53 orders per day. The company averages at least 600 orders per day. The store has 10 computer workstations.
A permenant operator processes about 1.5 orders with errors each day, whereas a temporary operator averages 4.5 orders with errors daily. The store wants to limit errors to 24 per day. A permanent operator is paid $80 per day, including benefits, and a temporary operator is paid $50 per day. The company watns to know the number of permanent and temporary operators to hire to minimize costs.
Formulate an interger Programming model. Using the solver function in excel the following solution is obtained:
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 4 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
- PepsiCo sells its soft drinks in approximately 400,000 retail establishments, such as supermarkets, discount stores, and convenience stores. Sales representatives call on each retail account weekly, which means each account is called on by a sales rep 52 times per year. The average length of a sales call is 75 minutes (or 1.25 hours). An average salesperson works 2,000 hours per year (50 weeks per year * 40 hours perweek), but each spends 10 hours a week on nonselling activities, such as administrative tasks and travel. How many salespeople does PepsiCo need?A call center employs 1,425 agents. Every month 57 employees leave the company and 57 new employees are hired. a. How long on average does an agent work for this call center (in months) Suppose the cost of hiring and training a new agent is $1,140. The manager of this call center believes that increasing agents’ salaries would keep them working longer at the company. The manager wants to increase the average time that an agent works for the call center to 36 months, or three years. b-1. Given the current average working time for agents at this call center, determine the current annual cost for hiring and training. b-2. Assuming the average time that an agent works for the call center is increased to 36 months, determine the new annual cost for hiring and training. b-3. If the time an agent works for the call center is increased to 36 months on average, how much could the company save on hiring and training costs over a year?The Cove is a midsized furniture store. Sales staff are assigned standard shifts (1st shift usually takes place between the hours of 9 a.m. and 5 p.m. 2nd shift is worked between 5 p.m. and 1 a.m. 3rd shift typically takes place between the hours of 12 a.m. and 8 a.m.), and the number of customers arriving per shift averages 40, Poisson distributed. A salesperson can deal with one customer in 5 minutes on average and costs the company $100 per shift in salaries and fringe benefits. Service times closely follow an exponential distribution. The manager is reviewing the number of salespersons to schedule for each shift. The cost of customers waiting before they receive service has been estimated at $2 per minute in terms of lost sales and loss of goodwill. a. If management wants to minimize the cost of both sales staff and customer wait times, how many salespersons should be working in each shift? b. What is the cost per shift to the company if they use the number of salespersons you…
- (Requires the use of a spreadsheet or LINGO) USAirlines receives an average of 500 calls per hour fromcustomers who want to make a reservation (time betweencalls follows an exponential distribution). It takes an averageof 3 minutes to handle each call. Each customer who buys a ticket contributes $100 to US Airlines profit. It costs $15per hour to staff a telephone line. Any customer who receivesa busy signal will purchase a ticket on another airline. Howmany telephone lines should US Airlines have?During an eight-hour shift, 750 non-defective parts are desired as a result of a manufacturing operation. The default operation time is 15 minutes. As the operators of machine are inexperienced, the actual time they take to perform the operation is 20 minutes, and, on average, a fifth of the parts that start to be manufactured are lost. Assuming that each one of the machines used in this operation will not be available for one hour in each shift, determine the number of machines needed.ABC Apple Juice Company produces and markets fresh fruit juice. During the apple harvest season, trucks bring apples from the fields to the process plant during a workday that runs long hours from 7AM. On peak days, approximately 3,000 kg of apples are trucked in per hour. Trucks dump their contents in a holding bin with a storage capacity of 9,000 kg. When the bin is full, incoming trucks must wait until it has sufficient available space. A conveyor moves apples from bin to the processing plant. The plant is configured to process apples at the rate of 2,000 kg per hour. Trucks arrive uniformly between 7:00AM to 5:00PM. Each truck holds about 1,000 kg of apples. The truck drivers are paid at the rate of $10 per hour. As ABC makes fresh juice, it does not store apples. Processing plant starts at 10:00AM and ends when all the apples received during the day have been processed. It takes 2 hours to clean the empty plant that must be kept ready for the next day production. Trucks are owned…
- Manning Systems is a commercial software vendor that sells billing and other financial software to companies around the globe. Manning operates a centralized call center for customer support calls. Costs associated with use of the center are charged to the division with primary responsibility for the client. There are four geographical divisions: North America (NA), Central and South America (SA), Europe, and Asia-Pacific (APAC). The allocation is based on the length of time of calls made (Minutes). Idle time of the reservation agents and the fixed cost of the equipment are allocated based on the number of calls received (Calls) from clients in each division. Due to recent increased competition in the commercial software business, Manning has decided that it is necessary to better allocate its costs in order to price its services competitively and profitably. During the most recent period for which data are available, the use of the call center for each division was as follows:…There is an upstream Picking department that feeds two downstream Packing departments: Pack Singles and Pack Multis. Those Packing departments feed to a Shipping department that loads the outgoing trucks. 40% of your Pick volume goes to Pack Singles and has a packing rate of 104 units per labor hour (uph). 60% of the Pick volume goes to Pack Multis and has a pack rate of 215 units per labor hour. Your pickers pick both Single and Multi items throughout the day at an overall average rate of 114 units per labor hour. All units that are packed in both processes go through the Ship process at a rate of 570 units per hour. You have 102 people today for all 4 departments and you absolutely must pack 47,880 units in Pack Multis Items to meet a customer promise metric. How do you allocate labor to balance the flow in your department if you work a 10 hour shift? Do not assume breaks or lunches in your answer. Redirect 1: You now need to process all of the Pack Singles Volume in the first 5…The medical director of a large emergency clinic faces a problem of providing treatment for patients who arrive at different rates during the day. There are several doctors available to treat patients when needed. If not needed, they can be assigned to other responsibilities (for example, lab tests, reports, x-ray diagnoses) or else rescheduled to work at other hours. It is important to provide quick and responsive treatment, and the medical director feels that, on the average, patients should not have to sit in the waiting area for more than 20 minutes before being seen by a doctor. Patients are treated on a first-come, first-served basis and see the first available doctor after waiting in the queue. The arrival pattern for a typical day is: ________________________________________________ Arrival Rate, Time patients/hour…
- The medical director of a large emergency clinic faces a problem of providing treatment for patients who arrive at different rates during the day. There are several doctors available to treat patients when needed. If not needed, they can be assigned to other responsibilities (for example, lab tests, reports, x-ray diagnoses) or else rescheduled to work at other hours. It is important to provide quick and responsive treatment, and the medical director feels that, on the average, patients should not have to sit in the waiting area for more than 20 minutes before being seen by a doctor. Patients are treated on a first-come, first-served basis and see the first available doctor after waiting in the queue. The arrival pattern for a typical day is: These arrivals follow a Poisson distribution. The treatment time is 24 minutes on the average with an exponential distribution. Consider the service cost (by doctors) to be $130 per hour. For each patient, the waiting cost when waiting for service…Approximately 40 percent of a medical clinic’s weekly incoming calls for doctors’ appointments occur on Monday. Due to this large workload, 20 percent of the callers receive a busy signal and have to call back later. The clinic has one clerk for each two departments to handle incoming calls. Each clerk handles calls for the same departments all week and thus is familiar with the doctors’ hours, scheduling practices, and idiosyncrasies. Consider the following alternatives to solve thi problem: ∙ Continue the present system, which results in some customer inconvenience, loss of business, and perceived poor service. About 1000 patients attempt to call the clinic on Mondays. The clinic has 50,000 patients in all. ∙ Expand the phone lines and add more people to handle the peak load. The estimated cost for adding two more lines and two clerks is $60,000 per year. ∙ Install a computer to speed up appointments. In this case, the peak load could be handled with the current personnel. The…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?
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)