Question: View the below budget and by account determine the current budget and future budget by FY 2024, September 2024. Six period are already provided. Please

View the below budget and by account determine the current budget and future budget by FY 2024, September 2024. Six period are already provided. Please provide details on how you compiled your information, also place information in a pivot table. Thank you.

Dept Department Description Account Account Description Fiscal Year Period Budget Expense Encumbrance Pre-Encumbrance Available Budget* Percent Available
5007006 Back Office Services 720001 FEES AND SERVICES 2024 1 254,487.00 29,807.90 109,625.65 0 115,053.45 45.21
5007006 Back Office Services 720001 FEES AND SERVICES 2024 2 0 7,397.70 15,908.56 0 -23,306.26 0
5007006 Back Office Services 720001 FEES AND SERVICES 2024 3 0 72,370.45 -72,370.45 0 0 0
5007006 Back Office Services 720001 FEES AND SERVICES 2024 4 125,000.00 33,263.38 171,736.62 0 -80,000.00 -64
5007006 Back Office Services 720001 FEES AND SERVICES 2024 5 0 13,575.59 -13,575.59 0 0 0
5007006 Back Office Services 720001 FEES AND SERVICES 2024 6 50,000.00 0 0 0 50,000.00 100
5007006 Back Office Services 520040 GROUP HEALTH 2024 1 1,604,670.00 103,325.54 1,231,584.96 0 269,759.50 16.81
5007006 Back Office Services 520040 GROUP HEALTH 2024 2 -90,150.00 104,019.00 -87,375.96 0 -106,793.04 118.46
5007006 Back Office Services 520040 GROUP HEALTH 2024 3 0 102,632.08 -117,888.20 0 15,256.12 0
5007006 Back Office Services 520040 GROUP HEALTH 2024 4 0 104,712.46 -77,667.52 0 -27,044.94 0
5007006 Back Office Services 520040 GROUP HEALTH 2024 5 0 104,712.46 -116,501.28 0 11,788.82 0
5007006 Back Office Services 520040 GROUP HEALTH 2024 6 0 51,316.04 -62,411.40 0 11,095.36 0
5007006 Back Office Services 510030 INCENTIVES ALLOWANCES 2024 1 32,102.00 2,475.39 29,444.40 0 182.21 0.57
5007006 Back Office Services 510030 INCENTIVES ALLOWANCES 2024 2 -60 2,467.07 -2,332.04 0 -195.03 325.05
5007006 Back Office Services 510030 INCENTIVES ALLOWANCES 2024 3 0 2,446.30 -2,741.76 0 295.46 0
5007006 Back Office Services 510030 INCENTIVES ALLOWANCES 2024 4 0 2,462.45 -2,187.76 0 -274.69 0
5007006 Back Office Services 510030 INCENTIVES ALLOWANCES 2024 5 0 2,455.53 -2,612.44 0 156.91 0
5007006 Back Office Services 510030 INCENTIVES ALLOWANCES 2024 6 0 1,207.22 -1,462.10 0 254.88 0
5007006 Back Office Services 711100 OFFICE SUPPLIES 2024 1 3,761,519.00 0 0 0 3,761,519.00 100
5007006 Back Office Services 711100 OFFICE SUPPLIES 2024 4 -125,000.00 198 139,338.58 0 -264,536.58 211.63
5007006 Back Office Services 711100 OFFICE SUPPLIES 2024 5 0 7,920.00 -7,920.00 0 0 0
5007006 Back Office Services 711204 POSTAGE 2024 1 2,289,994.00 607,451.68 0 0 1,682,542.32 73.47
5007006 Back Office Services 711204 POSTAGE 2024 3 0 538,287.90 0 0 -538,287.90 0
5007006 Back Office Services 711204 POSTAGE 2024 4 0 790,410.74 0 0 -790,410.74 0
5007006 Back Office Services 711204 POSTAGE 2024 5 0 482,313.83 0 0 -482,313.83 0
5007006 Back Office Services 520070 RETIREMENT 2024 1 710,328.00 44,627.74 532,764.96 0 132,935.30 18.71
5007006 Back Office Services 520070 RETIREMENT 2024 2 -38,756.00 44,959.30 -38,507.24 0 -45,208.06 116.65
5007006 Back Office Services 520070 RETIREMENT 2024 3 0 45,382.87 -32,909.72 0 -12,473.15 0
5007006 Back Office Services 520070 RETIREMENT 2024 4 1,515.00 45,996.28 -35,412.92 0 -9,068.36 -598.57
5007006 Back Office Services 520070 RETIREMENT 2024 5 0 45,989.15 -59,499.72 0 13,510.57 0
5007006 Back Office Services 520070 RETIREMENT 2024 6 0 22,759.39 -25,044.51 0 2,285.12 0
5007006 Back Office Services 510010 SALARIES 2024 1 4,609,654.00 292,889.56 3,498,795.36 0 817,969.08 17.74
5007006 Back Office Services 510010 SALARIES 2024 2 -253,198.00 295,276.10 -252,681.50 0 -295,792.60 116.82
5007006 Back Office Services 510010 SALARIES 2024 3 0 293,125.73 -314,735.26 0 21,609.53 0
5007006 Back Office Services 510010 SALARIES 2024 4 9,901.00 296,798.05 -248,424.24 0 -38,472.81 -388.57
5007006 Back Office Services 510010 SALARIES 2024 5 0 296,758.71 -318,425.40 0 21,666.69 0
5007006 Back Office Services 510010 SALARIES 2024 6 0 146,498.81 -167,046.81 0 20,548.00 0
5007006 Back Office Services 510020 SALARIES FINAL BENEFITS 2024 1 46,097.00 182.66 0 0 45,914.34 99.6
5007006 Back Office Services 510020 SALARIES FINAL BENEFITS 2024 2 -2,532.00 0.23 0 0 -2,532.23 100.01
5007006 Back Office Services 510020 SALARIES FINAL BENEFITS 2024 3 0 4,976.70 0 0 -4,976.70 0
5007006 Back Office Services 510020 SALARIES FINAL BENEFITS 2024 4 99 0 0 0 99 100
5007006 Back Office Services 510020 SALARIES FINAL BENEFITS 2024 5 0 0 0 0 0 0
5007006 Back Office Services 510020 SALARIES FINAL BENEFITS 2024 6 0 370.93 0 0 -370.93 0
5007006 Back Office Services 520010 SOCIAL SECURITY 2024 1 342,562.00 21,922.72 262,387.20 0 58,252.08 17
5007006 Back Office Services 520010 SOCIAL SECURITY 2024 2 -18,691.00 22,106.13 -19,367.50 0 -21,429.63 114.65
5007006 Back Office Services 520010 SOCIAL SECURITY 2024 3 0 22,320.62 -16,002.90 0 -6,317.72 0
5007006 Back Office Services 520010 SOCIAL SECURITY 2024 4 731 22,221.99 -21,152.24 0 -338.75 -46.34
5007006 Back Office Services 520010 SOCIAL SECURITY 2024 5 0 22,227.80 -28,624.40 0 6,396.60 0
5007006 Back Office Services 520010 SOCIAL SECURITY 2024 6 0 11,009.60 -12,096.16 0 1,086.56 0
5007006 Back Office Services 520060 UNEMPLOYMENT INSURANCE 2024 1 4,642.00 286.59 3,429.84 0 925.57 19.94
5007006 Back Office Services 520060 UNEMPLOYMENT INSURANCE 2024 2 -254 288.9 -254.36 0 -288.54 113.6
5007006 Back Office Services 520060 UNEMPLOYMENT INSURANCE 2024 3 0 291.87 -206.68 0 -85.19 0
5007006 Back Office Services 520060 UNEMPLOYMENT INSURANCE 2024 4 0 294.03 -277.98 0 -16.05 0
5007006 Back Office Services 520060 UNEMPLOYMENT INSURANCE 2024 5 0 290.55 -374.34 0 83.79 0
5007006 Back Office Services 520060 UNEMPLOYMENT INSURANCE 2024 6 0 143.94 -157.38 0 13.44 0
5007006 Back Office Services 510032 WELLNESS INCENTIVE 2024 4 0 0 0 0 0 0
5007006 Back Office Services 520050 WORKERS COMPENSATION 2024 1 40,847.00 2,599.28 31,049.52 0 7,198.20 17.62
5007006 Back Office Services 520050 WORKERS COMPENSATION 2024 2 -2,228.00 2,620.19 -2,244.48 0 -2,603.71 116.86
5007006 Back Office Services 520050 WORKERS COMPENSATION 2024 3 0 2,601.08 -2,793.84 0 192.76 0
5007006 Back Office Services 520050 WORKERS COMPENSATION 2024 4 87 2,633.56 -2,205.30 0 -341.26 -392.25
5007006 Back Office Services 520050 WORKERS COMPENSATION 2024 5 0 2,633.15 -2,825.42 0 192.27 0
5007006 Back Office Services 520050 WORKERS COMPENSATION 2024 6 0 1,299.84 -1,482.88 0 183.04 0

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To determine the current budget and future budget by FY 2024 September 2024 we will need to compile and analyze the data provided in the table The dat... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

