In this assessment, you’ll participate in a scenario where you’re in charge of budgeting decisions. This scenario puts you in charge of preparing a budget for the Redmond Management Association annual


In this assessment, you’ll participate in a scenario where you’re in charge of budgeting decisions. This scenario puts you in charge of preparing a budget for the Redmond Management Association annual public relations luncheon. Save and upload each part of the assessment as a separate file and title the files so it’s clear to see what part of the assessment they serve.  

Use Microsoft Excel—showing all work and formulas—to complete the following:

  • Prepare a flexible budget.
  • Compute the sales volume variance and the variable cost volume variances based on a comparison between the master budget and the flexible budget.
  • Compute flexible budget variances by comparing the flexible budget with the actual results.

Create a 6- to 8-slide presentation for the budget committee meeting showing your findings and recommendations from your computations. 

Complete the following in your presentation:

  • Summarize the results of the sales volume and variable cost volume variances computations based on the comparison between the master budget and the flexible budget.
  • Summarize the results of the flexible budget variances computations based on the comparison between the flexible budget and the actual results.
  • Justify the favorable or unfavorable budget variances.
  • Since this is a not-for-profit organization, address why anyone should be concerned with meeting the budget.
  • Make recommendations for what can be done differently to stay on budget for future luncheons. Provide specific examples to support your recommendations.
  • Include speaker notes