Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Overview: You are the Budget Analyst for a small company. One of your primary tasks is to carefully monitor expenses to ensure you do not
Overview:
You are the Budget Analyst for a small company. One of your primary tasks is to carefully monitor expenses to ensure you do not spend more than allocatedbudgeted by the top management.
Requirements:
Your manager has asked you to generate a report using the following criteria:
Develop a table using the information provided in Attachment do not forget columns for rent and insurance
Utilize cell arithmetic.
Provide totals for each expense category eg salary column and for each month row.
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 and rent payments
c Estimate at Completion EAC total actual expenses plus the ETC from b above.
d Difference between the budget attachment and your EAC for each expense category and the total budget.
Generate a Column chart based on the differences for each expense category between the Budget and the EAC eg Salary, Supplies, etc. There should be data series. Include the following in the chart:
a Chart Title as "Difference Comparison".
b Data Labels under each expense categorycolumn
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.
What to Turn In
Your written report to your supervisor with charts embedded into the text to support your findings.
Your spreadsheet file.
The grade will be based on completion of the requirements stated above and your recommendation to meet the organizational goal of not exceeding your budget.
Attachment
tableSalaries,Supplies,Phone,Utilities,Travel,Training,AdvertisingJanFebMarAprMayJunJulAugSep
Oct
Nov
Dec
Monthly rent for the office is $
Insurance is $per month for the first months and goes up to $ in May
Annual Budget Information:
tableAmount,
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started