0 0 medium 0 used car 646 0 0 medium 0 low medium 0

This preview shows page 9 - 13 out of 14 pages.

$0 $0 MEDIUM $0 Used Car $646 $0 $0 MEDIUM $0 LOW MEDIUM $0 New Car $538 $344 $0 MEDIUM $0 LOW MEDIUM $0 Furniture $0 $204 LOW $0 $0 LOW MEDIUM $0 Small Appliance $0 $148 LOW $0 $0 LOW MEDIUM $0 Furniture $0 $435 LOW $0 $0 LOW MEDIUM $0 Small Appliance $0 $914 LOW $0 $0 $0 MEDIUM $0 New Car $135 $0 LOW $0 $0 LOW MEDIUM $0 Used Car $2,472 $0 $0 MEDIUM HIGH LOW MEDIUM $0 New Car $0 $412 LOW $0 $0 LOW MEDIUM $0 New Car $10,417 $19,811 $0 MEDIUM HIGH $0 $0 HIGH Small Appliance $211 $822 LOW $0 $0 $0 MEDIUM $0 Small Appliance $16,630 $0 $0 MEDIUM HIGH LOW MEDIUM $0 Furniture $0 $3,369 LOW $0 $0 $0 $0 HIGH Furniture $642 $0 $0 MEDIUM $0 LOW MEDIUM $0 Small Appliance $0 $707 LOW $0 $0 $0 MEDIUM $0 Small Appliance $296 $818 LOW $0 $0 $0 MEDIUM $0 Business $898 $177 $0 MEDIUM $0 LOW MEDIUM $0 New Car $478 $4,071 LOW $0 $0 $0 $0 HIGH New Car $315 $466 LOW $0 $0 LOW MEDIUM $0 New Car $122 $460 LOW $0 $0 LOW MEDIUM $0 Furniture $0 $991 LOW $0 $0 $0 MEDIUM $0 Small Appliance $0 $17,653 LOW $0 $0 $0 $0 HIGH Education $0 $497 LOW $0 $0 LOW MEDIUM $0 Business $670 $4,014 $0 MEDIUM $0 $0 $0 HIGH Business $444 $921 LOW $0 $0 $0 MEDIUM $0 New Car $3,880 $0 $0 MEDIUM HIGH LOW MEDIUM $0 Used Car $819 $0 $0 MEDIUM $0 LOW MEDIUM $0 Used Car $0 $607 LOW $0 $0 $0 MEDIUM $0 Large Appliance $0 $15,800 LOW $0 $0 $0 $0 HIGH Furniture $0 $369 LOW $0 $0 LOW MEDIUM $0 Business $0 $4,973 LOW $0 $0 $0 $0 HIGH Furniture $0 $0 LOW $0 $0 LOW MEDIUM $0 New Car $0 $761 LOW $0 $0 $0 MEDIUM $0 Education $0 $471 LOW $0 $0 LOW MEDIUM $0 Used Car $0 $674 LOW $0 $0 $0 MEDIUM $0 New Car $0 $547 LOW $0 $0 $0 MEDIUM $0 Furniture $161 $524 LOW $0 $0 $0 MEDIUM $0 Furniture $0 $815 LOW $0 $0 $0 MEDIUM $0 Used Car $0 $0 LOW $0 $0 LOW MEDIUM $0 New Car $789 $989 $0 MEDIUM $0 $0 MEDIUM $0 Small Appliance $765 $10,406 $0 MEDIUM $0 $0 $0 HIGH Furniture $0 $957 LOW $0 $0 $0 MEDIUM $0 New Car $0 $770 LOW $0 $0 $0 MEDIUM $0 Furniture $983 $950 $0 MEDIUM $0 $0 MEDIUM $0 Used Car $0 $160 LOW $0 $0 LOW MEDIUM $0 Used Car $0 $276 LOW $0 $0 LOW MEDIUM $0 Education $798 $137 $0 MEDIUM $0 LOW MEDIUM $0 New Car $0 $579 LOW $0 $0 $0 MEDIUM $0 New Car $193 $2,684 LOW $0 $0 $0 $0 HIGH Small Appliance $497 $0 LOW $0 $0 LOW MEDIUM $0 Furniture $0 $0 LOW $0 $0 LOW MEDIUM $0
New Car $0 $0 LOW $0 $0 LOW MEDIUM $0 New Car $0 $712 LOW $0 $0 $0 MEDIUM $0 New Car $0 $912 LOW $0 $0 $0 MEDIUM $0
bank customers who had applied for loans. s account balances, ed, gender, marital status, age, ype, and credit-risk classification by the bank.7 (Evans 50) applied for new-car, (Evans 50) ng account balances less than $500. mns, (Evans 50) the balance is less than $500, wise.
Problem 5 Supplier Order No. Item No. Item Description Item Cost Quantity Cost per order Order No. Item Description Cost per order Spacetime Technologies A0111 6489 O-Ring $ 3.00 900 $ 2,700.00 A1567 Airframe fasteners $ 63,000.00 Steelpin Inc. A0115 5319 Shielded Cable/ft. $ 1.10 17,500 $ 19,250.00 C8854 Electrical Connector $ 6,781.25 Steelpin Inc. A0123 4312 Bolt-nut package $ 3.75 4,250 $ 15,937.50 A0207 Bolt-nut package $ 15,750.00 Steelpin Inc. A0204 5319 Shielded Cable/ft. $ 1.10 16,500 $ 18,150.00 Steelpin Inc. A0205 5677 Side Panel $ 195.00 120 $ 23,400.00 Steelpin Inc. A0207 4312 Bolt-nut package $ 3.75 4,200 $ 15,750.00 Alum Sheeting A0223 4224 Bolt-nut package $ 3.95 4,500 $ 17,775.00 Alum Sheeting A0433 5417 Control Panel $ 255.00 500 $ 127,500.00 PROBLEM Alum Sheeting A0443 1243 Airframe fasteners $ 4.25 10,000 $ 42,500.00 Alum Sheeting A0446 5417 Control Panel $ 255.00 406 $ 103,530.00 A manager needs to identify some information from Spacetime Technologies A0533 9752 Gasket $ 4.05 1,500 $ 6,075.00 but has only the order number. Modify the Excel file Spacetime Technologies A0555 6489 O-Ring $ 3.00 1,100 $ 3,300.00 the VLOOKUP function to find the item description a

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture