Maintenance at a major theme park in central Florida is an ongoing process that occurs 24 hours a day. Because it is a long drive from most residential areas to the park, employees do not like to work shifts of fewer than eight hours. These eighthour shifts start every four hours throughout the day. The number of maintenance workers needed at different times throughout the day varies. The following table summarizes the minimum number of employees needed in each four-hour time period. Time Period Needed Minimum Employees 12 a.m. – 4 a.m. 80 4 a.m. – 8 a.m. 210 8 a.m. – 12 p.m. 245 12 p.m. – 4 p.m. 160 4 p.m. – 8 p.m. 295 8 p.m. – 12 a.m. 120 The maintenance supervisor wants to determine the minimum number of employees to schedule that meets the minimum staffing requirements. 1. Formulate the LP model for this problem. 2. Create the spreadsheet model and use Solver to solve the problem.

Maintenance at a major theme park in central Florida is an ongoing process that occurs 24 hours a day. Because it is a long drive from most residential areas to the park, employees do not like to work shifts of fewer than eight hours. These eighthour shifts start every four hours throughout the day. The number of maintenance workers needed at different times throughout the day varies. The following table summarizes the minimum number of employees needed in each four-hour time period. Time Period Needed Minimum Employees 12 a.m. – 4 a.m. 80 4 a.m. – 8 a.m. 210 8 a.m. – 12 p.m. 245 12 p.m. – 4 p.m. 160 4 p.m. – 8 p.m. 295 8 p.m. – 12 a.m. 120 The maintenance supervisor wants to determine the minimum number of employees to schedule that meets the minimum staffing requirements. 1. Formulate the LP model for this problem. 2. Create the spreadsheet model and use Solver to solve the problem.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter12: Queueing Models

Section: Chapter Questions

Problem 59P

See similar textbooks

Similar questions

