Answered step by step
Verified Expert Solution
Question
1 Approved Answer
? Using the previous - quarter data you pulled and cleaned in the previous two tasks, identify insights and calculate the metrics required for the
? Using the previousquarter data you pulled and cleaned in the previous two tasks, identify insights and calculate the metrics required for the report, namely:Inventory turnoverDays sales outstanding DSOActual revenue versus target revenueYearoveryear revenue growthPS ?The dataset is too large to upload ?all columns are listed though. Provide instructions on how to calculate the above metrics using Excel.
Report ID Report Month RR000854 6/1/2023 Retailer Revenue Revenue Target Transactions Average Inventory Accounts Receivable Inventory Cost Pack Land 212333.33 212268.33 1716 23636.36 47918 131300 RR000855 6/1/2023 RR000856 6/1/2023 RR000857 6/1/2023 RR000858 6/1/2023 RR000859 6/1/2023 RR000860 6/1/2023 RR000861 6/1/2023 RR000862 6/1/2023 RR000863 5/1/2023 RR000864 5/1/2023 RR000865 5/1/2023 RR000866 5/1/2023 RR000867 5/1/2023 Adventure Bags Clip & Carry 14431.93 12951.58 73 5772.77 1871.15 12988.73 11396.15 9250.45 45 837.44 1036.01 10256.53 Petra's Packs 27843.75 28113.75 194 3672 3273.75 22500 City Chic 20742.96 19913.24 162 7083.18 2254.21 16758.67 a la mode bags 15000 16059 128 9504 2160 12000 Urbanicity Barlowe's 11355.88 10903.94 51 10468.42 4017 9652.5 168994.97 165631.97 1188 15615.14 36198.72 121845.37 Canvas Collective Pack Land 127285.71 132428.57 1249 11496.77 23175 92700 221000 210166.67 1716 24345.45 50882 128700 Adventure Bags 14574.82 12197.12 71 5658.46 1948.31 13245.94 Clip & Carry 11165.92 9344.84 43 837.44 1004.93 10152.93 Petra's Packs 28406.25 28113.75 194 3600 3476.25 22725 City Chic 19921.46 20110.4 155 7448.3 2369.22 16265.77 RR000868 5/1/2023 RR000869 5/1/2023 RR000870 5/1/2023 RR000871 5/1/2023 RR000872 4/1/2023 RR000873 4/1/2023 RR000874 4/1/2023 RR000875 4/1/2023 RR000876 4/1/2023 RR000877 4/1/2023 RR000878 4/1/2023 RR000879 4/1/2023 RR000880 4/1/2023 RR000881 3/1/2023 RR000882 3/1/2023 a la mode bags 15150 15741 133 9600 2116.8 12240 Urbanicity Barlowe's Canvas Collective Pack Land 11470.59 168994.97 132428.57 11128.76 51 10365.79 3822 9847.5 167305.02 1249 16246.05 36553.61 121845.37 132428.57 1261 11612.9 22275 87300 429000 416130 3571 46800 98800 262600 Adventure Bags Clip & Carry Petra's Packs 10999.59 9679.64 55 4399.84 1454.95 10199.62 5555.15 4418.56 21 429.14 509.96 4849.64 47812.5 47334.38 317 6000 5568.75 37500 City Chic 32187.26 29099.79 245 10888.81 3569.97 24249.82 a la mode bags Urbanicity Barlowe's 27500 28858.5 234 17776 3920.4 22440 20091.18 20087.12 86 18521.05 6693 17250 262283.78 246932.47 1882 24719.82 53999.6 178198.69 Canvas Collective Pack Land 231000 237930 2200 21503.23 41250 169950 884000 840666.67 6726 94545.45 191672 514800 Adventure Bags 12703.57 11749.51 67 5133.28 1784.98 11899.87 DR000eee 2/1/2000 Clip Corals by b col 1022 2 1519 41 7 121 71 161.00 1600 01
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started