Analyze the validity of four scorecard measures of the bsc

Assignment Help Financial Accounting
Reference no: EM13876040

Validating the Balanced Scorecard Bernard Daisy Inc. is a chain of home supply and gardening product stores. In 2010, Daisy adopted the balanced scorecard (BSC) for evaluation of store and store manager performance. The BSC has helped Daisy to identify the critical success factors for sales and profitability. In particular, it has helped Daisy better understand its competitive environ- ment and the drivers of success in that environment. On the advice of its chief financial officer, Daisy's board has requested the company president to conduct a study to validate the balanced scorecard. The objective of the study is to make sure that the scorecard measures being used are in fact the key measures associated with success. The following data has been obtained for the most recent quarter's results for each of the company's 30 stores, listed in order of when the store was opened (most recent is store 30). There are five district managers, each of which is responsible for six of the stores. In this study a store manager's success is measured by increase in sales of each store for the current quarter over the same quarter last year. The data below include the percentage change in sales and four of the measures included in the customer perspective of the company's BSC. The scorecard measures include:

1. A survey of customers; this measure is taken from a survey form that is handed to customers on a random basis as they leave the store. The customers rate the store's performance on a scale of 0 to 100, where 100 is the highest score.

2. Each district manager evaluates each store once a quarter, using also a scale from 0 to 100, where 100 is the highest score.

3. The district managers have a staff that on a random basis measures the wait time in the check-out line for customers in each store. The figures shown here are the average wait times, in seconds, for the samples taken in the most recent quarter.

4. Average number of store employees who have had one or more of the company's in-house train- ing courses in the past quarter, as a proportion of total employees at the store.

Required: Use regression and correlation analysis in Excel to analyze the validity of the four scorecard measures in the customer perspective of the BSC; here validity means that the BSC measure contributes to an increase in sales over the prior quarter. What conclusions can you draw from your analysis?

Store Number

Sales

Survey

Manager Review

Average Wait Time

Employee Training

1

-18.1%

65

33

95

56

2

-13.3%

54

54

92

30

3

0.5%

72

86

81

45

4

-9.8%

50

94

89

60

5

-4.5%

53

40

85

75

6

0.0%

57

86

81

50

7

7.5%

61

80

75

45

8

15.5%

67

74

69

88

9

20.6%

70

70

80

90

10

31.5%

79

61

71

60

11

35.0%

81

88

68

30

12

12.5%

64

76

80

18

13

-2.6%

54

38

83

33

14

3.5%

59

27

78

48

15

20.6%

71

70

65

63

16

7.8%

62

80

75

78

17

14.5%

66

43

69

93

18

20.0%

71

70

65

55

19

29.4%

77

63

58

39

20

39.4%

84

55

50

67

21

45.7%

88

49

59

34

22

59.4%

84

87

49

78

23

63.8%

89

56

45

48

24

35.6%

81

58

62

36

25

5.2%

60

82

77

51

26

11.8%

64

77

72

66

27

30.7%

77

62

57

81

28

7.8%

77

73

68

96

29

15.1%

73

67

62

57

30

24.8%

77

62

57

36

Reference no: EM13876040

Questions Cloud

Determining the constant angular velocity : Bar BDE is attached to two links AB and CD. Knowing that at the instant shown link AB rotates with a constant angular velocity of 3 rad/s clockwise, determine the acceleration
What are your sales objectives : What are your sales objectives? What extra information would be useful?
Provide diagnostic impressions based upon the dsm-5 : List in order of importance the key issues you believe are involved in the case study, as if you were the client's counselor. Provide a rationale for the order in which you prioritized issues. What are the most important features to you, and why?
Firms attempt to internationalize : As firms attempt to internationalize,  they may be tempted to locate their facilities where business regulation laws are lax.Discuss the advantages and potential risks of such an  approach, using specific examples to support  your response Please li..
Analyze the validity of four scorecard measures of the bsc : Analyze the validity of the four scorecard measures in the customer perspective of the BSC; here validity means that the BSC measure contributes to an increase in sales over the prior quarter. What conclusions can you draw from your analysis?
Describing the steps the program will perform : An algorithm in pseudocode describing the steps the program will perform. This pseudocode algorithm would consist of a list of steps explaining the sequence of tasks the program will follow to complete the task
Problem regarding the constant deceleration : Automobiles A and B are traveling in adjacent highway lanes and at t = 0 have the positions and speeds shown. Knowing that automobile A has a constant acceleration of 0.6 m/s2 and that B has a constant deceleration of 0.4 m/s2, determine
Identify someone who exemplifies servant leader traits : In three pages, please identify someone who exemplifies servant leader traits. (an example is Harriet Tubman). Please use three resources.
Develop the erd for given problem : An art museum owns a large volume of works of art. Each work of art is described by an item code (identifier), title, type, and size; size is further composed of height, width, and weight.

Reviews

Write a Review

Financial Accounting Questions & Answers

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd