plz make a model using excel

solve this by using excel and thank you.

THE PROBLEM You are planning a dinner party for yourself and five guests. This is your menu: Onion soup with French bread Roast chicken with boiled mixed vegetables Pie with hot chocolate sauce You have arranged to go to a baseball game before the dinner, and afterward the six of you are going to the theater. You can prepare the ingredients for the meal before you leave for the match, but will you be able to get back in time to cook and serve the dinner? Will you and your guests get to the theater on time? Your problem is to estimate the shortest time in which you could cook, serve, and eat the meal. (The clearing and washing can wait until the next morning.) THE DATA The following are your best estimates of the times needed to complete the var- ious activities associated with the dinner: Cooking the onion soup 30 minutes Warming the bread in the oven 10 minutes Roasting the chicken in the oven 45 minutes Boiling the vegetables 25 minutes Warming the pie in the oven 15 minutes 92 HOW TO MODEL IT Cooking the chocolate sauce Serving and eating the soup Serving and eating the chicken Serving and eating the apple pie 40 minutes 20 minutes 25 minutes 15 minutes You have been saving two bottles of a good red wine for an occasion such as this. You need to allow 5 minutes to uncork the wines and 30 minutes to let them breathe. You intend to serve the wine with the chicken, even though you know your friend Andrew will pass a snide remark about serving red wine with poultry. Incidentally, you have only one pot to use for boiling the soup, the mixed vegetables, and the chocolate sauce. (You can assume that it takes no time at all to rinse it.) Also, your oven can hold only one item at a time. How quickly can you cook, serve, and consume the meal? ht You should be able to get the answer in 15 to 20 minutes, but take a little longer to think about how you got there. How, for instance, would you persuade somebody that the answer you have found really is the shortest time? FIGURE 6.5 Incorporating the activity numbering of Figure 6.3 into the tirne representation of Figure. 6.2. TIME, min 0 10 20 30 40 50 60 70 80 90 100 110 1 3 Cook soup Warm bread 2 Roast chicken 3 5 6 8 8 7 Boil vegetable Warm pie Cook chocolate sauce Eat soup & bread Eat chicken & vegetable Eot pie & chocolate sauce Wine open/breathe 7 8 9 8 3 7 Suppose we calculate the difference between the late finishing time and the early starting time. The answer must surely be greater than or equal to the du- ration of the activity. This leads to the second concept. We define the slack of an activity as follows: Slack late finishing time - early starting time - duration Suppose we calculate the difference between the late finishing time and the early starting time. The answer must surely be greater than or equal to the du- ration of the activity. This leads to the second concept. We define the slack of an activity as follows: Slack late finishing time - early starting time - duration Similarly, the slack for activity 7-8 (serving and eating the chicken) is 95 - 55 - 25 = 15 minutes FIGURE 6.10 Results of the critical path analysis. All the information in this computer output can be calculated directly from Figure 6.7 ACTIVITIES FLOAT 1. Cook soup 30 0 2. Warm bread DURATION, EARLY LATE min Start End Start End 0 30 0 30 10 0 10 15 25 45 10 55 25 70 25 30 55 30 55 15 3. Roast chicken 15 0 4. Boil vegetable 5. Warm pie 15 55 70 80 95 25 6. Cook chocolate sauce 40 55 95 55 95 0 7. Eat soup 20 30 50 50 70 20 25 55 80 70 95 15 15 8. Eat chicken 9. Eat pie 10. Wine open/ breathe 95 110 95 110 0 35 0 35 35 70 35