Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I am required to give a full analysis on the financial situation outlined in the following image. The accounts labeled A-C are labeled based on
I am required to give a full analysis on the financial situation outlined in the following image. The accounts labeled A-C are labeled based on A being large dollar accounts that take more time to close, while C accounts are smaller profit accounts that take less time to close with B being somewhere in between. ?What type of analysis and/or strategy could be used to make the districts more effective based on the data?
District 2019 District 2019 1 2 3 4 5 6 7 8 1 2 3 4 5 6 7 8 District 2019 District 2 District 7 Potenital Accounts District District 2 District 7 Sales Reps 7 7 7 6 5 5 5 6 Sales 10,626,700 9,425,778 10,245,700 8,660,000 8,605,000 8,150,000 8,050,000 8,567,000 72,330,178 Sales - A A 2,394,148 2,270,100 Active A 120 85 65 58 Quota GP actual 10,520,400 10,626,700 4,102,956 4,410,081 9,720,000 9,425,778 3,790,800 3,487,538 10,345,900 10,245,700 4,034,901 4,016,314 8,735,040 8,660,000 3,406,666 3,567,920 8,474,400 8,605,000 3,305,016 3,416,185 8,087,040 8,150,000 3,153,946 3,097,000 7,850,000 8,050,000 3,061,500 3,252,200 8,124,560 8,567,000 3,168,578 3,152,656 71,857,340 72,330,178 28,024,363 28,399,894 Gross Profit B B Sales - B 4,410,081 3,487,538 4,016,314 3,567,920 3,416,185 Selling Exp. Contribution 988,283 952,004 983,587 3,032,727.00 831,360 2,736,560 826,080 2,590,105 3,097,000 794,625 2,302,375 3,252,200 722,085 2,530,115 3,152,656 817,292 2,335,364 28,399,894 6,915,316 21,484,578 4,279,303 4,145,750 425 314 Sales 233 205 Sales - C C 2,752,327 1,634,150 GP quota 650 500 389 226 3,421,798 2,535,534 Total 9,425,778 8,050,000
Step by Step Solution
★★★★★
3.38 Rating (154 Votes )
There are 3 Steps involved in it
Step: 1
There are various types of analysis Descriptive analysis Diagnostic analysis Predictive analysis Prescriptive analysis Descriptive analysis Descriptive analysis is the simplest and common use of data ...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