You must also state why you selected the Non$-$profit.

Excel File

Part $1-$ input the following data in the Excel template $($using the form $990-$line item indicated$)$:

a$.$ Name of the PO $($Page $1,$ Line F$)$

b$.$ Total number of employees $($Part I, Line $5).$

c$.$ Total contributions and grants revenue $($Part I, Line $8)$

d$.$ Total program service revenue $($Part I, Line $9)$

e$.$ Total other revenue $($Part I, Line $11,$ may be negative$)$

f$.$ Revenue less expenses for the current and prior years $($Part I, Line $19,$ may be negative$)$

g$.$ Total variable program service expenses $($Hint: first categorize the costs in Part IX$,$ Column B$)$

h$.$ Total fixed program service expenses $($Hint: first categorize the costs in Part IX$,$ Column B$)$

i$.$ Total salaries and wages for program services $($Part IX$,$ Column B$,$ Lines $6,7,8,9,$ and $10)$

j$.$ Total salaries and wages for management and general $($Part IX$,$ Column C$,$ Lines $6,7,8,9,$ and $10)$

k$.$ Total salaries and wages for fundraising $($Part IX$,$ Column D$,$ Lines $6,7,8,9,$ and $10)$

I. Compute the program services contribution margin ratio

m$.$ Compute the program services revenue dollars to breakeven, assuming constant sales mix

n$.$ Not Applicable

o$.$ Compute the program services safety margin in terms of revenue dollars

p$.$ Compute the overall operating leverage factor

HINT: To complete $g,h,$ and I through $p,$ first prepare a contribution format income statement. Assume that other revenue is part of program services.

Explain what the computations mean $($I$.$ to p$.$ right above$).$ Identify and briefly explain at least three issues related to your analysis and the CVP assumptions.

$($Hint: state what the assumption is$,$ why it matters, and how it affects mission and decisions$)$