Please read through the attachments & complete the assignment according to the “Assignment Expectations”: (1 page Excel sheet, 4 page word document with Memo and Short Essay) Each submission should include two files: (1) An Excel file; and (2) A Word document (memo/short essay).

(1) Excel File:
– Prepare a flexible budget and show variances for the year that passed. Indicate whether the flexible budget variances are favorable or unfavorable.
– Headquarters are contemplating charging each store a 5% marketing expense based on sales. How will that affect the operating profit of the store and the money available for managerial bonuses based on actual results for the past year? Summarize the information in a table.

(2) Word document: shows the memo first (Write a 4- or 5-paragraph memo to the division manager explaining the flexible budget variances;  how to interpret the information  and what action, if any to take.  Comment on the 5% marketing proposal too. Start with an introduction and end with a recommendation. Each of the four or five paragraphs should have a heading. Then write a short essay. Again, starting with a intro, ending with a summary using heading’s to evaluate and discuss 1) how to interpret static and flexiblebudget variances,
2) what are the benefits of variance analysis? How can such analysis be detrimental rather than beneficial to the organization…. Have an Intro, Conclusion, in-text citations and References. Please show clearly in the written report/memo and excel the questions from the Module 4- Case Assignment being answered, answer each question directly & entirely. Pages 4 and 1 excel sheet for a total of 5 pages.