HOW DO I CALCULATE THE BREAK EVEN ANALYSIS SECTION?

$ 590.00 $ 2,500.00 $ 2,000.00 $ 800.00 $ 200.00 $6,090.00 $ $ 25.00 15.00 $40.00 Fixed Costs Utilities 1 Health Wellness Staff 2 Arts/Crafts Staff 3 Supplies 4 Fitness Equipment 5 6 Total Fixed Costs 7 8 9 Variable Costs Monthly Lunch Costs 1 Monthly Breakfast Costs 2 3 Total Variable Costs 4 5 6 Break-Even Analysis 7 Total Revenues - Total VC - FC = Profit 8 Total Revenues - Total VC 9 Total FC/Total Revenues - Total VC D 1 2 3 Payback period 4 Initial investment s 15 Year 6 2nd Year 7 314 Year 3 4th Year 5th Year 0 $317.880 $46,920 $68,166 $93,404 $123,287 $158,573 Instructions Maryland Home and Community-Based Services (MHCBS) is considering a major expansion that will enable it to attract a different clientele to its organization. Currently, they serve only 34% of the frail elderly seniors and persons with disabilities in the local area. The new chief executive officer (CEO) would like the organization to expand its revenue stream by investing in a multipurpose center serving healthy seniors by offering them arts and crafts and health and wellness programs. The center will also contain an Internet caf offering nutritious breakfast and lunch options. The CEO has commissioned a needs assessment and the study's results reveal the following: . . Approximately 120 seniors in the local community are interested in this center. The CEO expects growth of the aging population to be at least 10% each year. Cost growth across all areas of expenses is expected to rise by 5% each year. The CEO has presented her proposal and financial information to the Board of Directors, and they have advised her that they are in full support of her strategy only if the program is a benefit to the community and if the organization can recoup its investment in five years. The CEO has asked you if this can be achieved. Based on the information presented in the scenario: 1. Calculate break-even and payback period analyses. See Excel Spreadsheet to show your calculation. Service Line Break Even Analysis Memo The proposed costs to operate this new facility are as follows: Expected Monthly Revenue (Membership Fee): $125 per person Monthly Fixed Costs . Utilities: $590 Health/Wellness Staff: $2,500 Arts/Crafts Staff: $2,000 Supplies: $800 Fitness Equipment Maintenance Contract: $200 . Variable Costs Monthly Lunch Cost: $25 Monthly Breakfast Cost: $15 Based on the information above, once the minimum threshold of participants is reached, the initial investment to establish the center is $317,880. The organization anticipates that it will generate $46,920 of net revenues in the first year, $68,166 in the second year, $93,404 in the third year, $123,287 in the fourth year, and $158,573 in the fifth year. 1. Perform the break-even analysis to determine how many seniors would need to have a full monthly membership for MHCBS to cover its monthly expenses. 2. Calculate the payback period to determine how long it will take MHCBS to recover its initial investment of establishing the senior multipurpose center