Slide 1Slide 2Slide 3Slide 4Slide 5Slide 6Slide 7Slide 8Slide 9Slide 10Slide 11Slide 12Slide 13Slide 14Slide 15Slide 16Slide 17Slide 18Slide 19Slide 20Slide 21Slide 22Slide 23Slide 24Slide 25Slide 26Slide 27Slide 28Slide 29Slide 30Slide 31Slide 32Slide 33Slide 34Slide 35Creating an Agency Budget Using Multiple WorksheetsOpen the AgencyBudgetTemplate.xls workbookCreating an Agency Budget, Slide 3 Copyright © 2004, Jim Schwab, University of Texas at AustinWe will build the agency budget using a template of budget categories that are typical for human service agencies. The workbook, AgencyBudgetTemplate.xls, can be downloaded using a link on the Class 3 Worksheet.We will build the agency budget using a template of budget categories that are typical for human service agencies. The workbook, AgencyBudgetTemplate.xls, can be downloaded using a link on the Class 3 Worksheet.Save the template using the agency's nameCreating an Agency Budget, Slide 3 Copyright © 2004, Jim Schwab, University of Texas at AustinSave the budget, incorporating the name of your hypothetical agency in the file name. For my agency, I will save the workbook as HypotheticalHomeForChildrenBudget.xls.Save the budget, incorporating the name of your hypothetical agency in the file name. For my agency, I will save the workbook as HypotheticalHomeForChildrenBudget.xls.The reason that we save the template under a different name is so we can look back at the template if necessary.The reason that we save the template under a different name is so we can look back at the template if necessary.Change default sheet names to descriptive namesCreating an Agency Budget, Slide 4 Copyright © 2004, Jim Schwab, University of Texas at AustinChange the names of the two detail revenue categories that you choose to include in the workbook. I have chosen to include fees for services and foundations, so I change the name of Sheet1 to Fees for Services and change the name of Sheet2 to Foundations.Change the names of the two detail expenditure categories that you choose to include in the workbook. I have chosen to include personnel and purchased services, so I change the name of Sheet3 to Personnel and change the name of Sheet4 to Purchased Services.Change the names of the two detail revenue categories that you choose to include in the workbook. I have chosen to include fees for services and foundations, so I change the name of Sheet1 to Fees for Services and change the name of Sheet2 to Foundations.Change the names of the two detail expenditure categories that you choose to include in the workbook. I have chosen to include personnel and purchased services, so I change the name of Sheet3 to Personnel and change the name of Sheet4 to Purchased Services.Open personnel budget to copy it to agency budgetCreating an Agency Budget, Slide 5 Copyright © 2004, Jim Schwab, University of Texas at AustinWe created the data for the Personnel worksheet in the agency budget for the last class.Open the copy of the personnel budget created for the last assignment. In my case, I open PersonnelBudget.xls.We created the data for the Personnel worksheet in the agency budget for the last class.Open the copy of the personnel budget created for the last assignment. In my case, I open PersonnelBudget.xls.Copy the personnel budget worksheet to the clipboardCreating an Agency Budget, Slide 6 Copyright © 2004, Jim Schwab, University of Texas at AustinFirst, select the entire worksheet that contains the personnel budget by clicking on the intersection for rows and columns.First, select the entire worksheet that contains the personnel budget by clicking on the intersection for rows and columns.Second, click on the Copy tool button to copy the worksheet to the clipboard so we can paste in in the agency budget worksheet.Second, click on the Copy tool button to copy the worksheet to the clipboard so we can paste in in the agency budget worksheet.Paste the clipboard in the personnel worksheetCreating an Agency Budget, Slide 7 Copyright © 2004, Jim Schwab, University of Texas at AustinFirst, navigate to the Personnel worksheet in the HypotheticalHome ForChildrenBudget.xls workbook and select cell A1.First, navigate to the Personnel worksheet in the HypotheticalHome ForChildrenBudget.xls workbook and select cell A1.Second, click on the Paste tool button to paste the worksheet on the clipboard in the personnel worksheet in the agency budget workbook.Second, click on the Paste tool button to paste the worksheet on the clipboard in the personnel worksheet in the agency budget workbook.Enter the fees for services revenue dataCreating an Agency Budget, Slide 8 Copyright © 2004, Jim Schwab, University of Texas at AustinNavigate to the Fees for Services worksheet and enter the data as shown. Use a Sum function to compute the total, format the amounts as currency, bold the column headers and total row, adjust the column widths so that all entries are visible, and center the column headers.Navigate to the Fees for Services worksheet and enter the data as shown. Use a Sum function to compute the total, format the amounts as currency, bold the column headers and total row, adjust the column widths so that all entries are visible, and center the column headers.Add the notes explaining how fees were computedCreating an Agency Budget, Slide 9 Copyright © 2004, Jim Schwab, University of Texas at AustinEnter the notes explaining how the different fee amounts were computed.Enter the notes explaining how the different fee amounts were computed.Enter the foundations revenue dataCreating an Agency Budget, Slide 10 Copyright © 2004, Jim Schwab, University of Texas at AustinNavigate to the Foundations worksheet and enter the data as shown. Use a Sum function to compute the total, format the amounts as currency, bold the column headers and total row, adjust the column widths so that all entries are visible, and center the column headers.Navigate to the Foundations worksheet and enter the data as shown. Use a Sum function to compute the total, format the amounts as currency, bold the column headers and total row, adjust the column widths so that all entries are visible, and center the column headers.Add the notes explaining the foundation supportCreating an Agency Budget, Slide 11 Copyright © 2004, Jim Schwab, University of Texas at AustinEnter the notes explaining how the purposes for which the foundation provided support.Enter the notes explaining how the purposes for which the