Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Basic Finance Expert

Already answered by Curltra69 and posted but it needs a password to open the word document. Can I use my tutor credit to get the password and open the file PLEASE! Today if possible? Thank you 

This assignment must be completed in either MS Excel or in with a MS Word table

Budget Case Problem

Meadow Lake Elementary will receive 600 additional students next fiscal year. This increase in student enrollment will raise the school over the number needed for several additional staff. You are only concerned with the budget for the additional students.

Your school will be allocated an additional:

Description Salary Costs

Assistant Principal $ 53,000

Guidance Counselor $ 48,000

4 six-hour Teacher Aides $ 9,600 each

Regular Classroom Teachers $ 48,000 each

One ESE Classroom Teacher $ 48,000 each

One Speech/Language Teacher $ 48,000 each

One ESOL Teacher $ 48,000 each

One Custodian $ 20,000

Secretary Clerk $ 14,000

Data Processor, $ 16,000

The regular education student-teacher formula is 20:1

The school will also receive:

A. $ 4 per student for administrative supplies

B. $16 per student for classroom supplies for regular teacher

C. $ 5 per student for custodial supplies

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M91573556
  • Price:- $15

Priced at Now at $15, Verified Solution

This is the case study of Meadow Lake. In this case study, the salary cost of the staff is given. We have to evaluate the FUNCTION OBJECT, DESCRIPTION of EMP. CT. SALARY, NON-SALARY etc. and various other parameters.

Have any Question?


Related Questions in Basic Finance

This morning you purchased one share of stock for 26 the

This morning, you purchased one share of stock for $26. The stock pays $.32 per share each quarter as a dividend. What must the stock price be 1 year from now if you want to earn a total return of 16 percent for the year ...

Consider the following two mutually exclusive

Consider the following two mutually exclusive projects: Project / Year 0 1 2 3 4 Cost of Capital A -100 40 40 40 40 15% B -73 30 30 30 30 15% Which of the following is closest to the incremental IRR?

A life-cycle cost lcc analysis is being used to help

A life-cycle cost (LCC) analysis is being used to help determine whether the purchase of a high-performance heating ventilating and air conditioning (HVAC) system is cost-effective or not. This analysis would customarily ...

Consider the balance sheet in millions of for first

Consider the balance sheet (in millions of $) for First Integrated Bank: FY 2017 AMOUNT DURATION ASSETS  $790 MILLION 7.5 YEARS LIABILITIES  $650 MILLION 1.5 YEARS What is the FIB's duration gap? 4.9 years 5.4 years 6.0 ...

Corporate finance chapter 6 6 1 how to determine the future

Corporate finance chapter 6. 6. 1. How to determine the future and present value of investments with multiple cash flows? Explain theoretically

Abc company has projected sales of 19810 in january the

ABC Company has projected Sales of $19810 in January. The sales are expected to grow by 10% each month. ABC's collection schedule is as follows: ABC collects 88 percent of its sales in the month of sale and the remainder ...

Please show all work use of formula etcyou have just joined

Please show all work (use of formula, etc) You have just joined the investment banking firm of Danny, Chatman, and Howard. They have offered you two different salary arrangements. You can have $80,000 per year for the ne ...

A project has an initial cost of 30000 and will produce

A project has an initial cost of $30,000 and will produce cash inflows of 8000 per year for the next five years. In addition, the project will have a salvage value of $2000 at the end of its useful life. Find the net pre ...

What are financial ratios commonly used in quantitative

What are financial ratios commonly used in quantitative models of debt ratings? List THREE financial ratios that represent three different factors and explain why these ratios can capture the company's ability to meet it ...

What is the present value of 10000 to be received in 6

What is the present value of $10,000 to be received in 6 years? Your required rate of return is 8% per year. Please show the explanation of work so i will be able to figure out other calculations.

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As