Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need help filling this chart out! Please complete the missing data using the given data in the table and information from the case text.
I need help filling this chart out!
- Please complete the missing data using the given data in the table and information from the case text. Evaluate Roses result from the CRM analysis that selling costs per call were $110 dollars. (20 points)
- Briefly explain 2 distinct problems that the company faces based on the data in the table above. (16 points)
| Data
| Explanation |
Problem 1
|
|
|
Problem 2
|
|
|
- Pick one of the problems you identified in Part 2) and discuss a sales strategy how the company could address it. (14 points)
+ Annual Customer Volumne Number of Accounts Number of Calls $ Sales Volume $ Sales Volume Selling Expense Selling Expense Selling Expense Operating Profit Per Call (% of sales) $ volume per call 4 9.5 4 4 32 24 25 ($000) Over $200 $100-200 $50-99.9 $40-49.9 $30-39.9 $20-29.9 $10-19.9 $5-9.9 $4-4.9 $3-3.9 $2-2.9 $1-1.9 Under $1 No sales Total Average Sales (% of Total) 10.9 2.9 11.7 5.4 4 8.5 13.2 15.7 5 5.2 7.1 6.9 3.5 256 274 1344 1011 1158 3114 4725 7021 2639 3233 4212 6360 6345 2001 43693 Gross Profit (% of sales) 15.9 23.6 19.8 18.4 21.8 22.8 23.9 25.9 29 31.6 31.2 30.4 63 157 349 235 309 569 842 871 688 4172 10.2 10.2 9.6 10.9 13.4 16.8 19.3 21.9 25.3 34.3 75.3 % of sales) 11.9 14.1 9.6 8.2 12.2 11.9 10.5 9.1 10.3 9.7 5.9 -3.6 -44.4 30.9 0 0 0 0 100 25 20.1 5.0 1 + Annual Customer Volumne Number of Accounts Number of Calls $ Sales Volume $ Sales Volume Selling Expense Selling Expense Selling Expense Operating Profit Per Call (% of sales) $ volume per call 4 9.5 4 4 32 24 25 ($000) Over $200 $100-200 $50-99.9 $40-49.9 $30-39.9 $20-29.9 $10-19.9 $5-9.9 $4-4.9 $3-3.9 $2-2.9 $1-1.9 Under $1 No sales Total Average Sales (% of Total) 10.9 2.9 11.7 5.4 4 8.5 13.2 15.7 5 5.2 7.1 6.9 3.5 256 274 1344 1011 1158 3114 4725 7021 2639 3233 4212 6360 6345 2001 43693 Gross Profit (% of sales) 15.9 23.6 19.8 18.4 21.8 22.8 23.9 25.9 29 31.6 31.2 30.4 63 157 349 235 309 569 842 871 688 4172 10.2 10.2 9.6 10.9 13.4 16.8 19.3 21.9 25.3 34.3 75.3 % of sales) 11.9 14.1 9.6 8.2 12.2 11.9 10.5 9.1 10.3 9.7 5.9 -3.6 -44.4 30.9 0 0 0 0 100 25 20.1 5.0 1
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