excel functioning

User Generated

Fnqrzbag94

Business Finance

Description

  1. The Excel file Science and Engineering Jobs shows the number of jobs in thousands in the year 2000 and projections for 2010 from a government study. Use the Excel file to compute the projected increase from the 2000 baseline and also the percentage increase for each occupational category.
  2. The Excel file Store and Regional Sales Database provides sales data for computers and peripherals showing the store identification number, sales region, item number, item description, unit price, units sold, and month when the sales were made during the fourth quarter of last year.3Modify the spreadsheet to calculate the total sales revenue for each of the eight stores as well as each of the three sales regions.
  3. The Excel file President’s Inn Guest Database provides a list of customers, rooms they occupied, arrival and departure dates, number of occupants, and daily rate for a small bed-and-breakfast inn during one month.4 Room rates are the same for one or two guests; however, additional guests must pay an additional $20 per person per day for meals. Guests staying for seven days or more receive a 10% discount. Modify the spreadsheet to calculate the number of days that each party stayed at the inn and the total revenue for the length of stay.
  4. The worksheet Base Data in the Excel file Credit Risk Data provides information about 425 bank customers who had applied for loans. The data include the purpose of the loan, checking and savings account balances, number of months as a customer of the bank, months employed, gender, marital status, age, housing status and number of years at current residence, job type, and credit-risk classification by the bank.5
    1. Use the COUNTIF function to determine (1) how many customers applied for new-car, used-car, business, education, small-appliance, and furniture loans and (2) the number of customers with checking account balances less than $500.
    2. Modify the spreadsheet using IF functions to include new columns, classifying the checking and savings account balances as low if the balance is less than $250, medium if between $250 but less than $2000, and high otherwise.
  5. A manager needs to identify some information from the Purchase Orders Excel file but has only the order number. Modify the Excel file to use the VLOOKUP function to find the item description and cost per order for the following order numbers: Aug11008, Sep11023, and Oct11020.

Unformatted Attachment Preview

