1. How each clothing store is likely to perform. 2. An indication of the influence of seasonality on the business. 3. Potential trouble spots in terms of anticipated under-performing stores. 4. The...

1 answer below »
1. How each clothing store is likely to perform.
2. An indication of the influence of seasonality on the business.
3. Potential trouble spots in terms of anticipated under-performing stores.
4. The influence of national personal income on Clothier Inc.’s business. (The owners believe that a potential factor affecting Clothier Inc.’s sales is national disposable income, the data for which are provided in Tab 2 for the years 2004-
2021). The remaining projected figures for Q2 of the year 2021 are also provided in Tab 3.
5. They also want to understand what influence National Retail Clothing Sales (Small to Large Retailers) and Foreign Resident Spending have on clothing sales. Data is provided in Tab 4 and Tab 5.
6. Clothier Inc., although they are not sure how you will use this information, has also provided you with total costs for each clothing store in Tab 6 and marketing spend/activities in Tab 7 (broken out from the total costs). Due to their limited budget, they have provided you with some web-based activities for one of their clothing stores (Rags) in Tab 8. They want to see if additional online metrics at the clothing store level would be worth it for them to explore for their other clothing stores at an additional cost. Additional information is also provided in Tab 9.
7. Other elements you feel is necessary to include that will help Clothier Inc. in their decision or business operations overall.



