A B C D E F G Time Year 1 2 3 4 - W NPD N 5 NNNPP 6 7 8 Quarter Individual Donations Donations from Local Businesses Total Revenue 1 1 17600 40000 57600 1 2 18800 24000 42800 1 3 20800 48000 68800 1 4 22000 80000 102000 2 1 19200 44000 63200 2. 2 19200 30000 49200 2 3 21200 44000 65200 2 4 22400 88000 110400 3 1 20400 48000 68400 3 2 20800 32000 52800 3 3 22000 52000 74000 3 4 23200 72000 95200 4 1 21600 48000 69600 4 2 22000 40000 62000 4 3 23600 56000 79600 4 4 24400 84000 108400 9 10 nm 11 mmm + 12 13 14 15 16 17 5 1 18 5 2 19 3 5 5 20 4 Using your forecasted revenues from Part I, I'd like you to consider the following changes your nonprofit would like to make to its budget in the upcoming year (year 5). Your boss has suggested building off the operating budget for last year in the following way. Operating Budget for Fiscal Year 4 (last year) Operating Budget for Last $ Fiscal Year (Year 4) Personnel Budget $200,000 Non-Personnel Budget $90,000 $290,000 Total Operating Budget (entire Fiscal Year) Breakdown of Personnel Budget for Fiscal Year 4 Component of Personnel Budget $ Salaries (3 employees @ 50,000 each) $150,000 Health Insurance for 3 employees $38,525 FICA Tax (7.65% of salaries) $11,475 Total $200,000 Given the information presented in the tables above, your boss would like to know if it is possible to give raises to all three employees. To keep up with inflation (which is rising all too quickly) your boss suggests an increase in salary of 8%. In addition to this salary request you are already projecting the following (as it relates to your operating expenses) Non-Personnel Budget will increase by 5% in the next fiscal year Health Insurance costs will increase by 5% in the next fiscal year Based on these assumptions and your answer from Part 1, can we afford to give each employee an 8% raise? Explain your answer. If you can't give each employee an 8% raise, what is the highest percentage raise you can give, conditional on your budgetary constraints (think percentage raise as 2% or 3% or 4% - whole numbers). A B C D E F G Time Year 1 2 3 4 - W NPD N 5 NNNPP 6 7 8 Quarter Individual Donations Donations from Local Businesses Total Revenue 1 1 17600 40000 57600 1 2 18800 24000 42800 1 3 20800 48000 68800 1 4 22000 80000 102000 2 1 19200 44000 63200 2. 2 19200 30000 49200 2 3 21200 44000 65200 2 4 22400 88000 110400 3 1 20400 48000 68400 3 2 20800 32000 52800 3 3 22000 52000 74000 3 4 23200 72000 95200 4 1 21600 48000 69600 4 2 22000 40000 62000 4 3 23600 56000 79600 4 4 24400 84000 108400 9 10 nm 11 mmm + 12 13 14 15 16 17 5 1 18 5 2 19 3 5 5 20 4 Using your forecasted revenues from Part I, I'd like you to consider the following changes your nonprofit would like to make to its budget in the upcoming year (year 5). Your boss has suggested building off the operating budget for last year in the following way. Operating Budget for Fiscal Year 4 (last year) Operating Budget for Last $ Fiscal Year (Year 4) Personnel Budget $200,000 Non-Personnel Budget $90,000 $290,000 Total Operating Budget (entire Fiscal Year) Breakdown of Personnel Budget for Fiscal Year 4 Component of Personnel Budget $ Salaries (3 employees @ 50,000 each) $150,000 Health Insurance for 3 employees $38,525 FICA Tax (7.65% of salaries) $11,475 Total $200,000 Given the information presented in the tables above, your boss would like to know if it is possible to give raises to all three employees. To keep up with inflation (which is rising all too quickly) your boss suggests an increase in salary of 8%. In addition to this salary request you are already projecting the following (as it relates to your operating expenses) Non-Personnel Budget will increase by 5% in the next fiscal year Health Insurance costs will increase by 5% in the next fiscal year Based on these assumptions and your answer from Part 1, can we afford to give each employee an 8% raise? Explain your answer. If you can't give each employee an 8% raise, what is the highest percentage raise you can give, conditional on your budgetary constraints (think percentage raise as 2% or 3% or 4% - whole numbers)