3. (30pts) A consultant who lives in Denver will spend the majority of the month of March with a client in Los Angeles. The consultant's travel schedule for the month is as follows: Leave Denver Monday, March 2 Monday, March 9 Tuesday, March 17 Monday, March 23 Leave Los Angeles Friday, March 6 Thursday, March 12 Friday, March 20 Wednesday, March 25 The usual round trip ticket price between Denver and Los Angeles is $350. However, the airline offers a 20% discount if the dates on a round-trip ticket cover less than 7 nights and include a weekend. A 30% discount is offered for round-trip tickets covering 10 or more nights, and a 40% discount is available for round-trip tickets covering 20 or more nights. The consultant can purchase 4 round-trip tickets in any manner that allows leaving Denver and Los Angeles on the days indicated. a) Draw a network flow model for this problem. b) Create a spreadsheet model for this problem and solve it. Narom 3. (30pts) A consultant who lives in Denver will spend the majority of the month of March with a client in Los Angeles. The consultant's travel schedule for the month is as follows: Leave Denver Monday, March 2 Monday, March 9 Tuesday, March 17 Monday, March 23 Leave Los Angeles Friday, March 6 Thursday, March 12 Friday, March 20 Wednesday, March 25 The usual round trip ticket price between Denver and Los Angeles is $350. However, the airline offers a 20% discount if the dates on a round-trip ticket cover less than 7 nights and include a weekend. A 30% discount is offered for round-trip tickets covering 10 or more nights, and a 40% discount is available for round-trip tickets covering 20 or more nights. The consultant can purchase 4 round-trip tickets in any manner that allows leaving Denver and Los Angeles on the days indicated. a) Draw a network flow model for this problem. b) Create a spreadsheet model for this problem and solve it. Narom