Activity$-$based costing and customer profitabilityMetroid Electric manufactures power distribution equipment for commercial customers, such as hospitals and manufacturers. Activity$-$based costing was used to determine customer profitability. Customer service activities were assigned to individual customers, using the following assumed customer service activities, activity base, and activity rate:VAssume that the company had the following gross profit information for three representative customers:The administrative records indicated that the activity$-$base usage quantities for each customer were as follows:a$.$ Prepare a customer profitability report dated for the year ended December $31,20$Y$8,$ 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 forCheck My WorkPrevious NextAssignment Score: $80\mathrm{.}17\%$All work saveSave and ExitSubmit Assignment for GradingCustomer $1$ Customer $2$ Customer $3$Revenues$$130,000$$$210,000$$$180,000$Cost of goods sold$(81,900)(113,400)(90,000)$Gross profit$$48,100$$$96,600$$$90,000$Gross profit as a percent of sales$37\%46\%50\%$Activity BaseCustomer $1$Customer $2$ Customer $3$Number of bid requests$154060$Number of shipments$255550$Number of standard items ordered$203552$