Answered step by step
Verified Expert Solution
Link Copied!

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!
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Options Futures And Other Derivatives

Authors: John C. Hull

7th Edition

0136015867, 9780136015864

More Books

Students also viewed these Finance questions

Question

2. Why is resilience sometimes described as ordinary magic?

Answered: 1 week ago

Question

5. What are the other economic side effects of accidents?

Answered: 1 week ago