Answered step by step
Verified Expert Solution
Link Copied!

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!

image text in transcribed

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

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

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

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Finance questions