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

Determine taxable profit, While on a business trip to Texas, David attended...

While on a business trip to Texas, David attended a mortgage foreclosure auction. At the auction (held on February 4, 1999), he acquired an abandoned sugarcane farm near Pearland.

Case study, Ask q6) The Net Sales revenue reported is derived from the sale...

Ask q6) The Net Sales revenue reported is derived from the sale of products. Each year Findley records from cash sells, sells on account and completed purchase orders. During 2016

Material price variance (mpv), Material Price Variance (MPV) This may b...

Material Price Variance (MPV) This may be described as the difference amoung the actual price and the standard price of the materials consumed. MPV = Actual quantity used (S

Inventory systems, Find a journal article online about just-in-time invento...

Find a journal article online about just-in-time inventory systems. In the subject line of your post, include the title of the article that you read. Post a link to that article wi

What is operating costing, Describe Operating Costing The Chartered Ins...

Describe Operating Costing The Chartered Institute of Management Accountants, London defines "operating cost" as "the cost of providing a service." Services performed may be in

Advantages of average costing method, Average costing method has the follow...

Average costing method has the following main advantages: 1.It is a realistic costing method useful to management in analyzing operating results and appraising future production

Planning, what is planning and what part of this activity would you describ...

what is planning and what part of this activity would you describe as planning in the situasion above

Timing of cashflows, The time of cashflows for the project are as follows; ...

The time of cashflows for the project are as follows; Operating Income (rent) is received annually, in advance. For NPV purposes they are assumed to have been received at th

Which of the four types of costs would include direct labor, Which of the f...

Which of the four types of costs would include Direct Labor? A. Unit-Level B. Batch-Level C. Product Sustaining D. None of the above

Evaluate the expected earning, During his career in the energy industry, T-...

During his career in the energy industry, T-Bone McAdams has accumulated $5,000,000 in "surplus savings" that he is planning to donate to his college alma mater, Oklahoma A&M, in

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