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

Objectives of budgetary planning, Objectives of Budgetary Planning 1...

Objectives of Budgetary Planning 1) Coordination The budgetary process needs that visible detailed budgets are developed to cover every activity, function or department

Determine the customer inter-arrival time, During the dinner hour, the dist...

During the dinner hour, the distribution of the inter-arrival time of customers at Burger Barn is predictable to be as follows: Inter-arrival Time Probabi

What are the variable expenses per unit, Superior Door Company sells pre-hu...

Superior Door Company sells pre-hung doors to home builders. The doors are sold for $60 each. Variable costs are $42 per door and fixed costs total $450,000 per year. The company i

Prepare a flexible overhead budget, Under a contract with the provincial go...

Under a contract with the provincial government, ChemLabs Inc. analyzes the chemical and bacterial composition of well water in various municipalities in the interior of British Co

Fixed overheads variance, Fixed Overheads Variance This is defined lik...

Fixed Overheads Variance This is defined like the difference between the fixed overheads attributed and the standard cost of fixed overheads absorbed in the production achieve

Total variable overheads variances, Total Variable Overheads Variances ...

Total Variable Overheads Variances  If Variable Overhead Expenditure Variance =  Shs.1, 330 Variable Overhead Efficiency Variance = Shs.320 Then total variable overheads

Calculate the rate of learning of initial production phase, Calculate the r...

Calculate the rate of learning at which the initial production phase profit target would be achieved, assuming no other cost savings can be made.   Assuming no other cost savi

What was the cost of supplies cal farm, Cal Farms reported a supplies expen...

Cal Farms reported a supplies expense of $2,000,000 a year. The supplies amount decreased by 200,000 during the year to an ending balance of $400,000. What was the cost of supplies

Prepare cash flow statement, The following details are available from a com...

The following details are available from a company:                                                  2003                 2004                                      2003

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