(cont'd) Creating a Budget - HSM 220

posted by .

Operating Expenses
RENT Per Year $125,000
UTILITIES Per Year $100,000
OFFICE SUPPLIES Per Year $25,000
EQUIP/LEASE $50,000
TRANSPTN/TRAVEL $100,000
OUTSIDE CONSULTANTS $100,000
OVERHEAD COSTS $100,000

Peronal Expenses
EXEC DIRECTOR Annl Sal $100,000 1-FTEs
TRAINING SUPERVSR Sal $80,000 1-FTEs
TRAINERS Annl Sal $50,000 10-FTEs
ADMIN COORD Annl Sal $45,000 1-FTEs
ADMIN STAFF Annl Sal $25,000 3-FTEs
Employee-benefit
expenses @ 25% Sal $200,000 0-FTEs

All costs excluding the salary of the executive director and training supervisor will be allocated according to this formula: 60% to basic skills program / 40% to vocational program. Number of eligible students: 1,000

Use the information above to create each of the following: 1. A line-item budget table showing all associated costs implementing the training programs. 2. A combined functional and program budget to calculate all costs per enrolled student.

  • (cont'd) Creating a Budget - HSM 220 -

    See the other post.

    Use an Excel worksheet to figure all these -- or whatever spreadsheet program you have been instructed to use.

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. HSM 220 Creating a Budget

    Need help with how to start this assignment, as I am not sure how to begin making my budgets (ex: line-item, functional and program budgets). Any assistance would be most appreciated. This is due Oct 12th. Creating a Budget Various …
  2. Budget Matrix

    Creating a Budget Various budget approaches play an important role in resource allocation in human service organizations. You are the executive director for a local government workforce agency that focuses on providing career- and …
  3. Accounting

    I am having the worst time: I need to build a four year projected balance sheet. I've already done my four year profit projection and was wondering if someone could help me with the balance sheet. I did year one, can't go any further: …
  4. hsm220

    I am having the worst time with this. Even after reading the material several times I a very lost. Any help would be great. The Department of Education has awarded your agency with grant funding of $1.6 million to provide training …
  5. Accoubting

    Creating a Budget Various budget approaches play an important role in resource allocation in human service organizations. You are the executive director for a local government workforce agency that focuses on providing career- and …
  6. Human Services

    Creating a Budget Various budget approaches play an important role in resource allocation in human service organizations. You are the executive director for a local government workforce agency that focuses on providing career- and …
  7. healthcare fiancare

    HINT: 6% X $1,000,000 – {20% X ($1,000,000 – (6% X $1,000,000))} = 6% X $1,000,000 – {20% X ($1,000,000 - $60,000))}= 6% X $1,000,000 - {20% X $940,000}= 6% X $1,000,000 - $188,000 = $60,000 - $ 188,000= -$128,000 A) The interst …
  8. Economics

    Suppose that a tour bus business incurred implicit costs of $600,000 and explicit costs of $7 million in a specific year. If the firm sold 125,000 tours at $60 per person, its accounting: A) profits were $100,000 and its economic profits …
  9. Human Resources

    Creating a Budget Various budget approaches play an important role in resource allocation in human service organizations. You are the executive director for a local government workforce agency that focuses on providing career- and …
  10. Math

    Would 72,060,964,765 look like the following in it's expanded form?

More Similar Questions