bu1410_week1_lab2.xlsx
Sheet3
| | | | | Orders and Suppliers |
| Vendor Name | Vendor No. | Order No. | Item No. | Item Description | Item Cost | Quantity | Cost per order | A/P Terms | Ship Date | Transit Time | Arrival Date |
| Toytime Technologies | 1002 | 0111 | 6489 | Washers Pkg | $ 3.00 | 900 | $ 2,700.00 | 25 | 10/10/11 | 5 | 10/18/11 |
| Acme Inc. | 1006 | 0115 | 5319 | String/ft. | $ 1.10 | 500 | $ 550.00 | 30 | 08/20/11 | 11 | 08/31/11 |
| Acme Inc. | 1006 | 0123 | 4312 | Bolt-nut package | $ 3.75 | 4,250 | $ 15,937.50 | 30 | 08/25/11 | 5 | 09/01/11 |
| Acme Inc. | 1006 | 0204 | 5319 | String/ft. | $ 1.10 | 500 | $ 550.00 | 30 | 09/15/11 | 15 | 10/05/11 |
| Acme Inc. | 1006 | 0207 | 4312 | Bolt-nut package | $ 3.75 | 900 | $ 3,375.00 | 30 | 09/01/11 | 6 | 09/10/11 |
| Toy Supply | 1005 | 0223 | 4224 | Bolt-nut package | $ 3.95 | 500 | $ 1,975.00 | 30 | 10/15/11 | 5 | 10/20/11 |
| Toy Supply | 1005 | 0433 | 5417 | Doll Head | $ 2.55 | 500 | $ 1,275.00 | 30 | 10/20/11 | 5 | 10/27/11 |
| Toy Supply | 1005 | 0443 | 1243 | Doll Body | $ 4.25 | 1,000 | $ 4,250.00 | 30 | 08/08/11 | 5 | 08/14/11 |
| Toy Supply | 1005 | 0446 | 5417 | Doll Head | $ 2.55 | 405 | $ 1,032.75 | 30 | 09/01/11 | 6 | 09/10/11 |
| Toytime Technologies | 1002 | 0533 | 9752 | Doll Appendages pkg | $ 4.05 | 500 | $ 2,025.00 | 25 | 09/20/11 | 5 | 09/25/11 |
| Toytime Technologies | 1002 | 0555 | 6489 | Washers Pkg | $ 3.00 | 1,100 | $ 3,300.00 | 25 | 10/05/11 | 5 | 10/10/11 |
| Toytime Technologies | 1002 | 0622 | 9752 | Doll Appendages pkg | $ 4.05 | 550 | $ 2,227.50 | 25 | 09/25/11 | 5 | 10/05/11 |
| Toytime Technologies | 1002 | 0666 | 5125 | String/ft. | $ 1.15 | 500 | $ 575.00 | 25 | 10/01/11 | 10 | 10/15/11 |
| Toytime Technologies | 1002 | 0777 | 6489 | Washers Pkg | $ 3.00 | 1,050 | $ 3,150.00 | 25 | 10/29/11 | 5 | 11/10/11 |
| Toytime Technologies | 1002 | 1222 | 4111 | Bolt-nut package | $ 3.55 | 500 | $ 1,775.00 | 25 | 09/15/11 | 20 | 10/15/11 |
| Dependable Vendors | 1003 | 1234 | 9399 | Doll Appendages pkg | $ 3.65 | 1,050 | $ 3,832.50 | 45 | 10/01/11 | 5 | 10/06/11 |
| Dependable Vendors | 1003 | 1235 | 9399 | Doll Appendages pkg | $ 3.65 | 450 | $ 1,642.50 | 45 | 10/03/11 | 5 | 10/08/11 |
| Dependable Vendors | 1003 | 1344 | 5454 | Doll Head | $ 2.20 | 550 | $ 1,210.00 | 45 | 10/09/11 | 6 | 10/14/11 |
| Dependable Vendors | 1003 | 1345 | 9399 | Doll Appendages pkg | $ 3.65 | 470 | $ 1,715.50 | 45 | 10/07/11 | 5 | 10/12/11 |
| Dependable Vendors | 1003 | 1346 | 9399 | Doll Appendages pkg | $ 3.65 | 985 | $ 3,595.25 | 45 | 10/05/11 | 5 | 10/11/11 |
| Toytime Technologies | 1002 | 1444 | 4111 | Bolt-nut package | $ 3.55 | 550 | $ 1,952.50 | 25 | 09/20/11 | 15 | 10/10/11 |
| Toytime Technologies | 1002 | 1445 | 4111 | Bolt-nut package | $ 3.55 | 500 | $ 1,775.00 | 25 | 09/25/11 | 25 | 10/25/11 |
| Toytime Technologies | 1002 | 1449 | 4111 | Bolt-nut package | $ 3.55 | 600 | $ 2,130.00 | 25 | 10/05/11 | 15 | 10/19/11 |
| Dependable Vendors | 1003 | 1456 | 5454 | Doll Head | $ 2.20 | 500 | $ 1,100.00 | 45 | 10/15/11 | 5 | 10/20/11 |
| Dependable Vendors | 1003 | 1457 | 4569 | Bolt-nut package | $ 3.50 | 900 | $ 3,150.00 | 45 | 10/05/11 | 5 | 10/10/11 |
| Dependable Vendors | 1003 | 1567 | 1369 | Doll Body | $ 4.20 | 500 | $ 2,100.00 | 45 | 09/25/11 | 5 | 09/30/11 |
| First Vendor | 1007 | 2345 | 6431 | Washers Pkg | $ 2.85 | 1,250 | $ 3,562.50 | 30 | 10/05/11 | 5 | 10/10/11 |
| First Vendor | 1007 | 2356 | 7258 | Car Wheels 4 pk | $ 1.50 | 950 | $ 1,425.00 | 30 | 10/20/11 | 8 | 10/29/11 |
| First Vendor | 1007 | 2378 | 6431 | Washers Pkg | $ 2.85 | 1,350 | $ 3,847.50 | 30 | 10/01/11 | 5 | 10/07/11 |
| Toytime Technologies | 1002 | 3467 | 4111 | Bolt-nut package | $ 3.55 | 800 | $ 2,840.00 | 25 | 09/05/11 | 10 | 09/20/11 |
| Toytime Technologies | 1002 | 5689 | 4111 | Bolt-nut package | $ 3.55 | 585 | $ 2,076.75 | 25 | 09/10/11 | 15 | 09/30/11 |
| First Vendor | 1007 | 9821 | 6431 | Washers Pkg | $ 2.85 | 1,300 | $ 3,705.00 | 30 | 09/25/11 | 5 | 10/01/11 |
| First Vendor | 1007 | 9842 | 7258 | Car Wheels 4 pk | $ 1.50 | 1,000 | $ 1,500.00 | 30 | 10/15/11 | 8 | 10/24/11 |
| First Vendor | 1007 | 9876 | 9955 | Decal | $ 0.55 | 150 | $ 82.50 | 30 | 11/01/11 | 5 | 11/06/11 |
| Razor Accessories | 1008 | 9999 | 6433 | Washers Pkg | $ 2.95 | 1,500 | $ 4,425.00 | 15 | 10/01/11 | 5 | 10/10/11 |
| Toy Supply | 1005 | 0247 | 1243 | Doll Body | $ 4.25 | 900 | $ 3,825.00 | 30 | 09/05/11 | 5 | 09/12/11 |
| Acme Inc. | 1006 | 0445 | 4312 | Bolt-nut package | $ 3.75 | 450 | $ 1,687.50 | 30 | 09/03/11 | 5 | 09/11/11 |
| Toy Supply | 1005 | 0567 | 1243 | Doll Body | $ 4.25 | 500 | $ 2,125.00 | 30 | 10/10/11 | 6 | 10/17/11 |
| Razor Accessories | 1008 | 1111 | 9764 | Doll Appendages pkg | $ 3.75 | 980 | $ 3,675.00 | 15 | 09/20/11 | 6 | 09/29/11 |
| Dependable Vendors | 1003 | 1234 | 7258 | Car Wheels 4 pk | $ 0.90 | 1,000 | $ 900.00 | 45 | 08/25/11 | 4 | 08/28/11 |
| Dependable Vendors | 1003 | 1345 | 7258 | Car Wheels 4 pk | $ 0.90 | 1,200 | $ 1,080.00 | 45 | 09/05/11 | 4 | 09/09/11 |
| Dependable Vendors | 1003 | 1468 | 1369 | Doll Body | $ 4.20 | 1,000 | $ 4,200.00 | 45 | 09/27/11 | 6 | 10/03/11 |
| Dependable Vendors | 1003 | 1589 | 5275 | String/ft. | $ 1.00 | 500 | $ 500.00 | 45 | 10/25/11 | 4 | 10/30/11 |
| Dependable Vendors | 1003 | 1666 | 1369 | Doll Body | $ 4.20 | 1,000 | $ 4,200.00 | 45 | 09/29/11 | 5 | 10/04/11 |
| Fast-Deliver Supplier | 1004 | 2333 | 6321 | Washers Pkg | $ 2.45 | 1,300 | $ 3,185.00 | 30 | 08/25/11 | 10 | 09/04/11 |
| Fast-Deliver Supplier | 1004 | 2345 | 6321 | Washers Pkg | $ 2.45 | 1,200 | $ 2,940.00 | 30 | 09/12/11 | 9 | 09/23/11 |
| Fast-Deliver Supplier | 1004 | 2356 | 6321 | Washers Pkg | $ 2.45 | 500 | $ 1,225.00 | 30 | 09/25/11 | 9 | 10/04/11 |
| Fast-Deliver Supplier | 1004 | 2367 | 6321 | Washers Pkg | $ 2.45 | 1,250 | $ 3,062.50 | 30 | 10/12/11 | 8 | 10/21/11 |
| Fast-Deliver Supplier | 1004 | 2378 | 6321 | Washers Pkg | $ 2.45 | 500 | $ 1,225.00 | 30 | 10/25/11 | 8 | 11/02/11 |
| Fast-Deliver Supplier | 1004 | 2499 | 7268 | Car Wheels 4 pk | $ 0.95 | 1,100 | $ 1,045.00 | 30 | 11/01/11 | 10 | 11/12/11 |
| Fast-Deliver Supplier | 1004 | 2511 | 7268 | Car Wheels 4 pk | $ 0.95 | 1,050 | $ 997.50 | 30 | 11/05/11 | 10 | 11/16/11 |
| Fast-Deliver Supplier | 1004 | 2519 | 5462 | String/ft. | $ 1.05 | 500 | $ 525.00 | 30 | 08/20/11 | 5 | 08/26/11 |
| Fast-Deliver Supplier | 1004 | 2537 | 5462 | String/ft. | $ 1.05 | 500 | $ 525.00 | 30 | 08/15/11 | 5 | 08/22/11 |
| Fast-Deliver Supplier | 1004 | 2566 | 5462 | String/ft. | $ 1.05 | 1,000 | $ 1,050.00 | 30 | 08/10/11 | 5 | 08/15/11 |
| Acme Inc. | 1006 | 3041 | 5234 | Doll Wigs | $ 1.65 | 500 | $ 825.00 | 30 | 08/28/11 | 5 | 09/05/11 |
| Acme Inc. | 1006 | 3042 | 5234 | Doll Wigs | $ 1.65 | 750 | $ 1,237.50 | 30 | 09/05/11 | 5 | 09/13/11 |
| Acme Inc. | 1006 | 3111 | 5234 | Doll Wigs | $ 1.65 | 850 | $ 1,402.50 | 30 | 09/02/11 | 6 | 09/11/11 |
| Fast-Deliver Supplier | 1004 | 0234 | 5166 | Doll Wigs | $ 1.25 | 650 | $ 812.50 | 30 | 10/01/11 | 5 | 10/06/11 |
| Fast-Deliver Supplier | 1004 | 0433 | 5462 | String/ft. | $ 1.05 | 500 | $ 525.00 | 30 | 08/25/11 | 6 | 09/02/11 |
| Acme Inc. | 1006 | 0589 | 5319 | String/ft. | $ 1.10 | 1,000 | $ 1,100.00 | 30 | 08/25/11 | 10 | 09/05/11 |
| First Vendor | 1007 | 1111 | 9955 | Decal | $ 0.55 | 125 | $ 68.75 | 30 | 11/05/11 | 5 | 11/10/11 |
| Jones Suppilers | 1001 | 1212 | 1122 | Doll Body | $ 4.25 | 500 | $ 2,125.00 | 30 | 08/05/11 | 7 | 08/13/11 |
| Jones Suppilers | 1001 | 1313 | 3166 | Doll Wigs | $ 1.25 | 600 | $ 750.00 | 30 | 08/25/11 | 5 | 08/29/11 |
| Razor Accessories | 1008 | 2211 | 9764 | Doll Appendages pkg | $ 3.75 | 850 | $ 3,187.50 | 15 | 09/25/11 | 6 | 10/05/11 |
| First Vendor | 1007 | 2222 | 7258 | Car Wheels 4 pk | $ 1.50 | 900 | $ 1,350.00 | 30 | 10/10/11 | 7 | 10/17/11 |
| Jones Suppilers | 1001 | 2323 | 1122 | Doll Body | $ 4.25 | 500 | $ 2,125.00 | 30 | 09/04/11 | 8 | 09/12/11 |
| Jones Suppilers | 1001 | 2929 | 3166 | Doll Wigs | $ 1.25 | 500 | $ 625.00 | 30 | 09/01/11 | 5 | 09/06/11 |
| Jones Suppilers | 1001 | 3232 | 1122 | Doll Body | $ 4.25 | 1,000 | $ 4,250.00 | 30 | 10/01/11 | 7 | 10/08/11 |
| Jones Suppilers | 1001 | 3434 | 1122 | Doll Body | $ 4.25 | 500 | $ 2,125.00 | 30 | 09/05/11 | 7 | 09/11/11 |
| Jones Suppilers | 1001 | 4545 | 1122 | Doll Body | $ 4.25 | 1,000 | $ 4,250.00 | 30 | 09/08/11 | 7 | 09/15/11 |
| Jones Suppilers | 1001 | 5656 | 1122 | Doll Body | $ 4.25 | 500 | $ 2,125.00 | 30 | 09/28/11 | 7 | 10/03/11 |
| Jones Suppilers | 1001 | 6765 | 5066 | String/ft. | $ 0.95 | 500 | $ 475.00 | 30 | 09/05/11 | 8 | 09/12/11 |
| Jones Suppilers | 1001 | 7875 | 3166 | Doll Wigs | $ 1.25 | 650 | $ 812.50 | 30 | 09/05/11 | 5 | 09/10/11 |
| Jones Suppilers | 1001 | 8854 | 3166 | Doll Wigs | $ 1.25 | 425 | $ 531.25 | 30 | 09/10/11 | 5 | 09/15/11 |
| Razor Accessories | 1008 | 1111 | 9764 | Doll Appendages pkg | $ 3.75 | 800 | $ 3,000.00 | 15 | 09/28/11 | 5 | 10/05/11 |
| Jones Suppilers | 1001 | 1212 | 5066 | String/ft. | $ 0.95 | 500 | $ 475.00 | 30 | 09/15/11 | 8 | 09/22/11 |
| Jones Suppilers | 1001 | 2121 | 1122 | Doll Body | $ 4.25 | 500 | $ 2,125.00 | 30 | 10/25/11 | 8 | 11/03/11 |
| Jones Suppilers | 1001 | 3232 | 1122 | Doll Body | $ 4.25 | 1,000 | $ 4,250.00 | 30 | 10/11/11 | 8 | 10/19/11 |
| Razor Accessories | 1008 | 3333 | 9764 | Doll Appendages pkg | $ 3.75 | 750 | $ 2,812.50 | 15 | 09/20/11 | 5 | 09/25/11 |
Aiavker621
