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

  Basics of amount of dividends common shareholders

The shareholders' equity of Green Corporation includes $200,000 of $1 par common stock and $400,000 of 6% cumulative preferred stock. The board of directors of Green declared cash dividends of $50,000 in 2011 after paying $20,000 cash dividends in..

  Direct reduction of purchase cost

Reduction of cost of goods sold for the period when payments are made.

  Advanced nbspmanagement accounting questionsq1 activity

advanced nbspmanagement accounting questionsq1 activity based managementseneca foods is a regional producer of

  Smith kline company maintains inventory records at selling

Smith-Kline Company maintains inventory records at selling prices as well as at cost. For 2016, the records indicate the following data: Use the retail method to approximate cost of ending inventory in each of the following ways:

  What is the entry to record the trade in

Crowe Company purchased a heavy-duty truck on July 1, 2007, for $30,000. It was estimated that it would have a useful life of 10 years and then would have a trade-in value of $6,000.

  What would happen it choynski set target revenues and

Plot the monthly data and the regression lines for each of the following cost functions: Which cost driver for manufacturing overhead costs would you choose? Explain. Choynski anticipates 2,600 machine-hours and 300 batches for next month. Using the ..

  Two products wood chips and fiberboard come out of a joint

two products wood chips and fiberboard come out of a joint process costing 420000 per year. the sales value of the wood

  What is budgeted operating income

Assume that COGS is a variable cost and that operating expenses are a fixed cost. What is budgeted operating income for 20X9?

  Cash flow benefit of the loss

Her projected share of the loss for the first year is $36,000.Agnes' individual tax rate is 33%. Determine the cash flow benefit of the loss to Agnes if the business form is:

  Svi is a large securities dealer last year the company made

svi is a large securities dealer. last year the company made 600000 trades with an average commission of 20. because of

  Prepare a consolidated income statement

Prepare a consolidated income statement with expenses classified by function - Calculate consolidated retained earnings - Prepare a consolidated income statement with expenses classified by function.

  Brummitt corporation is working on its direct labor budget

brummitt corporation is working on its direct labor budget for the next two months. each unit of output requires 0.05

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