Assignment: Managing Budget Variances
Scenario
You are a sales manager responsible for the midwestern U.S. division of a grab and go style, limited-item restaurant chain that specializes in breakfast items, such as donuts and other bakery items, egg-based sandwiches, coffee, etc. Through the first three months of the fiscal year, the net sales revenue for the midwestern U.S. division has been 5% below budget combined across all items. Your supervisor, the head of sales for the entire U.S., has requested that you investigate the situation and make recommendations to prevent further revenue declines and increase sales revenue enough in the upcoming months to get back to the budgeted amount for the total year.
The business analyst supporting your sales team has prepared a set of budgets for review. The data includes the original master budget for the year and the sales figures for the completed quarter with variance amounts. The analyst has also provided the sales plan with mix information (i.e. price and quantity sales budgets along with variances for the quarter). The file also includes promotional metrics showing historical sales volume increases resulting from advertising and loyalty rewards.
Instructions
Write a memo summarizing your analysis of the variances to budget.
o Describe at least two issues identified in your analysis;
o Discuss at least two recommendations to prevent further declines in sales revenue and recover the unfavorable revenue variance from the first quarter;
o Include a justification for your recommendations versus other possible options and describe the potential risks; and
o Include supporting detail such as tables, calculations, or a revised forecast copied from Excel as appendices with the memo.
Format your assignment according to the following formatting requirements:
o The answer should be typed, using Times New Roman font (size 12), double spaced, with one-inch margins on all sides.
o 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.
o Also include a reference page. The Citations and references must follow APA format. The reference page is not included in the required page length.
Attachment:- MBV-Scenario.rar