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

Calculate the cost of job - manufacturing overhead, Cube Manufacturing bega...

Cube Manufacturing began two jobs during May 200X. The company had no beginning inventory. The following information is available:

Reasons for overhead variances useful for control reasons, Reasons for Over...

Reasons for Overhead Variances Useful for Control Reasons Overhead variances are essentially a book balancing exercising giving an arithmetic reconciliation between the actual

Calculate the maximum capital cost allowance, At the beginning of 2010, Mir...

At the beginning of 2010, Mirror Corporation, had undepreciated capital cost (UCC) of $1,575,000 in asset Class 38 with a CCA rate of 30%. On April 15, 2010, Mirror sold an asset t

Circle the categories of values method , You perform a travel cost study th...

You perform a travel cost study that looks at the relationship between the cost of visiting a lake (including costs of travel, value of time spent not working & any entry fees), it

Idle capacity, How does idel capacity effect cost behavior patterns and fac...

How does idel capacity effect cost behavior patterns and factory overhead application methods

Show the profit volume charts, Q. Show the Profit volume charts? A vari...

Q. Show the Profit volume charts? A variation of a break-even chart, representing graphically the relationship between profit &losses at different levels of sales volume achiev

Calculate average cost to manufacture, Sony manufactures battery for Iphone...

Sony manufactures battery for Iphone 6+. The average costs to manufacture batteries are $4 for 10,000 ad $2.67 for 30,000. Assuming the total cost function is linear, what will be

Variable overhead efficiency variance, Variable Overhead Efficiency Varianc...

Variable Overhead Efficiency Variance Budget for December 2003; Shs. Fixed Overheads 11,480 Variable Over

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