Fill out the following chart, using the information that is provided below.

Please complete the budgeting analysis based on the following information , by filling out the chart below - you must USE EXCEL for credit 1 1 Salaries at the end of the year came in 11 .5*6 less than budgeted 2) Fringe benefits budget is a given at 32.5 % of Salaries ;" 3) Supplies were budgeted at 2. 125%` of Salaries in January 2017 but ABC actually spent 5. 5*6} more than budgeted* 4 ) ABC Spent $300 more on equipment than budgeted 5 ) What is your observation of each line item ?" Adopted VS Actual Budget ( Fiscal Year Ended 12 / 31 / 2018 1 MPA HEALTHCARE WALK - IN CLINIC EXPENDITURES BY" TYPE End of Year Adopted Budget in Percent Change* Percent of Total (December 2017 beginning of ( January Net Change Budgeted VS . Expenditures Actual / Spent ) 2017 ) Year (Variance* Actual Spent Analysis / Observation salaries $155, 525. 00 Fringe Benefits Total Personal EXPENSES Operating Expenditures Supplies Equipment 5300.00 Subtotal Operating* Expenditures Total Expenditures