Prepare the unit count calculation

Assignment Help Accounting Basics
Reference no: EM131512936

School Budget Assignment

Assumptions:

Annual Average Teacher Salary - $48,000

Other Employment Costs - 22.3%

Annual Benefits Cost Per Employee - $8,800

1)  Prepare the unit count calculation (based on the Delaware formula and divisors) for the sample school below:

Delaware Intermediate School

Grade

Regular

Basic

Intensive

Complex

4

305

35

17

13

5

316

32

14

12

6

309

27

18

15

2) Prepare a budget based on the following:

Based on the number of teaching units received - calculate the teacher salary, OEC amount and annual benefit amount.

In addition to teachers assign one Principal at a salary of $92,000 and the appropriate number of Assistant Principals based on the Delaware formula - each with a salary of $83,000 (again include OEC's and benefits).  You do not need to add any other staff.

Allocate costs to (you may add additional categories if you wish):

Textbooks

Instructional Supplies

Student Body Activities

Phones

Utilities

Computers

Contracted Services

Your estimated revenues are $7,500,000.

3)  Explain your rationale for allocating expenses to the various categories you have been given (include terms from class notes).

Your grade will be based on correct calculations of a unit count, final product includes the elements of a budget (must "look" like a budget and neatness counts), math is correct and you have applied terms and practices described in our first 2 classes.

Please show all formulas used and all math calculations so I can give partial credit where applicable.

Instructions for part 2 of the assignment

You need to multiply quantity by price (number of staff times the average salary) to obtain the various salary items.

OEC's or Other Employment Costs are a percentage of the total salary.

Every employee will have benefits - again - use quantity times price.

You do not have a lot of history or detail at this point - spend your revenue on the various items - you can add to the list.  During the process make a list of additional information you would like to have if you were compiling the budget as a needs based budget.  These items will be part of a discussion board and class discussion.

Do not include calculations in the budget itself - they should be separate.

Do not overthink the allocation of your remaining funds - your grade will be based on math calculations being done correctly, it looks like a budget, it is balanced.

Here is the information on how to calculate principals and assistant principals for the state for Delaware

In addition to determining the units or number of teachers to be employed with the state funds the unit count determines many other positions. 

Determined by location:

Principal - 1 for each school over 15 units (never more than 1/school)

Asst. Principal -   .65 at 25

                         1 at 30

                         1.65 at 50

                         2 at 55

                         1 every 20 thereafter

Attachment:- Assignment Files.rar

Reference no: EM131512936

Questions Cloud

List steps you will take to identify barriers : List steps you will take to identify barriers when developing a coalition. Discuss what barriers are. Discuss approach you will take to overcome these barriers.
Profits by hiring factors : A firm will maximize its profits by hiring factors up to the point at which:
Contrast business environments in jamaica : Compare and contrast business environments in Jamaica and USA.
What is a multidivisional organization : Is a firm that exports or licenses its product to a firm in another country a MNE and what is a multidivisional organization?
Prepare the unit count calculation : School Budget Assignment - Prepare the unit count calculation (based on the Delaware formula and divisors) for the sample school
High fixed costs and low marginal costs : It would carry goods from New York, and it would pick up agricultural goods in Dillen, Texas along the way. The railroad had high fixed costs and low marginal.
Which business organizational form would be best given : Develop a 350- to 700-word summary with the following information: Which business organizational form would be best given the above circumstances, and why?
Diminishing returns to an input : What do economists mean by "diminishing returns" to an input? What causes diminishing returns?
Which administrative agency governs regulatory compliance : Which administrative agency governs regulatory compliance of the manufacturer? Cite a minimum of two peer-reviewed references.

Reviews

len1512936

5/31/2017 5:26:44 PM

The following assignment I would like to have today or tomorrow. Could you please give me an estimate? We are required to balance the budget using that attached information. Our Total Revenue on page 1 must equal the Total Expenditures on page 2. Please show all formulas used and all math calculations on a separate excel sheet/tab and not in the budget itself. Please show all formulas used and all math calculations so I can give partial credit where applicable. Do not include calculations in the budget itself – they should be separate. Do not overthink the allocation of your remaining funds – your grade will be based on math calculations being done correctly, it looks like a budget, it is balanced.

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

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