A Support Labor Staff lifts bricks from 30, 53-ft long trailers in their 8-hr shift using forklifts. The typical 53-ft trailer holds 26 pallets of bricks. The warehouse receives in the first half of the shift and ships in the second half of the shift. The work standard for forklift operations is listed below: Load/unload pallet from trailer 45 sec Move from dock to warehouse or warehouse to dock 120 sec Load/unload pallet from Truck 30 sec Move within warehouse 60 sec Calculate the number of forklifts needed to process all the pallets is most nearly: А. 7 В. 9 С. 10 D. 11
A process improvement team is working to improve the production output at the Johnson Manufacturing plant’sHeader Cell that manufactures a key component, headers, used in commercial air conditioners. A header is partof the circulatory system of a commercial air conditioner that moves coolant between various components suchas the evaporator coil and the condenser coil. Currently, the header production cell is scheduled separately fromthe main work in the plant. Often, individual headers are not sequenced to match the product they go into on thefinal assembly line in a timely fashion, and so the product can sit in queue waiting for a header
Abbott Manufacturing produces plastic cases for solar photovoltaic panels and has decided to combine orders from customers to increase work order size, and thereby, make one large production run per model type. Plastic injection molding machines are used to make these parts, and it is time consuming to clean and re-setup the machines between production runs. Each molding machine and operator works one 10-hour shift with a one- hour lunch break and one-half hour for operator breaks. Consolidated Work Orders Model XVT-5 Case Model UYT-3 Case Model KLY-6 Case Work Order Quantity 8,800 panels 8,700 12,400 Setup (Changeover) Time per Work Order (minutes) 86 63 135 Processing Time per Panel (seconds) 2.50 2.22 4.11 What is the total workload (demand) in hours for this work order mix? Round your answer to one decimal place. The total workload is hours. How many machines will it take to do this work in one, two, or three days? Round your answers up to the nearest whole number. To do this work…
Abbott Manufacturing produces plastic cases for solar photovoltaic panels and has decided to combine orders from customers to increase work order size, and thereby, make one large production run per model type. Plastic injection molding machines are used to make these parts, and it is time consuming to clean and re-setup the machines between production runs. Each molding machine and operator works one 10-hour shift with a one-hour lunch break and one-half hour for operator breaks. Consolidated Work Orders Model XVT-5 Case Model UYT-3 Case Model KLY-6 Case Work Order Quantity 9,600 panels 7,900 12,000 Setup (Changeover) Time per Work Order (minutes) 98 160 What is the total workload (demand) in hours for this work order mix? Round your answer to one decimal place. The total workload is hours. How many machines will it take to do this work in one, two, or three days? Round your answers up to the nearest whole number. To do this work in 1 day they need machine(s). machine(s). To do this…
R. C. Coleman distributes a variety of food products that are sold through grocery store and supermarket outlets. The company receives orders directly from the individual outlets, with a typical order requesting the delivery of several cases of anywhere from 20 to 50 different products. Under the company’s current warehouse operation, warehouse clerks dispatch order-picking personnel to fill each order and have the goods moved to the warehouse shipping area Because of the high labor costs and relatively low productivity of hand order picking, management has decided to automate the warehouse operation by installing a computer-controlled order-picking system along with a conveyor system for moving goods from storage to the warehouse shipping area. R. C. Coleman’s director of material management has been named the project manager in charge of the automated warehouse system. After consulting with members of the engineering staff and warehouse management personnel, the director compiled a…
Macon Controls produces three different types of control units used to protect industrial equipment from overheating. Each of these units must be processed by a machine that Macon considers to be their process bottleneck. The plant operates on two 8-hour shifts, 5 days per week, 52 weeks per year. The table below provides the time standards at the bottleneck, lot sizes, and demand forecasts for the three units. Because of demand uncertainties, the operations manager obtained three demand forecasts (pessimistic, expected, and optimistic). The manager believes that a 30 percent capacity cushion is best. Time Standard Demand Forecast Setup (hr/lot) Lot Size Processing (hr/unit) Component Pessimistic Expected Optimistic (units/lot) A 0.05 1.0 50 16,000 16,000 27,000 В 0.30 4.6 80 11,000 12,000 17,000 C 0.05 8.3 100 16,000 23,000 35,000 a. How many machines are required to meet minimum (Pessimistic) demand, expected demand, and maximum (Optimistic) demand? (Enter your responses rounded up…
Macon Controls produces three different types of control units used to protect industrial equipment from overheating. Each of these units must be processed by a machine that Macon considers to be their process bottleneck. The plant operates on two 8-hour shifts, 5 days per week, 52 weeks per year. The table below provides the time standards at the bottleneck, lot sizes, and demand forecasts for the three units. Because of demand uncertainties, the operations manager obtained three demand forecasts (pessimistic, expected, and optimistic). The manager believes that a 25 percent capacity cushion is best. D Demand Forecast Component A B C Time Standard Processing Setup (hr/unit) (hr/lot) 0.04 1.0 0.20 4.4 0.05 8.5 Lot Size (units/lot) 50 75 100 Demand Forecast Pessimistic Expected Optimistic Pessimistic 16,000 10,000 18,000 a. How many machines are required to meet minimum (Pessimistic) demand, expected demand, and maximum (Optimistic) demand? (Enter your responses rounded up to the next…
Macon Controls produces three different types of control units used to protect industrial equipment from overheating. Each of these units must be processed by a machine that Macon considers to be their process bottleneck. The plant operates on two 8-hour shifts, 5 days per week, 52 weeks per year. The table below provides the time standards at the bottleneck, lot sizes, and demand forecasts for the three units. Because of demand uncertainties, the operations manager obtained three demand forecasts (pessimistic, expected, and optimistic). The manager believes that a 25 percent capacity cushion is best. i Demand Forecast Component A B C Time Standard Processing (hr/unit) 0.04 0.20 0.05 Setup (hr/lot) 1.0 4.4 8.5 Lot Size (units/lot) 50 75 100 Demand Forecast Pessimistic Expected 16,000 17,000 10,000 12,000 18,000 24,000 a. How many machines are required to meet minimum (Pessimistic) demand, expected demand, and maximum (Optimistic) demand? (Enter your responses rounded up to the next…
A total of 5000 mechanical subassemblies are needed annually on a final assembly line. The subassemblies can be obtained in one of three ways: (1) Make them in one of three plants owned by the company; (2) buy them off the shelf from the one and only manufacturer; or (3) contract to have them made to specifications by a vendor. The estimated annual equivalent cost for each alternative is dependent upon specific circumstances of the plant, producer, or contractor. The information shown details the circumstance, a probability of occurrence, and the estimated annual cost. Construct and solve a decision tree to determine the least-cost alternative to provide the subassemblies.
William Beebe owns a small shoe store. He has 10 pairs of shoes that requireresoling and polishing. He has a machine that can resole one pair of shoes at atime, and the time required for the operation varies with the type and condition of theshoe and the type of sole that is used. Shoes are polished on a machine dedi-cated tothis purpose as well, and polishing is always done after resoling. His assistant generally does the polishing while Mr. Beebe does the resoling. The resoling and polishingtimes (in minutes) are Shoes Resoling Time Polishing Time1 14 32 28 13 12 24 6 55 10 106 14 67 4 128 25 89 15 510 10 5In what order should the shoes be repaired in order to minimize the total makespanfor these 10 jobs?
How do standard circular flow and expanded circular flow differ?
Consider the following tasks that must be assigned to four workers on a conveyor-paced assembly line (i.e., a machine-paced line flow). Each worker must perform at least one task. There exists unlimited demand unless stated otherwise. Time to Complete Task (seconds): Task 1: 30 Task 2: 25 Task 3: 15 Task 4: 20 Task 5: 15 Task 6: 20 Task 7: 50 Task 8: 15 Task 9: 20 Task 10: 25 Task 11: 15 Task 12: 20 The current conveyor-paced assembly-line configuration assigns the workers in the following way: • Worker 1: Tasks 1, 2, 3 • Worker 2: Tasks 4, 5, 6 • Worker 3: Tasks 7, 8, 9 • Worker 4: Tasks 10, 11, 12 What is the direct labor content (in seconds per unit)?