budgeting homework

You have been hired as an executive director of a small nonprofit organization. Among your many duties are to determine an annual budget and develop a fiscal plan for the organization.

For this assignment, you must develop a 2-page spreadsheet that you will deliver to the director and staff containing an annual generic annual budget for the RTWMTC.  Using an income of 800,000 per year, you must answer the following questions:

· How many employees does the RTWMTC company have, and what is the breakdown of their salaries (you may choose)?

· What additional costs does RTWMTC have (include utilities, lease/mortgage, phone, etc.)?

· What is the surplus or deficit of the RTWMTC?

Either way, you need to determine what you think the Income Statement would look like if the top line revenue is $800,000.

Here is the homework word for word:

You have been hired as an executive director of a small nonprofit organization. Among your many duties are to determine an annual budget and develop a fiscal plan for the organization.

For this assignment, you must develop a 2-page spreadsheet that you will deliver to the director and staff containing an annual generic budget for the RTWMTC. Using an income of 800,000 per year, you must answer the following questions:

How many employees does the RTWMTC company have and what is the break down of their salaries (you may choose)

What additional costs does RTWMTC have (include utilities, lease/mortgage, phone, etc.)?

What is the surplus or deficit of the RTWMTC?

OK, so you have to do a spreadsheet with a budget...you can use my template shown in the chat, or follow the rows on page 14, and then answer the homework questions. Also provide a 1 page word document with how you derived the numbers for expenses and salaries...just base it on your opinion or current salaries in your area. Just one page, that's it, with APA standards and cited references.

Now , I will show you how to do the spreadsheet I toggle to it in Excel, so check the archive.

Here are the rows in my report:

HERE ARE THE ROWS:

GROSS REVENUE

VARIABLE COST OF SALES

GROSS MARGIN (sum)

DIRECT DISTRIBUTION COSTS

VARIABLE

FIXED

TOTAL DIRECT DISTRIBUTION COSTS

CONTINUING COSTS

FIXED OVERHEAD

salaries

lease/mortgage

OTHER INDIRECT COSTS

utilities - electric

utilities - gas

utilities - water

utilities - phone/INTERNET

utilities - waste disposal

Total continuing costs (sum)

Income before taxes (sum)

Less: Taxes (assume 35%)

Net income (sum)

=====================================================================

Add another spreadsheet with salaries per employee, and then wrap it all up with short commentary in a word document about how you came up with the numbers and you are good to go for the homework!