Science and Engineering Jobs Total science and engineering jobs in thousands: 2000 and projected 2010 Occupation Scientists Life scientists Mathematical/computer scientists Computer specialists Mathematical scientists Physical scientists Social scientists Engineers All occupations 2000 2010 PROJECTED INCREASE Nominal JECTED INCREASE Percentage ID Store No. Sales Region 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 1 1 1 1 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 2 2 2 2 2 3 3 3 3 3 3 3 3 3 3 3 3 4 4 4 4 4 4 4 4 4 4 South South South South South South South South South South South South South South South South South South South South South South South South South South South South South South South South South South South South North North North North North North North North North North Item No. Item Description Unit Price Units Sold 2005 2005 2005 3006 3006 3006 6050 6050 6050 8500 8500 8500 2005 2005 2005 3006 3006 3006 6050 6050 6050 8500 8500 8500 2005 2005 2005 3006 3006 3006 6050 6050 6050 8500 8500 8500 2005 2005 2005 3006 3006 3006 6050 6050 6050 8500 24" Monitor 24" Monitor 24" Monitor Wireless Keyboard Wireless Keyboard Wireless Keyboard PC Mouse PC Mouse PC Mouse Laptop Laptop Laptop 24" Monitor 24" Monitor 24" Monitor Wireless Keyboard Wireless Keyboard Wireless Keyboard PC Mouse PC Mouse PC Mouse Laptop Laptop Laptop 24" Monitor 24" Monitor 24" Monitor Wireless Keyboard Wireless Keyboard Wireless Keyboard PC Mouse PC Mouse PC Mouse Laptop Laptop Laptop 24" Monitor 24" Monitor 24" Monitor Wireless Keyboard Wireless Keyboard Wireless Keyboard PC Mouse PC Mouse PC Mouse Laptop $229.00 $229.00 $229.00 $19.95 $19.95 $19.95 $8.95 $8.95 $8.95 $849.95 $849.95 $849.95 $229.00 $229.00 $229.00 $19.95 $19.95 $19.95 $8.95 $8.95 $8.95 $849.95 $849.95 $849.95 $229.00 $229.00 $229.00 $19.95 $19.95 $19.95 $8.95 $8.95 $8.95 $849.95 $849.95 $849.95 $229.00 $229.00 $229.00 $19.95 $19.95 $19.95 $8.95 $8.95 $8.95 $849.95 28 30 9 30 35 39 28 3 38 25 27 33 8 8 10 8 8 8 9 9 8 18 18 20 38 30 3 30 32 33 25 5 26 28 27 29 18 20 4 12 24 36 29 11 38 21 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 4 4 5 5 5 5 5 5 5 5 5 5 5 5 6 6 6 6 6 6 6 6 6 6 6 6 7 7 7 7 7 7 7 7 7 7 7 7 8 8 8 8 8 8 8 8 8 8 8 North North North North North North North North North North North North North North East East East East East East East East East East East East East East East East East East East East East East East East East East East East East East East East East East East 8500 8500 2005 2005 2005 3006 3006 3006 6050 6050 6050 8500 8500 8500 2005 2005 2005 3006 3006 3006 6050 6050 6050 8500 8500 8500 2005 2005 2005 3006 3006 3006 6050 6050 6050 8500 8500 8500 2005 2005 2005 3006 3006 3006 6050 6050 6050 8500 8500 Laptop Laptop 24" Monitor 24" Monitor 24" Monitor Wireless Keyboard Wireless Keyboard Wireless Keyboard PC Mouse PC Mouse PC Mouse Laptop Laptop Laptop 24" Monitor 24" Monitor 24" Monitor Wireless Keyboard Wireless Keyboard Wireless Keyboard PC Mouse PC Mouse PC Mouse Laptop Laptop Laptop 24" Monitor 24" Monitor 24" Monitor Wireless Keyboard Wireless Keyboard Wireless Keyboard PC Mouse PC Mouse PC Mouse Laptop Laptop Laptop 24" Monitor 24" Monitor 24" Monitor Wireless Keyboard Wireless Keyboard Wireless Keyboard PC Mouse PC Mouse PC Mouse Laptop Laptop $849.95 $849.95 $229.00 $229.00 $229.00 $19.95 $19.95 $19.95 $8.95 $8.95 $8.95 $849.95 $849.95 $849.95 $229.00 $229.00 $229.00 $19.95 $19.95 $19.95 $8.95 $8.95 $8.95 $849.95 $849.95 $849.95 $229.00 $229.00 $229.00 $19.95 $19.95 $19.95 $8.95 $8.95 $8.95 $849.95 $849.95 $849.95 $229.00 $229.00 $229.00 $19.95 $19.95 $19.95 $8.95 $8.95 $8.95 $849.95 $849.95 24 30 27 25 23 80 82 75 65 24 55 55 57 47 24 85 56 52 58 69 35 39 44 78 88 99 34 36 35 49 47 48 45 42 45 55 57 55 18 17 23 22 18 22 14 16 17 32 28 96 8 East 8500 Laptop $849.95 30 Store and Regional Database Week Ending October November December October November December October November December October November December October November December October November December October November December October November December October November December October November December October November December October November December October November December October November December October November December October Total Weekly Revenue $6,412.00 $6,870.00 $2,061.00 $598.50 $698.25 $778.05 $250.60 $26.85 $340.10 $21,248.75 $22,948.65 $28,048.35 $1,832.00 $1,832.00 $2,290.00 $159.60 $159.60 $159.60 $80.55 $80.55 $71.60 $15,299.10 $15,299.10 $16,999.00 $8,702.00 $6,870.00 $687.00 $598.50 $638.40 $658.35 $223.75 $44.75 $232.70 $23,798.60 $22,948.65 $24,648.55 $4,122.00 $4,580.00 $916.00 $239.40 $478.80 $718.20 $259.55 $98.45 $340.10 $17,848.95 STORE NO TOTAL SALES REVENUE 1 2 3 4 5 6 7 8 SALES REGION TOTAL SALES REVENUE South North East November December October November December October November December October November December October November December October November December October November December October November December October November December October November December October November December October November December October November December October November December October November December October November December October November $20,398.80 $25,498.50 $6,183.00 $5,725.00 $5,267.00 $1,596.00 $1,635.90 $1,496.25 $581.75 $214.80 $492.25 $46,747.25 $48,447.15 $39,947.65 $5,496.00 $19,465.00 $12,824.00 $1,037.40 $1,157.10 $1,376.55 $313.25 $349.05 $393.80 $66,296.10 $74,795.60 $84,145.05 $7,786.00 $8,244.00 $8,015.00 $977.55 $937.65 $957.60 $402.75 $375.90 $402.75 $46,747.25 $48,447.15 $46,747.25 $4,122.00 $3,893.00 $5,267.00 $438.90 $359.10 $438.90 $125.30 $143.20 $152.15 $27,198.40 $23,798.60 December $25,498.50 President's Inn Guest Database ID Guest First Name 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Barry Michael Kim Edward Thomas Paul Randall Calvin Homer David Buster Julia Samuel Arthur Darlene Carlyle Albert Charlene Everett Gerald Jamal Louis Nigel Peter Ronald Trista Valerie Walter Xavier Zachary Guest Last Name Lloyd Lunsford Kyuong Holt Collins Bodkin Battenburg Nowotney Gonzalez Sanchez Whisler Martines Kim Gottfried Shore Charleston Goldstone Tilson Chad Pittsfield Smith Paris Stratford Willington Cartier Leven Snell Acton Trezza Miller Room Hayes Cleveland Coolidge Washington Lincoln Coolidge Washington Lincoln Lincoln Jefferson Jackson Reagan Truman Garfield Arthur Quincy Adams Johnson Van Buren Madison Roosevelt Tyler Jackson Eisenhower Grant Jefferson Eisenhower Adams Polk McKinley Washington Room Type Bay-window Ocean Bay-window Ocean Ocean Bay-window Ocean Ocean Ocean Bay-window Ocean Bay-window Side Side Ocean Bay-window Ocean Bay-window Ocean Ocean Bay-window Ocean Ocean Ocean Bay-window Ocean Bay-window Side Side Ocean Arrival Date 12/1/2014 12/1/2014 12/4/2014 12/1/2014 12/9/2014 12/1/2014 12/4/2014 12/2/2014 12/5/2014 12/5/2014 12/5/2014 12/10/2014 12/20/2014 12/13/2014 12/24/2014 12/3/2014 12/5/2014 12/5/2014 12/10/2014 12/5/2014 12/20/2014 12/10/2014 12/14/2014 12/19/2014 12/24/2014 12/17/2014 12/3/2014 12/24/2014 12/14/2014 12/13/2014 Departure Date 12/4/2014 12/9/2014 12/7/2014 12/3/2014 12/13/2014 12/3/2014 12/12/2014 12/4/2014 12/7/2014 12/7/2014 12/8/2014 12/15/2014 12/30/2014 12/15/2014 12/31/2014 12/6/2014 12/7/2014 12/7/2014 12/14/2014 12/7/2014 12/23/2014 12/14/2014 12/16/2014 12/21/2014 12/28/2014 12/20/2014 12/6/2014 12/31/2014 12/17/2014 12/16/2014 Additional Fee Per Guest $ 20.00 per day No of Guests Daily Rate 2 3 1 4 2 2 2 1 5 2 2 1 3 2 5 2 3 1 2 2 2 1 2 1 4 1 1 6 2 2 $150.00 $112.50 $150.00 $325.00 $300.00 $150.00 $292.50 $300.00 $320.00 $175.00 $250.00 $150.00 $112.50 $125.00 $198.00 $150.00 $250.00 $150.00 $275.00 $275.00 $150.00 $250.00 $200.00 $200.00 $175.00 $200.00 $150.00 $148.50 $125.00 $325.00 Daily Rate Considering Number of Days Number of Guests Stayed Discount after 6 days 10% Total Revenue Credit Risk Base Data (b) Loan Purpose Small Appliance Furniture New Car Furniture Education Furniture New Car Business Small Appliance Small Appliance Business New Car Business New Car New Car Used Car Furniture New Car Repairs Education Furniture Furniture Furniture Furniture New Car Business Used Car Used Car Small Appliance Small Appliance Education Small Appliance Small Appliance Business Business Small Appliance Furniture Small Appliance Small Appliance New Car Other Used Car Small Appliance Furniture Checking $0 $0 $0 $638 $963 $2,827 $0 $0 $6,509 $966 $0 $0 $322 $0 $396 $0 $652 $708 $207 $287 $0 $101 $0 $0 $0 $141 $0 $2,484 $237 $0 $335 $3,565 $0 $16,647 $0 $0 $0 $940 $0 $0 $218 $0 $16,935 $664 Savings $739 $1,230 $389 $347 $4,754 $0 $229 $533 $493 $0 $989 $3,305 $578 $821 $228 $129 $732 $683 $0 $12,348 $17,545 $3,871 $0 $485 $10,723 $245 $0 $0 $236 $485 $1,708 $0 $407 $895 $150 $490 $162 $715 $323 $128 $0 $109 $189 $537 Checking Savings Acct Acct Status Status (a) Loan Purpose New Car Used Car Business Education Small Appliance Furniture Checking Acct Balance less than $500 Furniture Small Appliance Furniture New Car Business Small Appliance Small Appliance Furniture Business New Car Used Car Education Furniture New Car New Car Furniture New Car New Car Small Appliance New Car Small Appliance Small Appliance Business Used Car Furniture Furniture New Car Small Appliance Business Furniture Small Appliance New Car Business Business Repairs Business New Car Education New Car Education New Car Small Appliance Used Car Small Appliance Small Appliance Furniture Education Small Appliance Repairs $150 $0 $216 $0 $0 $0 $265 $4,256 $870 $162 $0 $0 $0 $461 $0 $0 $0 $580 $0 $0 $0 $0 $758 $399 $513 $0 $0 $565 $0 $0 $0 $166 $9,783 $674 $0 $15,328 $0 $713 $0 $0 $0 $0 $0 $303 $900 $0 $1,257 $0 $273 $6,520 $138 $0 $660 $724 $897 $947 $0 $917 $595 $789 $0 $746 $140 $659 $717 $667 $0 $763 $1,366 $552 $14,643 $2,665 $0 $442 $8,357 $0 $863 $322 $800 $656 $922 $885 $2,886 $626 $0 $904 $784 $806 $3,281 $759 $680 $104 $899 $1,732 $706 $0 $576 $904 Business Small Appliance Small Appliance Small Appliance New Car Small Appliance Furniture Small Appliance New Car Retraining Furniture New Car Education Business Furniture New Car Used Car Small Appliance Furniture Business Used Car Furniture Furniture Small Appliance Used Car Large Appliance Furniture Furniture Small Appliance Small Appliance Furniture New Car New Car New Car Furniture Small Appliance Business Furniture Small Appliance Small Appliance Small Appliance Other Business Repairs New Car Furniture Furniture Small Appliance Small Appliance $522 $0 $0 $0 $0 $514 $457 $5,133 $0 $644 $305 $9,621 $0 $0 $0 $0 $0 $6,851 $13,496 $509 $0 $19,155 $0 $0 $374 $0 $828 $0 $829 $0 $0 $939 $0 $889 $876 $893 $12,760 $0 $0 $959 $0 $0 $0 $0 $698 $0 $0 $0 $12,974 $194 $710 $5,564 $192 $637 $405 $318 $698 $369 $0 $492 $308 $127 $565 $12,632 $116 $178 $901 $650 $241 $609 $131 $544 $10,853 $0 $409 $391 $322 $583 $12,242 $479 $496 $466 $1,583 $1,533 $0 $4,873 $0 $717 $7,876 $4,449 $0 $104 $897 $4,033 $945 $836 $325 $19,568 Furniture Small Appliance Business Repairs Small Appliance Furniture New Car New Car Used Car New Car Used Car New Car Small Appliance New Car Used Car Education Furniture Large Appliance Furniture Furniture Business Used Car Small Appliance Small Appliance Used Car Small Appliance Repairs Furniture Used Car New Car New Car New Car Repairs Furniture Used Car Small Appliance New Car Business Small Appliance Small Appliance Business Furniture Furniture Small Appliance Small Appliance Furniture Used Car Business New Car $0 $317 $0 $0 $0 $192 $0 $0 $0 $0 $0 $942 $0 $3,329 $0 $0 $0 $0 $0 $0 $339 $0 $0 $0 $105 $0 $216 $113 $109 $0 $0 $8,176 $0 $468 $7,885 $0 $0 $0 $0 $0 $0 $0 $0 $0 $734 $0 $0 $172 $644 $803 $10,980 $265 $609 $1,851 $199 $500 $509 $270 $457 $260 $3,036 $643 $0 $6,345 $922 $909 $775 $979 $948 $2,790 $309 $762 $970 $320 $861 $262 $692 $540 $470 $192 $12,230 $772 $14,186 $6,330 $18,716 $886 $750 $3,870 $3,273 $406 $461 $340 $6,490 $348 $506 $14,717 $0 $1,571 New Car Furniture New Car Small Appliance Furniture Small Appliance Business Small Appliance New Car Education New Car New Car New Car Furniture Small Appliance Business Other Small Appliance New Car Small Appliance New Car Furniture Business Used Car Used Car Small Appliance Small Appliance Education Small Appliance Large Appliance Education Furniture Business New Car Repairs Furniture Small Appliance New Car Small Appliance Business New Car Small Appliance Used Car New Car Small Appliance Furniture New Car Used Car Business $0 $617 $0 $586 $0 $0 $0 $0 $0 $522 $585 $5,588 $0 $352 $0 $2,715 $560 $895 $305 $0 $0 $0 $8,948 $0 $0 $0 $0 $0 $483 $0 $0 $0 $663 $624 $0 $0 $152 $0 $0 $498 $0 $156 $1,336 $0 $0 $0 $2,641 $0 $0 $0 $411 $544 $0 $835 $823 $5,180 $408 $821 $385 $2,223 $0 $605 $7,525 $3,529 $1,435 $887 $243 $4,553 $418 $771 $463 $110 $10,099 $13,428 $208 $552 $3,105 $415 $1,238 $238 $127 $0 $785 $718 $493 $757 $9,125 $364 $598 $374 $0 $0 $508 $956 $636 $0 $1,519 $922 Furniture Used Car Small Appliance Small Appliance Business Furniture Small Appliance Small Appliance New Car New Car Used Car Small Appliance Business Education Furniture Business Other Furniture New Car New Car Business Used Car Business Small Appliance New Car New Car Furniture Repairs Small Appliance Small Appliance Furniture Furniture Furniture Furniture Other Education Small Appliance New Car Business Business Education New Car Used Car Used Car New Car New Car New Car Small Appliance New Car $0 $0 $0 $887 $0 $0 $0 $0 $18,408 $497 $0 $946 $986 $8,122 $0 $778 $645 $0 $682 $19,812 $0 $0 $859 $0 $0 $0 $0 $0 $0 $795 $0 $0 $0 $0 $852 $0 $0 $425 $0 $0 $0 $11,072 $0 $219 $8,060 $0 $0 $0 $0 $180 $701 $296 $519 $800 $736 $11,838 $364 $212 $888 $999 $0 $578 $136 $734 $861 $855 $4,486 $2,017 $0 $500 $859 $3,305 $1,218 $9,016 $11,587 $8,944 $807 $867 $16,804 $347 $836 $142 $169 $3,613 $403 $836 $0 $11,481 $3,285 $164 $891 $0 $841 $607 $486 $108 $0 $113 New Car Furniture Retraining New Car Education Education Furniture New Car Small Appliance Business New Car Small Appliance New Car Furniture New Car Furniture Small Appliance Small Appliance Furniture New Car New Car New Car New Car New Car Furniture Small Appliance Furniture New Car Repairs New Car Small Appliance Small Appliance New Car Used Car New Car Other Used Car Small Appliance Used Car New Car Furniture New Car Business Small Appliance New Car Education Education Furniture New Car $1,613 $757 $0 $0 $977 $197 $0 $0 $0 $0 $0 $256 $296 $0 $0 $0 $298 $0 $8,636 $0 $0 $19,766 $0 $0 $0 $0 $4,089 $0 $271 $949 $0 $911 $0 $0 $0 $0 $271 $0 $0 $0 $0 $4,802 $177 $0 $0 $996 $705 $0 $0 $0 $208 $603 $343 $463 $0 $299 $490 $6,628 $859 $750 $954 $591 $13,970 $857 $5,857 $3,326 $726 $214 $207 $713 $2,141 $483 $127 $367 $813 $0 $102 $759 $0 $503 $823 $693 $973 $648 $523 $7,090 $596 $904 $541 $154 $0 $0 $337 $716 $837 $0 $7,710 $531 Small Appliance Furniture Furniture Furniture Small Appliance Business Small Appliance Small Appliance Small Appliance Small Appliance Small Appliance New Car Furniture Education Repairs Small Appliance Furniture Small Appliance Small Appliance Repairs Small Appliance Small Appliance New Car Small Appliance New Car Business Small Appliance Used Car New Car Furniture New Car Used Car Small Appliance Used Car New Car Furniture Small Appliance Furniture Small Appliance New Car Used Car New Car New Car Small Appliance Small Appliance Furniture Furniture Small Appliance Small Appliance $5,960 $0 $759 $0 $651 $257 $955 $0 $8,249 $0 $956 $382 $0 $842 $3,111 $0 $0 $2,846 $231 $0 $17,366 $0 $332 $242 $0 $929 $0 $0 $0 $0 $0 $0 $0 $646 $538 $0 $0 $0 $0 $135 $2,472 $0 $10,417 $211 $16,630 $0 $642 $0 $296 $129 $941 $596 $987 $0 $460 $0 $798 $0 $959 $1,482 $883 $12,721 $0 $0 $302 $538 $0 $702 $2,688 $0 $425 $214 $0 $272 $124 $17,124 $612 $862 $146 $14,190 $396 $519 $0 $344 $204 $148 $435 $914 $0 $0 $412 $19,811 $822 $0 $3,369 $0 $707 $818 Business New Car New Car New Car Furniture Small Appliance Education Business Business New Car Used Car Used Car Large Appliance Furniture Business Furniture New Car Education Used Car New Car Furniture Furniture Used Car New Car Small Appliance Furniture New Car Furniture Used Car Used Car Education New Car New Car Small Appliance Furniture New Car New Car New Car $898 $478 $315 $122 $0 $0 $0 $670 $444 $3,880 $819 $0 $0 $0 $0 $0 $0 $0 $0 $0 $161 $0 $0 $789 $765 $0 $0 $983 $0 $0 $798 $0 $193 $497 $0 $0 $0 $0 $177 $4,071 $466 $460 $991 $17,653 $497 $4,014 $921 $0 $0 $607 $15,800 $369 $4,973 $0 $761 $471 $674 $547 $524 $815 $0 $989 $10,406 $957 $770 $950 $160 $276 $137 $579 $2,684 $0 $0 $0 $712 $912 (a) Number of Applicants No of Customers Purchase Orders Supplier Order No. Item No. Item Description Hulkey Fasteners Aug11001 Aug11002 Aug11003 Aug11004 Aug11005 Aug11006 Aug11007 Aug11008 Aug11009 Aug11010 Aug11011 Aug11012 Aug11013 Aug11014 Sep11001 Sep11002 Sep11003 Sep11004 Sep11005 Sep11006 Sep11007 Sep11008 Sep11009 Sep11010 Sep11011 Sep11012 Sep11013 Sep11014 Sep11015 Sep11016 Sep11017 Sep11018 Sep11019 Sep11020 Sep11021 Sep11022 Sep11023 Sep11024 Sep11025 Sep11026 Sep11027 Sep11028 Sep11029 Sep11030 Alum Sheeting Fast-Tie Aerospace Fast-Tie Aerospace Steelpin Inc. Fast-Tie Aerospace Steelpin Inc. Durrable Products Fast-Tie Aerospace Fast-Tie Aerospace Steelpin Inc. Hulkey Fasteners Hulkey Fasteners Steelpin Inc. Steelpin Inc. Alum Sheeting Hulkey Fasteners Steelpin Inc. Steelpin Inc. Hulkey Fasteners Spacetime Technologies Alum Sheeting Durrable Products Steelpin Inc. Hulkey Fasteners Hulkey Fasteners Hulkey Fasteners Hulkey Fasteners Spacetime Technologies Hulkey Fasteners Fast-Tie Aerospace Steelpin Inc. Spacetime Technologies Hulkey Fasteners Spacetime Technologies Spacetime Technologies Pylon Accessories Pylon Accessories Spacetime Technologies Spacetime Technologies Durrable Products Manley Valve Fast-Tie Aerospace Pylon Accessories 1122 1243 Airframe fasteners Airframe fasteners 5462 5462 5319 5462 Shielded Cable/ft. Shielded Cable/ft. Shielded Cable/ft. Shielded Cable/ft. Item Cost Quantity $ 4.25 19,500 10,000 23,000 21,500 17,500 22,500 4,250 100 4312 Bolt-nut package 7258 Pressure Gauge $ 4.25 $ 1.05 $ 1.05 $ 1.10 $ 1.05 $ 3.75 $ 90.00 6321 O-Ring $ 2.45 1,300 5462 5319 3166 9966 5234 Shielded Cable/ft. Shielded Cable/ft. Electrical Connector Hatch Decal Electrical Connector $ 1.05 $ 1.10 $ 1.25 $ 0.75 $ 1.65 $ 3.75 $ 255.00 $ 1.25 $ 1.65 $ 3.75 22,500 18,100 5,600 500 4,500 4,200 406 5,500 4,850 4,150 $ $ 4.25 3.55 15,500 4,800 9,000 120 4,750 4312 Bolt-nut package 5417 3166 5234 Control Panel Electrical Connector Electrical Connector 4312 1122 4111 1243 Bolt-nut package Airframe fasteners Bolt-nut package Airframe fasteners 7258 5234 Pressure Gauge Electrical Connector $ 4.25 $ 90.00 $ 1.65 1122 Airframe fasteners $ 4.25 12,500 5066 3166 Shielded Cable/ft. Electrical Connector $ $ 0.95 1.25 25,000 5,650 1122 4111 Airframe fasteners Bolt-nut package $ $ 4.25 3.55 15,000 4,585 3166 Electrical Connector $ 1.25 5,425 6321 O-Ring $ 2.45 1,200 5319 Shielded Cable/ft. $ 1.10 16,500 4111 Bolt-nut package $ 3.55 4,200 5066 Shielded Cable/ft. 9752 4111 9764 9764 9752 4111 1369 6431 6321 9764 Gasket Bolt-nut package Gasket Gasket Gasket Bolt-nut package Airframe fasteners O-Ring O-Ring Gasket $ $ 0.95 4.05 17,500 1,500 $ 3.55 4,250 $ $ $ 3.75 3.75 4.05 1,980 1,750 1,550 $ 3.55 4,200 $ $ 4.20 2.85 15,000 1,300 $ 2.45 2,500 $ 3.75 1,850 Durrable Products Hulkey Fasteners Pylon Accessories Durrable Products Spacetime Technologies Durrable Products Manley Valve Pylon Accessories Fast-Tie Aerospace Hulkey Fasteners Durrable Products Spacetime Technologies Durrable Products Spacetime Technologies Durrable Products Manley Valve Durrable Products Durrable Products Spacetime Technologies Alum Sheeting Steelpin Inc. Manley Valve Manley Valve Hulkey Fasteners Fast-Tie Aerospace Alum Sheeting Durrable Products Manley Valve Steelpin Inc. Alum Sheeting Manley Valve Alum Sheeting Durrable Products Fast-Tie Aerospace Fast-Tie Aerospace Hulkey Fasteners Steelpin Inc. Steelpin Inc. Spacetime Technologies Alum Sheeting Manley Valve Manley Valve Fast-Tie Aerospace Fast-Tie Aerospace Steelpin Inc. Manley Valve Fast-Tie Aerospace Sep11031 Sep11032 Sep11033 Sep11034 Oct11001 Oct11002 Oct11003 Oct11004 Oct11005 Oct11006 Oct11007 Oct11008 Oct11009 Oct11010 Oct11011 Oct11012 Oct11013 Oct11014 Oct11015 Oct11016 Oct11017 Oct11018 Oct11019 Oct11020 Oct11021 Oct11022 Oct11023 Oct11024 Oct11025 Oct11026 Oct11027 Oct11028 Oct11029 Oct11030 Oct11031 Oct11032 Oct11033 Oct11034 Oct11035 Oct11036 Nov11001 Nov11002 Nov11003 Nov11004 Nov11005 Nov11006 Nov11007 $ 4.20 14,000 $ 4.25 14,500 $ $ $ 3.75 4.20 1.15 1,800 10,000 15,000 $ 3.65 1,250 $ $ $ 2.85 2.95 1.25 1,350 1,500 5,650 Airframe fasteners Gasket O-Ring Gasket Bolt-nut package Bolt-nut package O-Ring Gasket $ $ 4.25 3.65 18,000 1,450 5454 Control Panel 6489 1243 O-Ring Airframe fasteners 8008 7258 8148 Machined Valve Pressure Gauge Machined Valve 1122 6321 4224 Airframe fasteners O-Ring Bolt-nut package 5454 7258 8008 5417 7258 5634 5275 Control Panel Pressure Gauge Machined Valve Control Panel Pressure Gauge Side Panel Shielded Cable/ft. 1369 1122 9764 1369 Airframe fasteners Airframe fasteners Gasket Airframe fasteners 5125 Shielded Cable/ft. 9399 6431 6433 Gasket O-Ring O-Ring 5166 Electrical Connector 1122 9399 6489 9399 4111 4569 6431 9399 $ 3.00 1,100 $ $ 3.65 3.55 1,985 4,600 $ $ 3.50 2.85 3,900 1,250 $ 3.65 1,470 $ $ $ $ $ $ 220.00 3.00 4.25 645.00 100.50 655.50 550 900 10,500 100 90 125 $ $ 4.25 2.45 17,000 1,250 $ $ $ $ $ $ $ $ 3.95 220.00 100.50 645.00 255.00 100.50 185.00 1.00 4,500 500 100 150 500 95 150 25,000 6321 O-Ring $ 2.45 1,500 5689 Side Panel $ 175.00 155 1122 Airframe fasteners $ 4.25 17,500 5677 8008 Side Panel Machined Valve 6489 O-Ring 5634 9977 9955 5689 7268 5677 9967 7268 Side Panel Panel Decal Door Decal Side Panel Pressure Gauge Side Panel Hatch Decal Pressure Gauge $ $ $ $ $ $ $ $ $ $ $ 195.00 645.00 3.00 185.00 1.00 0.55 175.00 95.00 195.00 0.85 95.00 130 120 1,050 140 525 150 150 110 120 550 105 Fast-Tie Aerospace Steelpin Inc. Manley Valve Nov11008 Nov11009 Nov11010 5689 5677 9955 Side Panel Side Panel Door Decal $ 175.00 $ 195.00 $ 0.55 175 110 125 Cost per order $ $ 82,875.00 42,500.00 $ $ $ $ $ $ 24,150.00 22,575.00 19,250.00 23,625.00 15,937.50 9,000.00 $ 3,185.00 $ 23,625.00 $ 19,910.00 $ 7,000.00 $ 375.00 $ 7,425.00 $ 15,750.00 $ 103,530.00 $ 6,875.00 $ 8,002.50 $ 15,562.50 $ $ $ 65,875.00 17,040.00 38,250.00 $ $ 10,800.00 7,837.50 $ 53,125.00 $ $ 23,750.00 7,062.50 $ $ 63,750.00 16,276.75 $ 6,781.25 $ 2,940.00 $ 18,150.00 $ 14,910.00 $ $ 16,625.00 6,075.00 $ 15,087.50 $ $ $ 7,425.00 6,562.50 6,277.50 $ $ 14,910.00 63,000.00 $ 3,705.00 $ 6,125.00 $ 6,937.50 Order No. Item Description Aug11008 Pressure Gauge Sep11023 Gasket Oct11020 Airframe fasteners Cost per order $ $ 58,800.00 61,625.00 $ 6,750.00 $ 42,000.00 $ 17,250.00 $ 4,562.50 $ $ $ 3,847.50 4,425.00 7,062.50 $ $ 76,500.00 5,292.50 $ 3,300.00 $ $ 7,245.25 16,330.00 $ $ 13,650.00 3,562.50 $ 5,365.50 $ 121,000.00 $ 2,700.00 $ 44,625.00 $ $ $ 64,500.00 9,045.00 81,937.50 $ $ 72,250.00 3,062.50 $ 17,775.00 $ 110,000.00 $ 10,050.00 $ 96,750.00 $ 127,500.00 $ 9,547.50 $ 27,750.00 $ 25,000.00 $ 3,675.00 $ 27,125.00 $ 74,375.00 $ $ $ $ $ $ $ $ $ $ $ 25,350.00 77,400.00 3,150.00 25,900.00 525.00 82.50 26,250.00 10,450.00 23,400.00 467.50 9,975.00 $ $ $ 30,625.00 21,450.00 68.75
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

