Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Part 1: Analyze the Week 1 Business Growth Overview dataset. This is a marketing report generated by an analyst for the Senior Vice President (SVP)

image text in transcribed

Part 1:

Analyzethe Week 1 Business Growth Overview dataset. This is a marketing report generated by an analyst for the Senior Vice President (SVP) of Marketing at a large corporation. The analyst is new and has provided summary data but no insights or commentary for the SVP.

Constructa minimum 525-word memorandum for the SVP providing insights and commentary. The memorandum should include your analysis of the following:

  • Major areas of increase and decrease in revenue or type and/or category of business
  • Trends that are evident in terms of revenue or type and/or category of business
  • Insights that would help formulate marketing strategies to either continue growth or reverse decline
  • Additional analysis you (if you were SVP)would like to build a marketing goal and strategy or strategies (and why)
image text in transcribed YTD (Jan-June 2016 vs. Jan-June 2015) 129 125 YTD Days Global Breakout 2016 PY2015 Revenue Revenue/Day Revenue/Day $ 13,644,073 $ 105,768 $ 96,976 Domestic INTL $ $ Customer Rank Acquire Expand Retain Serve Non-Coded Revenue $ 1,312,868 $ 7,634,424 $ 3,026,592 $ 1,666,355 $ 3,834 2016 Revenue/Day $ 10,177 $ 59,182 $ 23,462 $ 12,917 $ 30 PY2015 Revenue/Day % Total $ 6,427 10% $ 57,566 56% $ 21,759 22% $ 11,225 12% $ (0) 0% Customer Class Commercial INTL Municipal Reseller - Other Industrial Labs Government Resell - Industrial Hygiene Education Other Revenue $ 7,195,592 $ 1,535,905 $ 1,634,643 $ 1,386,876 $ 900,409 $ 425,018 $ 336,569 $ 154,662 $ 74,399 2016 Revenue/Day $ 55,780 $ 11,906 $ 12,672 $ 10,751 $ 6,980 $ 3,295 $ 2,609 $ 1,199 $ 577 PY2015 Revenue/Day $ 50,772 $ 11,700 $ 12,034 $ 9,785 $ 6,373 $ 2,669 $ 2,419 $ 1,031 $ 194 % Total 53% 11% 12% 10% 7% 3% 2% 1% 1% Top Customers ABC Corp Fish Limited Delta Appliance ALPS Company Here4U XYZ Inc Expert Engineers Check Gmbh Francios and Sons Euro Ltd Marketing Accounts Revenue $ 601,368 $ 480,717 $ 424,678 $ 398,347 $ 269,038 $ 208,819 $ 207,066 $ 201,704 $ 186,532 $ 177,660 $ 2,759,521 2016 Revenue/Day $ 4,662 $ 3,726 $ 3,292 $ 3,088 $ 2,086 $ 1,619 $ 1,605 $ 1,564 $ 1,446 $ 1,377 $ 21,392 PY2015 Revenue/Day $ 4,208 $ 2,889 $ 3,478 $ 2,877 $ 1,568 $ 1,362 $ 1,561 $ 1,023 $ 960 $ 1,215 $ 20,029 % Total 4% 4% 3% 3% 2% 2% 2% 1% 1% 1% 20% 12,085,137 $ 1,558,936 $ 93,683 $ 12,085 $ 85,181 11,795 % Total 100% 89% 11% 5) QTD (Apr, May, Jun 2016 vs Apr, May, Jun 2015) PM 59% 60% 50% GPSales - Avg/Day Avg/Day 9.1% 8.3% 10.0% 2.5% 8.9% 3.1% Global Breakout Revenue % Total $ 7,024,096 100% PM 58% Domestic INTL $ $ 60% 48% Customer Rank Acquire Expand Retain Serve Non-Coded Revenue % Total $ 654,170 9% $ 4,017,070 57% $ 1,505,103 21% $ 843,966 12% $ 3,787 0% PM 58% 58% 59% 60% 6,145,978 878,119 87% 13% PM 58% 58% 58% 61% GPSales - Avg/Day Avg/Day 58.4% 50.1% 2.8% 2.0% 7.8% 7.5% 15.1% 16.3% PM 61% 50% 62% 62% 59% 60% 32% 59% GPSales - Avg/Day Avg/Day 9.9% 9.2% 1.8% 2.3% 5.3% 3.9% 9.9% 5.8% 9.5% 9.2% 23.4% 23.1% 7.9% 6.9% 16.2% 5.1% 197.1% Customer Class Commercial INTL Municipal Reseller Industrial Labs Government Resell - Industrial Hygiene Education Other Revenue % Total $ 3,719,525 53% $ 868,634 12% $ 814,624 12% $ 721,253 10% $ 464,827 7% $ 183,030 3% $ 140,804 2% $ 84,981 1% $ 26,418 0% PM 61% 48% 63% 61% 58% 58% 32% 61% PM 64% 66% 53% 61% 59% 29% 52% 49% 49% 54% 63% GPSales - Avg/Day Avg/Day 10.8% 11.1% 29.0% 25.2% -5.3% 1.8% 7.3% 12.4% 33.0% 37.6% 18.9% 5.6% 2.8% -3.6% 52.9% 32.8% 50.6% 72.1% 13.4% 3.0% 6.8% 6.0% Top Customers ABC Corp Fish Limited Delta Appliance ALPS Company Here4U XYZ Inc Expert Engineers Check Gmbh Francios and Sons Euro Ltd Marketing Accounts Revenue % Total $ 332,350 5% $ 239,460 3% $ 230,032 3% $ 226,766 3% $ 119,433 2% $ 117,490 2% $ 104,936 1% $ 100,171 1% $ 96,755 1% $ 75,156 1% $ 1,381,927 20% PM 63% 67% 53% 61% 59% 11% 52% 48% 50% 55% 63% May, Jun 2015) MTD (June 2016 vs. June 2015) Sales 8.3% GP 6.5% Global Breakout Revenue % Total $ 2,257,102 100% PM 56% 8.0% 11.1% 6.6% 5.7% Domestic INTL $ $ 58% 42% Sales 50.8% 3.0% 10.4% 7.4% GP 42.7% 0.6% 10.3% 8.0% Customer Rank Acquire Expand Retain Serve Non-Coded Net Sales % Total $ 219,791 10% $ 1,282,340 57% $ 477,879 21% $ 273,533 12% $ 3,559 0% PM 56% 55% 57% 57% Sales 8.5% 10.9% 1.7% 10.9% 14.2% 14.2% -8.4% 2.1% GP 6.8% 5.2% 1.7% 6.8% 12.8% 12.8% -14.2% -3.8% Customer Class Commercial INTL Municipal Reseller - Other Industrial Labs Government Resell - Industrial Hygiene Education Other Net Sales % Total $ 1,130,973 50% $ 323,990 14% $ 263,030 12% $ 266,066 12% $ 135,694 6% $ 50,261 2% $ 43,642 2% $ 35,846 2% $ 7,600 0% PM 60% 51% 60% 57% 59% 61% 29% 60% Sales 7.2% 18.1% -21.0% 8.8% 31.9% 213.1% 22.1% 2835.2% -7.0% 19.1% 8.9% GP 4.2% 16.3% 14.7% 12.3% 28.0% 16.8% 8.6% 3186.6% -16.9% 19.1% 6.3% Top Customers ABC Corp Fish Limited Delta Appliance ALPS Company Here4U XYZ Inc Expert Engineers Check Gmbh Francios and Sons Euro Ltd Marketing Accounts Net Sales % Total $ 87,955 4% $ 76,813 3% $ 75,000 3% $ 60,179 3% $ 56,444 3% $ 51,610 2% $ 35,156 2% $ 31,740 1% $ 29,154 1% $ 28,452 1% $ 447,025 20% PM 62% 66% -1% 59% 52% 56% 57% 45% 54% 58% 56% 1,930,466 326,636 86% 14% 15) Sales 11.2% GP 6.1% 4.2% 83.4% 2.3% 52.4% Sales 54.3% 8.1% 18.0% 18.0% GP 40.2% 0.5% 17.3% 17.3% Sales 1.0% 83.2% 12.3% 26.4% -7.4% 30.9% -39.7% 25.6% GP -1.0% 50.8% 3.4% 14.9% 2.6% 33.8% -50.1% 14.4% Sales -2.6% 6.4% 5258.2% -10.7% 100.0% -23.0% -8.2% -7.1% 3.7% 126.6% 6.4% GP -10.9% 1.3% -164.1% -10.4% -0.5% -11.3% -27.9% 5.0% 119.5% 6.8% YTD QTD MTD Year to Date Quarter to Date Month to Date YTD Days Number of selling days in the current year (or comparable year, depending on location in header) Days Adj Domestic INTL PM GP Days Adjusted---in finance, each month may have a different number of reporting/selling days based on how measured. Some companies use a 5 week, 4 week, 4 week quarter to standardize the reporting/selling days. means that when comparing different years you are comparing the same number of days. United States International or ROW (Rest of World) Prior Month Gross Profit Customer Rank Classification schema for determining selling activities. Acquire-gain new customers, Expand-grow within cus customer, Serve-get service business in addition to product sales, non-coded--not coded Customer Class Classification schema by industry or area. Commercial-US/domestic. Used when not classifed by industry typ international customers. Municipal-self-explanatory. Reseller-other--resellers of your products to other end classifed ( i.e. Reseller-Industrial hygiene). Industrial labs, Governement, Education--specific classifications. when not a company cannot be classified in one of the previous categories. on location in header) orting/selling days based on how a quarter is dardize the reporting/selling days. Days adjusted umber of days. stomers, Expand-grow within customer, Retain-keep d--not coded when not classifed by industry type. INTLers of your products to other end users except where ducation--specific classifications. Other--catch all

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Personal Finance

Authors: Jeff Madura, Hardeep Singh Gill

4th Canadian edition

134724712, 134724713, 9780134779782 , 978-0134724713

More Books

Students also viewed these Finance questions

Question

Excel caculation on cascade mental health clinic

Answered: 1 week ago