Your team has been assigned to complete 10 client projects over the next two months. These projects and their processing times (time taken to complete a project once started, in days) are described in the table below. In addition, each project has a due-date that has been set by your internal marketing team so that the customers will be delighted with your service if you complete the project by the due-date. However, your team has only enough resources to pursue exactly one project at any given time. Once started, a project is worked through its completion and is not interrupted. As a result of the sequence in which you choose to handle projects, each project will either be on time, or late if it is completed past the due date. If a project is late, the amount of time by which it misses its due-date is called its tardiness. The objective is to pick the sequence in which to complete the projects so as to minimize the total tardiness in the schedule. What is the minimum total tardiness and a sequence in which you should perform the projects that achieves it? a. Project # 1 2 4 7 8 10 Processing time (days) 6 1 5 12 3 7 Due date 17 25 15 20 8 44 24 50 20

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...
icon
Related questions
Question
Your team has been assigned to complete 10 client projects over the next two months. These
projects and their processing times (time taken to complete a project once started, in days) are
described in the table below. In addition, each project has a due-date that has been set by your
internal marketing team so that the customers will be delighted with your service if you complete the
project by the due-date. However, your team has only enough resources to pursue exactly one
project at any given time. Once started, a project is worked through its completion and is not
interrupted. As a result of the sequence in which you choose to handle projects, each project will
either be on time, or late if it is completed past the due date. If a project is late, the amount of time
by which it misses its due-date is called its tardiness. The objective is to pick the sequence in which to
complete the projects so as to minimize the total tardiness in the schedule.
What is the minimum total tardiness and a sequence in which you should perform the projects
that achieves it?
а.
Project #
1
2
3.
4
5
7
8
9
10
Processing
time
(days)
6
1
2
9
12
3
7
Due date
17
25
15
20
8
44
24
50
20
Transcribed Image Text:Your team has been assigned to complete 10 client projects over the next two months. These projects and their processing times (time taken to complete a project once started, in days) are described in the table below. In addition, each project has a due-date that has been set by your internal marketing team so that the customers will be delighted with your service if you complete the project by the due-date. However, your team has only enough resources to pursue exactly one project at any given time. Once started, a project is worked through its completion and is not interrupted. As a result of the sequence in which you choose to handle projects, each project will either be on time, or late if it is completed past the due date. If a project is late, the amount of time by which it misses its due-date is called its tardiness. The objective is to pick the sequence in which to complete the projects so as to minimize the total tardiness in the schedule. What is the minimum total tardiness and a sequence in which you should perform the projects that achieves it? а. Project # 1 2 3. 4 5 7 8 9 10 Processing time (days) 6 1 2 9 12 3 7 Due date 17 25 15 20 8 44 24 50 20
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
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
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
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…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.