As we saw in Problem Set 2, on a Thursday, Jeanie decided that she would like to have a dinner party for a few of her colleagues and was wondering if Saturday was a feasible day to have the party or not. She wanted to get an idea of how many hours of work she would need to do to make a fancy dinner ready by 6 PM on Saturday. She decided to create a project network based on the activities she thought were essential for doing this. We had helped her to identify the critical path by creating a project network and activity schedule. Now, Jeanie realizes that she has another project that needs to be completed by Saturday and wonders if she can “outsource” some of her activities by paying someone else to do them, since she only has a total of 8 hours available now instead of her original 12 hours of availability. Her normal costs and crashing costs along with the crashing time are given in the table below. She wants to minimize her costs, so running a crashing LP model is her best option. Activity Description Time Normal Crashing Crash Immediate (hours) Cost Time Cost Predecessor Ti Ci Ti' Ci' A Choosing dishes/recipes -- 2 200 1.5 300 B Inviting and confirming # of people -- 2 200 1 300 C Making ingredient list A 1 100 0 500 D Making shopping list B, C 1 100 0 200 E Going for shopping D 2 200 0 300 F Making the meal E 5 500 0 1500 G Setting the Table F 0.5 50 0 100 Notice that the original PERT/CPM model you created will work for this problem since the order of the activities has not changed. Create a Crashing Model and answer the following questions: Jeanie’s total cost of crashing is $ The activities that Jeanie needs to crash are: by hours by hours by hours Jeanie will be able to finish her tasks within the 8 hours if she spends the extra money. Show the updated PERT/CPM model in your spreadsheet and answer “True” or “False” based on it in this blank.

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

Related questions

Question

As we saw in Problem Set 2, on a Thursday, Jeanie decided that she would like to have a dinner party for a few of her colleagues and was wondering if Saturday was a feasible day to have the party or not. She wanted to get an idea of how many hours of work she would need to do to make a fancy dinner ready by 6 PM on Saturday. She decided to create a project network based on the activities she thought were essential for doing this. We had helped her to identify the critical path by creating a project network and activity schedule. Now, Jeanie realizes that she has another project that needs to be completed by Saturday and wonders if she can “outsource” some of her activities by paying someone else to do them, since she only has a total of 8 hours available now instead of her original 12 hours of availability. Her normal costs and crashing costs along with the crashing time are given in the table below. She wants to minimize her costs, so running a crashing LP model is her best option.

Activity	Description		Time	Normal	Crashing	Crash
Immediate	(hours)	Cost	Time	Cost
Predecessor	Ti	Ci	Ti'	Ci'
A	Choosing dishes/recipes	--	2	200	1.5	300
B	Inviting and confirming # of people	--	2	200	1	300
C	Making ingredient list	A	1	100	0	500
D	Making shopping list	B, C	1	100	0	200
E	Going for shopping	D	2	200	0	300
F	Making the meal	E	5	500	0	1500
G	Setting the Table	F	0.5	50	0	100

Notice that the original PERT/CPM model you created will work for this problem since the order of the activities has not changed. Create a Crashing Model and answer the following questions:

Jeanie’s total cost of crashing is $
The activities that Jeanie needs to crash are:
1. by hours
2. by hours
3. by hours
Jeanie will be able to finish her tasks within the 8 hours if she spends the extra money. Show the updated PERT/CPM model in your spreadsheet and answer “True” or “False” based on it in this blank.

Expert Solution