C Customer Service Activity Activity Base Activity Rate Bid preparation Number of bid requests $420 perre Number of woments $90 per shipment Support standard Items Number of standard items ordered $30 pertem Support nostandard Items Number of constandard intens ordered $180 per nonstonem Assume that the company had the following gross profit information for three representative customers: Customer 1 Customer 2 Customer $130,000 $210,000 (81,9001 (113,400) 90,000 36,600 590,000 Gross profile 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 Number of shipments Number of standard Items ordered Number of nonstandard items ordered Customer 1 Customer 2 Customer 15 60 25 55 50 20 35 52 65 85 a. Prepare a customer profitability report dated for the year ended December 31, 2018, 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. Metrold Electric Customer Profitability Report For the Year Ended December 31, 2018 Customer Customer Customer Cost of goods sold Grosso Customer service activities Shipment Support standard items Support montandard me Total customer service activities Operating income after customer service activities Gross profit as a percent of sales Operating income after customer service activities as a percent of