On January 1, 2024, the Mason Manufacturing Company began construction of a building to be used as its office headquarters. The building was completed on September 30, 2025. Expenditures on the...

Q:

Question: Old MathJax webview Old MathJax webview i need ans of these question but the source is alot Old MathJax webviewOld MathJax webview i need ans of these question but the source is alot these...

Q:

The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...

Q:

Use the attached "words.txt" file to store the words along with their ranks in an AVL tree. Then provide the user the option to search for any word. If the word exists the program displays the rank...

Q:

View the below budget and by account determine the current budget and future budget by FY 2024, September 2024. Six period are already provided. Please provide details on how you compiled your...

Q:

I need help with answering these questions, please. 1) Ryanair is considering increasing its average fares to 45 euros. Give two reasons for and two reasons against. Based on these four items, what...

Q:

Performance objective The candidate will demonstrate the ability to implement financial management approaches. Assessment description In response to the scenario provided, you will access and...

Q:

Locate and use an audited annual financial statement STEP 1: The Company Assigned to you Find the most recent audited annual financial statement online for the Canadian public company assigned to the...

Q:

Need ONLY an answer to Part C, step 1, questions 1 and 3. Term Project Part A: Understanding Financial Statements Locate and use an annual report STEP 1: The Company Assigned to you Find the most...

