What do I do to get the dollar amounts for Program 1, Program 2, Program 3, and Management and General, and Fund-Raising based on and/or using the percentages that appear on Program 1, Program 2, Program 3 , Management and General, and Fund-Raising on (Part a) of Question 2 and and the dollar amount associated with Salaries and Fringe Benefits Expense, Supplies Expense, Telephone and Postage Expense, and Utilities Expense? Can you all show me the step by step work to get the correct values for and the dollar amount associated with Salaries and Fringe Benefits Expense, Supplies Expense, Telephone and Postage Expense, and Utilities Expense on the Statement of Activities, please? If you don't want to show me the step by step work, do not respond to this question then.

A2 Trial Balance B 1 Nm Feed The Hungry Children, Women, and Men Trial Balance as of 12/31/18 4 5 Cash 6 Pledges Receivable-Without Donor Restrictions 7 Estimated Uncollectible Pledges 8 Inventory 9 Investments 10 Furniture and Equipment 11 Accumulated Depreciation-Furniture and Equipment 12 Accounts Payable 13 Net Assets Without Donor Restrictions 14 Net Assets With Donor Restrictions-Programs 15 Net Assets With Donor Restrictions-Permanent Endowment 16 Contributions-Without Donor Restrictions 17 Contributions-With Donor Restrictions-Programs 18 Investment Income-Without Donor Restrictions 19 Depreciation Expense 20 Printing and Publishing Expense 21 Rent Expense 22 Salaries and Fringe Benefit Expense 23 Supplies Expense 24 Telephone and Postage Expense 25 Utilities Expense 26 Totals Debit Credit $156,500 41,000 $4,100 2,800 178,000 210,000 120,000 20,520 196,500 50,500 140,000 378,8201 38,100 11,2001 30,000 4,190 32,000 288,410 5,940 4,500 6,400 $959,740 $959,740 A 00 Nm $156,500.00 $36,900.00 $2,800.00 $178,000.00 $90,000.00 $464,200.00 1 Feed The Hungry Children, Women, and Men Statement of Financial Position December 31, 2018 4 Assets 5 Cash 6 Pledges Receivable 7 Inventory 8 Investments 9 Furniture and Equipment 10 11 Total Assets 12 Liabilities 13 Accounts Payable 14 15 Total Liabilities 16 Net Assets 17 Without Donor Restrictions 18 With Donor Restrictions-Programs 19 With Donor Restrictions-Permanent Endowment 20 21 Total Net Assets 22 Total Liabilities and Net Assets 23 $20,520.00 $20,520.00 $0.00 $20,520.00 D Total 4 $416,920 11,200 $428,120 A B C 1 Feed The Hungry Children, Women, and Men 2 Statement of Activities 3 Year Ended December 31, 2018 Without Donor With Donor Restrictions Restrictions 5 Revenues, Gains, and Other Support: 6 Contributions $378,820 $38,100 7 Investment Income 11,200 8 9 Total Revenues, Gains, and Other Support $390,020 $38,100 10 Expenses and Losses: 11 Program Services: 12 Program 1 13 Program 2 14 Program 3 15 16 Total Program Expenses $0 $0 17 Support Expenses: 18 Management and General 19 Fundraising 20 21 Total Support Expenses $0 $0 22 Total Expenses and Losses 0 0 23 Change in Net Assets $390,020 $38,100 24 Net Assets, December 31, 2017 25 Net Assets, December 31, 2018 $390,020 $38,100 0 0 0 $0 0 0 $0 0 $428,120 0 $428,120 Overview: The nonprofit that you established has just completed its second year of operations. In the Final Project Workbook you will find six tabs at the bottom. You will use the Trial Balance tab to prepare the Financial Reports (Statement of Financial Position, Statement of Activities, and Statement of Cash Flows) for your nonprofit. The information in each step relates to the financial activity for your nonprofit during the second year of operations. Remember to save your work in your Excel workbook as you will need to populate the Budget and Financial Analysis tabs and make any revisions based on feedback from your instructor in your final project due in Module Seven. For Milestone Two, you will leave those two tabs blank. Use the information in the Trial Balance tab to prepare the following financial statements: 1. Statement of Financial Position You will use the data provided in the Trial Balance tab to complete this statement. 2. Statement of Activities In addition to the information provided from the Trial Balance tab, use the following information about your nonprofit to prepare the Statement of Activities. a. Salaries and Fringe Benefit Expenses were allocated to Program Services and Supporting Expenses in the following percentages: i. Program 1: 40% ii. Program 2: 20% iii. Program 3: 10% iv. Management and General: 20% V. Fund-Raising: 10% b. Rent and Utility, Supplies, Printing and Publishing, and Telephone and Postage Expenses were allocated in the same manner as Salaries and Fringe Benefit Expenses. c. Depreciation Expense was divided equally to each functional expense category. A2 Trial Balance B 1 Nm Feed The Hungry Children, Women, and Men Trial Balance as of 12/31/18 4 5 Cash 6 Pledges Receivable-Without Donor Restrictions 7 Estimated Uncollectible Pledges 8 Inventory 9 Investments 10 Furniture and Equipment 11 Accumulated Depreciation-Furniture and Equipment 12 Accounts Payable 13 Net Assets Without Donor Restrictions 14 Net Assets With Donor Restrictions-Programs 15 Net Assets With Donor Restrictions-Permanent Endowment 16 Contributions-Without Donor Restrictions 17 Contributions-With Donor Restrictions-Programs 18 Investment Income-Without Donor Restrictions 19 Depreciation Expense 20 Printing and Publishing Expense 21 Rent Expense 22 Salaries and Fringe Benefit Expense 23 Supplies Expense 24 Telephone and Postage Expense 25 Utilities Expense 26 Totals Debit Credit $156,500 41,000 $4,100 2,800 178,000 210,000 120,000 20,520 196,500 50,500 140,000 378,8201 38,100 11,2001 30,000 4,190 32,000 288,410 5,940 4,500 6,400 $959,740 $959,740 A 00 Nm $156,500.00 $36,900.00 $2,800.00 $178,000.00 $90,000.00 $464,200.00 1 Feed The Hungry Children, Women, and Men Statement of Financial Position December 31, 2018 4 Assets 5 Cash 6 Pledges Receivable 7 Inventory 8 Investments 9 Furniture and Equipment 10 11 Total Assets 12 Liabilities 13 Accounts Payable 14 15 Total Liabilities 16 Net Assets 17 Without Donor Restrictions 18 With Donor Restrictions-Programs 19 With Donor Restrictions-Permanent Endowment 20 21 Total Net Assets 22 Total Liabilities and Net Assets 23 $20,520.00 $20,520.00 $0.00 $20,520.00 D Total 4 $416,920 11,200 $428,120 A B C 1 Feed The Hungry Children, Women, and Men 2 Statement of Activities 3 Year Ended December 31, 2018 Without Donor With Donor Restrictions Restrictions 5 Revenues, Gains, and Other Support: 6 Contributions $378,820 $38,100 7 Investment Income 11,200 8 9 Total Revenues, Gains, and Other Support $390,020 $38,100 10 Expenses and Losses: 11 Program Services: 12 Program 1 13 Program 2 14 Program 3 15 16 Total Program Expenses $0 $0 17 Support Expenses: 18 Management and General 19 Fundraising 20 21 Total Support Expenses $0 $0 22 Total Expenses and Losses 0 0 23 Change in Net Assets $390,020 $38,100 24 Net Assets, December 31, 2017 25 Net Assets, December 31, 2018 $390,020 $38,100 0 0 0 $0 0 0 $0 0 $428,120 0 $428,120 Overview: The nonprofit that you established has just completed its second year of operations. In the Final Project Workbook you will find six tabs at the bottom. You will use the Trial Balance tab to prepare the Financial Reports (Statement of Financial Position, Statement of Activities, and Statement of Cash Flows) for your nonprofit. The information in each step relates to the financial activity for your nonprofit during the second year of operations. Remember to save your work in your Excel workbook as you will need to populate the Budget and Financial Analysis tabs and make any revisions based on feedback from your instructor in your final project due in Module Seven. For Milestone Two, you will leave those two tabs blank. Use the information in the Trial Balance tab to prepare the following financial statements: 1. Statement of Financial Position You will use the data provided in the Trial Balance tab to complete this statement. 2. Statement of Activities In addition to the information provided from the Trial Balance tab, use the following information about your nonprofit to prepare the Statement of Activities. a. Salaries and Fringe Benefit Expenses were allocated to Program Services and Supporting Expenses in the following percentages: i. Program 1: 40% ii. Program 2: 20% iii. Program 3: 10% iv. Management and General: 20% V. Fund-Raising: 10% b. Rent and Utility, Supplies, Printing and Publishing, and Telephone and Postage Expenses were allocated in the same manner as Salaries and Fringe Benefit Expenses. c. Depreciation Expense was divided equally to each functional expense category