Clothier Inc Tab 1 - Sales Data YearQuarterRagsSHQPauseSurrealChangeTrendingStepGLAMS LINEREDSTotal 200419577.457258.636338.220.000.000.000.000.000.000.0023174.29 29685.427339.036699.900.000.000.000.000.000.000.0023724.35 39558.497321.676523.990.000.000.000.000.000.000.0023404.15 49912.287426.046841.290.000.000.000.000.000.000.0024179.61 200519693.477354.636582.430.000.000.000.000.000.000.0023630.53 29831.347546.536861.580.000.000.000.000.000.000.0024239.45 39690.977624.716774.510.000.000.000.000.000.000.0024090.19 49952.967529.896947.680.000.000.000.000.000.000.0024430.53 200619745.227420.066813.560.000.000.000.000.000.000.0023978.84 29983.217626.806958.600.000.000.000.000.000.000.0024568.61 39730.597667.546804.080.000.000.000.000.000.000.0024202.21 410082.837648.187019.160.000.000.000.000.000.000.0024750.17 200719952.967623.606904.890.000.000.000.000.000.000.0024481.45 210077.707754.387124.660.000.000.000.000.000.000.0024956.74 39907.597881.636878.264790.920.000.000.000.000.000.0029458.40 410273.197804.407250.676137.636438.540.000.000.000.000.0037904.42 2008110058.837663.816850.065912.997067.870.000.000.000.000.0037553.56 210164.327728.366950.345579.897131.160.000.000.000.000.0037554.07 39883.467381.956559.565255.826858.860.000.000.000.000.0035939.65 410332.947644.337004.375434.377124.690.000.000.000.000.0037540.71 2009110103.607419.916762.895306.467621.731867.430.000.000.000.0039082.02 210150.587570.506889.565457.767312.812227.040.000.000.000.0039608.24 310077.707516.266737.835213.477040.512094.977617.580.000.000.0046298.31 410356.577453.036938.405270.997307.712180.619384.580.000.000.0048891.88 2010110145.707325.986735.745174.317806.112080.649165.430.000.000.0048433.91 210052.207262.596565.395095.367501.282024.029062.150.000.000.0047563.00 39967.217238.176626.264994.587230.351963.608987.825965.320.000.0052973.30 410410.817437.916995.595042.737497.552041.569294.096421.660.000.0055141.90 2011110063.487468.136895.865257.788002.781931.379253.765895.110.000.0054768.27 210285.077369.036927.425136.367702.051768.529117.136297.710.000.0054603.29 310106.707428.146805.305111.617433.851997.248996.055981.530.000.0053860.43 410436.447495.207188.045099.207702.422031.839375.326440.550.000.0055768.98 2012110229.957458.666981.435122.848214.472074.159404.586092.730.000.0055578.81 210357.327523.147114.725097.807916.481902.319557.786328.350.000.0055797.88 310207.957708.097078.655181.467651.011864.029485.176279.460.000.0055455.80 410457.817624.117179.155066.767920.940.009707.056538.715896.660.0060391.20 2013110251.577521.597053.324893.308441.190.009666.306277.416721.940.0060826.63 210273.077574.277255.704969.248144.570.009634.256239.386386.350.0060476.83 310231.457634.567032.824897.707880.460.009633.376268.736914.570.0060493.66 410522.867771.137095.225056.168180.440.009926.296645.167001.210.0062198.48 2014110401.567742.796996.364866.788707.520.009865.726277.697075.050.0061933.48 210423.067795.477198.744942.728410.890.009833.686261.466739.470.0061605.48 310381.447855.766975.854871.188146.790.009832.796155.897267.680.0061487.39 410659.107992.337038.255029.648452.230.0010125.716560.287354.330.0063211.88 2015110639.057975.066956.484827.008986.140.0010181.476336.647434.050.0063335.89 210660.558027.737158.864902.938696.340.0010149.436479.487098.470.0063173.79 310618.938088.036935.974831.398440.430.0010148.546334.607626.680.0063024.58 410782.928164.747079.645154.758656.360.0010257.766590.247550.510.0064236.92 2016111076.558212.646929.604898.699338.650.0010455.926479.047746.620.0065137.70 211184.818339.417711.874881.998936.980.0010341.196205.557185.310.0064787.10 310768.938238.037085.974981.398590.430.0010298.546484.600.000.0056447.90 410949.928331.747169.645321.758823.360.0010364.766723.247717.510.0065401.92 2017111309.558445.647162.605131.699571.650.0010688.926712.047979.627907.6374909.33 211529.818684.418056.875226.999281.980.0010686.196550.557530.318412.7275959.82 310788.1913562.277180.075101.468788.450.0010485.596596.817939.307032.6977474.83 411153.618530.27322.765493.649008.350.0010469.676981.617824.79286.1476070.68 2018111456.288697.857432.95355.539820.020.0010974.776992.618134.198410.4977274.64 211275.839005.158522.645449.129639.480.0011004.326905.347742.628862.9578407.45 310979.078463.567309.425225.529016.070.0010717.656769.628232.877162.1873875.96 411485.588573.567593.215679.499231.340.0010772.347088.288111.659523.3978058.84 2019111704.518912.647686.765689.9810070.60.0011259.787335.078219.638778.6179657.58 211542.999244.428867.475791.159870.270.0011307.567229.048011.829227.1981091.91 311422.848886.077566.565575.469472.370.0011038.167019.818453.047710.3077144.61 411658.208692.987857.075889.299400.40.0010977.527364.68351.459796.9579988.46 2020111769.989224.38809.966054.1310410.080.0011468.567831.058361.198993.3282922.57 211814.579466.29123.26060.1610255.20.0011588.567509.398163.219445.7183426.20 312013.989223.447781.445814.389680.890.0011343.817170.28599.748004.2279632.10 411901.128711.988069.36012.899413.270.0011146.287528.98487.329939.3781210.43 2021111921.389453.27898.386102.7610618.990.0011735.977868.18445.29121.7583165.73 26113.1554864.054693.633160.4555261.490.005948.453920.3754194.734884.50543040.84 Tab 2 - DI - Data Table 2: Disposable Income Data YearQuarterNat. Per. Inc. (Billions) 20041736.02 2729.22 3704.95 4758.35 20051667.09 2717.57 3797.18 4684.57 20061607.87 2831.16 3804.95 4852.52 20071736.99 2843.78 3952.51 4707.87 20081783.59 2911.74 31025.33 41192.31 20091863.20 21009.79 3911.74 41076.78 20101901.06 21102.99 31057.36 41125.32 201111031.15 21392.30 31149.59 41161.24 201211116.58 21180.66 31198.13 41207.84 201311131.14 21221.43 31217.55 41285.51 201411225.31 21333.08 31375.79 41378.70 201511281.62 21375.79 31388.41 41482.58 201611403.64 21413.05 31410.18 41489.29 201711455.42 21435.19 31433.20 41500.51 201811573.30 21441.19 31443.95 41514.43 201911597.29 21457.95 31451.96 41521.08 202011611.52 21468.41 31471.11 41527.34 202111643.23 2Prediction in Tab 3 Tab 3 - DI - Predicted Table 3: Predicted Quarterly values for Disposable Income -- 2021 Year 2021Per Income Quarter(Billions) 21504.29 Tab 4 - Retail Clothing Sales Table 4: National Retail Clothing Sales YearQuarterRetail Clothing Sales (Millions) 200412145.81 22252.85 32525.05 42199.31 200511998.30 22713.22 32598.92 42810.73 200612456.73 22804.65 33162.34 42458.87 200712755.94 23156.31 33617.98 44175.69 200813084.19 23687.41 33360.93 43944.13 200913459.21 24221.54 34081.10 44353.83 201014011.28 25404.88 34551.32 44637.70 201114508.72 24794.10 34901.02 45080.29 201214860.07 25322.43 35261.43 45744.09 201315666.48 26496.61 36815.47 46878.14 201416010.66 27171.05 37171.89 47162.61 201517086.86 27140.42 37187.65 47555.12 201617456.10 27512.14 37554.88 47564.77 201717566.22 27685.97 37563.20 47565.21 201817567.54 27720.95 37703.02 47764.66 201917568.71 27745.90 37798.39 47809.53 202017570.13 27768.41 37940.63 47909.23 202117573.11 27787.30 Tab 5 - Foreign Spend Table 5: Spending in Canada by foreign residents (receipts in millions) 19933193.90 19944241.55 19955465.91 19966367.92 19976827.18 19988571.97 19999663.32 200010493.48 200110920.70 200211215.86 20039307.95 200411447.92 200511150.81 200611087.70 200710951.77 200810611.94 200910702.23 201010485.71 201110613.88 201210974.10 201311661.53 201412039.91 201512169.90 201612688.40 201712879.95 201813064.80 201913169.41 202013277.22 2021Not Available Tab 6 - Total Costs YearQuarterRagsSHQPauseSurrealChangeTrendingStepGLAMS LINEREDSTotal 20041989.621209.55844.810.000.000.000.000.000.000.003043.98 2850.271158.80903.430.000.000.000.000.000.000.002912.49 3793.021148.82887.200.000.000.000.000.000.000.002829.04 4858.361305.74975.840.000.000.000.000.000.000.003139.95 20051853.941167.76843.270.000.000.000.000.000.000.002864.97 2916.151278.02986.240.000.000.000.000.000.000.003180.41 3852.751322.95941.640.000.000.000.000.000.000.003117.34 41065.051268.461030.330.000.000.000.000.000.000.003363.85 20061877.291205.35961.640.000.000.000.000.000.000.003044.29 2984.691324.151035.930.000.000.000.000.000.000.003344.77 3870.691347.56956.790.000.000.000.000.000.000.003175.04 41029.651336.441066.940.000.000.000.000.000.000.003433.03 20071971.041322.311008.420.000.000.000.000.000.000.003301.77 21027.341397.461120.970.000.000.000.000.000.000.003545.77 3950.571470.581100.30951.700.000.000.000.000.000.004473.14 41115.561426.201185.511248.12875.410.000.000.000.000.005850.79 200811018.821442.37980.331043.37998.930.000.000.000.000.005483.82 21066.431382.501031.69860.59890.210.000.000.000.000.005231.43 3939.681183.45831.55682.77795.640.000.000.000.000.004433.10 41142.521334.221059.37780.75887.970.000.000.000.000.005204.82 200911039.021205.27935.69710.561060.601857.640.000.000.000.006808.78 21060.231291.801000.56793.58953.302165.500.000.000.000.007264.97 31027.341260.63922.86659.53858.732006.821008.470.000.000.007744.37 41153.181224.301025.58691.10951.532109.721431.120.000.000.008586.52 20101964.011151.30921.79638.051124.631989.611366.880.000.000.008156.27 21015.831114.87887.30554.981018.761921.581336.600.000.000.007849.92 3977.471197.79865.71539.43924.661848.991314.82879.910.000.008548.78 41177.661215.611054.87565.851017.471942.651404.59948.400.000.009327.11 201111020.921232.981003.80683.851192.941810.261392.77743.600.000.009081.11 21120.921176.031019.96617.231088.501614.611352.72900.190.000.008890.15 31040.421210.00957.41603.64995.342013.601317.23777.210.000.008914.86 41189.231248.531153.43596.831088.621930.961333.09955.750.000.009496.45 201211190.051227.531047.62609.801266.472230.201436.98820.460.000.009829.12 21153.521264.581115.88596.061162.971775.351481.89912.110.000.009462.37 31086.111370.861097.41641.971070.771729.341460.60838.590.000.009295.66 41198.871322.611148.88579.031164.520.001525.64993.93914.550.008848.04 201311199.811263.701084.44483.861345.210.001513.70892.301235.530.009018.55 21115.501293.961188.09525.521242.190.001504.31877.501058.150.008805.23 31096.721328.611073.94486.271150.460.001504.05888.921222.120.008751.08 41228.231407.081105.90573.221254.650.001589.911035.341383.150.009577.47 201411173.491390.801055.26469.301437.710.001572.15859.711422.180.009380.61 21183.191518.021158.92610.351334.690.001467.45886.091244.800.009403.51 31164.411455.711044.76471.711242.960.001562.50845.031639.240.009426.33 41289.711534.191013.41558.661349.050.001648.371111.321569.800.0010074.51 201511092.641524.261034.84447.471534.480.001664.71915.341611.940.009825.69 21290.361554.531138.49559.471433.830.001655.32970.891434.560.0010037.46 31271.581686.131024.34449.881344.950.001655.06914.541713.760.0010060.24 41345.591633.251097.92627.311419.950.001591.761013.971788.730.0010518.49 201611357.481729.841118.47432.521626.440.001757.53927.431689.380.0010639.09 21426.111753.201094.82492.801564.100.001656.85900.911633.090.0010521.88 31282.641765.821099.18448.291525.660.001773.871088.50644.180.009628.14 41390.591678.251142.92672.311464.950.001636.761058.972143.620.0011188.37 201711334.481706.841095.47409.521603.440.001734.53904.431666.381715.0012170.09 21504.111831.201172.82500.701642.100.001734.85978.911711.091398.4012474.18 31303.784505.061187.00452.761566.940.001872.071132.891899.851105.9115026.26 41404.651767.731169.66697.081554.730.001679.281131.781893.741466.6912765.34 201811362.651737.851164.91476.981656.60.001780.29942.211691.841753.8012567.13 21618.011934.291215.92506.71667.380.001846.571050.871771.081563.8013174.62 31317.081797.961353.69777.31655.070.001971.951153.542002.511167.2513196.35 41458.331812.061268.99718.311581.370.001725.711146.411993.281462.7213167.18 201911402.151788.21177.9495.041690.190.001818.88967.321736.221793.7612869.66
clothier-inc-yhq2x5qr.xls clothier-inc-bkophqhp.pdf
Answered Same DayJul 31, 2021

Answer To: 1. How each clothing store is likely to perform. 2. An indication of the influence of seasonality on...

Mohd answered on Aug 01 2021
156 Votes
Clothier Inc
Q-1&3
        Data
    Year    Average of Rags    Average of SHQ    Average of Pause    Average of Surreal    Average of Change    Average of Trending    Average of Step    Average of GLAM    Average of S LINE    Average of REDS
    2004    9683.41113959    7336.3432046547    6600.8466760938    0    0    0    0    0    0    0
    2005    9792.184139744    7513.9401733102    6791.5524694677    0    0    0    0    0    0    0
    2006    9885.461425664    7590.6459314744    6898.8506097074    0    0    0    0    0    0    0
    2007    10052.860561568    7766.0007260078    7039.620349313    2732.1375263393    1609.6340236854    0    0    0    0    0
    2008    10109.889387968    7604.6124195786    6841.0788336177    5545.7691239262    7045.6455081751    0    0    0    0    0
    2009    10172.1120467665    7489.9227074262    6832.1689894667    5312.1703894952    7320.6875691151    2092.5132314222    4250.5395699115    0    0    0
    2010    10143.98168912    7316.1626808562    6730.7449593022    5076.7445474017    7508.8237079131    2027.4548886665    9127.3738970111    3096.7433163976    0    0
    2011    10222.9217030926    7440.126591787    6954.1558427815    5151.2355019751    7710.2761977331    1932.2383544901    9185.5652459611    6153.7246605212    0    0
    2012    10313.255745344    7578.4985434945    7088.4866761645    5117.2119274426    7925.7279283711    1460.1198200663    9538.6458002541    6309.8114538421    1474.1659356815    0
    2013    10319.7367199168    7625.3876647136    7109.2651633569    4954.099888646    8161.6663528891    0    9715.05466329    6357.6723048256    6756.0169317317    0
    2014    10466.2929915968    7846.5898151136    7052.2993453569    4927.577392646    8429.3591529211    0    9914.47539969    6313.8316285767    7109.1325730717    0
    2015    10675.36535648    8063.887747559    7032.7401317466    4929.016238054    8694.8191197886    0    10184.2999652365    6435.2400624552    7427.4280695452    0
    2016    10995.053799088    8280.4527845575    7224.272294848    5020.9531305536    8922.3561715396    0    10365.1039494374    6473.1053183206    5662.3586198934    0
    2017    11195.290414    9805.629808384    7430.575699918    5238.443958    9162.607233902    0    10582.5925501075    6710.2506916734    7818.4815778129    8159.7942
    2018    11299.19    8685.03    7714.5425    5427.415    9426.7275    0    10867.27    6938.9625    8055.3325    8489.7525
    2019    11582.135    8934.0275    7994.465    5736.47    9703.41    0    11145.755    7237.13    8258.985    8878.2625
    2020    11874.9125    9156.48    8445.975    5985.39    9939.86    0    11386.8025    7509.885    8402.865    9095.655
    2021    9017.2675    7158.625    6296.005    4631.6075    7940.24    0    8842.21    5894.2375    6319.965    7003.1275
    Grand Total    10473.8679068536    7977.888617081    7138.8367452081    4198.310764256    6601.812598059    429.2757882654    6896.2619166228    4141.9128963779    3664.2713547278    2178.5730257143
