Answered step by step
Verified Expert Solution
Question
1 Approved Answer
i am confised on how to use this excel sheet to answer these questions. can somoene please help me! Click on the link below to
i am confised on how to use this excel sheet to answer these questions. can somoene please help me!
Click on the link below to access the dataset Scorecard.xlsx and complete the following scorecard to assess performance on the following objectives Excel Doto File Instructions: In the "Target" column, enter your responses rounded to the nearest whole number. In the "Result column, enter your responses rounded to two decimal places. a Average regional revenue is at least $200oo. b. Average regional growth is at least 5% c. Returns are no more than $10,000 in any store Target Goals Measure Result 5 $ $ Revenues Average Revenue Region North South East North South East North South East Performance Too LOW Good Good Too Low Too LOW Almost Too High Too High Too High Growth Average Growth X $ 5 $ $ Maximum Store Return V Returns 1 07 fx F. G H 3 A B D E 1 Store Number Region Sales Growth (%) Returns 2 1 South $224,932.00 -3 $3,757.00 3 2 South $308,051.00 2 $8,325.00 4 3 South $70,078.00 0 $8,668.00 5 4 East $175,864.00 9 $7,092.00 6 5 South $336,880.00 12 $4,362.00 7 6 North $57,339.00 -2 $9,914.00 8 7 North $229,771.00 1 $8,820.00 9 8 East $298,814.00 1 $4,342.00 10 9 South $278,059.00 11 $7,848.00 11 10 North $98,152.00 5 $9,501.00 12 11 North $164,833.00 9 $6,803.00 13 12 North $285,545.00 3 $4,125.00 14 13 South $331,959.00 -1 $7,250.00 15 14 South $52,642.00 9 $4,903.00 16 15 South $165,407.00 -5 $7,173.00 17 16 South $222,417.00 2 $8,636.00 18 17 North $239,172.00 10 $4,753.00 19 18 South $142,577.00 -5 $3,921.00 20 19 East $76,590.00 12 $7,529.00 21 20 North $272,873.00 0 $7,083.00 22 21 South $147,960.00 -4 $5,839.00 23 22 East $165,807.00 -5 $5,951.00 24 23 North $311,001.00 3 $5,171.00 25 24 South $320,939.00 12 $10,280.00 fx A D F B C 25 East $187,265.00 26 South $240,216.00 27 South $286,710.00 28 South $139,639.00 29 North $68,394.00 30 North $231,428.00 31 South $248,463.00 32 North $181,316.00 33 North $282,616.00 34 East $93,956.00 35 North $211,761.00 36 East $109,352.00 37 North $76,900.00 38 East $134,476.00 39 East $290,245.00 40 North $106,645.00 41 East $125,789.00 42 South $172,708.00 43 North $280,949.00 44 South $315,622.00 45 East $259,648.00 46 East $182,637.00 47 East $118,823.00 48 East $218,857.00 49 South $304,810.00 E 10 $7,893.00 7 $8,644.00 11 $5,938.00 6 $8,348.00 -4 $7,251.00 -3 $5,432.00 -3 $7,959.00 6 $8,894.00 0 $7,205.00 -4 $7,696.00 4 $9,545.00 12 $4,301.00 9 $5,064.00 7 $5,684.00 11 $6,193.00 9 $10,151.00 5 $4,584.00 3 $6,378.00 2 $9,842.00 -5 $7,700.00 12 $8,799.00 0 $7,273.00 3 $9,007.00 1 $6,849.00 6 $3,852.00 A = Sheet1 Sheet2 Sheet3 E F 50 North $309,283.00 51 East $229,711.00 52 East $93,407.00 53 South $310,806.00 54 East $224,420.00 55 North $172,399.00 56 East $124,527.00 57 South $240,212.00 58 South $223,878.00 59 North $293,265.00 60 East $165,505.00 61 South $51,958.00 62 North $210,317.00 63 South $253,544.00 64 East $170,748.00 65 North $89,434.00 66 East $75,483.00 67 East $182,215.00 68 East $263,720.00 69 East $344,644.00 70 South $284,519.00 71 North $90,852.00 72 North $274,215.00 73 East $340,647.00 74 East $222,483.00 12 $10,111.00 9 $10,078.00 -4 $6,955.00 12 $4,024.00 -3 $7,833.00 6 $8,228.00 6 $6,529.00 8 $8,564.00 0 $3,809.00 -5 $8,890.00 3 $6,683.00 6 $9,747.00 11 $7,646.00 11 $7,196.00 7 $7,872.00 -5 $5,427.00 -5 $3,041.00 8 $3,772.00 12 $3,926.00 2 $9,034.00 -1 $7,824.00 3 $4,004.00 1 $7,943.00 -4 $10,219.00 $4,455.00 4 Sheet1 75 North $272,828.00 76 North $121,115.00 77 East $152,018.00 78 East $249,129.00 79 East $89,240.00 80 North $327,019.00 81 East $344,971.00 82 North $187,259.00 83 East $118,366.00 84 North $76,866.00 85 East $103,683.00 86 North $68,173.00 87 South $308,786.00 88 East $231,155.00 89 South $283,748.00 90 East $248,602.00 91 North $63,091.00 92 East $319,383.00 93 East $201,560.00 94 East $159,479.00 95 North $204,682.00 96 North $118,708.00 97 North $252,290.00 98 East $309,510.00 99 North $195.771.00 7 $4,968.00 6 $3,229.00 10 $10,062.00 7 $8,603.00 9 $3,006.00 3 $8,356.00 11 $3,621.00 10 $9,154.00 3 $7,480.00 .10 $5,861.00 -3 $4,223.00 -4 $8,979.00 -1 $5,317.00 8 $4,559.00 -4 $6,580.00 5 $7,465.00 5 $10,202.00 0 $9,166.00 5 $3,025.00 12 $7,906.00 10 $5,616.00 -1 $4,763.00 10 $3,527.00 8 $7,385.00 -2 $10 1490 F 100 East $171,946.00 101 South $155,106.00 102 North $212,681.00 103 South $109,379.00 104 South $292,708.00 105 South $320,096.00 106 North $163,986.00 107 East $129,010.00 108 East $308,744.00 109 South $161,296.00 110 East $139,339.00 111 East $69,049.00 112 East $225,099.00 113 South $160,737.00 114 North $161,184.00 115 South $229,670.00 116 East $211,959.00 117 South $194,394.00 118 South $211,634.00 119 North $163,451.00 120 North $196,537.00 121 East $254,160.00 122 South $60,708.00 123 East $85,638.00 124 North $245,417.00 6 $6,097.00 1 $4,323.00 -3 $3,033.00 6 $10,017.00 6 $8,051.00 8 $8,465.00 8 $5,055.00 -2 $3,114.00 9 $6,085.00 7 $5,270.00 11 $9,523.00 2 $10,297.00 1 $3,516.00 6 $3,114.00 3 $3,929.00 -2 $7,687.00 2 $6,506.00 7 $9,379.00 10 $6,607.00 0 $8,206.00 11 $5,847.00 0 $8,618.00 -3 $7,034.00 12 $6,982.00 -4 $6,640.00 D E F 125 North $240,514.00 126 East $295,957.00 127 North $55,068.00 128 East $340,932.00 129 North $173,133.00 130 South $83,583.00 131 South $220,624.00 132 East $140,161.00 133 South $335,039.00 134 South $155,330.00 135 North $135,999.00 136 East $231,124.00 137 South $129,791.00 138 East $263,402.00 139 South $214,374.00 140 East $345,111.00 141 East $140,226.00 142 South $162,806.00 143 East $216,724.00 144 North $211,461.00 145 North $86,195.00 146 North $152,466.00 147 South $152,837.00 148 East $312,706.00 149 East $124,461.00 0 $5,772.00 6 $7,902.00 0 $4,166.00 8 $4,096.00 4 $8,611.00 9 $5,820.00 6 $8,891.00 2 $7,519.00 4 $7,380.00 -5 $10,261.00 6 $7,523.00 9 $6,390.00 1 $7,485.00 4 $10,162.00 10 $9,465.00 -4 $8,993.00 8 $10,078.00 7 $7,000.00 0 $7,865.00 6 $6,716.00 -2 $6,480.00 6 $6,063.00 7 $5,134.00 9 $4,301.00 0 $9,683.00 F H 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 150 North $315,152.00 151 South $182,210.00 152 South $53,333.00 153 North $108,031.00 154 South $259,671.00 155 North $199,005.00 156 South $89,336.00 157 North $328,914.00 158 South $139,882.00 159 North $69,658.00 160 East $303,698.00 161 East $230,527.00 162 East $176,697.00 163 East $344,782.00 164 North $116,783.00 165 South $212,228.00 166 East $338,048.00 167 South $163,441,00 168 South $133,798.00 169 South $216,181.00 170 South $322,402.00 171 South $90,143.00 172 South $204,256.00 173 North $203,548.00 174 East $242,438.00 1 $6,635.00 0 $3,021.00 10 $5,726.00 9 $4,415.00 1 $6,417.00 6 $5,216.00 2 $6,255.00 7 $9,699.00 6 $5,738.00 .3 $6,393.00 11 $5,854.00 6 $8,453.00 7 $5,512.00 4 $3,657.00 9 $5,230.00 4 $7,064.00 -2 $3,399.00 $7,600.00 12 $9,473.00 0 $8,221.00 9 $9,846.00 - 1 $6,014.00 -1 $7,554.00 10 $5,037.00 -4 $7,872.00 11 174 175 = Sheet1 Sheet2 Sheet3 A 00 B C D E F G H LON -6 7 -8 -9 0 1 2. 3 4 5 -6 +7 8 29 30 31 165 South $212,228.00 166 East $338,048.00 167 South $163,441.00 168 South $133,798.00 169 South $216,181.00 170 South $322,402.00 171 South $90,143.00 172 South $204,256.00 173 North $203,548.00 174 East $242,438.00 175 East $73,838.00 176 South $188,369.00 177 North $149,795.00 4 $7,064.00 -2 $3,399.00 11 $7,600.00 12 $9,473.00 0 $8,221.00 9 $9,846.00 -1 $6,014.00 -1 $7,554.00 10 $5,037.00 -4 $7,872.00 10 $8,369.00 -2 $8,960.00 -1 $6,632.00 un Click on the link below to access the dataset Scorecard.xlsx and complete the following scorecard to assess performance on the following objectives Excel Doto File Instructions: In the "Target" column, enter your responses rounded to the nearest whole number. In the "Result column, enter your responses rounded to two decimal places. a Average regional revenue is at least $200oo. b. Average regional growth is at least 5% c. Returns are no more than $10,000 in any store Target Goals Measure Result 5 $ $ Revenues Average Revenue Region North South East North South East North South East Performance Too LOW Good Good Too Low Too LOW Almost Too High Too High Too High Growth Average Growth X $ 5 $ $ Maximum Store Return V Returns 1 07 fx F. G H 3 A B D E 1 Store Number Region Sales Growth (%) Returns 2 1 South $224,932.00 -3 $3,757.00 3 2 South $308,051.00 2 $8,325.00 4 3 South $70,078.00 0 $8,668.00 5 4 East $175,864.00 9 $7,092.00 6 5 South $336,880.00 12 $4,362.00 7 6 North $57,339.00 -2 $9,914.00 8 7 North $229,771.00 1 $8,820.00 9 8 East $298,814.00 1 $4,342.00 10 9 South $278,059.00 11 $7,848.00 11 10 North $98,152.00 5 $9,501.00 12 11 North $164,833.00 9 $6,803.00 13 12 North $285,545.00 3 $4,125.00 14 13 South $331,959.00 -1 $7,250.00 15 14 South $52,642.00 9 $4,903.00 16 15 South $165,407.00 -5 $7,173.00 17 16 South $222,417.00 2 $8,636.00 18 17 North $239,172.00 10 $4,753.00 19 18 South $142,577.00 -5 $3,921.00 20 19 East $76,590.00 12 $7,529.00 21 20 North $272,873.00 0 $7,083.00 22 21 South $147,960.00 -4 $5,839.00 23 22 East $165,807.00 -5 $5,951.00 24 23 North $311,001.00 3 $5,171.00 25 24 South $320,939.00 12 $10,280.00 fx A D F B C 25 East $187,265.00 26 South $240,216.00 27 South $286,710.00 28 South $139,639.00 29 North $68,394.00 30 North $231,428.00 31 South $248,463.00 32 North $181,316.00 33 North $282,616.00 34 East $93,956.00 35 North $211,761.00 36 East $109,352.00 37 North $76,900.00 38 East $134,476.00 39 East $290,245.00 40 North $106,645.00 41 East $125,789.00 42 South $172,708.00 43 North $280,949.00 44 South $315,622.00 45 East $259,648.00 46 East $182,637.00 47 East $118,823.00 48 East $218,857.00 49 South $304,810.00 E 10 $7,893.00 7 $8,644.00 11 $5,938.00 6 $8,348.00 -4 $7,251.00 -3 $5,432.00 -3 $7,959.00 6 $8,894.00 0 $7,205.00 -4 $7,696.00 4 $9,545.00 12 $4,301.00 9 $5,064.00 7 $5,684.00 11 $6,193.00 9 $10,151.00 5 $4,584.00 3 $6,378.00 2 $9,842.00 -5 $7,700.00 12 $8,799.00 0 $7,273.00 3 $9,007.00 1 $6,849.00 6 $3,852.00 A = Sheet1 Sheet2 Sheet3 E F 50 North $309,283.00 51 East $229,711.00 52 East $93,407.00 53 South $310,806.00 54 East $224,420.00 55 North $172,399.00 56 East $124,527.00 57 South $240,212.00 58 South $223,878.00 59 North $293,265.00 60 East $165,505.00 61 South $51,958.00 62 North $210,317.00 63 South $253,544.00 64 East $170,748.00 65 North $89,434.00 66 East $75,483.00 67 East $182,215.00 68 East $263,720.00 69 East $344,644.00 70 South $284,519.00 71 North $90,852.00 72 North $274,215.00 73 East $340,647.00 74 East $222,483.00 12 $10,111.00 9 $10,078.00 -4 $6,955.00 12 $4,024.00 -3 $7,833.00 6 $8,228.00 6 $6,529.00 8 $8,564.00 0 $3,809.00 -5 $8,890.00 3 $6,683.00 6 $9,747.00 11 $7,646.00 11 $7,196.00 7 $7,872.00 -5 $5,427.00 -5 $3,041.00 8 $3,772.00 12 $3,926.00 2 $9,034.00 -1 $7,824.00 3 $4,004.00 1 $7,943.00 -4 $10,219.00 $4,455.00 4 Sheet1 75 North $272,828.00 76 North $121,115.00 77 East $152,018.00 78 East $249,129.00 79 East $89,240.00 80 North $327,019.00 81 East $344,971.00 82 North $187,259.00 83 East $118,366.00 84 North $76,866.00 85 East $103,683.00 86 North $68,173.00 87 South $308,786.00 88 East $231,155.00 89 South $283,748.00 90 East $248,602.00 91 North $63,091.00 92 East $319,383.00 93 East $201,560.00 94 East $159,479.00 95 North $204,682.00 96 North $118,708.00 97 North $252,290.00 98 East $309,510.00 99 North $195.771.00 7 $4,968.00 6 $3,229.00 10 $10,062.00 7 $8,603.00 9 $3,006.00 3 $8,356.00 11 $3,621.00 10 $9,154.00 3 $7,480.00 .10 $5,861.00 -3 $4,223.00 -4 $8,979.00 -1 $5,317.00 8 $4,559.00 -4 $6,580.00 5 $7,465.00 5 $10,202.00 0 $9,166.00 5 $3,025.00 12 $7,906.00 10 $5,616.00 -1 $4,763.00 10 $3,527.00 8 $7,385.00 -2 $10 1490 F 100 East $171,946.00 101 South $155,106.00 102 North $212,681.00 103 South $109,379.00 104 South $292,708.00 105 South $320,096.00 106 North $163,986.00 107 East $129,010.00 108 East $308,744.00 109 South $161,296.00 110 East $139,339.00 111 East $69,049.00 112 East $225,099.00 113 South $160,737.00 114 North $161,184.00 115 South $229,670.00 116 East $211,959.00 117 South $194,394.00 118 South $211,634.00 119 North $163,451.00 120 North $196,537.00 121 East $254,160.00 122 South $60,708.00 123 East $85,638.00 124 North $245,417.00 6 $6,097.00 1 $4,323.00 -3 $3,033.00 6 $10,017.00 6 $8,051.00 8 $8,465.00 8 $5,055.00 -2 $3,114.00 9 $6,085.00 7 $5,270.00 11 $9,523.00 2 $10,297.00 1 $3,516.00 6 $3,114.00 3 $3,929.00 -2 $7,687.00 2 $6,506.00 7 $9,379.00 10 $6,607.00 0 $8,206.00 11 $5,847.00 0 $8,618.00 -3 $7,034.00 12 $6,982.00 -4 $6,640.00 D E F 125 North $240,514.00 126 East $295,957.00 127 North $55,068.00 128 East $340,932.00 129 North $173,133.00 130 South $83,583.00 131 South $220,624.00 132 East $140,161.00 133 South $335,039.00 134 South $155,330.00 135 North $135,999.00 136 East $231,124.00 137 South $129,791.00 138 East $263,402.00 139 South $214,374.00 140 East $345,111.00 141 East $140,226.00 142 South $162,806.00 143 East $216,724.00 144 North $211,461.00 145 North $86,195.00 146 North $152,466.00 147 South $152,837.00 148 East $312,706.00 149 East $124,461.00 0 $5,772.00 6 $7,902.00 0 $4,166.00 8 $4,096.00 4 $8,611.00 9 $5,820.00 6 $8,891.00 2 $7,519.00 4 $7,380.00 -5 $10,261.00 6 $7,523.00 9 $6,390.00 1 $7,485.00 4 $10,162.00 10 $9,465.00 -4 $8,993.00 8 $10,078.00 7 $7,000.00 0 $7,865.00 6 $6,716.00 -2 $6,480.00 6 $6,063.00 7 $5,134.00 9 $4,301.00 0 $9,683.00 F H 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 150 North $315,152.00 151 South $182,210.00 152 South $53,333.00 153 North $108,031.00 154 South $259,671.00 155 North $199,005.00 156 South $89,336.00 157 North $328,914.00 158 South $139,882.00 159 North $69,658.00 160 East $303,698.00 161 East $230,527.00 162 East $176,697.00 163 East $344,782.00 164 North $116,783.00 165 South $212,228.00 166 East $338,048.00 167 South $163,441,00 168 South $133,798.00 169 South $216,181.00 170 South $322,402.00 171 South $90,143.00 172 South $204,256.00 173 North $203,548.00 174 East $242,438.00 1 $6,635.00 0 $3,021.00 10 $5,726.00 9 $4,415.00 1 $6,417.00 6 $5,216.00 2 $6,255.00 7 $9,699.00 6 $5,738.00 .3 $6,393.00 11 $5,854.00 6 $8,453.00 7 $5,512.00 4 $3,657.00 9 $5,230.00 4 $7,064.00 -2 $3,399.00 $7,600.00 12 $9,473.00 0 $8,221.00 9 $9,846.00 - 1 $6,014.00 -1 $7,554.00 10 $5,037.00 -4 $7,872.00 11 174 175 = Sheet1 Sheet2 Sheet3 A 00 B C D E F G H LON -6 7 -8 -9 0 1 2. 3 4 5 -6 +7 8 29 30 31 165 South $212,228.00 166 East $338,048.00 167 South $163,441.00 168 South $133,798.00 169 South $216,181.00 170 South $322,402.00 171 South $90,143.00 172 South $204,256.00 173 North $203,548.00 174 East $242,438.00 175 East $73,838.00 176 South $188,369.00 177 North $149,795.00 4 $7,064.00 -2 $3,399.00 11 $7,600.00 12 $9,473.00 0 $8,221.00 9 $9,846.00 -1 $6,014.00 -1 $7,554.00 10 $5,037.00 -4 $7,872.00 10 $8,369.00 -2 $8,960.00 -1 $6,632.00 un Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started