Question

#1) Generate a pie chart based on the total actual expenses for each category (e.g., Salary, Supplies, etc.). Include the following in the chart:

A) Chart Title as “Total Actual Expenses”

B) Data Labels as a percentage of the total expense and including the category name

#2) Generate a report to your supervisor indicating your findings. Include the following:

A) Introduction explaining why you have decided to perform this analysis.

B) Methodology utilized.

C) Findings of your analysis. Develop a single table that shows all calculations. Provide a narrative of the significant differences between the budget and EAC.

D) Recommendations. Suggest a course of action that should be taken in order to ensure that the established budget is not exceeded.

1) Salaries Supplies Phone UtilitiesTravel Training Advertising Rent 12,543 9,953 11,245 13,678 12,005 10,745 11,486 81,655 11,665 58,325 139,980 135,000 4,980 Insurance Total 187 187 187 195 195 195 195 1,341 192 975 2,316 2,136 19,838 16,766 19,968 18,886 20,660 18,584 19,906 134,608 19,230 96,166 230,774 219,286 11,488 1,256 485 387 446 1,254 2,750 2,750 2,750 2,750 2,750 2,750 2,750 19,250 2,750 13,750 33,000 33,000 175 236 187 897 547 299 684 799 1,089 2,879 589 589 2,898 1,985 1,656 11,537 1,648 8,241 19,778 12,000 7,778 879 632 823 4,921 198 230 June 1,546 6,959 994.14 4,971 11,930 12,000 70 695 3,631 519 2,594 6,225 5,750 2) Totals 3,984 3) aAverage of actual expenses 3) c)EAC (Actual + ETC) 3) d)Difference 2,846 6,830 ETC 2,280 2,400 120 3,515 8,436 10,000 1,564 Working Note -12543+9953+11245+13678+12005+10745+11486 81655 Average -81,655/7 11665 -11665 X5 58325 (Remaining months 5) (Same procedure has to be followed for rest of the expenses)