hello, here is the finale answer

Science and Engineering Jobs
Total science and engineering jobs in thousands: 2000 and projected 2010

PROJECTED INCREASE
Nominal
8,090112785
5,283362603
7,794008949

Occupation
Scientists
Life scientists
Mathematical/computer scientists

2000
3.241
184
2.408

2010
5.301
218
4.308

Computer specialists

2.318

4.213

7,756021903

89
239
410
1.465
145.571

95
283
492
1.603
167.754

4,608082329
5,534052791
6,055556246
7,306895825
11,888847354

Mathematical scientists
Physical scientists
Social scientists
Engineers
All occupations

question 1:

1. The Excel file Science and Engineering Jobs shows the number of jobs in thousands in the year 2000 and projectio
government study. Use the Excel file to compute the projected increase from the 2000 baseline and also the percentage
occupational category.

PROJECTED INCREASE
Percentage
63,5606294%
18,4782609%
78,9036545%
81,7515099%
6,7415730%
18,4100418%
20,0000000%
9,4197952%
15,2386121%

bs in thousands in the year 2000 and projections for 2010 from a
rom the 2000 baseline and also the percentage increase for each
ategory.

ID

Store No. Sales Region
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46

1
1
1
1
1
1
1
1
1
1
1
1
2
2
2
2
2
2
2
2
2
2
2
2
3
3
3
3
3
3
3
3
3
3
3
3
4
4
4
4
4
4
4
4
4
4

