Revenues Cost of goods sold Gross profit Customer 1 Customer 2 Customer 3 $130,000 $210,000 $180,000...

 

Transcribed Image Text:

Revenues Cost of goods sold Gross profit Customer 1 Customer 2 Customer 3 $130,000 $210,000 $180,000 (81,900) (113,400) (90,000) $48,100 $96,600 $90,000 37% 46% 50% Gross profit as a percent of sales The administrative records indicated that the activity-base usage quantities for each customer were as follows: Activity Base Number of bid requests Customer 1 Customer 2 Customer 3 15 40 60 Number of shipments 25 55 50 Number of standard items ordered 20 35 52 Number of nonstandard items ordered 6 65 85 a. Prepare a customer profitability report dated for the year ended December 31, 20Y8, showing (1) the operating income after customer service activities, (2) the gross profit as a percent of sales, and (3) the operating income after customer service activities as a percent of sales. Prepare the report with a column for each customer. Round percentages to the nearest whole percent. Revenues Cost of goods sold Gross profit Customer 1 Customer 2 Customer 3 $130,000 $210,000 $180,000 (81,900) (113,400) (90,000) $48,100 $96,600 $90,000 37% 46% 50% Gross profit as a percent of sales The administrative records indicated that the activity-base usage quantities for each customer were as follows: Activity Base Number of bid requests Customer 1 Customer 2 Customer 3 15 40 60 Number of shipments 25 55 50 Number of standard items ordered 20 35 52 Number of nonstandard items ordered 6 65 85 a. Prepare a customer profitability report dated for the year ended December 31, 20Y8, showing (1) the operating income after customer service activities, (2) the gross profit as a percent of sales, and (3) the operating income after customer service activities as a percent of sales. Prepare the report with a column for each customer. Round percentages to the nearest whole percent.