Homework Help is Here – Start Your Trial Now!
Business
Operations Management
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. Immediate Predecessor(s) Activity A Activity A B с D E F G 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) BUD с Normal Time Crash Time Normal Cost (weeks) (weeks) ($) 3 1 7,000 2 3,000 1 12,000 3 1 4 2 A B с D, E E 3 4 WWN 1 6 3 Time according to schedule (weeks) Activity E F G 12,000 8,000 5,000 9,000 D Crash Cost ($) 14,000 3,000 40,000 22,000 8,000 13,000 16,000 3

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. Immediate Predecessor(s) Activity A Activity A B с D E F G 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) BUD с Normal Time Crash Time Normal Cost (weeks) (weeks) ($) 3 1 7,000 2 3,000 1 12,000 3 1 4 2 A B с D, E E 3 4 WWN 1 6 3 Time according to schedule (weeks) Activity E F G 12,000 8,000 5,000 9,000 D Crash Cost ($) 14,000 3,000 40,000 22,000 8,000 13,000 16,000 3

Practical Management Science
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
icon
Related questions
Question

please solve for question C

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 | Immediate Predecessor(s) | Normal Time (weeks) | Crash Time (weeks) | Normal Cost ($) | Crash Cost ($) | |----------|-------------------------|------------------|-----------------|----------------|--------------| | A | — | 3 | 1 | 7,000 | 14,000 | | B | — | 2 | 2 | 3,000 | 3,000 | | C | A | 3 | 1 | 12,000 | 40,000 | | D | B | 4 | 3 | 12,000 | 22,000 | | E | C | 1 | 1 | 8,000 | 8,000 | | F | D, E | 6 | 4 | 5,000 | 13,000 | | G | E | 3 | 2 | 9,000 | 16,000 | **Questions and Answers:** 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 **$203,500**. *(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: | Activity | Time according to schedule (weeks) | |----------|-----------------------------------| | A | 1 | | B | 2 | | C | 3 | | D | 3 | | Activity
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 | Immediate Predecessor(s) | Normal Time (weeks) | Crash Time (weeks) | Normal Cost ($) | Crash Cost ($) | |----------|-------------------------|------------------|-----------------|----------------|--------------| | A | — | 3 | 1 | 7,000 | 14,000 | | B | — | 2 | 2 | 3,000 | 3,000 | | C | A | 3 | 1 | 12,000 | 40,000 | | D | B | 4 | 3 | 12,000 | 22,000 | | E | C | 1 | 1 | 8,000 | 8,000 | | F | D, E | 6 | 4 | 5,000 | 13,000 | | G | E | 3 | 2 | 9,000 | 16,000 | **Questions and Answers:** 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 **$203,500**. *(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: | Activity | Time according to schedule (weeks) | |----------|-----------------------------------| | A | 1 | | B | 2 | | C | 3 | | D | 3 | | Activity
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 6 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar 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.
SEE MORE TEXTBOOKS