South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
North
North
North
North
North
North
North
North
North
North

Item No. Item Description Unit Price Units Sold
2005
2005
2005
3006
3006
3006
6050
6050
6050
8500
8500
8500
2005
2005
2005
3006
3006
3006
6050
6050
6050
8500
8500
8500
2005
2005
2005
3006
3006
3006
6050
6050
6050
8500
8500
8500
2005
2005
2005
3006
3006
3006
6050
6050
6050
8500

24" Monitor
24" Monitor
24" Monitor
Wireless Keyboard
Wireless Keyboard
Wireless Keyboard
PC Mouse
PC Mouse
PC Mouse
Laptop
Laptop
Laptop
24" Monitor
24" Monitor
24" Monitor
Wireless Keyboard
Wireless Keyboard
Wireless Keyboard
PC Mouse
PC Mouse
PC Mouse
Laptop
Laptop
Laptop
24" Monitor
24" Monitor
24" Monitor
Wireless Keyboard
Wireless Keyboard
Wireless Keyboard
PC Mouse
PC Mouse
PC Mouse
Laptop
Laptop
Laptop
24" Monitor
24" Monitor
24" Monitor
Wireless Keyboard
Wireless Keyboard
Wireless Keyboard
PC Mouse
PC Mouse
PC Mouse
Laptop

