BUSN250-Wk2.xlsx | bartleby

Science and Engineering Jobs Total science and engineering jobs in thousands: 2000 and projected 2010 PROJECTE Occupation 2000 2010 Nominal Scientists 3,241 5,301 "=C6-B6" 2,060 Life scientists 184 218 34 Mathematical/computer scientists 2,408 4,308 1,900 Computer specialists 2,318 4,213 1,895 Mathematical scientists 89 95 6 Physical scientists 239 283 44 Social scientists 410 492 82 Engineers 1,465 1,603 138 All occupations 145,571 167,754 22,183 Fill formulas in to get results

ED INCREASE Percentage 63.56% "=G6/B6" 18.48% 78.90% 81.75% 6.74% 18.41% 20.00% 9.42% 15.24%

ID Store No. Sales Region Item No. Item Description Unit PriceUnits Sold 1 1 South 2005 24" Monitor $229.00 28 2 1 South 2005 24" Monitor $229.00 30 3 1 South 2005 24" Monitor $229.00 9 4 1 South 3006 Wireless Keyboard $19.95 30 5 1 South 3006 Wireless Keyboard $19.95 35 6 1 South 3006 Wireless Keyboard $19.95 39 7 1 South 6050 PC Mouse $8.95 28 8 1 South 6050 PC Mouse $8.95 3 9 1 South 6050 PC Mouse $8.95 38 10 1 South 8500 Laptop $849.95 25 11 1 South 8500 Laptop $849.95 27 12 1 South 8500 Laptop $849.95 33 13 2 South 2005 24" Monitor $229.00 8 14 2 South 2005 24" Monitor $229.00 8 15 2 South 2005 24" Monitor $229.00 10 16 2 South 3006 Wireless Keyboard $19.95 8 17 2 South 3006 Wireless Keyboard $19.95 8 18 2 South 3006 Wireless Keyboard $19.95 8 19 2 South 6050 PC Mouse $8.95 9 20 2 South 6050 PC Mouse $8.95 9 21 2 South 6050 PC Mouse $8.95 8 22 2 South 8500 Laptop $849.95 18 23 2 South 8500 Laptop $849.95 18 24 2 South 8500 Laptop $849.95 20 25 3 South 2005 24" Monitor $229.00 38 26 3 South 2005 24" Monitor $229.00 30 27 3 South 2005 24" Monitor $229.00 3 28 3 South 3006 Wireless Keyboard $19.95 30 29 3 South 3006 Wireless Keyboard $19.95 32 30 3 South 3006 Wireless Keyboard $19.95 33 31 3 South 6050 PC Mouse $8.95 25 32 3 South 6050 PC Mouse $8.95 5 33 3 South 6050 PC Mouse $8.95 26 34 3 South 8500 Laptop $849.95 28 35 3 South 8500 Laptop $849.95 27 36 3 South 8500 Laptop $849.95 29 37 4 North 2005 24" Monitor $229.00 18 38 4 North 2005 24" Monitor $229.00 20 39 4 North 2005 24" Monitor $229.00 4 40 4 North 3006 Wireless Keyboard $19.95 12 41 4 North 3006 Wireless Keyboard $19.95 24 42 4 North 3006 Wireless Keyboard $19.95 36 43 4 North 6050 PC Mouse $8.95 29 44 4 North 6050 PC Mouse $8.95 11

45 4 North 6050 PC Mouse $8.95 38 46 4 North 8500 Laptop $849.95 21 47 4 North 8500 Laptop $849.95 24 48 4 North 8500 Laptop $849.95 30 49 5 North 2005 24" Monitor $229.00 27 50 5 North 2005 24" Monitor $229.00 25 51 5 North 2005 24" Monitor $229.00 23 52 5 North 3006 Wireless Keyboard $19.95 80 53 5 North 3006 Wireless Keyboard $19.95 82 54 5 North 3006 Wireless Keyboard $19.95 75 55 5 North 6050 PC Mouse $8.95 65 56 5 North 6050 PC Mouse $8.95 24 57 5 North 6050 PC Mouse $8.95 55 58 5 North 8500 Laptop $849.95 55 59 5 North 8500 Laptop $849.95 57 60 5 North 8500 Laptop $849.95 47 61 6 East 2005 24" Monitor $229.00 24 62 6 East 2005 24" Monitor $229.00 85 63 6 East 2005 24" Monitor $229.00 56 64 6 East 3006 Wireless Keyboard $19.95 52 65 6 East 3006 Wireless Keyboard $19.95 58 66 6 East 3006 Wireless Keyboard $19.95 69 67 6 East 6050 PC Mouse $8.95 35 68 6 East 6050 PC Mouse $8.95 39 69 6 East 6050 PC Mouse $8.95 44 70 6 East 8500 Laptop $849.95 78 71 6 East 8500 Laptop $849.95 88 72 6 East 8500 Laptop $849.95 99 73 7 East 2005 24" Monitor $229.00 34 74 7 East 2005 24" Monitor $229.00 36 75 7 East 2005 24" Monitor $229.00 35 76 7 East 3006 Wireless Keyboard $19.95 49 77 7 East 3006 Wireless Keyboard $19.95 47 78 7 East 3006 Wireless Keyboard $19.95 48 79 7 East 6050 PC Mouse $8.95 45 80 7 East 6050 PC Mouse $8.95 42 81 7 East 6050 PC Mouse $8.95 45 82 7 East 8500 Laptop $849.95 55 83 7 East 8500 Laptop $849.95 57 84 7 East 8500 Laptop $849.95 55 85 8 East 2005 24" Monitor $229.00 18 86 8 East 2005 24" Monitor $229.00 17 87 8 East 2005 24" Monitor $229.00 23 88 8 East 3006 Wireless Keyboard $19.95 22 89 8 East 3006 Wireless Keyboard $19.95 18 90 8 East 3006 Wireless Keyboard $19.95 22 91 8 East 6050 PC Mouse $8.95 14 92 8 East 6050 PC Mouse $8.95 16

93 8 East 6050 PC Mouse $8.95 17 94 8 East 8500 Laptop $849.95 32 95 8 East 8500 Laptop $849.95 28 96 8 East 8500 Laptop $849.95 30

Store and Regional Database Week Ending Total Weekly Revenue STORE NO TOTAL SALES REVENUE October $6,412.00 1 $90,281.10 November $6,870.00 2 $54,262.70 December $2,061.00 3 $90,051.25 October $598.50 4 $75,498.75 November $698.25 5 $158,334.00 December $778.05 6 $267,648.90 October $250.60 7 $170,040.85 November $26.85 8 $91,435.05 December $340.10 October $21,248.75 November $22,948.65 December $28,048.35 SALES REGION TOTAL SALES REVENUE October $1,832.00 South $234,595.05 November $1,832.00 North $233,832.75 December $2,290.00 East $529,124.80 October $159.60 November $159.60 December $159.60 October $80.55 November $80.55 December $71.60 October $15,299.10 November $15,299.10 December $16,999.00 October $8,702.00 November $6,870.00 December $687.00 October $598.50 November $638.40 December $658.35 October $223.75 November $44.75 December $232.70 October $23,798.60 November $22,948.65 December $24,648.55 October $4,122.00 November $4,580.00 December $916.00 October $239.40 November $478.80 December $718.20 October $259.55 November $98.45

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help