Q:

I need to answer the questions around 5-6 pages. 1. Why is there a need for separate system for governmental accounting and reporting? 2. Why can't we use the same standards applicable for private...

Q:

Since Ryanair DAC's2 emergence as an upstart challenger to the Aer Lingus Ltd.-British Airways plc duopoly in the late 1980s, it had been both a consumer champion and antagonist; a technological...

Q:

Southeast Corporation made sales of $825 million during 2014. Of this amount, Southeast collected cash for all but $27 million. The companys cost of goods sold was $255 million, and all other...

Q:

The following progress report has faults in grammar, punctuation, spelling, number form, wordiness, and word use. Use standard proofreading marks (see appendix b) to correct the errors. when you...

Q:

*1316. The 2-Mg truck is traveling at 15 m>s when the brakes on all its wheels are applied, causing it to skid for a distance of 10 m before coming to rest. Determine the constant horizontal force...

Q:

In a survey of 3917 adults, 738 oppose allowing transgender students to use the bathrooms of the opposite biological sex. Construct a 99% confidence interval for the population proportion. Interpret...

Q:

In a survey of 2668 adults, 1448 say they have started paying bills online in the last year. Construct a 99% confidence interval for the population proportion. Interpret the results. A 99% confidence...

Q:

1. Present and future value tables of $1 at 3% are presented below Today, Thomas deposited $160,000 in a 3-year, 12% CD that compounds quarterly. What is the maturity value of the CD? A. $174,400. B....

Q:

A publisher wants to estimate the mean length of time (in minutes) all adults spend reading newspapers. To determine this estimate, the publisher takes a random sample of 15 people and obtains the...

Q:

A crate of mass m hangs from a mass less rope of length L magnitude pushes horizontal force F of variable the crate at a constant speed (that is, there is no net force on the crate at L. A any point...

Q:

Which of the following factors is most likely to be excluded from calculations fo individual's retirement needs a decade from now? A manally expectations Expectations for return on investments. The...

Q:

Bea Jones (age 32) moved from Texas to Florida in December 2011. She lives at 654 Ocean Way, Gulfport, FL 33707. Bea's Social Security number is 466-78-7359 and she is single. Her earnings and income...

Q:

Frank Willingham has the following transactions during the year: Sale of office equipment on March 15 that cost $20,000 when purchased on July 1, 2010. Frank has claimed $5,000 in depreciation and...

Q:

Cedar Corporation has an S corporation election in effect. During the 2012 calendar tax year, the corporation had ordinary taxable income of $200,000, and on January 15, 2012, the corporation paid...

Q:

Draw an individual's utility curve to illustrate that the person is risk-averse with respect to a loss but is risk-preferring with respect to a gain?

Q:

What are the major differences between expected utility theory and prospect theory?

Q:

Jen, in Exercise 2.2, may buy Stock A or Stock B. Stock A has a 50% chance of being worth $100 and 50% of being worth $200. Stock B's value is $50 with a change of a half or $250 with a probability...