yellow sticky number= 80

Create in Microsoft Excel, a template that does the following: Column A - Your Company's Quantity Produced/Total Cost Column B - Competitor/Complement Company's Sales/Total Revenue Column C- Your Company's Overhead Cost Use your yellow sticky number to find the "block" of random numbers, on your random number table. That first block of random numbers will be your Column A, the block right below that, will be your Column B, the block right below that will be your Column C. In Excel, under Formulas, More Functions, Statistical, Correl - do a correlation coefficient for Your Company's Q/TC and Competitor/Complement Company's Sales/TR. Then do another correlation coefficient for Your Company's Q/TC and Your Company's Overhead Cost. State which variable is the most correlated to Your Company's Q/TC. Set up Excel formula that states the average for each column, in the cell right below the last value of each column. Then create, in Excel, a brief Income Statement: Your Budgeted Revenue set up Excel formula so this is 1.5 us "Your Total Cost" (Your Total Cost) set up Excel formula so this is 85 times the average of the most correlated variable Your Net Income B.8 Table of Random Numbers 7507 316 79 3652 LEN 5200 OOMS 17300 56454 ROOMS MO 20 008 83319 1491 25170 5818 2017 10295 99618 85920 45827 MAI 79741 23 37200 74164 01704 700 3468 30533 716 1634 BOMO 14085 736 1977 2100 Sewe T7040 81565 1934 G KA TIC 1370 458 De 780 1941 04742 14813 5760 81300 SOTTO 87208 1057 ASI 2007 1000 32471 53444 91182 61411 50373 11 53800 92500 58710 65251 47797 8822 16620 276 23312 36.306 491 55405 11173 56177 19220 88247 17173 34370 71635 1542 39807 00778 406 0001 55721 4034 223 80731 02406 2113 TSH 28472 89171 ROSOL 90326 pa 68100 42636 42459 07960 05043 38230 88108 $5185 06124 17407 16154 72064 95000 83917 57925 32357 38272 45201 96451 58601 52441 18825 11413 2867 90510 22024 OSMO 77799 LETO 4807 we 31864 51574 35350 20821 25160 67170 22812 1960 72170 BOE92 7013 36502 87226 32722 43319 3.2925 01172 33304 557 85689 82124 46045 57975 146.2 76530 82634 4.991 03945 05148 27909 35681 54905 05467 43500 B0006 65796 50113 21777 89136 35542 72015 21119 51141 35599 61056 81666 72949 34138 75666 89205 2008 21566 21564 94645 SE570 201310 396 77002 21544 27500 212580 97857 47784 25648 15656 24545 1183) 40090 3370 37738 06435 1040 97902 28007 24849 52754 06.720 73550 78187 82632 83736 16516 27495 06112 59956 06016 49644 34530 08160 24709 94397 $260 70122 AS STBOS 1121 06978 12529 34870 31702 15290 30782 03040 96196 7.000 48156 20224 70172 10160 81054 16220 53752 73444 41666 03701 40350 0840 38780 51995 26598 28723 24362 53620 05711 70013 15354 83716 30780 00790 63794 57171 80413 24371 33437 60300 86867 97016 74639 68519 23250 en 5316 2077 21727 1202 80561 0812 2880 8452 26703 28720 89286 51887 412 09333 80161 86883 16175 57479 12514 83371 36797 81511 93325 45 53720 21615 380 13160 6383 76.362 93015 7805A 62727 81877 4032 58820 18172 46616 52150 31232 11131 9130 84193 44889 20205 D4200 108 770 1204 5746 70339 19197 61782 12219 90900 22440 67877 86294 65766 34937 12000 19207 68786 88150 97054 5374 54194 2074 15181 82845 52498 57179 9364 69803 97720 0708 86077 62865 20255 83746 42100 25172 13124 24955 8607277722 37700 44902 95020 93050 83532 31062 60875 OM 9118 PCOS 72829 20090 som 25860 49455 47641 4094 29190 24211 2000 $200 92786 52560 80754 762 85666 20451 2017 17025 11172 22571 01549 41218 55049 79548 9787 73898 72226 38000 12000 BOOK 40000 751 06015 47535 617 49700 97310 00112 94416 OSA 46611 22651 34481 73530 17195 70657 60446 20470 34417 26674 16320 $5800 44163 25650 13829 07283 07235 WERS 17012 0611 R2122 65400 77100 62092 1028 1072 64230 0040 60 11004 33282 05481 2009 120 90410 87827 40404 2578 51487 07857 13345 1403 42510 51696 ROLA 70803 04501 77253 MES 01400 7866 Create in Microsoft Excel, a template that does the following: Column A - Your Company's Quantity Produced/Total Cost Column B - Competitor/Complement Company's Sales/Total Revenue Column C- Your Company's Overhead Cost Use your yellow sticky number to find the "block" of random numbers, on your random number table. That first block of random numbers will be your Column A, the block right below that, will be your Column B, the block right below that will be your Column C. In Excel, under Formulas, More Functions, Statistical, Correl - do a correlation coefficient for Your Company's Q/TC and Competitor/Complement Company's Sales/TR. Then do another correlation coefficient for Your Company's Q/TC and Your Company's Overhead Cost. State which variable is the most correlated to Your Company's Q/TC. Set up Excel formula that states the average for each column, in the cell right below the last value of each column. Then create, in Excel, a brief Income Statement: Your Budgeted Revenue set up Excel formula so this is 1.5 us "Your Total Cost" (Your Total Cost) set up Excel formula so this is 85 times the average of the most correlated variable Your Net Income B.8 Table of Random Numbers 7507 316 79 3652 LEN 5200 OOMS 17300 56454 ROOMS MO 20 008 83319 1491 25170 5818 2017 10295 99618 85920 45827 MAI 79741 23 37200 74164 01704 700 3468 30533 716 1634 BOMO 14085 736 1977 2100 Sewe T7040 81565 1934 G KA TIC 1370 458 De 780 1941 04742 14813 5760 81300 SOTTO 87208 1057 ASI 2007 1000 32471 53444 91182 61411 50373 11 53800 92500 58710 65251 47797 8822 16620 276 23312 36.306 491 55405 11173 56177 19220 88247 17173 34370 71635 1542 39807 00778 406 0001 55721 4034 223 80731 02406 2113 TSH 28472 89171 ROSOL 90326 pa 68100 42636 42459 07960 05043 38230 88108 $5185 06124 17407 16154 72064 95000 83917 57925 32357 38272 45201 96451 58601 52441 18825 11413 2867 90510 22024 OSMO 77799 LETO 4807 we 31864 51574 35350 20821 25160 67170 22812 1960 72170 BOE92 7013 36502 87226 32722 43319 3.2925 01172 33304 557 85689 82124 46045 57975 146.2 76530 82634 4.991 03945 05148 27909 35681 54905 05467 43500 B0006 65796 50113 21777 89136 35542 72015 21119 51141 35599 61056 81666 72949 34138 75666 89205 2008 21566 21564 94645 SE570 201310 396 77002 21544 27500 212580 97857 47784 25648 15656 24545 1183) 40090 3370 37738 06435 1040 97902 28007 24849 52754 06.720 73550 78187 82632 83736 16516 27495 06112 59956 06016 49644 34530 08160 24709 94397 $260 70122 AS STBOS 1121 06978 12529 34870 31702 15290 30782 03040 96196 7.000 48156 20224 70172 10160 81054 16220 53752 73444 41666 03701 40350 0840 38780 51995 26598 28723 24362 53620 05711 70013 15354 83716 30780 00790 63794 57171 80413 24371 33437 60300 86867 97016 74639 68519 23250 en 5316 2077 21727 1202 80561 0812 2880 8452 26703 28720 89286 51887 412 09333 80161 86883 16175 57479 12514 83371 36797 81511 93325 45 53720 21615 380 13160 6383 76.362 93015 7805A 62727 81877 4032 58820 18172 46616 52150 31232 11131 9130 84193 44889 20205 D4200 108 770 1204 5746 70339 19197 61782 12219 90900 22440 67877 86294 65766 34937 12000 19207 68786 88150 97054 5374 54194 2074 15181 82845 52498 57179 9364 69803 97720 0708 86077 62865 20255 83746 42100 25172 13124 24955 8607277722 37700 44902 95020 93050 83532 31062 60875 OM 9118 PCOS 72829 20090 som 25860 49455 47641 4094 29190 24211 2000 $200 92786 52560 80754 762 85666 20451 2017 17025 11172 22571 01549 41218 55049 79548 9787 73898 72226 38000 12000 BOOK 40000 751 06015 47535 617 49700 97310 00112 94416 OSA 46611 22651 34481 73530 17195 70657 60446 20470 34417 26674 16320 $5800 44163 25650 13829 07283 07235 WERS 17012 0611 R2122 65400 77100 62092 1028 1072 64230 0040 60 11004 33282 05481 2009 120 90410 87827 40404 2578 51487 07857 13345 1403 42510 51696 ROLA 70803 04501 77253 MES 01400 7866