Assignment: Information and Decision Tool
Overview:
You are the Budget Analyst for a small company. One of you primary tasks is to carefully monitor expenses to ensure you do not spend more than allocated/budgeted by the top management.
Requirements:
Your manager has asked you to generate a report using the following criteria:
1) Develop a table using the information provided in Attachment 1 (do not forget columns for rent and insurance).
2) Provide totals for each expense category (e.g., salary) and for each month.
3) Calculate the following:
a) Average of the actual expenses incurred for each expenses category.
b) Estimate to Complete (ETC). This is the amount you are forecasting will be spent for each of the expense categories for the remainder of the year. (Use the monthly average times the number of remaining months except for the insurance payment)
c) Estimate at Completion (EAC) - total actual expenses plus the ETC.
d) Difference between the budget (attachment 1) and your EAC for each expense category.
4) 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
5) 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.
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.
Attachment:- Tool-Budget.rar