Prepare a cash budget for the kindergarten

Assignment Help Operation Management
Reference no: EM13856778

Cash budget

This is a real situation, using real data. One of the authors was asked to prepare a budget for his child's pre-school. The data has been adjusted.

On attending its first meeting in 20X9 you have been appointed honorary treasurer of the Ashmont Pre-School Kindergarten. The previous treasurer was a bank officer's wife, who has now moved interstate and thus can give you no assistance. Your first task is to prepare an annual budget for 20X9, and set the fees to be charged.

Ongoing through the treasurer's cardboard box containing cheque books, bank deposit books, raffle tickets, fees book, invoices, monthly bank reconciliation statements, postage stamps, etc., you discover a statement of cash receipts and payments for the previous year (shown on next page).

After making various inquiries of the teacher, parents on the 20X8 school committee and others, you arrive at the following conclusions:

(i) Salaries and wages are expected to increase by an average of 4% for 20X9.

(ii) You decide to allow 9% for general cost increases in 20X9 on recurrent expenditures other than salaries and wages and repairs and maintenance (to the building).

(iii) Repairs and maintenance should be about $2,000.

(iv) The Fete and other fund raising activities are unknowns and last year's results are your best guess for this year.

(v) Staff has been asked to purchase their own coffee and biscuits.

(vi) Government subsidies are likely to be reduced by $4,000 on last year's subsidies.

(vii) Purchases of assets to the sum of $5,000 are contemplated by the teacher, if the money is available.

(viii) A cash balance of at least $12,000 as at 31 December, 20X9 is necessary to cover salaries in January 20Y0 over the Christmas vacation.

(ix) No debtors' or creditors' balances exist at 1 January 20X9.

(x) The school can accept 75 children, 25 in each of three groups per week:

Group A: 3 mornings per week (9-12) Mon., Tue., Wed.

Group B: 2 mornings per week (9-12) Thu. Fri.

Group C: 4 afternoons per week (1.00-3.30) M,T,W,T.

It is expected that, because of heavy demand, each group will be filled to capacity. Friday afternoon is free for the teacher to carry out administrative duties.

Note that the problem presented here is adapted from the text data.

1. There are no bank or government charges levied on this account.

2. Past experience indicates that the piano needs tuning once every three years.

3. During the last 20 weeks of the year the lawns were mowed on 10 occasions at $40 per time. Previously parents had taken turns to mow the lawns but it had become increasingly difficult to get volunteers so that the mowing was contracted out.

4. Orange cordial and fresh fruit for children mid-morning and mid-afternoon, and includes $100 for coffee and biscuits for staff and visitors.

Required:

(a) Prepare a cash budget for the kindergarten to determine the total fees revenue required in 20X9.

(b) Calculate the annual fees required per child from each group, where the different groups are charged on the basis of their fair share of the total teaching time available.

(c) It is possible that some of these forecasts could change. Discuss the role of sensitivity analysis in budgeting.

The following spreadsheet template will be useful.

Reference no: EM13856778

Questions Cloud

Under what theory might darla be liable : CARDWARE Inc. plans to take over First Class Purses & Accessories (FCPA) in an effort to coordinate elegant CARDWARE professional attire with items from FCPA that will complement CARDWARE’s fashion designs. Under what theory might Darla be liable? Do..
What function does this circuits performs : Problem: As you know, diodes allow current to flow in one direction but not the other. Sketch a current vs. time plots for the points A, B, and output C of the following circuits. What function does this circuits performs?
Consider same organization mechanistic-organic or hybrid : With regard to your current organization (or one with which you are familiar), which design structure is being used? Would you consider this same organization mechanistic, organic, or hybrid? Do you believe this structure and design are effective giv..
How does power differ from authority-from influence : How would you define power in your own words? How does power differ from authority? From influence?
Prepare a cash budget for the kindergarten : On attending its first meeting in 20X9 you have been appointed honorary treasurer of the Ashmont Pre-School Kindergarten. Prepare a cash budget for the kindergarten to determine the total fees revenue required in 20X9. Calculate the annual fees requi..
Proponent of decentralized form of socialism usually support : Proponents of decentralized forms of socialism usually support
What amount barbara include in computing her medical expense : Before considering the AGI limitation, what amount may Barbara include in computing her medical expense deduction?
Problem regarding advanced challenge : Currently, the contents of the Category column in the BOOKS table are the actual name for each category. This structure presents a problem if one user enters COMPUTER for the Computer category and another user enters COMPUTERS.

Reviews

Write a Review

 

Operation Management Questions & Answers

  Discuss the legalese of bribery and bartering

Discuss the legalese of bribery and bartering? Compare and contrast business ethics of two foreign countries.

  Prepare a critique outlining main points success of project

Be careful to correctly spell the name "engebretson" or the search will fail. After retrieving and reviewing the article, prepare a critique outlining the main points of the article as well as explaining why these are critical to the success of an..

  Critically reflect on the significance of the risk and

critically reflect on the importance of the risk and return balance. consider the followinga can we ever have any

  Assignment on the business policy and strategy

The Business Policy and Strategy. This course requires at at least 9 cases, I have to do one case each week. However, I want you to write a case about "SOLAR FEEDER" - I want you to ANALYSIS the case.

  Compare and contrast defined contribution plans

Compare and contrast defined contribution plans and defined benefit plans. Describe ESOP and the features of 401(k), IRAs, SEPs, Keogh, SIMPLE, Roth, and Education IRA plans.

  How would you measure the efficiency of the process

What are the key design principles that govern the effectiveness of this process. Did you observe lag times in the process

  According to service-profit chain-high-value service

Sapphire Farm is a business that trains and boards horses and educates young riders about horse care, nutrition, and riding. The farm provides both a learning and a fun environment for young equestrians and their families. According to the service-pr..

  Understanding of personality and motivation

Demonstrate your understanding of personality and motivation, as well as your critical thinking and writing skills, by synthesizing theories of personality and motivation

  A leadership impact ideology for tq implementation

Spuport a leadership impact ideology for TQ implementation by synthesizing the processes necessary to provide an organization with a TQ paradigm.

  Growth rates

Sales for Hanebury Corporation’s just-ended year were $12 million. Sales were $6 million 5 years earlier. At what rate dis sales grow?

  Write a paper using the five steps in the organizational

Write a paper using the five steps in the organizational process found on page 200 in the text. In your paper, you must: Consider the concept of authority in organizational management and evaluate how authority influences and fosters change in an o..

  Analyzed and discussed the external forces

Analyzed and discussed the external forces and industry conditions that have impacted TEOCO's performance over the years. Analyzed and discussed how the internal organization and culture at TEOCO influenced its performance.

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