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

Manufacturing a/c, format of manufacturing,tradind,p/l a/c

format of manufacturing,tradind,p/l a/c

Absorption of non production overheads in production cost, Absorption of No...

Absorption of Non Production Overheads in Production Cost Product costs may be compiled for a range of purposes including a) Stock valuation b) Product pricing c) Dec

Calculate the consumption ratios for each product, The activity driver for ...

The activity driver for the shipping activity is the number of orders shipped. Product A uses 20 orders and Product B uses 60 orders. Calculate the consumption ratios for each prod

Purchase cost and ordering cost, Ordering cost is incurred whenever the ...

Ordering cost is incurred whenever the inventory is replenished. It includes costs associated with the processing and chasing of the purchase order transportation, inspec

Marvin''s motors company (mmc) manufactures outboard, Marvin's Motors Compa...

Marvin's Motors Company (MMC) manufactures outboard motors for use on small to medium sized boats. MMC produces three models: the Standard, the Deluxe and the Performance. The comp

Irr, The following data pertains to an investment proposal: Required invest...

The following data pertains to an investment proposal: Required investment $400,000 Annual cost savings $105,700 Projected life of investment 6 years Projected salvage value $0 Req

Calculate the cumulative cash flows, Assume that you are the purchaser of t...

Assume that you are the purchaser of the building at the end of the construction period, and you have paid the developer an amount which gives you a 7% annual return on net revenue

Prepare a statement of cash flows, Bickering Ltd Income Stateme...

Bickering Ltd Income Statement for the year ended 30 June 2012   Sales (credit)                                                                           636,10

Calculate the total direct labor cost & labor wage rate, Peter Coffin and P...

Peter Coffin and Paul Bearer own The Grave Undertaking, Inc. and their firm uses a predetermined overhead rate to apply overhead to the production of custom-built coffins.  They us

Calculate the total profit for the leisure center, A local government autho...

A local government authority owns and operates a leisure centre with numerous sporting facilities, residential accommodation, a cafeteria and a sports shop. The summer season lasts

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