I need help with this Case study Report

Instructions:

The report needs to follow the five steps: 1) define the problem, 2) identify the alternatives, 3) determine the criteria, 4) evaluate the alternatives, 5) choose an alternative.

Case ProblemScheduling a Golf League

Chris Lane, the head professional at Royal Oak Country Club, must develop a schedule of matches for the couples' golf league that begins its season at 4:00p.m. tomorrow. Eighteen couples signed up for the league, and each couple must play every other couple over the course of the 17-week season. Chris thought it would be fairly easy to develop a schedule, but after working on it for a couple of hours, he has been unable to come up with a schedule. Because Chris must have a schedule ready by tomorrow afternoon, he has asked you to help him. A possible complication is that one of the couples told Chris that they may have to cancel for the season. They told Chris they would let him know by 1:00p.m. tomorrow whether they will be able to play this season.

Managerial Report

I have to create a report for Chris Lane. The report should include, at a minimum, the following items:

1.A schedule that will enable each of the 18 couples to play every other couple over the

17-week season.

2.A contingency schedule that can be used if the couple that contacted Chris decides

to cancel for the season.

**I need an actual schedule created and the five steps part of 1) defining problem, 2) identify the alternatives, etc. and so on has to be covered as well.

This is what I have so far for the written, rationale part:

"An athletic related schedule is a functional concept that can be organized in a number of ways and through a variety of methods. The case problem presented above is a complex problem but given that it does not include certain qualities such as specific venues and other key personals (related sport leagues) in the mix, the process can be a little more straight-forward.

One of the equations for the first part of this problem, can be solved in the following manner using the combination expression = 18x17/2= 153 matches

Thus, the number of matches per every week would be 153/17 = 9 matches. This would meet the requirement for all of the "18 couples to play" at least once every week "over the 17-week season."

Speaking of contingencies, the second part requires a schedule be created upon the premise of a potential: "if the couple that contacted Chris decides to cancel for the season."

The 17 hypothetical couples that would remain would need to play the remaining 16 hypothetical couples at least once. The equation for this problem would be = 16x17/2 = 136 matches. Thus, the number of matches per every week would be 136/17 = 8 matches. That is, each of the 17 couples will need to play with each of the other 16 couples at least once to meet the obligation. And that means that each couple will be required to play at least once every week of the 17-week season, but due to the number difference, they will have at least one week off during the 17 week season."