Chapter 8. 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	100	0.5	150
B	Inviting and confirming # of people	--	2	100	0.5	150
C	Making ingredient list	A	1	45	0	100
D	Making shopping list	B, C	1	45	0	100
E	Going for shopping	D	2	100	0	300
F	Making the meal	E	5	250	0	750
G	Setting the Table	F	0.5	10	0.25	50

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 dont forget to show the updated PERT/CPM model along with the crashing model in your spreadsheet. Answer the following questions:

1. Jeanies total cost of crashing is $
2. The activities that Jeanie needs to crash are:
   1. Activity by hours
   2. Activity by hours
   3. Activity by hours
   4. Activity by hours

USING EXCEL