Pharmahelp - Current Income Statement General Drugstore Mom & Pop Total 0 Revenues Cost of Goods Sold Gross Margin Other Operating Costs Operating Income Compute the 2017 gross-margin percentage for each of Pharmahelp's three market segments. Compute the cost driver rates for each of the five activity areas. Use the activity-based costing information to allocate the $301,080 of other operating costs" to each of the market segments. Compute the operating income 8,400,000 438,000 for each market segment. 301,080 136.920 Comment on the results. What new insights are available with the activity-based costing information: please show calculation on ecxel sheet 3,600,000 108,000 3,000,000 150,000 1,800,000 180,000 Gross Margin % 2.91% 4.76% 9.09% Activity Based Cost Data General Drugstore Mom & Pop Total ABC OH Rate Total Cost Orders Processed Line Items Ordered Store Deliveries Made Cartons Shipped to Stores Shelf Stocking Hours 140 1,960 120 36,000 360 360 4,320 360 24,000 180 1,500 15,000 1,000 16,000 2,000 21,280 1,480 76,000 640 80,000 63,840 71,000 76,000 10,240 100 Total 301,080 Pharmacare - ABC Income Statement General 3,708,000 3,600,000 108,000 Drugstore 3,150,000 3,000,000 150,000 Mom & Pop 1,980,000 1,800,000 180,000 Total 8,838,000 8,400,000 438,000 Revenues Cost of Goods Sold Gross Margin Order Processing Costs Line Item Ordering Costs Store Delivery Cost Carton Costs Shelf Stocking Costs Total Operating Costs Operating Income this total cost should be the $301,080 from above this net income should be the same $136.920 from the original income statement