Calculate the annual fees required per child from each group

Assignment Help Cost Accounting
Reference no: EM13833248

QUESTION 1 Job costing

Create a spreadsheet solution to the following problem. Follow the template provided.

Play the Job cost podcasts and work through the example problem in those podcasts.

QUESTION 2 Process costing

Prepare a spreadsheet to solve the following process costing problem.

Review the four process costing videos provided in Interact Resources. Note that in the situation below there are two production departments.

QUESTION 3 Joint costing

Create a spreadsheet to solve the following joint cost problem.

Question 4 Variance analysis

A. Solve using a spreadsheet. See the requirements embedded in the spreadsheet. Include the IF function to determine Favourable and Unfavourable variances.

B. Prepare a Business Report as if for senior management critically evaluating the purpose of variance analysis, why the materials price variance should be calculated on purchase, other areas in an organisation where variance analysis would be useful and the practical relevance of detailed overhead variance analysis. See the reading by Murray Wells. Suggested word limit about 300- 400 words. Ensure that your answer is in business report format. Read the following online references regarding business report writing.

https://bit.ly/FoBAcademic-Writing-Skills

and

https://unilearning.uow.edu.au/report/4b.html

QUESTION 5 Cash budget

Work Integrated Assessment. See the cash budget on page 261 of your textbook.

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 have 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: EM13833248

Questions Cloud

Suppose the employees of starbucks : Suppose the employees of Starbucks in China are paid 8 yuan per hour and a cup of coffee is priced at 8 yuan. If Starbucks is maximising its profit, What is the value of marginal product of labour (VMPL) per hour of the last worker employed by Starbu..
Solution of aluminum from a 5m stock of aluminum nitrate : Need to make 250 ml of a 0.100 M solution of aluminum from a 5M stock of aluminum nitrate. What do you do?
Under the responsibility scheme : Under the responsibility scheme proposed by the Hong Kong government, households will be charged for solid waste disposal. Is this charge justifiable from an economics point of view? Explain your answer with a diagram ( IT is Microeconomic question)
How much of the distribution will be taxed as a dividend : During 200, Wiley distributed$12,000 cash to shareholders on April 1, and an additional $8,000 cash to shareholders on October 1. How much of the October 1 distribution will be taxed as a dividend to Wiley's shareholders? a. $0 b.$4,000 c.$5,000 d.6,..
Calculate the annual fees required per child from each group : 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.
Dielectric constant of water drop as a function : Why does the dielectric constant of water drop as a function of temperature?
Write an expression that represents the lateral area : write an expression that represents the lateral area
Law of diminishing returns with the help of diagram : Define and explain ‘Law of Diminishing Returns with the help of diagram. What are the different stages of production in the short run? Define and explain ‘Price Discrimination (PD)’ with the help of diagram. Also give examples of Price Discrimination..
A stream of 5.00 wt% oleic acid in cottonseed oil enters : A stream of 5.00 wt% oleic acid in cottonseed oil enters an extraction unit at a rate of 100.0 kg/hr. A separate stream of propane enters the unit. Propane is able to dissolve oleic acid but cannot mix with the cottonseed oil. Two streams exit the un..

Reviews

Write a Review

 

Cost Accounting Questions & Answers

  Calculate the applied overhead rate

Calculate the applied overhead rate and use in determining value of WIP, Finished Goods and Cost of Goods Sold Indicate whether overhead was under or over applied and dispose of amount in appropriate manner.

  Effects of long-term bond investment on morgan stanley

Show all financial statement effects of long-term bond investment on Morgan Stanley's balance sheet and income statement at December 31, 20X0.

  Impact on the accounting profession

key provisions of the Sarbanes-Oxley Act of 2002. Order your list from most important to least important in terms of the likely long-term impact on the accounting profession and financial reporting.

  What is the learning curve represented by the data

What is the learning curve represented by the data in the unit learning curve table - What is the correct amount to include in your budget request for this project?

  The company is considering the acquisition of equipment

the company is considering the acquisition of equipment that would radically change its manufacturing process. the

  Questionyou have just hired as a new management trainee by

questionyou have just hired as a new management trainee by earrings unlimited a distributor of earrings to several

  How does the shareholders wealth change

How does the shareholders wealth change and outstanding equity are entitled to purchase one additional share of the new issue.

  Evaluate the average cost per unit for every plant

Evaluate the average cost per unit for every plant and why would manager of plant A be unhappy with using average cost as the performance measure?

  Greiner company makes and sells high-quality glare filters

greiner company makes and sells high-quality glare filters for microcomputer monitors. john graven controller is liable

  Determining appropriate product costs

Determining appropriate product costs is essential to reporting a reliable inventory valuation. Fraud examiners have indicated that scams that involve product costs and expenses are relatively easy to detect.

  Questionlangrova inc has the subsequent amounts included

questionlangrova inc. has the subsequent amounts included inits general ledger at december 31 2010.organization costs

  How much long-term debt does blackwell automotive have

How much long-term debt does Blackwell Automotive have - It also had accounts receivable of $141,258 and other current assets of $11,223. How much long-term debt does Blackwell Automotive have?

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