Average of Rags    2004    2005    2006    2007    2008    2009    2010    2011    2012    2013    2014    2015    2016    2017    2018    2019    2020    2021    9683.4111395899999    9792.1841397440003    9885.4614256639998    10052.860561567999    10109.889387968    10172.112046766517    10143.981689119999    10222.921703092601    10313.255745343999    10319.7367199168    10466.2929915968    10675.365356480001    10995.053799088    11195.290413999999    11299.189999999997    11582.134999999997    11874.912499999999    9017.2674999999999    Average of SHQ    2004    2005    2006    2007    2008    2009    2010    2011    2012    2013    2014    2015    2016    2017    2018    2019    2020    2021    7336.3432046546859    7513.9401733102059    7590.6459314744407    7766.0007260078328    7604.6124195785997    7489.9227074262244    7316.1626808562487    7440.126591787046    7578.4985434945256    7625.3876647135767    7846.5898151135771    8063.8877475590161    8280.4527845574921    9805.6298083839993    8685.0299999999988    8934.0275000000001    9156.48    7158.625    Average of Pause    2004    2005    2006    2007    2008    2009    2010    2011    2012    2013    2014    2015    2016    2017    2018    2019    2020    2021    6600.8466760938481    6791.5524694677169    6898.8506097073623    7039.6203493130488    6841.0788336177166    6832.1689894666633    6730.7449593022338    6954.1558427814634    7088.4866761644998    7109.265163356944    7052.2993453569452    7032.7401317466447    7224.2722948479823    7430.5756999179994    7714.5424999999996    7994.4650000000001    8445.9749999999985    6296.0050000000001    Average of Surreal    2004    2005    2006    2007    2008    2009    2010    2011    2012    2013    2014    2015    2016    2017    2018    2019    2020    2021    0    0    0    2732.1375263392506    5545.7691239262167    5312.1703894951888    5076.7445474017104    5151.2355019750494    5117.2119274425568    4954.0998886460111    4927.5773926460115    4929.0162380540114    5020.9531305535629    5238.4439579999998    5427.4149999999991    5736.47    5985.39    4631.6075000000001    Average of Change    2004    2005    2006    2007    2008    2009    2010    2011    2012    2013    2014    2015    2016    2017    2018    2019    2020    2021    0    0    0    1609.63402368536    7045.6455081751019    7320.6875691151008    7508.8237079131013    7710.2761977331011    7925.7279283711023    8161.6663528891013    8429.3591529211008    8694.8191197885808    8922.356171539599    9162.6072339019993    9426.7275000000009    9703.409999999998    9939.8599999999988    7940.24    Average of Trending    2004    2005    2006    2007    2008    2009    2010    2011    2012    2013    2014    2015    2016    2017    2018    2019    2020    2021    0    0    0    0    0    2092.5132314222178    2027.4548886665198    1932.2383544901072    1460.1198200662893    0    0    0    0    0    0    0    0    0    Average of Step    2004    2005    2006    2007    2008    2009    2010    2011    2012    2013    2014    2015    2016    2017    2018    2019    2020    2021    0    0    0    0    0    4250.5395699114724    9127.373897011099    9185.5652459610992    9538.6458002541403    9715.0546632899732    9914.4753996899726    10184.299965236523    10365.103949437353    10582.592550107498    10867.269999999999    11145.754999999997    11386.8025    8842.2099999999991    Average of GLAM    2004    2005    2006    2007    2008    2009    2010    2011    2012    2013    2014    2015    2016    2017    2018    2019    2020    2021    0    0    0    0    0    0    3096.7433163975998    6153.7246605211758    6309.8114538420714    6357.6723048255799    6313.8316285766905    6435.2400624551692    6473.1053183206413    6710.2506916733983    6938.9624999999987    7237.1299999999992    7509.8850000000002    5894.2375000000002    Average of S LINE    2004    2005    2006    2007    2008    2009    2010    2011    2012    2013    2014    2015    2016    2017    2018    2019    2020    2021    0    0    0    0    0    0    0    0    1474.1659356815055    6756.0169317317086    7109.132573071709    7427.4280695452399    5662.3586198934063    7818.4815778128977    8055.3324999999986    8258.9849999999988    8402.8649999999998    6319.9649999999992    Average of REDS    2004    2005    2006    2007    2008    2009    2010    2011    2012    2013    2014    2015    2016    2017    2018    2019    2020    2021    0    0    0    0    0    0    0    0    0    0    0    0    0    8159.7941999999975    8489.7524999999951    8878.2624999999971    9095.6549999999988    7003.1275000000005    
Tab 1 - Sales Data
    Year    Quarter    Rags    SHQ    Pause    Surreal    Change    Trending    Step    GLAM    S LINE    REDS    Total
    2004    1    9577.45    7258.63    6338.22    0.00    0.00    0.00    0.00    0.00    0.00    0.00    23174.29
    2004    2    9685.42    7339.03    6699.90    0.00    0.00    0.00    0.00    0.00    0.00    0.00    23724.35
    2004    3    9558.49    7321.67    6523.99    0.00    0.00    0.00    0.00    0.00    0.00    0.00    23404.15
    2004    4    9912.28    7426.04    6841.29    0.00    0.00    0.00    0.00    0.00    0.00    0.00    24179.61
    2005    1    9693.47    7354.63    6582.43    0.00    0.00    0.00    0.00    0.00    0.00    0.00    23630.53
    2005    2    9831.34    7546.53    6861.58    0.00    0.00    0.00    0.00    0.00    0.00    0.00    24239.45
    2005    3    9690.97    7624.71    6774.51    0.00    0.00    0.00    0.00    0.00    0.00    0.00    24090.19
    2005    4    9952.96    7529.89    6947.68    0.00    0.00    0.00    0.00    0.00    0.00    0.00    24430.53
    2006    1    9745.22    7420.06    6813.56    0.00    0.00    0.00    0.00    0.00    0.00    0.00    23978.84
    2006    2    9983.21    7626.80    6958.60    0.00    0.00    0.00    0.00    0.00    0.00    0.00    24568.61
    2006    3    9730.59    7667.54    6804.08    0.00    0.00    0.00    0.00    0.00    0.00    0.00    24202.21
    2006    4    10082.83    7648.18    7019.16    0.00    0.00    0.00    0.00    0.00    0.00    0.00    24750.17
    2007    1    9952.96    7623.60    6904.89    0.00    0.00    0.00    0.00    0.00    0.00    0.00    24481.45
    2007    2    10077.70    7754.38    7124.66    0.00    0.00    0.00    0.00    0.00    0.00    0.00    24956.74
    2007    3    9907.59    7881.63    6878.26    4790.92    0.00    0.00    0.00    0.00    0.00    0.00    29458.40
    2007    4    10273.19    7804.40    7250.67    6137.63    6438.54    0.00    0.00    0.00    0.00    0.00    37904.42
    2008    1    10058.83    7663.81    6850.06    5912.99    7067.87    0.00    0.00    0.00    0.00    0.00    37553.56
    2008    2    10164.32    7728.36    6950.34    5579.89    7131.16    0.00    0.00    0.00    0.00    0.00    37554.07
    2008    3    9883.46    7381.95    6559.56    5255.82    6858.86    0.00    0.00    0.00    0.00    0.00    35939.65
    2008    4    10332.94    7644.33    7004.37    5434.37    7124.69    0.00    0.00    0.00    0.00    0.00    37540.71
    2009    1    10103.60    7419.91    6762.89    5306.46    7621.73    1867.43    0.00    0.00    0.00    0.00    39082.02
    2009    2    10150.58    7570.50    6889.56    5457.76    7312.81    2227.04    0.00    0.00    0.00    0.00    39608.24
    2009    3    10077.70    7516.26    6737.83    5213.47    7040.51    2094.97    7617.58    0.00    0.00    0.00    46298.31
    2009    4    10356.57    7453.03    6938.40    5270.99    7307.71    2180.61    9384.58    0.00    0.00    0.00    48891.88
    2010    1    10145.70    7325.98    6735.74    5174.31    7806.11    2080.64    9165.43    0.00    0.00    0.00    48433.91
    2010    2    10052.20    7262.59    6565.39    5095.36    7501.28    2024.02    9062.15    0.00    0.00    0.00    47563.00
    2010    3    9967.21    7238.17    6626.26    4994.58    7230.35    1963.60    8987.82    5965.32    0.00    0.00    52973.30
    2010    4    10410.81    7437.91    6995.59    5042.73    7497.55    2041.56    9294.09    6421.66    0.00    0.00    55141.90
    2011    1    10063.48    7468.13    6895.86    5257.78    8002.78    1931.37    9253.76    5895.11    0.00    0.00    54768.27
    2011    2    10285.07    7369.03    6927.42    5136.36    7702.05    1768.52    9117.13    6297.71    0.00    0.00    54603.29
    2011    3    10106.70    7428.14    6805.30    5111.61    7433.85    1997.24    8996.05    5981.53    0.00    0.00    53860.43
    2011    4    10436.44    7495.20    7188.04    5099.20    7702.42    2031.83    9375.32    6440.55    0.00    0.00    55768.98
    2012    1    10229.95    7458.66    6981.43    5122.84    8214.47    2074.15    9404.58    6092.73    0.00    0.00    55578.81
    2012    2    10357.32    7523.14    7114.72    5097.80    7916.48    1902.31    9557.78    6328.35    0.00    0.00    55797.88
    2012    3    10207.95    7708.09    7078.65    5181.46    7651.01    1864.02    9485.17    6279.46    0.00    0.00    55455.80
    2012    4    10457.81    7624.11    7179.15    5066.76    7920.94    0.00    9707.05    6538.71    5896.66    0.00    60391.20
    2013    1    10251.57    7521.59    7053.32    4893.30    8441.19    0.00    9666.30    6277.41    6721.94    0.00    60826.63
    2013    2    10273.07    7574.27    7255.70    4969.24    8144.57    0.00    9634.25    6239.38    6386.35    0.00    60476.83
    2013    3    10231.45    7634.56    7032.82    4897.70    7880.46    0.00    9633.37    6268.73    6914.57    0.00    60493.66
    2013    4    10522.86    7771.13    7095.22    5056.16    8180.44    0.00    9926.29    6645.16    7001.21    0.00    62198.48
    2014    1    10401.56    7742.79    6996.36    4866.78    8707.52    0.00    9865.72    6277.69    7075.05    0.00    61933.48
    2014    2    10423.06    7795.47    7198.74    4942.72    8410.89    0.00    9833.68    6261.46    6739.47    0.00    61605.48
    2014    3    10381.44    7855.76    6975.85    4871.18    8146.79    0.00    9832.79    6155.89    7267.68    0.00    61487.39
    2014    4    10659.10    7992.33    7038.25    5029.64    8452.23    0.00    10125.71    6560.28    7354.33    0.00    63211.88
    2015    1    10639.05    7975.06    6956.48    4827.00    8986.14    0.00    10181.47    6336.64    7434.05    0.00    63335.89
    2015    2    10660.55    8027.73    7158.86    4902.93    8696.34    0.00    10149.43    6479.48    7098.47    0.00    63173.79
    2015    3    10618.93    8088.03    6935.97    4831.39    8440.43    0.00    10148.54    6334.60    7626.68    0.00    63024.58
    2015    4    10782.92    8164.74    7079.64    5154.75    8656.36    0.00    10257.76    6590.24    7550.51    0.00    64236.92
    2016    1    11076.55    8212.64    6929.60    4898.69    9338.65    0.00    10455.92    6479.04    7746.62    0.00    65137.70
    2016    2    11184.81    8339.41    7711.87    4881.99    8936.98    0.00    10341.19    6205.55    7185.31    0.00    64787.10
    2016    3    10768.93    8238.03    7085.97    4981.39    8590.43    0.00    10298.54    6484.60    0.00    0.00    56447.90
    2016    4    10949.92    8331.74    7169.64    5321.75    8823.36    0.00    10364.76    6723.24    7717.51    0.00    65401.92
    2017    1    11309.55    8445.64    7162.60    5131.69    9571.65    0.00    10688.92    6712.04    7979.62    7907.63    74909.33
    2017    2    11529.81    8684.41    8056.87    5226.99    9281.98    0.00    10686.19    6550.55    7530.31    8412.72    75959.82
    2017    3    10788.19    13562.27    7180.07    5101.46    8788.45    0.00    10485.59    6596.81    7939.30    7032.69    77474.83
    2017    4    11153.61    8530.2    7322.76    5493.64    9008.35    0.00    10469.67    6981.61    7824.7    9286.14    76070.68
    2018    1    11456.28    8697.85    7432.9    5355.53    9820.02    0.00    10974.77    6992.61    8134.19    8410.49    77274.64
    2018    2    11275.83    9005.15    8522.64    5449.12    9639.48    0.00    11004.32    6905.34    7742.62    8862.95    78407.45
    2018    3    10979.07    8463.56    7309.42    5225.52    9016.07    0.00    10717.65    6769.62    8232.87    7162.18    73875.96
    2018    4    11485.58    8573.56    7593.21    5679.49    9231.34    0.00    10772.34    7088.28    8111.65    9523.39    78058.84
    2019    1    11704.51    8912.64    7686.76    5689.98    10070.6    0.00    11259.78    7335.07    8219.63    8778.61    79657.58
    2019    2    11542.99    9244.42    8867.47    5791.15    9870.27    0.00    11307.56    7229.04    8011.82    9227.19    81091.91
    2019    3    11422.84    8886.07    7566.56    5575.46    9472.37    0.00    11038.16    7019.81    8453.04    7710.30    77144.61
    2019    4    11658.20    8692.98    7857.07    5889.29    9400.4    0.00    10977.52    7364.6    8351.45    9796.95    79988.46
    2020    1    11769.98    9224.3    8809.96    6054.13    10410.08    0.00    11468.56    7831.05    8361.19    8993.32    82922.57
    2020    2    11814.57    9466.2    9123.2    6060.16    10255.2    0.00    11588.56    7509.39    8163.21    9445.71    83426.20
    2020    3    12013.98    9223.44    7781.44    5814.38    9680.89    0.00    11343.81    7170.2    8599.74    8004.22    79632.10
    2020    4    11901.12    8711.98    8069.3    6012.89    9413.27    0.00    11146.28    7528.9    8487.32    9939.37    81210.43
    2021    1    11921.38    9453.2    7898.38    6102.76    10618.99    0.00    11735.97    7868.1    8445.2    9121.75    83165.73
    2021    2    6113.155    4864.05    4693.63    3160.455    5261.49    0.00    5948.45    3920.375    4194.73    4884.505    43040.84
