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.
Scenario Information
Mr. Snow was extremely upset with the budget deficit. He immediately called you, the treasurer, to complain about the budget variance for the meal cost. He told you that the added dessert caused the meal cost to be $4,810 ($25,110 – $20,300) over budget. He added, “I could expect a couple hundred dollars one way or the other, but several thousand is totally unacceptable. At the next budget meeting of the budget committee, I want you to explain what happened.”
Use Microsoft Excel—showing all work and formulas—to complete the following:
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: