Posted: August 5th, 2022

GBD230 Group Assignment (17.5%)

GBD230 Group Assignment (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) akin to the next questions. Enter knowledge in yellow highlighted cells and the primary dashboard (“grasp” spreadsheet) will auto-populate. Rationalize your inputs.
1. “Aim and Capital Raised” (5 factors)
a. How a lot cash (purpose/goal) do you assume the membership’s board ought to look to attain (i.e., $2,000,000 for brand new constructing; $800,000 for full renovation; $143,000 to make simply the required enhancements)?
b. Do you assume promoting lots (or each) is an effective monetary technique? Why/Why not?
2. “Membership Costs & Numbers” (eight factors)
a. Do you plan 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 potential that worth will increase may result in increased membership numbers?
three. “Income Particular Occasions” (eight factors)
a. Do you foresee any modifications to this income class?
b. What further occasions might be added?
c. How a lot income might be generated?
d. Are there any limitations to new/present occasions?
four. “Income Exterior Leases” (5 factors)
a. What number of “outdoors” leases would you plan every year?
b. Is the pricing related to present leases acceptable? Would you modify the price schedule? To what? Why?
5. “Projected Bills” (6 factors)
a. When implementing a finances for bills for the subsequent 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’ve 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 are feeling poses the higher risk to the membership’s sustainability? Why?
2. Focus on the position/existence of various buyer segments to a enterprise. (5 factors)
a. What’s your perspective of the SHRC’s segments?
b. Focus on the “pressure” across the totally different segments (buyer worth going ahead vs. buyer loyalty from previous purchases).
three. Focus on the position of “debt” as a type of leverage for a enterprise (most methods within the present case would require using debt). (5 factors)
a. What are the largest dangers to the membership taking over debt?
b. Is debt inherently dangerous?
four. Produce a listing of professionals and cons for divesting the land and producing important 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 listing of choices the membership is contemplating in its potential renovation plans? (5 factors)

Order | Check Discount

Tags: GBD230 Group Assignment (17.5%)