Kamron’s Supply, Inc. provides cleaning supplies to the automobile detailing industry. The most popular product is an all-in-one detailing package with several types of cleaning agents, wax, towels, and supplies. Kamron’s purchases the all-in-one boxes wholesale by the crate. The cost of each crate (50 all-in-one boxes) is $1,950. 

Required information:

  1. Determine the operating income of each of the five retail customers. Explain the
    results.
  2. How does this data inform decisions on customer targeting, customer retention, and
    sales? As a general manager of Kamron’s, how would you evaluate the delivery service
    and sales force? 
  3. What approach would you take going forward with Wildcat Motors and Greyhound
    Classic Cars?

Follow the instructions you see on the Data tab of the worksheet. Show all calculations within the cells of the Excel spreadsheet (accessed through Module 1 or by clicking “Next” at the bottom of this page). This means that you must use formulas and links so that your thought process can be examined.

Review the grading rubric to understand how you will be graded on this assignment. Reach out to your instructor if you have questions about the assignment.

Submit your downloaded and completed Excel file with your name added to the file name for grading by your instructor to the CT Assignment area in Module 1.