What is your recommendation to the chief financial officer

Assignment Help Financial Accounting

Reference no: EM131122305

Situation 1:

On June 15, 2016, the Title I accountant submits the May 2016 Title I reimbursement request to the State through the EGMS website. The District receives the funds on October 3, 2016. The District's fiscal year end is June 30, 2016. Please explain to the accountant how to record this reimbursement request on Title I's trial balance as of June 30, 2016, including the effect on both the Balance Sheet and the Income Statement, if any.

Situation 2:

As the Accountant, you are assisting the Chief Financial Officer with the preparation of the 2016-17 General Fund Budget. The Chief of Academics would like to buy a new collection of high school math textbooks. The District receives a quote for $2,716,500 which includes the following items:

	Value
Textbooks for 9^th-12^th grade Math	$ 961,500
Consumable Workbooks- School Year 2016-17	1 ,755,000
Consumable Workbooks- School Year 2017-18
Consumable Workbooks- School Year 2018-19
Consumable Workbooks- School Year 2019-20
Consumable Workbooks- School Year 2020-21
Consumable Workbooks- School Year 2021-22

The Superintendent gives you and the CFO a directive to make the textbooks "work" in the budget. While you know the District has enough money in the bank to pay the entire invoice, realistically the District can only afford $1,300,000 of Math textbooks in the 2016-2017 school year to hit the income statement. Please answer the following questions:

1. What is your recommendation to the Chief Financial Officer in order to make this purchase work into the budget?

2. The LA Dept of Education has a standardized set of budget codes that all school districts across the State are mandated to use, commonly referred to as the LAUGH Manual. Please provide the function and object code for these high school textbooks that should be used when preparing the budget.

Situation 3:

On June 1st, the District is going to purchase a new student activity bus using General Fund monies. As the Accountant, one of the accountants that you supervise asks for guidance on how to record this transaction. As their supervisor, please prepare a memo explaining how to record the transaction in the General Fund, including the effect on both the Balance Sheet and the Income Statement, if any.

Situation 4:

In July 2016, the Board amends the General Fund Budget to purchase a new student activity school bus. The Board wants to purchase the bus as soon as possible to have for the first day of school. Due to the urgency of the purchase, how would you work with the Purchasing Department to ensure that the District has a bus on the first day of school while following state purchasing laws.

Situation 5:

On February 1, 2016, the District was required to make a debt service payment relating to the 1985 1/2 cent Sales Tax Bond, Series 2007 in the amount of $1,015,000 (principal) and $341,535 (interest).

1. Please explain the effects of these two payments on the income statement and balance sheet, if any.

2. The LA Dept of Education has a standardized set of budget codes that all school districts across the State are mandated to use, commonly referred to as the LAUGH Manual. Please provide the function and object code for the principal and interest payments that should be used when disbursing the funds.

Situation 6:

Our charter school, Jefferson Charter School, receives their monthly MFP funding through Jefferson Parish Schools. During the first semester of school, the Charter School was 100% in the School Board building. For the second semester of the school year, the Charter School moved the seventh and eighth grade students to Non-School Board buildings adjacent to the School Board building. While the 7th and 8th grade's school day was located in the non-School Board building, the lunch/recess was on the School Board's campus.

As the Accountant, you need to reconcile what the Charter School received versus what they should have received. Prepare the year-end annual MFP calculation based on the facts andcircumstances of this School year to determine how much the charter school should have received during the school year. Please include a copy of your excel file calculation.

FACTS:

1. Enrollment by Grade is as follows:

K	81
1st	72
2nd	77
3rd	78
4th	77
5th	75
6th	77
7th	100
8th	127

2. Included in the total enrollment, are as the following counts:

ELL -
Low Income 481
Career & Tech -
Gifted & Talented 7
Students w/disabilities 87

3. The School Day is from 7:45 to 3:30.

1. Lunch and Recess Period of 45 minutes

2. The District withholds from the payment an amount of ($88.11/stu) for insurance.

3. The District withholds a 2% administrative fee.

4. Charter Schools receive MFP LOCAL funding based on one of two things:

a. Local funding per pupil- In a School Board Building at a rate of $4,663 per student
b. Local funding per pupil- Not in our Building at a rate of $5,242 per student.

8. Charter Schools receive MFP STATE funding for the following reasons:

a. State funding per pupil- School receives $3,622 per student enrolled
b. State funding per pupil- School receives $448 per ELL Student enrolled
c. State funding per pupil- School receives $448 per Low Income Student enrolled
d. State funding per pupil- School receives $122 per Career and Tech Student enrolled
e. State funding per pupil- School receives $1,221 per Gifted and Talented Studentenrolled
f. State funding per pupil- School receives $3,054 per Student w Disabilities enrolled

Reference no: EM131122305

Questions Cloud

Evaluate the characteristics of the business models : Next, evaluate the characteristics of the business models in terms of the degree to which the models in question have played a role in the success of the companies that you previously identified.

Rate of chemical weathering of the earth surface : The level of carbon dioxide in the atmosphere has been increasing for more than a century. Should this increase tend to accelerate or slow down the rate of chemical weathering of the Earth's surface

Purchase of an office computer on account : Assuming the use of a two-column (all-purpose) general journal, a purchases journal, and a cash payments journal as illustrated in this chapter, indicate the journal in which each of the following transactions should be recorded:

The following data from a simple random sample : Consider the following data from a simple random sample of size n = 2 from a population of size N = 8, in which y is the variable of interest and x is an auxiliary variable: y1 = 50, x1 = 10; y2 = 22, x2 = 2.

What is your recommendation to the chief financial officer : Explain the effects of these two payments on the income statement and balance sheet, if any. What is your recommendation to the Chief Financial Officer in order to make this purchase work into the budget?

How secure is cloud computing : How Secure is Cloud Computing? Privacy and security on the internet are very serious concerns. The type of threats we face include anything from the loss of crucial data to mass theft of personal and banking information. This is something we are not ..

The population mean or total using the regression estimator : Carry out a survey to estimate the mean or total of a population of your choice, in which an auxiliary variable might be expected to have a linear relationship with the variable of interest. In the process of carrying out the survey and making the..

Adjustment to record accrued salaries at the end of the year : Assuming the use of a two-column (all-purpose) general journal, a revenue journal, and a cash receipts journal as illustrated in this chapter, indicate the journal in which each of the following transactions should be recorded:

Discuss the interaction of the biosphere : Discuss the interaction of the biosphere, geosphere, atmosphere, and hydrosphere in the formation of soil

User Account

All Pages