GBD230 Group Task (17.5%)
Sunnyhill Well being & Racquet Membership (SHRC), 75factors
PART 1: Excel/Quantitative Inputs (40 factors)
T accompanying excel file has 7 corresponding spreadsheets and one tutorial. Every tab is numbered (1-6) equivalent to the next questions. Enter information in yellow highlighted cells and the primary dashboard (“grasp” spreadsheet) will auto-populate. Rationalize your inputs.
1. “Objective and Capital Raised” (5 factors)
a. How a lot cash (objective/goal) do you assume the membership’s board ought to look to attain (i.e., $2,000,000 for brand spanking new constructing; $800,000 for full renovation; $143,000 to make simply the mandatory enhancements)?
b. Do you assume promoting quite a bit (or each) is an efficient monetary technique? Why/Why not?
2. “Membership Costs & Numbers” (eight factors)
a. Do you intend a rise in membership charges? How a lot?
b. Do you assume any “new” class of membership ought to exist? Why? Why not?
c. How may worth will increase have an effect on membership numbers?
d. Is it attainable that worth will increase may result in larger membership numbers?
three. “Income Particular Occasions” (eight factors)
a. Do you foresee any adjustments to this income class?
b. What further occasions may very well be added?
c. How a lot income may very well be generated?
d. Are there any limitations to new/present occasions?
four. “Income Outdoors Leases” (5 factors)
a. What number of “exterior” leases would you intend every year?
b. Is the pricing related to present leases applicable? Would you alter the payment schedule? To what? Why?
5. “Projected Bills” (6 factors)
a. When implementing a price range for bills for the following 5 years, does something stand out?
b. How does the depreciation expense have an effect on the membership’s operations?
6. “Mortgage Financing Schedule” (eight factors)
a. What rate of interest did you select on any debt? Why?
b. How a lot are you proposing to repay every year?
c. Do you may have any “warning” indicators in your Excel spreadsheet? Why?
d. Are you proposing to make anniversary or pre funds? What do these accomplish?
PART 2: Dialogue/Qualitative Questions (35 factors)
1. What are the “dangers” to the SHRC’s long-term sustainability if: (10 factors)
a. Simply the essential upkeep necessities are accomplished?
b. Main renovations (or a brand new constructing) is constructed?
c. Which do you’re feeling poses the larger risk to the membership’s sustainability? Why?
2. Talk about the function/existence of various buyer segments to a enterprise. (5 factors)
a. What’s your perspective of the SHRC’s segments?
b. Talk about the “pressure” across the totally different segments (buyer worth going ahead vs. buyer loyalty from previous purchases).
three. Talk about the function of “debt” as a type of leverage for a enterprise (most methods within the present case would require the usage of debt). (5 factors)
a. What are the most important dangers to the membership taking over debt?
b. Is debt inherently dangerous?
four. Produce an inventory of professionals and cons for divesting the land and producing vital funds to pay for any proposed renovation to SHRC. (5 factors)
5. How do you assume worth will increase are greatest launched? (5 factors)
6. How may you prioritize the record of choices the membership is contemplating in its potential renovation plans? (5 factors)