Part 1 Read the following scenario which will be the basis for part one of the assignment: Forrest owns Turkey Creek Country Club in Gainesville, Florida. The current greens fees for playing one round (18 holes) of golf on the course is $175.00 per player. To increase sales, Forrest partners with six different hotels that have created golf packages marketing to their own customers. Each hotel pays Forrest a different amount for the rounds of golf included in their package. Forrest wants to calculate a net round yield for each hotel using the following formula: Distribution costs Standard Fee - Net Round Fee. New Round Fee/ Standard Round Fee = Net Golf Round Yield (round to nearest %) Where Standard Fee (-) Distribution Costs to hotel = Net Golf Round Fee Step 1: Fill in the empty boxes on the chart below with the following information: NOTE: In your calculations, write dollar values as S##.## and do not round. For percentages, however, round to the nearest tenth. Turkey Creek Weekly Sales Recap: Source (A) Standard Fee (B) Net Golf Round Fee (C) Dist. Costs Net Golf Golf Rounds per Hotel Round Yield Sold (D) (E) (F) In Dollars In Pereentage 25 Net Revenue (G) S92.00 Comfort $175.00 Suites Hampton Inn $175.00 S91.00 140 $20.00 40 Hilton Garden ($175.00 Inn Springhill $175.00 Suites Eleo $175.00 S88.00 30 385.00 50 UF Hilton |$175.00 $84.00 35 Average or $175.00 220 Total Step 2: Answer the following questions from your calculations: 1a. What is Forrest's average distribution cost for the hotel members? 1b. What is Forrest's average net round fee for all hotel members? 1c. What is Forrest's net revenue for each hotel member? 1d. What is the overall average net round fee for the 220 rounds of golf Forrest received during the week from these six hotel channel members? Step 3: Reflect on the data and answer the following question: le. Which channel(s) do you believe are Forrest's best partners and why? Explain your