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 opportunity costs, Suppose the Danny can prepare 50 pizzas or...

Suppose the Danny can prepare 50 pizzas or 100 sandwiches in an hour and Steve can produce 15 pizzas or 9 sandwiches. a) Draw each individual's PPF. b) Calculate the oppor

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

Marginal & Absorption, Ask quCalculate the standard production cost per uni...

Ask quCalculate the standard production cost per unit and standard profit per unit using Absorption costing principles. ii. Prepare a profit statement for January and February (se

Limitations of cvp analysis, Limitations of CVP Analysis The make use ...

Limitations of CVP Analysis The make use of the basic CVP model is just only relevant to planning and decision-making in an activity range whether the basic cost and revenue b

Gross rental revenue, Operating Income 1. Operating Income is derived f...

Operating Income 1. Operating Income is derived from two sources, Rental Income from businesses operating in the warehouse complex and Interest Income of the project operating

Last in first out or lifo, Last in first out or LIFO LIFO is based upo...

Last in first out or LIFO LIFO is based upon the assumption such the stock purchased last is issued first. Stock valuation should here be based upon the prices ruling on acqui

#title, compare tradition costing and activity costing methods of overhead...

compare tradition costing and activity costing methods of overheads abpsrption based on production units,labour hourd and machine hours

Calculate the incremental liquidation cash flows, How relevant to the decis...

How relevant to the decision are the $800(000) initial cost of the project and the operating losses of $300(000)? Calculate the incremental liquidation cash flows for the abando

Budgeting, traditional budgeting systems are incremental in nature and tend...

traditional budgeting systems are incremental in nature and tend to focus on cost centres..explain the weakness of the incremental budgeting system and explain ways of adressing th

Determine the expected range of returns , Series Arithmetic Mean ...

Series Arithmetic Mean Standard Deviation   Small-company stocks 15.9  % 32.8  %   Large-company

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