Based off of the information in the word document, I have to correctly fill out the adjustments and reclassifications in the trial balance spreadsheet. Why did I get the fundraising expense correct but the rest of my functional expenses are incorrect?

Community Child Care Center, Inc. Working Trial Balance June 30, 2015 Cash Pledges Receivable - Unrestricted Pledges Receivable - Temporarily Restricted Estimated Uncollectible Pledges Inventory Investments Buildings Furniture and Equipment Accumulated Depreciation Unrealized Gain on Investment Other Assets - Deposits Unadjusted Balance Debit 95,000 50,000 75,000 Adjustments Debit Credit Credit 5,000 1,000 e. reclassify printing and publishing f. reclassify contract computer services g. $30,000 moved from unrestricted to temp h. fair value unrestricted investments raised 628,000 15,000 1,000 70,000 30,000 30,000 4,500 100,000 70,000 4,500 500,000 125,000 150,000 45,000 230,000 552,500 60,000 475,000 8,000 6,000 500,000 125,000 150,000 75,000 200,000 552,500 60,000 479,500 8,000 6,000 Adjusted and Reclassified Balance Debit Credit 95,000 45,000 75,000 10,000 7,000 165,000 1,000,000 150,000 628,000 15,000 1,000 70,000 4,500 500,000 125,000 150,000 4,500 45,000 230,000 552,500 60,000 475,000 8,000 6,000 100,000 100,000 100,000 100,000 980,000 175,000 60,000 42,000 1,000 2,000 8,000 100,000 980,000 174,000 60,000 40,000 980,000 174,000 60,000 40,000 25,000 3,000 53,000 8,000 0 0 0 0 2,000 2,966,000 2,966,000 Dr 62,500 62,500 40,700 208,900 226,400 48,700 208,900 226,400 287,664 227,471 264,935 22,929 Totals e. Check stock incorrectly charged to expense 7,000 165,000 1,000,000 150,000 15,000 Contract Computer Services Unrealized Loss (gain) on Investments Depreciation Expense d. Service Fees - Daycare includes deferred revenue 3,000 2,000 Functional Expenses Support Fundraising Expense Administrative Expense Executive Expense Program Services Afterschool Expense Preschool Expense Daycare Expense Parent Training Expense c. Ending inventory includes 3,000 for September Credit Reclassifications Debit Credit 10,000 2,000 15,000 630,000 Contributions - Unrestricted Contributions - Temporarily Restricted Fees for Services - After School Fees for Services - Preschool Fees for Services - Preschool Daycare Fees for Services - Parent Training Classes Investment Income - Unrestricted Net Assets Released from Restrictions Temporarily Restricted Unrestricted Salaries and Fringe Benefits Occupancy and Utility Expense Program Supplies Expense Printing and Publishing Expense b. Depreciation recorded incorrectly Debit 95,000 45,000 75,000 10,000 8,000 150,000 1,000,000 150,000 Accounts Payable Deferred Revenues Unrestricted Net Assets Temporarily Restricted Net Assets Permanently Restricted Net Assets Background Information a. $1,000 deposit charged to occupancy expense Adjusted Balance 287,664 227,471 264,935 22,929 25,000 3,000 51,000 2,979,000 25,000 2,979,000 1,279,000 Cr Deposits Occupancy and Utility Expense 1,000 Accumulated Depreciation Depreciation Expense 2,000 Fundraising Expense Inventory 3,000 Service Fees - Daycare Deferred Revenue 4,500 Inventory Printing and Publishing Expense Fundraising Expense Administrative Expense Printing and Publishing Expense 2,000 1,000 2,000 3,000 4,500 2,000 24,000 16,000 40,000 Afterschool Expense Preschool Expense Daycare Expense Parent Training Expense Fundraising Expense (donor database) Administrative Expense Contract Computer Services 6,304 685 5,420 91 2,500 10,000 Contributions - Unrestricted Contributions - Temporarily Restricted 30,000 Investments Unrealized Gain on Investment 15,000 25,000 30,000 15,000 Donor files chapter 7 bankruptcy Dr Fundraising Expense Pledges Receivable - Unrestricted After School Services Cr 5,000 5,000 Preschool Square Footage 1,500 15% 26,100 Expenses Daycare 2,500 25% 43,500 Dr After School Services Expense Preschool Expense Daycare Expense Parent Training Expense Administrative Expense Executive Expense Occupancy and Utility Expense After School Services Revenue Cr 174,000 Preschool After School Services Salaries & Fringe Benefits Program proportion Fundraising proportion Functional Expense Fundraising Expense Daycare 60,000 5% 685 3,286 Preschool 475,000 43% 5,420 26,016 Daycare 225,000 100% 180,000 100% 225,000 0 180,000 0 Dr After School Services Preschool Daycare Parent Training Administrative Executive Fundraising Salaries & Fringe Benefits Parent Training Administration Executive Total 1,000 1,500 1,000 10,000 10% 15% 10% 100% 17,400 26,100 17,400 174,000 26,100 43,500 43,500 17,400 26,100 17,400 552,500 50% 6,304 30,260 Computer Contract Services Program Supplies 2,500 25% 43,500 Parent Training Total 8,000 1,095,500 1% 100% 91 12,500 438 60,000 Parent Training Administrative Executive Total 5,000 160,000 220,000 980,000 100% 98% 95% 2% 5% 190,000 5,000 156,800 209,000 0 0 3,200 11,000 190,000 100% Cr 225,000 180,000 190,000 5,000 156,800 209,000 14,200 980,000 1,279,000 Salaries Occupancy Contract Printing Supplies 287,664 0 3,000 51,000 2,979,000 Statement of Functional Expenses After School Preschool Daycare Training Fundraising Administration Executive 225,000 180,000 190,000 5,000 14,200 156,800 209,000 26,100 43,500 43,500 17,400 26,100 17,400 6,304 685 5,420 91 2,500 10,000 24,000 16,000 30,260 3,286 26,016 438 227,471 264,935 22,929 Statement of Activities Unrestricted 2,979,000 Revenues, gains, and other support: Contributions After school service Preschool Service Daycare Service Parent Training service Investment Income Unrealized gain on investments Net assets released from restriction: Total revenues, gains, and other support: Expenses and losses: Program services: Afterschool Preschool Daycare Parent Trainng Total Program expenses Support expenses: Fundraising Administration Executive Total Support expenses Unrealized loss on investments Total Expenses and losses Change in net assets Previous net assets Net assets June 30, 2015 45,000 230,000 552,500 60,000 475,000 6,000 15,000 100,000 1,483,500 48,700 Temp 208,900 Permanently Total 230,000 (100,000) 130,000 226,400 0 275,000 230,000 552,500 60,000 475,000 6,000 15,000 0 1,613,500 287,664 227,471 264,935 22,929 803,000 287,664 227,471 264,935 22,929 803,000 48,700 208,900 226,400 484,000 3,000 1,290,000 193,500 500,000 693,500 48,700 208,900 226,400 484,000 3000 1,290,000 130,000 125,000 255,000 0 323,500 150,000 775,000 150,000 1,098,500 ACG 3501 Not-for-Profit Activity The purpose of this project is to reinforce the financial accounting and reporting concepts applicable to not-for-profit organizations. This assignment will allow students an opportunity to use critical thinking skills to evaluate and then record a number of typical transactions, adjustments, and reclassifications encountered by not-for-profit organizations1. Use an Excel spreadsheet to prepare a working trial balance to summarize the unadjusted amounts, adjustments, and final balance amounts (see additional instructions below). All journal entries posted to the trial balance are to be listed below the trial balance, adequately described, and all supporting calculations shown below the applicable journal entry. Organizing the information in this manner will allow you to answer the questions noted under the \"Quizzes\" tab for \"Not-for-Profit Activity\". You will be able to complete your work much more efficiently if you thoroughly review the questions you are required to answer before attempting to analyze the following information. Submission of your Excel spreadsheet is a required part of this assignment and is worth 50 points. The remaining 75 points for this assignment are related to the questions (located under the \"Quizzes\" tab) that you will need to answer using your completed adjusted trial balance and the background information provided here. In order to receive the 50 points for your spreadsheet, you will need to attach it and then submit it via the \"Assignments\" tab in Webcourses. 1 Adjustments normally affect both a balance sheet and operating statement account while reclassifications affect only one type of account within one statement. For example, classifying the current portion of notes payable would be a reclassification entry while adjusting the amount of notes payable for errors in applying payments would be an adjusting entry. 1 Guidelines for the preparation of your Excel spreadsheet are as follows: Use only one \"sheet\" for your work. Your name and ACG 3501 section number should appear at the top of the spreadsheet. Order your journal entries in the same order as the background information is presented. Indicate the question number(s) from the \"quiz\" on your spreadsheet next to the related amount or work. Prepare any adjustments needed based on the situations noted below. Journal entries should be in good form (i.e. balanced, debit and credit amounts clearly delineated, no abbreviations, brief description of the entry, etc.). Post any adjusting entries to the trial balance and extend the adjusted amounts. In cases where multiple entries are necessary for the same account, you must clearly indicate somewhere in this assignment 2 the detail amounts comprising the total amount(s) indicated on the trial balance. Prepare year end reclassification entries based on the situations noted. Entries should be in good form (i.e. balanced, debit and credit amounts clearly delineated, no abbreviations, brief description of the entry, etc.). Post any reclassifying entries to the trial balance and extend the reclassified amounts. In cases where multiple entries are necessary for the same account, you must clearly indicate somewhere in this assignment 1 the detail amounts comprising any aggregated amount indicated on the trial balance. Clearly label all columns and rows and show ALL of your work. Please avoid using abbreviations that are not generally accepted in the accounting vernacular. Enable the spreadsheet to allow the instructor to view the formulae used in each cell. Use commas for all numbers but do not use decimals or places (i.e. one thousand ten dollars and 20 cents should show as 1,010 not $1,010.20). The information on your spreadsheet will be critical to your ultimate success on this activity. In addition, the spreadsheet information will be used to determine if any partial credit should be awarded for questions that are missed on the \"quiz\". Therefore it is very important that you make the information on your spreadsheet easy for someone not familiar with how your brain thinks to follow the work and easily find your answers. 2 You may use additional lines on the trial balance, summations on supporting worksheets, etc. 2 Background Information 1. Review each of the following items that were noted by the CFO after the unadjusted trial balance was prepared and make adjusting and reclassifying entries as necessary. Do not assume that all items listed require adjustments or reclassifications. a. $1,000 was charged to occupancy and utility expense that represented a rental deposit for a three-year operating lease of a new copier. b. Depreciation expense recorded for the year was incorrect. The correct amount of depreciation should have been $51,000. c. Ending inventory included $3,000 for brochures related to the planned giving campaign scheduled to begin September 1, 2015. d. Service Fees - Daycare included $4,500 related to childcare services for the week beginning July 1, 2015. e. Printing and publishing expense included $2,000 for check stock (i.e. special watermarked paper for printing operating and payroll checks) that was received June 29, 2015. A review of all charges to this account indicated 60% of the charges related to Fundraising function and the remaining 40% were related to the Administrative function. f. A review of all charges to Contract Computer Services indicated 50% of the charges related to the Center's child care programs, 10% related to maintaining the Center's donor data base, and the remaining 40% related to the Administrative function. g. Unrestricted contributions revenue included $30,000 that, based on a letter dated March 1, 2015 from the donor, is to be used for a new after school reading program. The after school care program director plans to begin this new program with the start of the new school year in August of 2015. h. The fair value of unrestricted investments increased $15,000. 2. Two weeks after fiscal year end, a major donor with an outstanding unrestricted pledge of $5,000 filed for Chapter 7 bankruptcy. Remember that all bad debt write offs for uncollectible pledges are considered fundraising expenses. 3. Occupancy and related costs are charged to functions based on the relative square footage used for each program/function. Building space is utilized as follows: After school care services 1,500 square feet Preschool 2,500 square feet Preschool daycare 2,500 square feet Parent training classes 1,000 square feet Administration 1,500 square feet Executive 1,000 square feet 4. All program related expenses, unless otherwise noted, are incurred by each program in proportion to the related program revenues. 5. Following is a list of salaries and fringe benefits incurred by programs and functions. The CFO studied time records and talked to employees to determine how employees spent their time. After school care services 12 staff 100% program $ 225,000 Preschool 2 staff 100% program 180,000 Preschool daycare 8 staff 100% program 190,000 Parent training classes 1 staff 100% program 5,000 Administration 3 staff 2% fundraising 160,000 Executive 2 staff 5% fundraising 220,000 3