WMBA 6050 Week 2 Assignment

Using Accounting Information for Decision Making — Performance Report and the Balanced Scorecard

For this Assignment, you will continue in your role of a consultant to provide information about using accounting information for decision making to a fictional organization so it can better prepare for the future. Last week, you submitted the first of two reports on financial information and budgeting. This week, you will submit the second report, which will focus on performance reports and balanced scorecards.

In addition to the requirements that follow, be sure to incorporate into your report references to appropriate academic sources, such as those found in this week’s Learning Resources or those in the Walden Library.

To prepare for this Assignment: (Use attached document and Templates)

· Download the Week 2 Part 1 Assignment Template.

· Download the Week 2 Part 2 Assignment Template.

Your Instructor will provide part of the data to complete the calculations for this week’s Assignment. To access that information, refer to Doc Sharing:

For more information about formatting your reference list, please visit the following site: https://academicguides.waldenu.edu/writingcenter/apa/references.]

Submit your completed business report and accompanying Excel file. Your report should be 3–5 pages in length (excluding title page and references) and should address the following:

Analyzing the Performance Report — Preparing a Flexible Budget

For the first part of your report, you will examine a performance report based on the static budget about which the owners are very concerned. They feel that the unfavorable variances that are reflected in the report indicate an area that needs to be addressed, but they are looking to you for a better understanding and concurrence. To access this performance report, refer to the data that your Instructor provided in Doc Sharing for this week’s Assignment.

To complete this part, address the following:

Using the Week 2 Part 2 Assignment Template and the data provided by your Instructor in the Doc Sharing area, prepare a performance report that includes a flexible budget.

Note: In addition to submitting your work in Excel, you will insert your performance report into your main document.

In your report, analyze why the original report was incorrect and explain the conclusion you reached based on the performance report.

Then identify at least three questions regarding the performance report and include a rationale for why you asked each question.

The Balanced Scorecard

One of the owners read recently that the balanced scorecard is a strategic-based performance management system and is wondering if it would be beneficial to implement a balanced scorecard approach. For the second part of your report, you will provide an analysis of how using the balanced scorecard can benefit the company. To complete this part, address the following:

Explain how the balanced scorecard communicates strategy and provide examples.

Examine the four quadrants on the balanced scorecard, how they are related, and what their impact is on financial performance.

Solution – WMBA 6050 Week 2 Assignment

Step 1: Static Budget, Actual Costs, and Variances:

Manufacturing Overhead Costs	Static Budget	Actual	Variance (Actual – Static)	Favorable (F) or Unfavorable (U)
Indirect Labor	$125,500.00	$130,600.00	$5,100.00	U
Supplies	$225,000.00	$239,750.00	$14,750.00	U
Utilities	$119,000.00	$131,500.00	$12,500.00	U
Total	$469,500.00	$501,850.00	$32,350.00	U

The static budget assumes a production level of 50,000 assemblies, but the actual production was 55,000, resulting in unfavorable variances across all overhead cost categories.

Step 2. Calculate the Flexible Budget:

To adjust for the increased production in the flexible budget, costs should be recalculated based on the actual output of 55,000 assemblies.

Indirect Labor: The cost per assembly = $125,500 ÷ 50,000 = $2.51 per assembly. For 55,000 assemblies: $2.51 × 55,000 = $138,050.
Supplies: The cost per assembly