$229,00
$229,00
$229,00
$19,95
$19,95
$19,95
$8,95
$8,95
$8,95
$849,95
$849,95
$849,95
$229,00
$229,00
$229,00
$19,95
$19,95
$19,95
$8,95
$8,95
$8,95
$849,95
$849,95
$849,95
$229,00
$229,00
$229,00
$19,95
$19,95
$19,95
$8,95
$8,95
$8,95
$849,95
$849,95
$849,95
$229,00
$229,00
$229,00
$19,95
$19,95
$19,95
$8,95
$8,95
$8,95
$849,95

28
30
9
30
35
39
28
3
38
25
27
33
8
8
10
8
8
8
9
9
8
18
18
20
38
30
3
30
32
33
25
5
26
28
27
29
18
20
4
12
24
36
29
11
38
21

47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95

4
4
5
5
5
5
5
5
5
5
5
5
5
5
6
6
6
6
6
6
6
6
6
6
6
6
7
7
7
7
7
7
7
7
7
7
7
7
8
8
8
8
8
8
8
8
8
8
8

North
North
North
North
North
North
North
North
North
North
North
North
North
North
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East

8500
8500
2005
2005
2005
3006
3006
3006
6050
6050
6050
8500
8500
8500
2005
2005
2005
3006
3006
3006
6050
6050
6050
8500
8500
8500
2005
2005
2005
3006
3006
3006
6050
6050
6050
8500
8500
8500
2005
2005
2005
3006
3006
3006
6050
6050
6050
8500
8500

