The table below contains data for the installation of new equipment in a manufacturing process at Excello Corporation. Your company is responsible for the installation project. Indirect costs are $12,000 per week, and a penalty cost of $6,000 per week will be incurred by your company for every week the project is delayed beyond week 12. Activity A B с D E F G Immediate Predecessor(s) A B C D, E E Normal Time Crash Time Normal Cost (weeks) (weeks) ($) 3 1 7,000 3,000 2 2 1 12,000 3 12,000 1 8,000 5,000 9,000 3 4 1 6 3 4 2 a. What is the shortest time duration for this project regardless of cost? The shortest project duration regardless of cost is 9 weeks. (Enter your response as a whole number.) b. What is the minimum total cost associated with completing the project in 12 weeks? The minimum total cost to complete the project in 12 weeks is $203500. (Enter your response as a whole number.) c. What is the total time of the minimum-cost schedule? (Enter your responses as whole numbers.) The total project's duration according to the minimum-cost schedule is 10 week(s). The minimum-cost schedule is as follows: Crash Cost ($) 14,000 3,000 40,000 22,000 8,000 13,000 16,000

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
The table below contains data for the installation of new equipment in a manufacturing process at Excello Corporation. Your company is responsible for the installation project. Indirect costs are $12,000 per
week, and a penalty cost of $6,000 per week will be incurred by your company for every week the project is delayed beyond week 12.
Activity
A
B
с
D
E
F
G
Immediate
Predecessor(s)
AB
Activity
A
B
с
D
A
C
D, E
E
Normal Time Crash Time
(weeks) (weeks)
3
1
2
2
1
3
4
1
6
3
Time according to
schedule (weeks)
1
a. What is the shortest time duration for this project regardless of cost?
The shortest project duration regardless of cost is 9 weeks. (Enter your response as a whole number.)
b. What is the minimum total cost associated with completing the project in 12 weeks?
The minimum total cost to complete the project in 12 weeks is $ 203500. (Enter your response as a whole number.)
c. What is the total time of the minimum-cost schedule? (Enter your responses as whole numbers.)
The total project's duration according to the minimum-cost schedule is 10 week(s). The minimum-cost schedule is as follows:
Time according to
schedule (weeks)
3
1
4
2
Activity
E
F
G
Normal Cost
($)
7,000
3,000
12,000
12,000
8,000
5,000
9,000
1
Crash Cost
($)
14,000
3,000
40,000
22,000
8,000
3
13,000
16,000
Transcribed Image Text:The table below contains data for the installation of new equipment in a manufacturing process at Excello Corporation. Your company is responsible for the installation project. Indirect costs are $12,000 per week, and a penalty cost of $6,000 per week will be incurred by your company for every week the project is delayed beyond week 12. Activity A B с D E F G Immediate Predecessor(s) AB Activity A B с D A C D, E E Normal Time Crash Time (weeks) (weeks) 3 1 2 2 1 3 4 1 6 3 Time according to schedule (weeks) 1 a. What is the shortest time duration for this project regardless of cost? The shortest project duration regardless of cost is 9 weeks. (Enter your response as a whole number.) b. What is the minimum total cost associated with completing the project in 12 weeks? The minimum total cost to complete the project in 12 weeks is $ 203500. (Enter your response as a whole number.) c. What is the total time of the minimum-cost schedule? (Enter your responses as whole numbers.) The total project's duration according to the minimum-cost schedule is 10 week(s). The minimum-cost schedule is as follows: Time according to schedule (weeks) 3 1 4 2 Activity E F G Normal Cost ($) 7,000 3,000 12,000 12,000 8,000 5,000 9,000 1 Crash Cost ($) 14,000 3,000 40,000 22,000 8,000 3 13,000 16,000
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 12 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.