Creating budget and annual operating budget assignment, Cost Accounting

Assignment Help:

This assignment will consist of developing a center-based financial operating budget. A break-even and Cash-flow projection are not required for this assignment. Students will develop the budget based on the following information.

  • Use the ages and numbers of children, staff salaries, etc. from the Staffing Patterns Project
  • Ratios: Use NH Licensing ratios
  • Assume the program is non-profit (so this is a break-even budget)
  • Food subsidy: student choice (current reimbursement rates and eligibility requirements can be found online)
  • Grant funding (i.e. United Way, other foundations, etc.): student choice
  • Use a Utilization Rate of 90% - utilization rate is the potential percentage of child care slots being used.  On Blackboard are articles with examples.
  • Other Expenses (use these dollar amounts):
  •  
    1. Rent:  Assume $2000 per month for rental property
    2. Insurance:  Assume $6,000 per year for property and liability insurance
    3. Utilities (electricity, phone, gas): Assume $1000 per month
  • Food, equipment, classroom supplies, maintenance, and cleaning - students will determine the budget for these categories
  • Other components to include:
  •  
    1. Initial  and/or annual registration/enrollment fees (to make up for income lost due to utilization rate)
    2. Fundraising
    3. Professional membership costs
    4. Non-teaching staff salaries
    5. Curriculum materials
    6. Replacement items, i.e. furniture, computers, books, etc.
    7. Field trips
    8. Marketing/Advertising
    9. Office Supplies
    10. Attorney on retainer
    11. Tax preparation services
    12. The need for part-time staff

To supplement the budget, students will include rationale for any line items with comments in individual cells (i.e. how the number was calculated, determined, or estimated). In Excel, it will be apparent that students have included a comment because of a small red triangle in the right-hand corner of a cell. Students will also provide a reflection in a Microsoft Word document that addresses the following questions/statements in 2 to 3 pages:

  • What did you find to be the challenges of creating this budget?  What, if any, were the rewards?
  • Discuss what, if anything, you learned from this process? 
  • Do you aspire one day to be in a position where you have the opportunity to create a budget for a child care center?

Related Discussions:- Creating budget and annual operating budget assignment

Government and nonprofit accounting, I need project help in Government and ...

I need project help in Government and nonprofit accounting, can you help me in look out this problems?

Cost and budget, Frame-it Ltd is a manufacturer of metal picture frames. Th...

Frame-it Ltd is a manufacturer of metal picture frames. The firm's two product lines are designate S (small frames: 12 x18 cm) and L (large frames: 20 x 25 cm). The primary raw mat

Prepare journal entries to record the budget, The budgeted and actual reven...

The budgeted and actual revenues and expenditures of Seaside Township for a recent year (in millions) were as presented in the schedule that follows: 1. Prepare journal entries

Materials mix variance, M aterials mix variance :  It can be described a...

M aterials mix variance :  It can be described as that portion of direct material usage variance which is the variation between the actual quantities of ingredients used in a mi

Calculate the variable overhead, Questions 8-10 rely on the following data....

Questions 8-10 rely on the following data. FrontGrade Systems allocates manufacturing over- head based on machine hours. Each connector should require 11 machine hours. According t

Basic earnings per share, What are 'potential' ordinary shares?  In your an...

What are 'potential' ordinary shares?  In your answer provide three examples to support your explanation.  Briefly outline the process (steps) to determine whether 'potential' ordi

Wacc under every of the capital structures, Imperial Sandwich Plc is to be ...

Imperial Sandwich Plc is to be established shortly. The founders are considering their options with regard to capital structure. A total of £5 m will be required to establish the b

Period costs, Period Costs Some terms are difficult to define. In one s...

Period Costs Some terms are difficult to define. In one school of thought, period costs are the any costs that are not product costs. But, such a description is a stretch, beca

Compute the internal rate of return, ABC bond is a 20-year bond with face v...

ABC bond is a 20-year bond with face value $1000. The coupon payment is $25 per 6 months. The semi-annual yield is 4%. Use the PV function in Excel (or equivalent) to Önd the price

Determine operating cash flow, What are the missing amounts for the below a...

What are the missing amounts for the below amortization table, given the following information? -  A firm borrows $100,000 from a bank. -  The terms of the loan require the f

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd