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

Relationship among variances, Relationship among variances We cannot o...

Relationship among variances We cannot over emphasize the central aim of variance analysis as outlined in the above paragraphs:  that is to assign responsibility for a particu

Determine expected rate, Bebe, a manufacturer of sophisticated and fas...

Bebe, a manufacturer of sophisticated and fashionable women's clothing, is completing a new assembly plant in Malaysia.  A final construction payment of 6,000,000 MY

Definitions of manufacturing concepts interstate, Definitions of manufactur...

Definitions of manufacturing concepts  Interstate Manufacturing produces brass fasteners and incurred the following costs for the year just ended:  Materials and supplies used

Activity Based Costing, How do I figure the estimated activity and estimate...

How do I figure the estimated activity and estimated allocation base?

Valuation of work in progress, Valuation of Work In Progress The con...

Valuation of Work In Progress The concept of Equivalent units It is a notional quantity of completed goods in the production process. This is a collection of work applic

Explain break-even revenue, Q. Explain Break-even revenue? Sales revenu...

Q. Explain Break-even revenue? Sales revenue earned would give no profit and no loss. It can be computed by multiplying break-even volume (above) by products selling price, or

The average cost of production, Distinguish between,     (i)  short-run ...

Distinguish between,     (i)  short-run variable costs & long-run variable costs, and give an example of each one;   (ii)  the marginal cost &  the average cost of production

Calculate average cost and marginal cost, Farmer Dorr figures that her fixe...

Farmer Dorr figures that her fixed costs are $2,000, and the relevant portion of her total cost curve is:                                           Thousands of

allocate the support departments costs , Support Department Cost Allocatio...

Support Department Cost Allocations. Riverside Furniture Company manufactures unfinished furniture for sale to retailers. Riverside has two support departments, Maintenance and Hu

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