Laptop
Laptop
24" Monitor
24" Monitor
24" Monitor
Wireless Keyboard
Wireless Keyboard
Wireless Keyboard
PC Mouse
PC Mouse
PC Mouse
Laptop
Laptop
Laptop
24" Monitor
24" Monitor
24" Monitor
Wireless Keyboard
Wireless Keyboard
Wireless Keyboard
PC Mouse
PC Mouse
PC Mouse
Laptop
Laptop
Laptop
24" Monitor
24" Monitor
24" Monitor
Wireless Keyboard
Wireless Keyboard
Wireless Keyboard
PC Mouse
PC Mouse
PC Mouse
Laptop
Laptop
Laptop
24" Monitor
24" Monitor
24" Monitor
Wireless Keyboard
Wireless Keyboard
Wireless Keyboard
PC Mouse
PC Mouse
PC Mouse
Laptop
Laptop

$849,95
$849,95
$229,00
$229,00
$229,00
$19,95
$19,95
$19,95
$8,95
$8,95
$8,95
$849,95
$849,95
$849,95
$229,00
$229,00
$229,00
$19,95
$19,95
$19,95
$8,95
$8,95
$8,95
$849,95
$849,95
$849,95
$229,00
$229,00
$229,00
$19,95
$19,95
$19,95
$8,95
$8,95
$8,95
$849,95
$849,95
$849,95
$229,00
$229,00
$229,00
$19,95
$19,95
$19,95
$8,95
$8,95
$8,95
$849,95
$849,95