Q-2_Seasonality
        Data
    Quarter    Average of Rags    Average of SHQ    Average of Pause    Average of Surreal    Average of Change    Average of Trending    Average of Step    Average of GLAM    Average of S LINE    Average of REDS
    1    10561.1718992219    7954.3960159899    7099.5250401594    4144.1238689923    6926.5444064164    441.8665588046    6895.6206932376    4116.5276175426    3895.4159225042    2400.6555222222
    2    10300.278328845    7817.858611589    7260.064254501    3986.2179131954    6447.8321696423    440.1046424849    6568.3718019743    3884.8117577023    3502.9046402986    2268.5040222222
    3    10372.6759649205    8218.8158648152    6979.7963632411    4226.2547130797    6248.8521770835    465.8722544561    6975.5930623285    4178.0337216985    3237.2872050256    1759.3758823529
    4    10666.4210571119    7931.2794233759    7211.1427462104    4452.3100762462    6773.977440274    367.8820723304    7164.7874817764    4404.8953366569    4017.3730714741    2267.4029411765
    Grand Total    10473.8679068536    7977.888617081    7138.8367452081    4198.310764256    6601.8125980591    429.2757882654    6896.2619166228    4141.9128963779    3664.2713547278    2178.5730257143
        Data
    Quarter    Average of Rags    Average of SHQ    Average of Pause    Average of Surreal    Average of Change    Average of Trending    Average of Step    Average of GLAM    Average of S LINE    Average of REDS
    1    10561.1718992219    7954.3960159899    7099.5250401594    4144.1238689923    6926.5444064164    441.8665588046    6895.6206932376    4116.5276175426    3895.4159225042    2400.6555222222
    2    10300.278328845    7817.858611589    7260.064254501    3986.2179131954    6447.8321696423    440.1046424849    6568.3718019743    3884.8117577023    3502.9046402986    2268.5040222222
    3    10372.6759649205    8218.8158648152    6979.7963632411    4226.2547130797    6248.8521770835    465.8722544561    6975.5930623285    4178.0337216985    3237.2872050256    1759.3758823529
    4    10666.4210571119    7931.2794233759    7211.1427462104    4452.3100762462    6773.977440274    367.8820723304    7164.7874817764    4404.8953366569    4017.3730714741    2267.4029411765
    Grand Average    10473.8679068536    7977.888617081    7138.8367452081    4198.310764256    6601.8125980591    429.2757882654    6896.2619166228    4141.9128963779    3664.2713547278    2178.5730257143
    Seasonality_Index
        Data
    Quarter    Average of Rags    Average of SHQ    Average of Pause    Average of Surreal    Average of Change    Average of Trending    Average of Step    Average of GLAM    Average of S LINE    Average of REDS
    1    101%    100%    99%    99%    105%    103%    100%    99%    106%    110%
    2    98%    98%    102%    95%    98%    103%    95%    94%    96%    104%
    3    99%    103%    98%    101%    95%    109%    101%    101%    88%    81%
    4    102%    99%    101%    106%    103%    86%    104%    106%    110%    104%
Requirements
How each clothing store is likely to perform.
2. An indication of the influence of seasonality on the business.
3. Potential trouble spots in terms of anticipated under-performing stores.
4. The influence of national personal income on Clothier...
SOLUTION.PDF
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?