Your manager has asked you to generate a report using the following criteria. Your report will include a Word document and an Excel Spreadsheet. 1. Develop a table using the information provided in Attachment (do not forget to add columns for rent and insurance). 2. Utilize cell arithmetic or formulas. 3. Calculate the following: 1. Provide totals for each expense category (e.g. salary) and for each month 2. Average of the actual expenses incurred for each expense's category for months included in spreadsheet. of remaining months except for the insurance and rent payments) 4. Estimate at Completion (EAC) - total actual expenses plus the ETC from above. positive and negative values. 4. Generate a pie chart indicating how the budget has been allocated showing each category (e.g., Salary, Supplies, etc.). 1. Chart Title as "Budget Allocation". 2. Data Labels as a percentage and including the category name. 5. Generate a report in Word to your supervisor indicating your findings. Include the following: 1. Introduction explaining why you have decided to perform this analysis. 2. Methodology utilized, what did you look at to make your assessments. 3. Findings of your analysis. Develop a single table that shows all calculations. Provide a narrative of the significant differences between the budget and EAC. 4. 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. - Both file names should include your name. 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. Monthly rent for the office is $3,575. This is a fixed cost. Insurance is $220 (per month) for the first 4 months and goes up to $250 in May