project operation managementplease answer Q5Five jobs are waiting for processing through two work centers. Their processing time (inminutes) at each work center is contained in Table Q5 below. Each job requires work centerAlpha before work center Beta.(b)(c)Table Q5: Processing time (in minutes) at work centersJobRSTUVAlpha4025SO35$5Generate the optimal sequence of jobs.Beta1030203515Calculate the best schedule for the supervisor that will minimize the make spanof the five jobs.Determine the total length of time of this optimal solution.

Sequencing is an appropriate order of plan as per which the process of operations works. It defines…

Answered: (a) (b) Generate the optimal sequence…

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

Joan has a small design and tailoring shop making custom outfits for women. She has two employees. Each employee only begins working on a dress when a customer order has been received and then she makes the dress from beginning to end. The average production time of a dress is 1.8 days, with a standard deviation of 2.1 days. Historically, Joan has been receiving orders with interarrival times of one day on average. The interarrival times of orders have a coefficient of variation of one. (Carry at least 4 decimal places in all intermediate calculations. Round your final answer to 2 decimal places.) What is the expected waiting time, in days, between when an order is received and when production begins on the dress? A. 9.12 days B. 6.50 days C. 1.23 days D.3.41 days
The manager of a large group of employees must decideif she needs another photocopying machine. The cost of amachine is $40 per 8-hour day whether or not the machineis in use. An average of 4 people per hour need to use thecopying machine. Each person uses the copier for an averageof 10 minutes. Interarrival times and copying times areexponentially distributed. Employees are paid $8 per hour,and we assume that a waiting cost is incurred when a workeris waiting in line or is using the copying machine. Howmany copying machines should be rented?
The Hickory Company manufactures wooden desks. Manage-ment schedules overtime every weekend to reduce the backlogon the most popular models. The automatic routing machineis used to cut certain types of edges on the desktops. The fol-lowing orders need to be scheduled for the routing machine: The due dates reflect the need for the order to be at its nextoperation.a. Develop separate schedules by using the FCFS and EDDrules. Compare the schedules on the basis of average flowtime and average past due hours.b. Comment on the performance of the two rules relative tothese measures
A1 Credit provides credit information to its customersthroughout the country, 24 hours per day. Credit representativesanswer customer calls and provide information. Based on demandpatterns, the estimated number of representatives needed duringfour-hour time periods of each day are shown in the table. Employees work shift s of eight consecutive hours, and shift scan start at the beginning of any of the six periods shown inthe table. Assume this schedule will be repeated day aft er day,so that someone starting at 8 pm will contribute to the need forrepresentatives in the midnight–4 am time period. Th e supervisorhas been instructed to schedule employees so that all demandscan be met with a minimum possible number of employees.(a) Formulate an LP to minimize the number of representativesneeded.(b) Set up and solve the problem on a spreadsheet.(c) What is the optimal solution? Explain the rationale for thesolution.
(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?
Five jobs are waiting for processing through two work centers. Their processing time (in minutes) at each work center is contained in the table below. Each job requires work center Sigma before work center Delta. According to Johnson's rule, what sequence of jobs will minimize the completion time for all jobs? Job Sigma Delta R 20 10 S 25 30 T 30 20 U 35 35 V 15 25 Part 2 A. V−S−U−T−R B. V−R−U−S−T C. R−V−T−S−U D. S−U−T−V−R E. R−S−T−U−V
The most significant factor affecting the difference between planned lead time and actual lead time for a specific order or batch in a shop is/are A. PriorityB. CapacityC. QueuesD. Component availability
Which of the following statements about scenario analysis is NOT correct? Scenario analysis can help managers make insightful decision. Scenario analysis can be used to analyze the value of a utilization program. Scenario analysis can be used to find minimum PMPM rate for breakeven. By using scenario analysis, we can definitely accept a lower PMPM rate than the rate at breakeven since scenario analysis is a tool for control cost.
Consider the Dynamic Program formulation of the n-class optimal booking problem with sequential arrivals. In thisproblem, show some monotonicities of the value function.• Jt(x) − Jt(x − 1) is non-decreasing in t, ∀x.• Jt(x) − Jt(x − 1) is non-increasing in x, ∀t.Consider that the second property implies the first property. To prove the second property, given Dt, consider the discrete concavity of Ht(Dt, x) = max0≤u≤min{Dt,x} (pt)u + Jt−1(x − u) in x, i.e., Ht(Dt, x + 1) − Ht(Dt, x) ≤ Ht(Dt, x) − Ht(Dt, x − 1) for any x ∈ Z+ for any t. Image attatched for clarity.
BE Spreadsheet Mike Reynolds has four assignments due in class tomorrow, and his class times are as follows: Time 9 a.m. 12 p.m. 2 p.m. 5:30 p.m. Each class lasts one hour, and Mike has no other classes. It is now midnight, and Mike estimates that the marketing, finance, psychology, and OM assignments will take him one, four, five, and seven hours, respectively. Assume that all time till the last class begins can be spent on completing assignments but each assignment should be done till the time of the class on the same subject. (Mike can prepare assignments for the next classes during previous classes.) Use the Excel Sequencing template to determine how he should schedule the work. Use minus sign to enter negative lateness values, if any. Enter the half an hour value as 0.5, e.g., 3:30 p.m. should be entered as 15.5. If your answer is zero, enter "0". Round your answers for the due date, lateness, and tardiness to one decimal place. Round your answers for the average values to two…
The Fly-Right Airplane Company builds small jet airplanes to sell to corporations for use by their executives. To meet the needs of these executives, the company's customers sometimes order a custom design of the airplanes being purchased. When this occurs, a substantial start-up cost is incurred to initiate the production of these airplanes. Fly-Right has recently received purchase requests from three customers with short deadlines. However, because the company's production facilities already are almost completely tied up filling previous orders, it will not be able to accept all three orders. Therefore, a decision now needs to be made on the number of airplanes the company will agree to produce (if any) for each of the three customers. The relevant data are given in the next table. The first row gives the start-up cost required to initiate the production of the airplanes for each customer. Once production is under way. the marginal net revenue (which is the purchase price minus the…
How to develop an LP spreadsheet model that relates five-day shift schedules to daily numbers of employees available?

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS

(a) (b) Generate the optimal sequence of jobs. Calculate the best schedule for the supervisor that will minimize the make span of the five jobs. Determine the total length of time of this optimal solution.