ipl-logo

SS2AssignmentUpdated

.xlsx
School
Rutgers University**We aren't endorsed by this school
Course
UNKNOWN 602
Subject
Chemistry
Date
Dec 16, 2024
Pages
9
Uploaded by UltraInternet15746
rderDate20RegionStateCategoryProductQuantity UnitPricePriceTaxTotal_Price2nd QtrSouthFL Orange9764.2475784145.636 Not Found3rd QtrCentralMOSeltzer994 4.127725 4102.9590.042252nd QtrEastNJCranberry967 4.2375184097.680.066253rd QtrWestCA Purified9664.2077544064.69 Not Found2nd QtrEastNJOrange9554.24955 4058.3210.066254th QtrCentralMOApple 991 4.084888 4048.1240.042251st QtrCentralMOGinger Ale9684.13185 3999.6310.042253rd QtrCentralNYSeltzer9524.1858873984.964 Not Found1st QtrNorthMI Orange10003.9728553972.855 Not Found3rd QtrSouthFL Ginger Ale9684.0889463958.099 Not Found2nd QtrWestCA Cola9893.9298683886.639 Not Found1st QtrWestCA Orange9903.8928143853.886 Not Found1st QtrCentralMOCola951 4.010188 3813.6890.042251st QtrEastNJCranberry9084.1746 3790.5370.066252nd QtrWestCA Cranberry9364.0482993789.208 Not Found1st QtrWestCA Ginger Ale9663.8930423760.679 Not Found4th QtrCentralMOSpring903 4.154404 3751.4270.042254th QtrCentralCNGinger Ale9653.8806523744.829 Not Found1st QtrCentralMOMineral884 4.2200343730.510.042254th QtrWestCA Spring9314.0016113725.5 Not Found2nd QtrCentralMOSeltzer974 3.8217863722.420.042251st QtrNorthMI Cola9533.8838053701.266 Not Found3rd QtrEastNJOrange935 3.953116 3696.1640.066252nd QtrEastNJOrange910 4.056185 3691.1290.066253rd QtrWestCA Seltzer9723.7697723664.219 Not Found4th QtrEastNJOrange943 3.883498 3662.1390.066251st QtrEastNJMineral930 3.899186 3626.2430.066254th QtrWestCA Ginger Ale8554.2392473624.556 Not Found1st QtrEastNJOrange923 3.921513 3619.5560.066253rd QtrCentralMOGinger Ale941 3.796894 3572.8770.042254th QtrCentralMOPurified881 4.053298 3570.9550.042251st QtrEastNJCola882 4.042682 3565.6460.066254th QtrCentralMOSeltzer922 3.856459 3555.6560.042252nd QtrEastNJCranberry884 4.018454 3552.3130.066251st QtrWestCA Orange9023.9118413528.48 Not Found1st QtrSouthFL Cranberry9253.8131373527.151 Not Found3rd QtrEastNJPurified919 3.832885 3522.4220.066251st QtrWestCA Cola9343.7678313519.154 Not Found4th QtrNorthMI Seltzer9343.7644433515.99 Not Found2nd QtrEastNJGinger Ale871 3.998468 3482.6650.066251st QtrWestCA Seltzer8124.2433693445.616 Not Found4th QtrSouthFL Purified8803.9101953440.971 Not Found4th QtrWestPACranberry8553.9888673410.481 Not Found1st QtrCentralMOGinger Ale863 3.947958 3407.0880.04225
Background image
4th QtrWestCA Apple 8024.2051893372.561 Not Found1st QtrSouthFL Cola8284.0509453354.182 Not Found4th QtrNorthMI Ginger Ale8893.7633223345.593 Not Found1st QtrWestCA Spring8324.0022643329.884 Not Found4th QtrCentralMOGinger Ale823 4.015109 3304.4350.042254th QtrWestCA Ginger Ale8573.8516783300.888 Not Found1st QtrWestCA Mineral8513.8781613300.315 Not Found1st QtrCentralMOSeltzer850 3.880413 3298.3510.042251st QtrWestCA Cranberry8244.0005693296.468 Not Found4th QtrNorthMI Purified8353.9313453282.673 Not Found1st QtrCentralMOGinger Ale861 3.808543 3279.1560.042253rd QtrNorthMI Cola8573.8203143274.009 Not Found4th QtrEastNJSeltzer770 4.242461 3266.6950.066252nd QtrWestCA Apple 8193.9880043266.175 Not Found4th QtrWestNYApple 8363.9013383261.518 Not Found1st QtrWestCA Ginger Ale7954.0768513241.097 Not Found2nd QtrCentralMOSpring783 4.039645 3163.0420.042251st QtrSouthFL Apple 8333.7778183146.923 Not Found2nd QtrWestCA Ginger Ale7594.1400993142.335 Not Found1st QtrEastNJMineral760 4.069045 3092.4740.066253rd QtrEastNJSeltzer752 4.082946 3070.3750.066252nd QtrWestCA Orange7983.8364583061.493 Not Found4th QtrEastNJMineral793 3.834274 3040.5790.066252nd QtrNorthMI Cola7733.9243633033.533 Not Found3rd QtrNorthMI Orange7424.0850963031.141 Not Found4th QtrNorthMI Orange7334.1211793020.824 Not Found4th QtrCentralMOSeltzer794 3.794224 3012.6140.042252nd QtrCentralMOPurified767 3.9268193011.870.042251st QtrSouthFL Spring8023.7547513011.31 Not Found3rd QtrEastNJCola714 4.2151263009.60.066251st QtrSouthFL Seltzer7723.8896343002.798 Not Found1st QtrWestCA Apple 7374.071293000.541 Not Found2nd QtrNorthMI Seltzer7513.9927752998.574 Not Found1st QtrNorthMI Cola7523.9601722978.049 Not Found4th QtrEastNJApple 728 4.058009 2954.2310.066254th QtrSouthFL Cola7354.0139312950.239 Not Found4th QtrSouthFL Orange7713.8166122942.608 Not Found4th QtrEastNJSeltzer725 4.023063 2916.7210.066252nd QtrEastNJSpring682 4.239394 2891.2670.066252nd QtrCentralMOOrange681 4.240332 2887.6660.042254th QtrEastNJOrange761 3.792503 2886.0950.066252nd QtrWestCA Seltzer7044.091312880.282 Not Found4th QtrNorthMI Cranberry6844.1774442857.372 Not Found2nd QtrCentralMEApple 7483.7926392836.894 Not Found2nd QtrWestCA Cranberry6744.1902832824.251 Not Found
Background image
3rd QtrEastNJSeltzer710 3.959993 2811.5950.066251st QtrCentralMOPurified741 3.784641 2804.4190.042251st QtrSouthFL Cranberry6884.0751372803.694 Not Found3rd QtrWestCA Ginger Ale6724.1380912780.797 Not Found3rd QtrSouthFL Orange7073.9218662772.759 Not Found4th QtrEastNJGinger Ale685 3.981089 2727.0460.066252nd QtrNorthMI Orange6524.1692642718.36 Not Found2nd QtrEastNJSeltzer656 4.129107 2708.6940.066252nd QtrNorthMI Spring7133.7904532702.593 Not Found2nd QtrCentralMOCranberry712 3.7733422686.620.042254th QtrEastNJSpring643 4.173645 2683.6540.066251st QtrEastNJOrange663 4.005542 2655.6740.066252nd QtrSouthFL Seltzer6414.1056182631.701 Not Found3rd QtrEastNJCola642 4.095034 2629.0120.066253rd QtrCentralMOMineral638 4.118421 2627.5530.042254th QtrWestCA Cola6883.8081672620.019 Not Found2nd QtrNorthMI Spring6603.9600372613.624 Not Found4th QtrCentralMOMineral644 4.041737 2602.8790.042251st QtrEastNJApple 688 3.775346 2597.4380.066252nd QtrCentralMOOrange614 4.195811 2576.2280.042253rd QtrEastNJOrange622 4.104799 2553.1850.066252nd QtrSouthFL Orange6184.1129592541.808 Not Found2nd QtrWestCA Cranberry6064.1525672516.455 Not Found1st QtrEastNJOrange618 4.028706 2489.7410.066254th QtrWestCA Ginger Ale6094.0656842476.001 Not Found1st QtrWestCA Apple 6463.8043482457.609 Not Found4th QtrWestCOOrange6403.8312082451.973 Not Found3rd QtrNorthMI Purified6084.0134932440.204 Not Found4th QtrWestCA Purified5884.1476652438.827 Not Found3rd QtrSouthFL Cola6303.8599772431.785 Not Found2nd QtrCentralMOMineral628 3.842144 2412.8660.042251st QtrEastNJOrange5834.13124 2408.5130.066251st QtrSouthFL Cola5974.0152652397.113 Not Found1st QtrCentralMOSeltzer632 3.792068 2396.5870.042253rd QtrEastNJCola6013.96231 2381.3480.066252nd QtrWestCA Purified6243.8122072378.817 Not Found4th QtrEastNJCola600 3.953027 2371.8160.066252nd QtrCentralMOApple 6073.90317 2369.2240.042254th QtrSouthFL Seltzer6193.8211082365.266 Not Found2nd QtrEastNJApple 575 4.095169 2354.7220.066252nd QtrEastNJCola562 4.165858 2341.2120.066252nd QtrCentralMOOrange572 4.023631 2301.5170.042253rd QtrSouthFL Purified5813.9043822268.446 Not Found2nd QtrWestCA Apple 5973.7603552244.932 Not Found3rd QtrCentralMOApple 549 4.045026 2220.7190.04225
Background image
2nd QtrCentralMOCranberry535 4.135222 2212.3440.042252nd QtrWestCA Orange5793.8061252203.747 Not Found1st QtrWestCA Cranberry5354.109512198.588 Not Found3rd QtrSouthFL Apple 5414.0554342193.99 Not Found3rd QtrNorthMI Cola5643.886382191.918 Not Found3rd QtrWestCA Cranberry5523.953652182.415 Not Found1st QtrSouthFL Orange5593.894152176.83 Not Found2nd QtrWestCA Ginger Ale5324.0813592171.283 Not Found4th QtrWestCA Ginger Ale5124.2114922156.284 Not Found3rd QtrSouthFL Apple 5204.131622148.442 Not Found1st QtrEastNJPurified505 4.220686 2131.4470.066252nd QtrWestCA Cranberry5044.220072126.915 Not Found2nd QtrCentralMOSpring535 3.9605422118.890.042253rd QtrCentralMOSeltzer512 4.116008 2107.3960.042253rd QtrEastNJOrange495 4.2439192100.740.066252nd QtrWestCA Seltzer5463.7663512056.428 Not Found4th QtrCentralMOSpring4864.20921 2045.6760.042251st QtrEastNJMineral519 3.820538 1982.8590.066254th QtrCentralMOOrange489 3.977288 1944.8940.042253rd QtrNorthMI Spring5043.8460511938.41 Not Found3rd QtrEastNJGinger Ale498 3.874763 1929.6320.066253rd QtrEastNJOrange496 3.864019 1916.5540.066253rd QtrCentralMOPurified492 3.857912 1898.0930.042253rd QtrCentralMOSpring479 3.925937 1880.5240.042254th QtrSouthFL Mineral4753.9454641874.095 Not Found4th QtrCentralMOCranberry4564.04821 1845.9840.042251st QtrSouthFL Cola4613.9823821835.878 Not Found4th QtrCentralMOMineral480 3.820841 1834.0040.042251st QtrCentralMOCranberry461 3.9773111833.540.042254th QtrCentralMOGinger Ale454 4.0203291825.230.042254th QtrNorthMI Ginger Ale4514.0338881819.284 Not Found3rd QtrSouthFL Seltzer4314.2155511816.902 Not Found1st QtrNorthMI Seltzer4733.8250221809.235 Not Found1st QtrCentralMOOrange440 4.069824 1790.7220.042251st QtrEastNJOrange471 3.793286 1786.6370.066252nd QtrWestCA Cola4523.9408391781.259 Not Found4th QtrEastNJGinger Ale454 3.918923 1779.1910.066253rd QtrSouthFL Cola4553.9047121776.644 Not Found2nd QtrEastNYCola4134.2102481738.832 Not Found2nd QtrEastNJCola412 4.2133491735.90.066252nd QtrCentralMOMineral449 3.855878 1731.2890.042251st QtrSouthFL Cranberry4423.907081726.929 Not Found2nd QtrCentralMOSeltzer436 3.952788 1723.4160.042254th QtrEastNJSeltzer434 3.905956 1695.1850.066253rd QtrEastNJApple 443 3.797272 1682.1910.06625
Background image
3rd QtrSouthFL Seltzer4453.7508331669.121 Not Found1st QtrNorthMI Purified3834.2272891619.052 Not Found3rd QtrCentralMOPurified396 4.059109 1607.4070.042251st QtrNorthMI Apple 3894.1082561598.112 Not Found2nd QtrEastNJSpring393 4.053585 1593.0590.066253rd QtrSouthFL Cola3993.9764051586.585 Not Found1st QtrNorthMI Apple 4133.8391591585.573 Not Found4th QtrCentralMOGinger Ale383 4.121474 1578.5250.042253rd QtrWestCA Mineral4073.8686611574.545 Not Found4th QtrCentralMOApple 401 3.897046 1562.7160.042251st QtrCentralMOCranberry390 3.9742311549.950.042251st QtrSouthFL Seltzer4073.7519191527.031 Not Found4th QtrWestCA Cola3804.0070681522.686 Not Found4th QtrWestCA Apple 3823.9789351519.953 Not Found2nd QtrEastNJApple 360 4.219164 1518.8990.066251st QtrSouthFL Orange3784.0180681518.83 Not Found4th QtrCentralMOOrange356 4.243513 1510.6910.042251st QtrEastNJSeltzer373 4.0405371507.120.066253rd QtrNorthMI Purified3903.8594731505.194 Not Found1st QtrWestCA Spring3933.7615621478.294 Not Found3rd QtrCentralMOApple 351 4.183118 1468.2740.042252nd QtrCentralMOMineral385 3.763669 1449.0120.042253rd QtrSouthCNSeltzer3673.8684631419.726 Not Found1st QtrWestCA Ginger Ale3474.0879051418.503 Not Found1st QtrSouthFL Seltzer3743.7812361414.182 Not Found2nd QtrEastNJApple 340 4.102816 1394.9580.066251st QtrCentralMOCranberry361 3.774812 1362.7070.042251st QtrWestCA Apple 3234.0761321316.591 Not Found1st QtrSouthFL Orange3174.1280711308.599 Not Found3rd QtrCentralMOSpring313 4.158057 1301.4720.042252nd QtrEastNJOrange341 3.796031 1294.4460.066251st QtrNorthMI Spring3263.9059021273.324 Not Found2nd QtrSouthFL Apple 3114.0038141245.186 Not Found2nd QtrCentralMOCranberry324 3.812693 1235.3130.042253rd QtrWestCA Cola2934.1627441219.684 Not Found1st QtrSouthFL Cola3063.9543661210.036 Not Found3rd QtrCentralMOCola308 3.804961 1171.9280.042251st QtrEastNJPurified302 3.869467 1168.5790.066252nd QtrEastNJCranberry293 3.967739 1162.5480.066254th QtrEastNJSeltzer286 3.990058 1141.1570.066252nd QtrNorthMI Mineral2804.0255721127.16 Not Found3rd QtrCentralMOApple 270 4.160606 1123.3640.042251st QtrCentralMOCola296 3.761125 1113.2930.042253rd QtrCentralMOGinger Ale283 3.925046 1110.7880.042252nd QtrCentralMOApple 275 3.958622 1088.6210.04225
Background image
4th QtrEastNJPurified272 3.999328 1087.8170.066254th QtrNorthMI Cranberry2584.1739691076.884 Not Found1st QtrEastNJMineral284 3.771243 1071.0330.066253rd QtrWestCA Apple 2484.0734481010.215 Not Found1st QtrWestCOCola2603.8596081003.498 Not Found4th QtrEastNJMineral260 3.848719 1000.6670.066252nd QtrSouthFL Ginger Ale2384.158822989.7997 Not Found1st QtrEastNJGinger Ale235 4.197122 986.32360.066251st QtrEastNJCranberry233 4.165594 970.58340.066254th QtrSouthFL Mineral2304.159927956.7833 Not Found3rd QtrWestCA Cola2274.153656942.8798 Not Found3rd QtrWestCA Purified2343.992436934.2301 Not Found3rd QtrSouthFL Apple 2314.025024929.7806 Not Found2nd QtrEastNJGinger Ale240 3.788218 909.17240.066252nd QtrEastNJCranberry221 4.020574 888.54690.066252nd QtrWestCA Cranberry2154.076766876.5047 Not Found2nd QtrNorthMNGinger Ale2124.112903871.9354 Not Found1st QtrEastNJMineral223 3.834408 855.07310.066251st QtrWestCA Orange2233.804348848.3695 Not Found3rd QtrSouthFL Ginger Ale2043.881074791.739 Not FoundNot FoundNot FoundNot FoundNot FoundNot Found
Background image
Extra_1Extra_2Extra_3VLOOKUP TABLE #1STATETAXVLOOKUP TABLE #2PRODUCT CATEGORY
Background image
`
Background image
StateTax RateMO0.04225NJ0.06625FL0.06MI0.06CA0.0725
Background image