2. Sensorly Corporation is preparing its balanced Scorecard for the past quarter. The balanced Scorecard contains four perspectives: financial, customer, internal business process, and learning and growth. (Click the icon to view the specific objectives.) 2 (Click the icon to view KPIs and corresponding data.) Requirement Complete the balanced Scorecard report below. (Enter the objectives using the numbers provided in the popup.) Sensorly Corporation Balanced Scorecard Report For Quarter Ended December 31 Goal Perspective: Objective Goal Actual Achieved? Financial: (1) 1 (6) (2) (7) ( (3) (3 (8) (8 (4) (4) (9) (5) (10) Customer: (11) (12) (16) (17) (13) (18) (14) (19) (15) (20) Internal business process: (23) (24) (25) (28) (29) (30) (21) (22) (26) (27) Learning and growth: (31) (32) (36) (37) ) (35) (33) (38) (34) (39) (40) 1: Specific objectives Through its strategic management planning process, Sensorly Corporation has selected two specific objectives for each of the four perspectives. These are listed in the following table. Specific Objective 1. Develop new core products 2. Increase number of customers 3. Increase sales of core product line Increase number of employees with access to customer relationship 4. database 5. Increase profitability of core product line 6. Improve production efficiency 7. Improve employee product knowledge 8. Increase customer retention 2: KPls and corresponding data Sensorly Corporation has collected key performance indicators (KPIs) to measure progress toward achieving its specific objectives. The following table contains the KPIs and corresponding data that Sensorly Corporation has collected for the past quarter. Goal Actual KPI Sales revenue growth-Core product line.. $2,150,000 $2,100,000 Number of customers 125,000 135,000 6.6 7.3 99,000 100,000 2,200 Number of units produced per hour Number of repeat customers... Hours of employee training provided Number of new core products...... Core product line profit as a percentage of core product line sales... Percentage of employees w/ access to customer relationship database 2,350 12 18 17% 15% 77% 85% 3: Requirement Prepare a balanced Scorecard report for Sensorly Corporation. Place each of the specific objectives listed under the appropriate perspective heading in the report. Select a KPI from the list of KPIs that would be appropriate to measure progress toward each objective. (There are two specific objectives for each perspective and one KPI for each of the specific objectives.) In the last column of the balanced Scorecard report, select if the associated KPI goal has been achieved. 04 (1) O 1 O 2 O 3 (2) O O Percentage of employees w/ access to customer relationship database Core product line profit as a percentage of core product line sales Number of new core products Hours of employee training provided Sales revenue growth Core product line Number of customers O Number of repeat customers O Number of units produced per hour (3) O 17% 08 0000 O 12 0 77% O99,000 O $2,150,000 0 6.6 O 135,000 0 2,350 (4) O O 100,000 O 85% % O 7.3 O $2,100,000 2,200 O 125,000 O 15% (5) O O Yes O No 6) (6) O 5 06 07 0000 (7) O O Percentage of employees w/ access to customer relationship database Core product line profit as a percentage of core product line sales O Number of new core products Hours of employee training provided Sales revenue growth-Core product line Number of customers O Number of repeat customers Number of units produced per hour (8) O 17% 04 O 12 O 77% O99,000 O $2,150,000 0 6.6 O 135,000 O 2,350 (9) O O 100,000 O 85% O 7.3 O $2,100,000 2,200 O 125,000 O 15% (10) O O Yes O No (11) O O1 O2 03 (12) O O Percentage of employees w/ access to customer relationship database Core product line profit as a percentage of core product line sales O Number of new core products O Hours of employee training provided Sales revenue growth Core product line Number of customers O Number of repeat customers O Number of units produced per hour 0000 O 17% 08 (13) O O 12 O 77% 99,000 $2,150,000 0 6.6 O 135,000 0 2,350 (14) O O 100,000 85% 07.3 O $2,100,000 2,200 O 125,000 O 15% (15) O O No O Yes (16) O O 5 06 07 (17) O Percentage of employees w/ access to customer relationship database Core product line profit as a percentage of core product line sales O Number of new core products O Hours of employee training provided Sales revenue growth-Core product line Number of customers Number of repeat customers O Number of units produced per hour O 17% 04 (18) O O 12 O 77% 99,000 O $2,150,000 0 6.6 O 135,000 O 2,350 (19) O O 100,000 O 85% 07.3 O $2,100,000 2,200 O 125,000 O 15% (20) O O Yes O No Ooo (21) O 0 1 O2 03 (22) O O Percentage of employees w/ access to customer relationship database Core product line profit as a percentage of core product line sales O Number of new core products O Hours of employee training provided Sales revenue growth Core product line Number of customers O Number of repeat customers O Number of units produced per hour 0 17% % 08 (23) O O 12 O 77% 99,000 O $2,150,000 0 6.6 O 135,000 0 2,350 0000 (24) O O O O 18 O 85% 07.3 O $2,100,000 2,200 O 125,000 O 15% (25) C O No O Yes (26) O 05 06 07 (27) O O Percentage of employees w/ access to customer relationship database Core product line profit as a percentage of core product line sales O Number of new core products O Hours of employee training provided Sales revenue growth - Core product line Number of customers O Number of repeat customers O Number of units produced per hour O 17% ( (29) 04 (28) O O 12 O 77% 99,000 $2,150,000 6.6 135,000 O 2,350 0000 O 100,000 O 85% 07.3 $2,100,000 2,200 O 125,000 O 15% (30) O ( O Yes O No (31) O 01 02 O 3 (32) O Percentage of employees w/ access to customer relationship database Core product line profit as a percentage of core product line sales Number of new core products Hours of employee training provided Sales revenue growth-Core product line Number of customers O Number of repeat customers O Number of units produced per hour O 17% (35) 08 (33) O O 12 O 77% 99,000 O $2,150,000 6.6 O 135,000 O 2,350 (34) O O 100,000 O 85% O 7.3 O $2,100,000 2,200 0 125,000 O 15% O No O O Yes (36) O 05 06 07 (37) O O Number of new core products O Sales revenue growth-Core product line O Number of repeat customers Oood Percentage of employees w/ access to customer relationship database Core product line profit as a percentage of core product line sales Hours of employee training provided Number of customers Number of units produced per hour O 17% (39) (40) (38) O O 77% O $2,150,000 O 135,000 O 12 99,000 O 6.6 O 2,350 O 85% O $2,100,000 O 125,000 O 100,000 O 7.3 0 2,200 O 15% O No O Yes
