Question

In: Accounting

Balanced Scorecard Preparation The following information is presented for the Worldwide Auditor's Association. For the year...

Balanced Scorecard Preparation
The following information is presented for the Worldwide Auditor's Association. For the year ended November 30, 2017, the organization had set a membership goal of 100,000 members with the following anticipated results (and actual results for the year-end).

Worldwide Auditors' Association
Revenues and Expenses
For Year Ending November 30, 2017

($ in thousands)

Planned Actual
Revenues $55,859.6 $55,054.0
Expenses
Salaries 27,900.0 29,000.0
Other personnel costs 6,975.0 6,786.0
Occupancy costs 3,859.6 5,650.0
Reimbursement to local units 1,480.0 1,600.0
Other membership services 1,050.0 1,000.0
Printing and paper 525.0 640.0
Postage and shipping 220.0 242.0
General and administrative 1,090.0 1,076.0
Excess of revenues over expenses $12,760.0 $ 9,060.0

Additional information (PLANNED):

• Membership dues were increased from $360 to $400 at the beginning of the year.
• One-year subscriptions to Worldwide Auditor were anticipated to be 2,400 units.
• Advertising revenue was budgeted at $320,000. Each magazine was budgeted at a cost of $36.
• A total of 29,000 technical reports were anticipated at an average price of $80 with average costs of $22.
• The budgeted one-day courses had an anticipated attendance of 33,000 with an average fee of $450. The two-day courses had an anticipated attendance of 3,000 with an average fee of $770 per person.
• The organization began the year with net capital assets of $88,000,000 with a planned cost of capital of 9 percent.

Additional 2017 information (ACTUAL):

• Membership dues are $400 per year, of which $100 is considered to cover a one-year subscription to the association’s journal. Other benefits include membership in the association and unit affiliation.
• One-year subscriptions to Worldwide Auditor are sold to nonmembers for $160 each. A total of 2,500 of these subscriptions were sold. In addition to subscriptions, the journal generated $400,000 in advertising revenue. The cost per magazine was $40.
• A total of 30,000 technical reports were sold by the Books and Reports Department at an average unit selling price of $90. Average costs per publication were $24.
• The association offers a variety of continuing education courses to both members and nonmembers. During 2017, the one-day course, which cost participants an average of $500 each, was attended by 31,300 people. A total of 1,985 people took two-day courses at a cost of $800 per person.
• General and administrative expenses include all other costs incurred by the corporate staff to operate the association.
• The organization has net capital assets of $90,060,000 and had an actual cost of capital of 9 percent.

Required
a. Prepare a balanced scorecard for IAA for November 2017 with calculated key performance indicators presented in two columns for planned performance and actual performance--include key financial, customer, and operating performance indicators.

Include all zeros with figures. For example, 2017 Planned Total Revenues for $55,859.6 (thousand) is entered as $55,859,600

2017 Planned 2017 Actual
*Compute as a ratio. Round three decimal places.
Financial information
Total revenues Answer Answer
Total costs Answer Answer
Journal advertising Answer Answer
ROI (round to three decimal places) Answer Answer
Residual income
Income Answer Answer
Minimum return Answer Answer
Residual income Answer Answer
Customer information
Course attendance Answer Answer
Technical reports sold Answer Answer
Operating criteria
Average cost per special publication Answer Answer
Average cost per magazine Answer Answer
Other personnel costs vs. salaries* Answer Answer

b. Which of the evaluation areas you selected indicated success and which indicated failure?

Success areas:

1. AnswerMore reports were soldROI increased significantlyTotal revenues increased while total costs decreased
2. AnswerOther personnel costs were less in relation to salariesPublication costs went downResidual income increased significantly
3. AnswerAdvertising revenue went upMore people took coursesTotal revenues increased while total costs decreased


Failure areas:

1. AnswerAdvertising revenue went downLess reports were soldTotal revenues decreased while total costs increased
2. AnswerLess reports were soldOther personnel costs were more in relation to salariesROI decreased significantly
3. AnswerAdvertising revenue went downOther personnel costs were more in relation to salariesResidual income decreased significantly

Solutions

Expert Solution

\


Related Solutions

The following information is presented for the Worldwide Auditor's Association. For the year ended November 30,...
The following information is presented for the Worldwide Auditor's Association. For the year ended November 30, 2017, the organization had set a membership goal of 100,000 members with the following anticipated results (and actual results for the year-end). Worldwide Auditors' Association Revenues and Expenses For Year Ending November 30, 2017 ($ in thousands) Planned Actual Revenues $55,859.6 $55,054.0 Expenses Salaries 27,900.0 29,000.0 Other personnel costs 6,975.0 6,786.0 Occupancy costs 3,859.6 5,650.0 Reimbursement to local units 1,480.0 1,600.0 Other membership services...
Balanced scorecard measures for financial perspective Following is financial information for last period about China Express,...
Balanced scorecard measures for financial perspective Following is financial information for last period about China Express, a regional company with a number of fast-food stores: Revenue from operations $ 10,540,200 Operating costs 9,920,480 After-tax profits 455,078 Cost of capital 13 % Required rate of return 17 % Average assets $ 4,522,050 Required Calculate the following measures that could be used for the financial perspective. (If answer is negative, please use parenthesis. Show economic value added as a positive number.) Operating...
On a balanced scorecard, each of the following is an example of the customer perspective measure...
On a balanced scorecard, each of the following is an example of the customer perspective measure except A. Number of customer complaints. B. Time taken to fulfill orders. C. Customer retention. D. Economic value-added.
Prepare a Balanced Scorecard for The Ford Motor Company from the 2016 fiscal year.
Prepare a Balanced Scorecard for The Ford Motor Company from the 2016 fiscal year.
Volkswagen have all used the Balanced Scorecard. You are required to research and find information on...
Volkswagen have all used the Balanced Scorecard. You are required to research and find information on how Volkswagen used this strategic planning tool and the benefits achieved. What was the problem that the company was facing prior to implementation? How did they go about the implementation and use of the Balanced Scorecard? c)
Which of the following is FALSE about the balanced scorecard and its underlying logic? A. The...
Which of the following is FALSE about the balanced scorecard and its underlying logic? A. The balanced scorecard enables top management to translate its strategy into performance measures that employees can understand and influence. B. The balanced scorecard consists of an integrated set of performance measures that are derived from and support a company’s strategy. C. A company’s ability to change and improve determines its ability to have efficient internal business processes. D. A company’s financial results determine the level...
Information about an association between two interval-ratio variables is presented below. The association is between “the...
Information about an association between two interval-ratio variables is presented below. The association is between “the hours of screen time per day” (Y) and “years of schooling” (X). A measure of the overall association is given as well as the specific components of the OLS model. The OLS model estimates the effect of education (X) on the hours of screen time per day (Y). Association Between x and y Estimate r    -0.229 Rsqrd OLS Model components Estimate Constant (a)...
In relation to the Balanced Scorecard, which of the following Key Performance Indicators (KPI) would be...
In relation to the Balanced Scorecard, which of the following Key Performance Indicators (KPI) would be useful in evaluating a company's customer perspective of improving customer satisfaction for long term success?
QUESTION 1 Which of the following statements about the balanced scorecard approach is NOT true? The...
QUESTION 1 Which of the following statements about the balanced scorecard approach is NOT true? The four perspectives of the balanced scorecard revolve around measures of quality, productivity, efficiency and timeliness, and marketing success. The balanced scorecard approach requires looking at performance from four different but related perspectives: financial, customer, internal business, and learning and growth. The balanced scorecard approach integrates financial and non-financial performance measures. the balanced scorecard helps to keep management focused solely on a company's financial factors....
The following measures belong to one of the four perspectives of the balanced scorecard: 1) Return...
The following measures belong to one of the four perspectives of the balanced scorecard: 1) Return on investment 2) Marketing time 3) Number of new customers 4) Percentage of income from new sources 5) Quality costs 6) Employee productivity Required: a. Identify the appropriate perspective for each measure listed above. b. Suggest a possible strategic objective that could be associated with each measure (Be sure to clearly label each article)
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT