Answered step by step
Verified Expert Solution
Link Copied!

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?

image

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 ... 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

Governmental and Nonprofit Accounting

Authors: Robert Freeman, Craig Shoulders, Gregory Allison, Robert Smi

10th edition

132751267, 978-0132751261

More Books

Students also viewed these Accounting questions

Question

Compare and contrast licensing and subcontracting.

Answered: 1 week ago