You are an accountant for U.S. Outdoor Adventures and are asked to prepare an anlysis of sales for the monthly internal sales analysis report. Prepare following analysis and...

1 answer below »


































































































































































































































































































































































































































You are an accountant for U.S. Outdoor Adventures and are asked to prepare an anlysis of sales for the monthly internal sales analysis report. Prepare following analysis and visualizations:



1.


Create an Excel PivotTable to identify if there is a monthly sales pattern for total sales from 2023 to 2025. Format the PivotTable so that the sales amounts are in currency with zero decimal places.





2.


Create a bar chart of monthly sales from 2023 to 2025. Does this chart help you determine if there is a monthly sales pattern? Why or why not?





3.


Dig Deeper: Create a PivotTable and a line chart to illustrate monthly sales patterns by product category for 2023 - 2025. What does the line chart reveal about product category sales patterns?





Sheet1 IDOrder IDOrder DateShip DateCustomer IDCustomer NameCityStateCountryPostal CodeMarketRegionSegmentCategorySub-CategoryShip ModeOrder PrioritySalesQuantityUnit PriceDiscountDiscount $Unit CostShipping CostProfit 1CA-2020-1151611/2/223/2/22LC-17050Liz CarlisleMission ViejoCaliforniaUnited States92691USWestRetailTentsBase Camp ModelFirst ClassHigh$ 290.672145.330.1543.60232.6154.643.42 3CA-2020-1042691/3/226/3/22DB-13060Dave BrooksSeattleWashingtonUnited States98115USWestRetailTentsMountain Tent - 4 PersonSecond ClassMedium$ 457.572228.780.291.51358.2047.8951.48 4CA-2020-1683121/3/227/3/22GW-14605Giulietta WeimerHoustonTexasUnited States77036USCentralRetailTentsNorthface subzeroStandard ClassMedium$ 376.513125.500.3112.95386.8432.70-43.03 6CA-2020-1683121/3/227/3/22GW-14605Giulietta WeimerHoustonTexasUnited States77036USCentralRetailCamping GearPropane Portable GrillStandard ClassMedium$ 137.35345.780.227.47120.288.498.58 11US-2020-1437071/3/225/3/22HR-14770Hallie RedmondNew York CityNew YorkUnited States10035USEastTravel CompanyPaddlePaddlesStandard ClassMedium$ 5.9431.9800.003.920.421.60 5CA-2020-1310091/3/225/3/22SC-20380Shahid CollisterEl PasoTexasUnited States79907USCentralRetailTentsMountain Tent - 4 PersonStandard ClassMedium$ 362.25660.380.3108.68337.0325.220.00 7CA-2020-1310091/3/225/3/22SC-20380Shahid CollisterEl PasoTexasUnited States79907USCentralRetailCamping GearPropane Portable GrillStandard ClassMedium$ 129.55343.180.225.91144.228.00-22.67 8CA-2020-1310091/3/225/3/22SC-20380Shahid CollisterEl PasoTexasUnited States79907USCentralRetailTentsBackpacking TentStandard ClassMedium$ 63.55610.590.638.1391.137.38-34.95 9CA-2020-1310091/3/225/3/22SC-20380Shahid CollisterEl PasoTexasUnited States79907USCentralRetailCamping GearFastenersStandard ClassMedium$ 18.8453.770.23.7720.322.05-3.53 2CA-2020-1138801/3/225/3/22VF-21715Vicky FreymannElmhurstIllinoisUnited States60126USCentralTravel CompanyTentsMountain Tent - 4 PersonStandard ClassHigh$ 634.126105.690.3190.23736.1870.05-172.12 10CA-2020-1138801/3/225/3/22VF-21715Vicky FreymannElmhurstIllinoisUnited States60126USCentralTravel CompanyCamping GearFirst Aid KitStandard ClassHigh$ 17.4735.820.23.499.851.945.68 13CA-2020-1383591/4/226/4/22KH-16330Katharine HarmsRevereMassachusettsUnited States2151USEastConsumerCamping GearPropane Portable GrillStandard ClassMedium$ 66.96416.7400.0062.711.572.68 15CA-2020-1383591/4/226/4/22KH-16330Katharine HarmsRevereMassachusettsUnited States2151USEastConsumerCamping GearMicro Cooking unitStandard ClassMedium$ 6.2423.1200.002.840.343.06 12US-2020-1570211/4/226/4/22KM-16720Kunst MillerVallejoCaliforniaUnited States94591USWestRetailCamping GearFirestarter KitSecond ClassMedium$ 29.60214.8000.0011.793.0114.80 14US-2020-1570211/4/226/4/22KM-16720Kunst MillerVallejoCaliforniaUnited States94591USWestRetailCamping GearMicro Cooking unitSecond ClassMedium$ 17.0944.270.23.4210.880.655.55 19CA-2020-1110031/6/226/6/22CR-12625Corey RoperLakewoodNew JerseyUnited States8701USEastTravel CompanyCamping GearCook setStandard ClassMedium$ 289.20648.2000.00191.0014.3383.87 26CA-2020-1110031/6/226/6/22CR-12625Corey RoperLakewoodNew JerseyUnited States8701USEastTravel CompanyCamping GearMicro Cooking unitStandard ClassMedium$ 45.48315.1600.0023.211.3520.92 16CA-2020-1319261/6/226/6/22DW-13480Dianna WilsonLakevilleMinnesotaUnited States55044USCentralTravel CompanyCamping GearCamp stoveSecond ClassMedium$ 1,503.255300.6500.00886.34120.84496.07 18CA-2020-1319261/6/226/6/22DW-13480Dianna WilsonLakevilleMinnesotaUnited States55044USCentralTravel CompanyTentsMountain Tent - 4 PersonSecond ClassMedium$ 2,001.867285.9800.001,339.9381.39580.54 21CA-2020-1319261/6/226/6/22DW-13480Dianna WilsonLakevilleMinnesotaUnited States55044USCentralTravel CompanyCamping GearPropane Portable GrillSecond ClassMedium$ 166.72283.3600.00116.938.1141.68 23CA-2020-1319261/6/226/6/22DW-13480Dianna WilsonLakevilleMinnesotaUnited States55044USCentralTravel CompanyCamping GearFirst Aid KitSecond ClassMedium$ 47.8867.9800.0019.674.2723.94 25CA-2020-1319261/6/226/6/22DW-13480Dianna WilsonLakevilleMinnesotaUnited States55044USCentralTravel CompanyCamping GearFirst Aid KitSecond ClassMedium$ 25.9246.4800.0010.972.5112.44 17US-2020-1656591/6/226/6/22LT-17110Liz ThompsonLittle RockArkansasUnited States72209USSouthRetailPaddlePaddlesStandard ClassHigh$ 881.937125.9900.00540.31112.32229.30 24US-2020-1656591/6/226/6/22LT-17110Liz ThompsonLittle RockArkansasUnited States72209USSouthRetailTentsBackpacking TentStandard ClassHigh$ 22.2063.7000.0010.422.689.10 20US-2020-1570701/6/226/6/22QJ-19255Quincy JonesDetroitMichiganUnited States48234USCentralConsumerCamping GearMicro Cooking unitStandard ClassMedium$ 138.56434.6400.0060.7911.2666.51 22US-2020-1570701/6/226/6/22QJ-19255Quincy JonesDetroitMichiganUnited States48234USCentralConsumerCamping GearCamp stoveStandard ClassMedium$ 65.52513.100.16.5547.345.8012.38 28CA-2020-1531501/7/226/7/22Dl-13600Dorris liebeSeattleWashingtonUnited States98105USWestConsumerCamping GearMicro Cooking unitSecond ClassMedium$ 19.9253.980.23.9811.511.446.97 27CA-2020-1607731/7/225/7/22LW-16825Laurel WorkmanDeltonaFloridaUnited States32725USSouthConsumerPaddlePaddlesStandard ClassHigh$ 575.922287.960.2115.18410.8393.1071.99 29CA-2020-1607731/7/225/7/22LW-16825Laurel WorkmanDeltonaFloridaUnited States32725USSouthConsumerCamping GearMicro Cooking unitStandard ClassHigh$ 5.1860.860.73.638.120.69-3.63 35CA-2020-1626841/8/226/8/22AS-10630Ann SteelePhiladelphiaPennsylvaniaUnited States19120USEastTravel CompanyCamping GearFastenersStandard ClassHigh$ 5.6822.840.21.142.990.771.92 30CA-2020-1173451/8/225/8/22BF-10975Barbara FisherCharlotteNorth CarolinaUnited States28205USSouthConsumerCamping GearFirst Aid KitStandard ClassMedium$ 78.30239.150.215.6641.857.0929.36 31CA-2020-1173451/8/225/8/22BF-10975Barbara FisherCharlotteNorth CarolinaUnited States28205USSouthConsumerCamping GearCamp stoveStandard ClassMedium$ 62.92162.920.212.5847.085.6210.22 32CA-2020-1173451/8/225/8/22BF-10975Barbara FisherCharlotteNorth CarolinaUnited States28205USSouthConsumerTentsBackpacking TentStandard ClassMedium$ 44.13411.030.28.8327.684.3112.14 34CA-2020-1173451/8/225/8/22BF-10975Barbara FisherCharlotteNorth CarolinaUnited States28205USSouthConsumerCamping GearFirestarter KitStandard ClassMedium$ 17.5435.850.23.5110.690.935.92 33CA-2020-1522961/8/223/8/22IL-15100Ivan ListonSan FranciscoCaliforniaUnited States94122USWestRetailCamping GearMicro Cooking unitFirst ClassHigh$ 19.7536.580.23.959.613.236.91 37CA-2020-1654281/9/224/9/22JL-15130Jack LebronHoustonTexasUnited States77036USCentralRetailCamping GearFirst Aid KitFirst ClassHigh$ 31.1065.180.26.2210.329.9010.89 40CA-2020-1654281/9/224/9/22JL-15130Jack LebronHoustonTexasUnited States77036USCentralRetailCamping GearMicro Cooking unitFirst ClassHigh$ 3.6531.220.82.928.970.70-6.02 39CA-2020-1265221/9/225/9/22LT-16765Larry TronEscondidoCaliforniaUnited States92025USWestRetailCamping GearCook setSecond ClassHigh$ 53.94317.9800.0036.501.8015.64 36CA-2020-1098551/9/225/9/22LH-16900Lena HernandezNew York CityNew YorkUnited States10009USEastRetailPaddleAccessoriesStandard ClassHigh$ 357.003119.0000.00268.2931.5957.12 38CA-2020-1098551/9/225/9/22LH-16900Lena HernandezNew York CityNew YorkUnited States10009USEastRetailCamping GearMicro Cooking unitStandard ClassHigh$ 23.74211.870.24.7513.062.378.31 41US-2020-1327451/10/225/10/22NF-18475Neil FranzösischRenoNevadaUnited States89502USWestTravel CompanyCamping GearFastenersStandard ClassHigh$ 4.7114.7100.004.080.630.00 45US-2020-1371551/11/225/11/22DL-12925Daniel LacyLong BeachNew YorkUnited States11561USEastRetailCamping GearCamp stoveStandard ClassMedium$ 533.943177.9800.00349.3729.73154.84 51US-2020-1371551/11/225/11/22DL-12925Daniel LacyLong BeachNew YorkUnited States11561USEastRetailCamping GearFirst Aid KitStandard ClassMedium$ 167.94355.9800.0082.822.8382.29 54US-2020-1371551/11/225/11/22DL-12925Daniel LacyLong BeachNew YorkUnited States11561USEastRetailTentsBackpacking TentStandard ClassMedium$ 31.6865.2800.0019.961.909.82 46CA-2020-1394231/11/225/11/22DG-13300Deirdre GreerOrangeNew JerseyUnited States7050USEastConsumerCamping GearCamp stoveStandard ClassHigh$ 76.12238.0600.0044.409.6522.07 48CA-2020-1141951/11/223/11/22EA-14035Erin AshbrookMasonOhioUnited States45040USEastConsumerTentsBackpacking TentFirst ClassMedium$ 68.70234.350.213.7444.947.4516.32 56CA-2020-1141951/11/223/11/22EA-14035Erin AshbrookMasonOhioUnited States45040USEastConsumerCamping GearMicro Cooking unitFirst ClassMedium$ 22.4337.480.715.7038.851.52-17.94 61CA-2020-1141951/11/223/11/22EA-14035Erin AshbrookMasonOhioUnited States45040USEastConsumerCamping GearMicro Cooking unitFirst ClassMedium$ 3.1321.570.72.195.640.10-2.61 47CA-2020-1525621/11/228/11/22JO-15145Jack O'BriantRichmondKentuckyUnited States40475USSouthConsumerCamping GearPropane Portable GrillStandard ClassLow$ 69.52234.7600.0041.848.2119.47 59CA-2020-1525621/11/228/11/22JO-15145Jack O'BriantRichmondKentuckyUnited States40475USSouthConsumerCamping GearCook setStandard ClassLow$ 5.6431.8800.003.250.751.64 43CA-2020-1026731/11/225/11/22KH-16630Ken HeidelCharlotteNorth CarolinaUnited States28205USSouthConsumerPaddlePaddlesStandard ClassMedium$ 978.849108.760.2195.77811.9256.80110.12 49CA-2020-1026731/11/225/11/22KH-16630Ken HeidelCharlotteNorth CarolinaUnited States28205USSouthConsumerCamping GearFirestarter KitStandard ClassMedium$ 47.81123.980.29.5628.483.7915.54 57CA-2020-1026731/11/225/11/22KH-16630Ken HeidelCharlotteNorth CarolinaUnited States28205USSouthConsumerCamping GearCook setStandard ClassMedium$ 10.2733.420.22.058.161.210.90 60CA-2020-1026731/11/225/11/22KH-16630Ken HeidelCharlotteNorth CarolinaUnited States28205USSouthConsumerCamping GearFastenersStandard ClassMedium$ 7.5251.500.21.505.780.331.41 44CA-2020-1489151/11/225/11/22ND-18370Natalie DeCherneyPortlandOregonUnited States97206USWestRetailCamping GearPropane Portable GrillStandard ClassHigh$ 443.92588.780.288.78483.8154.44-94.33 50CA-2020-1489151/11/225/11/22ND-18370Natalie DeCherneyPortlandOregonUnited States97206USWestRetailPaddlePaddlesStandard ClassHigh$ 155.98351.990.231.2097.643.7454.59 52CA-2020-1683051/11/228/11/22PL-18925Paul LucasLos AngelesCaliforniaUnited States90049USWestTravel CompanyCamping GearFirestarter KitStandard ClassMedium$ 44.40314.8000.0019.432.7722.20 58CA-2020-1683051/11/228/11/22PL-18925Paul LucasLos AngelesCaliforniaUnited States90049USWestTravel CompanyCamping GearFirst Aid KitStandard ClassMedium$ 21.4054.2800.0010.850.929.63 42CA-2020-1343131/11/227/11/22RA-19915Russell ApplegateDenverColoradoUnited States80219USWestRetailPaddlePaddlesStandard ClassMedium$ 1,983.974495.990.2396.791,500.84235.13248.00 53CA-2020-1343131/11/227/11/22RA-19915Russell ApplegateDenverColoradoUnited States80219USWestRetailCamping GearCook setStandard ClassMedium$ 43.18314.390.28.6436.742.124.32 55CA-2020-1269071/11/228/11/22SM-20950Suzanne McNairChicagoIllinoisUnited States60610USCentralConsumerCamping GearFirst Aid KitStandard ClassLow$ 15.7035.230.23.148.771.825.10 65CA-2020-1432101/12/223/12/22AA-10645Anna AndreadiLowellMassachusettsUnited States1852USEastRetailPaddlePaddlesFirst ClassHigh$ 271.902135.9500.00130.5162.5478.85 68CA-2020-1432101/12/223/12/22AA-10645Anna AndreadiLowellMassachusettsUnited States1852USEastRetailTentsBackpacking TentFirst ClassHigh$ 45.84315.2800.0024.415.8415.59 72CA-2020-1432101/12/223/12/22AA-10645Anna AndreadiLowellMassachusettsUnited States1852USEastRetailTentsBackpacking TentFirst ClassHigh$ 9.8224.9100.005.311.273.24 63CA-2020-1507981/12/223/12/22JK-15730Joe KamberovaColumbusOhioUnited States43229USEastRetailTentsMountain Tent - 4 PersonSecond ClassMedium$ 909.726151.620.3272.92828.50133.20-51.98 66CA-2020-1507981/12/223/12/22JK-15730Joe KamberovaColumbusOhioUnited States43229USEastRetailPaddleKayakSecond ClassMedium$ 659.992329.990.4264.00489.6960.30110.00 71CA-2020-1507981/12/223/12/22JK-15730Joe KamberovaColumbusOhioUnited States43229USEastRetailCamping GearFirst Aid KitSecond ClassMedium$ 36.2975.180.27.2621.761.8312.70 73CA-2020-1507981/12/223/12/22JK-15730Joe KamberovaColumbusOhioUnited States43229USEastRetailTentsBackpacking TentSecond ClassMedium$ 8.1324.060.21.635.770.941.42 64US-2020-1616131/12/223/12/22MC-17605Matt ConnellHoustonTexasUnited States77070USCentralConsumerTentsMountain Tent - 4 PersonSecond ClassCritical$ 674.063224.690.3202.22570.00123.32-19.26 62CA-2020-1204741/12/223/12/22RP-19390Resi PölkingMadisonWisconsinUnited States53711USCentralRetailTentsMountain Tent - 4 PersonFirst ClassHigh$ 2,807.848350.9800.001,646.81487.15673.88 67CA-2020-1204741/12/223/12/22RP-19390Resi PölkingMadisonWisconsinUnited States53711USCentralRetailCamping GearCook setFirst ClassHigh$ 46.64411.6600.0025.178.8812.59 70CA-2020-1315271/12/227/12/22TB-21280Toby BraunhardtJacksonvilleNorth CarolinaUnited States28540USSouthRetailPaddlePaddlesStandard ClassMedium$ 95.97423.990.219.1981.694.689.60 69CA-2020-1310511/12/225/12/22TR-21325Toby RitterSan FranciscoCaliforniaUnited States94122USWestRetailTentsBackpacking TentStandard ClassMedium$ 58.20319.4000.0024.894.7928.52 4313CA-2020-1571471/14/22BD-11605Brian DahlenSan FranciscoCaliforniaUnited States94109USWestRetailCamping GearPropane Portable GrillStandard ClassHigh$ 1,325.855265.1700.00899.55187.65238.65 4317CA-2020-1571471/14/22BD-11605Brian DahlenSan FranciscoCaliforniaUnited States94109USWestRetailTentsBase Camp ModelStandard ClassHigh$ 334.003111.330.1550.10289.6340.443.93 4319CA-2020-1571471/14/22BD-11605Brian DahlenSan FranciscoCaliforniaUnited States94109USWestRetailCamping GearCook setStandard ClassHigh$ 19.9053.9800.0010.303.036.57 4314CA-2020-1627751/14/22CS-12250Chris SelesnickBossier CityLouisianaUnited States71111USSouthConsumerCamping GearPropane Portable GrillSecond ClassCritical$ 572.58695.4300.00391.94146.2934.35 4315CA-2020-1627751/14/22CS-12250Chris SelesnickBossier CityLouisianaUnited States71111USSouthConsumerPaddleAccessoriesSecond ClassCritical$ 646.746107.7900.00246.69141.35258.70 4318CA-2020-1627751/14/22CS-12250Chris SelesnickBossier CityLouisianaUnited States71111USSouthConsumerCamping GearChairsSecond ClassCritical$ 50.94316.9800.0012.8112.6625.47 4320CA-2020-1627751/14/22CS-12250Chris SelesnickBossier CityLouisianaUnited States71111USSouthConsumerCamping GearChairsSecond ClassCritical$ 11.3625.6800.003.142.885.34 4322CA-2020-1627751/14/22CS-12250Chris SelesnickBossier CityLouisianaUnited States71111USSouthConsumerCamping GearMicro Cooking unitSecond ClassCritical$ 5.6431.8800.002.080.852.71 4321CA-2020-1181921/14/22MM-17920Michael MooreNewarkOhioUnited States43055USEastRetailCamping GearFirst Aid KitStandard ClassMedium$ 37.4175.340.27.4822.861.4613.09 4323CA-2020-1181921/14/22MM-17920Michael MooreNewarkOhioUnited States43055USEastRetailCamping GearMicro Cooking unitStandard ClassMedium$ 3.4421.720.72.415.690.27-2.52 4316CA-2020-1092321/14/22ND-18370Natalie DeCherneyMount PleasantSouth CarolinaUnited States29464USSouthRetailTentsMountain Tent - 4 PersonSecond ClassMedium$ 545.94690.9900.00406.2752.3287.35 4649CA-2020-1495241/15/22BS-11590Brendan SweedPhiladelphiaPennsylvaniaUnited States19140USEastConsumerTentsBase Camp ModelFirst ClassHigh$ 61.96415.490.530.98104.2910.96-53.29 4972CA-2020-1033661/16/22EH-13990Erica HackneyRoswellGeorgiaUnited States30076USSouthRetailPaddleAccessoriesFirst ClassCritical$ 149.95529.9900.0038.7345.2465.98 5250CA-2020-1157911/17/22DL-13315Delfina LatchfordPhiladelphiaPennsylvaniaUnited States19134USEastRetailTentsBackpacking TentSecond ClassCritical$ 127.10621.180.225.4262.1136.4028.60 5251CA-2020-1157911/17/22DL-13315Delfina LatchfordPhiladelphiaPennsylvaniaUnited States19134USEastRetailPaddlePaddlesSecond ClassCritical$ 124.20341.400.449.68129.1326.12-31.05 5252CA-2020-1157911/17/22DL-13315Delfina LatchfordPhiladelphiaPennsylvaniaUnited States19134USEastRetailCamping GearFirestarter KitSecond ClassCritical$ 30.07310.020.26.019.7510.1710.15 5253CA-2020-1157911/17/22DL-13315Delfina LatchfordPhiladelphiaPennsylvaniaUnited States19134USEastRetailCamping GearMicro Cooking unitSecond ClassCritical$ 18.5929.290.713.0126.965.26-13.63 5876CA-2020-1234771/19/22DW-13195David WienerSpringfieldOregonUnited States97477USWestConsumerCamping GearCamp stoveSecond ClassHigh$ 64.86416.220.212.9753.345.046.49 6206CA-2020-1465911/20/22TS-21340Toby SwindellScottsdaleArizonaUnited States85254USWestRetailTentsBase Camp ModelFirst ClassMedium$ 181.47536.290.7127.03472.3929.68-320.60 6207CA-2020-1465911/20/22TS-21340Toby SwindellScottsdaleArizonaUnited States85254USWestRetailCamping GearFirst Aid KitFirst ClassMedium$ 56.06414.020.211.2121.9514.4919.62 6208CA-2020-1465911/20/22TS-21340Toby SwindellScottsdaleArizonaUnited States85254USWestRetailCamping GearChairsFirst ClassMedium$ 108.72521.740.221.7461.6410.3936.69 6209CA-2020-1465911/20/22TS-21340Toby SwindellScottsdaleArizonaUnited States85254USWestRetailCamping GearMicro Cooking unitFirst ClassMedium$ 32.34103.230.722.6450.036.03-23.72 6591US-2020-1476271/21/22HL-15040Hunter LopezJonesboroArkansasUnited States72401USSouthRetailTentsMountain Tent - 4 PersonStandard ClassMedium$ 1,067.943355.9800.00757.9585.72224.27 6592US-2020-1476271/21/22HL-15040Hunter LopezJonesboroArkansasUnited States72401USSouthRetailPaddlePaddlesStandard ClassMedium$ 699.93799.9900.00486.4331.52181.98 6598US-2020-1476271/21/22HL-15040Hunter LopezJonesboroArkansasUnited States72401USSouthRetailCamping GearChairsStandard ClassMedium$ 23.3437.7800.009.772.6010.97 6599US-2020-1476271/21/22HL-15040Hunter LopezJonesboroArkansasUnited States72401USSouthRetailTentsBackpacking TentStandard ClassMedium$ 38.6049.6500.0024.452.5711.58 6601US-2020-1476271/21/22HL-15040Hunter LopezJonesboroArkansasUnited States72401USSouthRetailCamping GearCook setStandard ClassMedium$ 22.9673.2800.0015.081.226.66 6607US-2020-1476271/21/22HL-15040Hunter LopezJonesboroArkansasUnited States72401USSouthRetailCamping GearCook setStandard ClassMedium$ 6.6332.2100.004.370.471.79 6604CA-2020-1486141/21/22MV-17485Mark Van HuffLos AngelesCaliforniaUnited States90049USWestRetailCamping GearFirst Aid KitStandard ClassMedium$ 19.3629.6800.009.130.949.29 6606CA-2020-1486141/21/22MV-17485Mark Van HuffLos AngelesCaliforniaUnited States90049USWestRetailTentsBackpacking TentStandard ClassMedium$ 19.3029.6500.0012.870.645.79 6597US-2020-1477741/21/22MM-18280Muhammed MacIntyreSmyrnaTennesseeUnited States37167USSouthConsumerCamping GearMicro Cooking unitStandard ClassMedium$ 67.19167.190.747.04115.713.00-51.52 6593CA-2020-1679271/21/22XP-21865Xylona PreisWestlandMichiganUnited States48185USCentralRetailTentsBackpacking TentStandard ClassMedium$ 272.94390.9800.00222.2420.6830.02 6594CA-2020-1679271/21/22XP-21865Xylona PreisWestlandMichiganUnited States48185USCentralRetailCamping GearCamp stoveStandard ClassMedium$ 247.72461.930.124.77139.6014.5393.58 6595CA-2020-1679271/21/22XP-21865Xylona PreisWestlandMichiganUnited States48185USCentralRetailCamping GearPropane Portable GrillStandard ClassMedium$ 66.58233.2900.0042.208.4015.98 6596CA-2020-1679271/21/22XP-21865Xylona PreisWestlandMichiganUnited States48185USCentralRetailCamping GearCook setStandard ClassMedium$ 43.92314.6400.0026.304.8812.74 6600CA-2020-1679271/21/22XP-21865Xylona PreisWestlandMichiganUnited States48185USCentralRetailCamping GearMicro Cooking unitStandard ClassMedium$ 29.7055.9400.0014.361.9813.37 6602CA-2020-1679271/21/22XP-21865Xylona PreisWestlandMichiganUnited States48185USCentralRetailCamping GearMicro Cooking unitStandard ClassMedium$ 19.0553.8100.008.891.218.95 6603CA-2020-1679271/21/22XP-21865Xylona PreisWestlandMichiganUnited States48185USCentralRetailCamping GearPropane Portable GrillStandard ClassMedium$ 13.98113.9800.008.791.144.05 6605CA-2020-1679271/21/22XP-21865Xylona PreisWestlandMichiganUnited States48185USCentralRetailTentsBackpacking TentStandard ClassMedium$ 14.7334.9100.009.160.714.86 6993CA-2020-1104221/22/22TB-21400Tom BoeckenhauerMiamiFloridaUnited States33180USSouthRetailTentsBackpacking TentSecond ClassCritical$ 25.2538.420.25.0517.513.644.10 7634CA-2020-1026451/24/22IM-15055Ionia McGrathLas VegasNevadaUnited States89115USWestRetailCamping GearFirst Aid KitStandard ClassMedium$ 40.0866.6800.0016.534.3119.24 7635CA-2020-1469971/24/22SG-20605Speros GoranitisLafayetteIndianaUnited States47905USCentralRetailCamping GearFastenersStandard ClassHigh$ 5.9431.9800.004.990.950.00 8648CA-2020-1679971/27/22CA-11965Carol AdamsRapid CitySouth DakotaUnited States57701USCentralConsumerTentsBase Camp ModelFirst ClassHigh$ 141.96270.9800.0077.6224.5939.75 8654CA-2020-1679971/27/22CA-11965Carol AdamsRapid CitySouth DakotaUnited States57701USCentralConsumerCamping GearMicro Cooking unitFirst ClassHigh$ 10.6825.3400.004.271.395.02 8649US-2020-1555021/27/221/2/22SD-20485Shirley DanielsAlexandriaVirginiaUnited States22304USSouthTravel CompanyCamping GearPropane Portable GrillStandard ClassMedium$ 489.92861.2400.00468.4421.480.00 8650US-2020-1555021/27/221/2/22SD-20485Shirley DanielsAlexandriaVirginiaUnited States22304USSouthTravel CompanyPaddlePaddlesStandard ClassMedium$ 187.98293.9900.00117.6917.6652.63 8651US-2020-1555021/27/221/2/22SD-20485Shirley DanielsAlexandriaVirginiaUnited States22304USSouthTravel CompanyPaddlePaddlesStandard ClassMedium$ 155.351311.9500.00143.4011.950.00 8652US-2020-1555021/27/221/2/22SD-20485Shirley DanielsAlexandriaVirginiaUnited States22304USSouthTravel CompanyTentsBackpacking TentStandard ClassMedium$ 62.82320.9400.0025.896.1530.78 8653US-2020-1555021/27/221/2/22SD-20485Shirley DanielsAlexandriaVirginiaUnited States22304USSouthTravel CompanyCamping GearFirst Aid KitStandard ClassMedium$ 19.4436.4800.008.581.539.33 8655US-2020-1555021/27/221/2/22SD-20485Shirley DanielsAlexandriaVirginiaUnited States22304USSouthTravel CompanyCamping GearFirst Aid KitStandard ClassMedium$ 16.6828.3400.007.211.138.34 8656US-2020-1555021/27/221/2/22SD-20485Shirley DanielsAlexandriaVirginiaUnited States22304USSouthTravel CompanyTentsBackpacking TentStandard ClassMedium$ 12.4234.1400.007.520.434.47 8968US-2020-1171631/28/223/2/22EJ-13720Ed JacobsSan DiegoCaliforniaUnited States92037USWestRetailTentsNorthface subzeroStandard ClassMedium$ 333.003111.000.266.60326.2223.43-16.65 8969US-2020-1171631/28/223/2/22EJ-13720Ed JacobsSan DiegoCaliforniaUnited States92037USWestRetailCamping GearPropane Portable GrillStandard ClassMedium$ 57.23157.2300.0038.924.0014.31 8970US-2020-1171631/28/223/2/22EJ-13720Ed JacobsSan DiegoCaliforniaUnited States92037USWestRetailCamping GearCook setStandard ClassMedium$ 36.4449.1100.0021.163.2512.03 9251CA-2020-1003281/29/224/2/22JC-15340Jasper CacioppoNew York CityNew YorkUnited States10024USEastRetailCamping GearMicro Cooking unitStandard ClassMedium$ 3.9313.930.20.792.240.361.33 9765CA-2020-1341031/31/225/2/22MV-18190Mike VittoriniDetroitMichiganUnited States48234USCentralRetailCamping GearPropane Portable GrillStandard ClassHigh$ 229.942114.9700.00200.4622.586.90 9766CA-2020-1341031/31/225/2/22MV-18190Mike VittoriniDetroitMichiganUnited States48234USCentralRetailCamping GearFirst Aid KitStandard ClassHigh$ 10.5625.2800.004.611.204.75 74CA-2020-1407952/2/224/2/22BD-11500Bradley DruckerGreen BayWisconsinUnited States54302USCentralRetailPaddleAccessoriesFirst ClassHigh$ 468.90678.1500.00195.7066.88206.32 76CA-2020-1075242/3/228/3/22KN-16705Kristina NunnNew York CityNew YorkUnited States10009USEastTravel CompanyCamping GearFirst Aid KitStandard ClassMedium$ 36.4057.2800.0016.752.1817.47 77CA-2020-1075242/3/228/3/22KN-16705Kristina NunnNew York CityNew YorkUnited States10009USEastTravel CompanyCamping GearChairsStandard ClassMedium$ 11.3625.6800.005.080.945.34 75CA-2020-1111572/3/226/3/22NH-18610Nicole HansenPhiladelphiaPennsylvaniaUnited States19120USEastConsumerPaddleAccessoriesStandard ClassHigh$ 151.20350.400.230.24109.869.2132.13 78CA-2020-1111572/3/226/3/22NH-18610Nicole HansenPhiladelphiaPennsylvaniaUnited States19120USEastConsumerCamping GearFirst Aid KitStandard ClassHigh$ 3.4213.420.20.681.940.411.07 81CA-2020-1602762/4/228/4/22AH-10690Anna HäberlinVirginia BeachVirginiaUnited States23464USSouthConsumerTentsBackpacking TentStandard ClassMedium$ 177.68288.8400.00120.6410.8446.20 79CA-2020-1643152/4/228/4/22RD-19585Rob DowdAthensGeorgiaUnited States30605USSouthRetailPaddlePaddlesStandard ClassMedium$ 1,049.937149.9900.00718.2837.67293.98 80CA-2020-1643152/4/228/4/22RD-19585Rob DowdAthensGeorgiaUnited States30605USSouthRetailCamping GearCamp stoveStandard ClassMedium$ 154.90530.9800.00101.6412.9940.27 83CA-2020-1643152/4/228/4/22RD-19585Rob DowdAthensGeorgiaUnited States30605USSouthRetailCamping GearFirst Aid KitStandard ClassMedium$ 15.8435.2800.007.521.197.13 82US-2020-1578472/4/226/4/22SC-20020Sam CravenHoustonTexasUnited States77095USCentralRetailCamping GearFirst Aid KitSecond ClassMedium$ 33.4974.780.26.7021.441.5810.47 84US-2020-1578472/4/226/4/22SC-20020Sam CravenHoustonTexasUnited States77095USCentralRetailCamping GearFirst Aid KitSecond ClassMedium$ 26.7255.340.25.3416.630.749.35 86CA-2020-1150562/5/222/5/22AR-10510Andrew RobertsColumbusOhioUnited States43229USEastRetailCamping GearCamp stoveSame DayHigh$ 26.1438.710.25.2317.246.941.96 85CA-2020-1246182/5/224/5/22CS-11860Cari SchnellingLakelandFloridaUnited States33801USSouthRetailPaddleKayakSecond ClassCritical$ 479.982239.990.296.00267.09122.9090.00 89CA-2020-1044722/6/227/6/22CK-12325Christine KargatisOremUtahUnited States84057USWestTravel CompanyCamping GearMicro Cooking unitStandard ClassMedium$ 59.81319.940.211.9635.614.7619.44 90CA-2020-1044722/6/227/6/22CK-12325Christine KargatisOremUtahUnited States84057USWestTravel CompanyTentsBackpacking TentStandard ClassMedium$ 73.32612.2200.0046.944.3822.00 87CA-2020-1008952/6/226/6/22SV-20785Stewart VisinskyRoswellGeorgiaUnited States30076USSouthRetailCamping GearPropane Portable GrillStandard ClassHigh$ 356.942178.4700.00200.8049.06107.08 88CA-2020-1008952/6/226/6/22SV-20785Stewart VisinskyRoswellGeorgiaUnited States30076USSouthRetailPaddlePaddlesStandard ClassHigh$ 239.97379.9900.00144.8227.9667.19 91CA-2020-1008952/6/226/6/22SV-20785Stewart VisinskyRoswellGeorgiaUnited States30076USSouthRetailCamping GearCook setStandard ClassHigh$ 8.5624.2800.004.491.422.65 92CA-2020-1075942/7/226/7/22EH-13945Eric HoffmannPlainfieldNew JerseyUnited States7060USEastRetailPaddlePaddlesStandard ClassMedium$ 73.98236.9900.0047.866.1519.97 93CA-2020-1075942/7/226/7/22EH-13945Eric HoffmannPlainfieldNew JerseyUnited States7060USEastRetailCamping GearCook setStandard ClassMedium$ 5.5815.5800.002.830.572.18 94US-2020-1062992/8/228/8/22NZ-18565Nick ZanduskySpringfieldMissouriUnited States65807USCentralTravel CompanyCamping GearPropane Portable GrillStandard ClassMedium$ 838.382419.1900.00508.62103.40226.36 95US-2020-1062992/8/228/8/22NZ-18565Nick ZanduskySpringfieldMissouriUnited States65807USCentralTravel CompanyCamping GearMicro Cooking unitStandard ClassMedium$ 26.7055.3400.0012.191.9612.55 96US-2020-1062992/8/228/8/22NZ-18565Nick ZanduskySpringfieldMissouriUnited States65807USCentralTravel CompanyPaddleAccessoriesStandard ClassMedium$ 21.20210.6000.0011.140.949.12 99CA-2020-1582812/9/227/9/22AG-10525Andy GerbodeHoustonTexasUnited States77095USCentralConsumerPaddlePaddle BoardStandard ClassMedium$ 559.713186.570.4223.88636.2644.72-121
Answered Same DaySep 25, 2023

Answer To: You are an accountant for U.S. Outdoor Adventures and are asked to prepare an anlysis of sales for...

Prince answered on Sep 26 2023
25 Votes
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here