24
30
27
25
23
80
82
75
65
24
55
55
57
47
24
85
56
52
58
69
35
39
44
78
88
99
34
36
35
49
47
48
45
42
45
55
57
55
18
17
23
22
18
22
14
16
17
32
28

96

8 East

8500 Laptop

$849,95

30

Store and Regional Database
Week Ending
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October

Total Weekly Revenue

$6.412,00
$6.870,00
$2.061,00
$598,50
$698,25
$778,05
$250,60
$26,85
$340,10
$21.248,75
$22.948,65
$28.048,35
$1.832,00
$1.832,00
$2.290,00
$159,60
$159,60
$159,60
$80,55
$80,55
$71,60
$15.299,10
$15.299,10
$16.999,00
$8.702,00
$6.870,00
$687,00
$598,50
$638,40
$658,35
$223,75
$44,75
$232,70
$23.798,60
$22.948,65
$24.648,55
$4.122,00
$4.580,00
$916,00
$239,40
$478,80
$718,20
$259,55
$98,45
$340,10
$17.848,95

STORE NO

TOTAL SALES REVENUE

1
2
3
4
5
6
7
8

$90.281,10
$54.262,70
$90.051,25
$75.498,75
$158.334,00
$267.648,90
$170.040,85
$91.435,05

SALES REGION TOTAL SALES REVENUE

South
North
East

$234.595,05
$233.832,75
$529.124,80

Question 2:

The Excel file Store and Regional Sales Database pr
item description, unit price, units sold, and month w
revenue
3 Based on Kenneth C. Laudon and Jane P. La

November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November
December
October
November

$20.398,80
$25.498,50
$6.183,00
$5.725,00
$5.267,00
$1.596,00
$1.635,90
$1.496,25
$581,75
$214,80
$492,25
$46.747,25
$48.447,15
$39.947,65
$5.496,00
$19.465,00
$12.824,00
$1.037,40
$1.157,10
$1.376,55
$313,25
$349,05
$393,80
$66.296,10
$74.795,60
$84.145,05
$7.786,00
$8.244,00
$8.015,00
$977,55
$937,65
$957,60
$4...


Anonymous
Really helped me to better understand my coursework. Super recommended.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags