I would need an excel sheet for a whole year budget for a new substance abuse clinic.
8. Develop an Operating Budget for the first year of operation. (Operating Budget to include First Quarter, Second Quarter, Third Quarter and Fourth Quarter). Project the anticipated service volumes, operating revenues, expenses and profit or loss for each quarter. Show the cumulative P&L.
Show your service volume calculations, staff productivity assumptions, anticipated service capacity and formulas used for revenue projections
FYI- The population in trenton is 83,412 and the percentage of the unmet need is 66% gave me a total of 55,051 population that suffers from substance abuse/mental health issues (our unmet need)
I am attaching my power point for you to have a better understanding.
