Please help me solve for all the requirements, based on the given information and blank answer slots:
Medhelp, Inc., a distributor of special pharmaceutical products, operates at capacity and has three main market segments. Rick Flair, the new controller of Medhelp, reported the following data for 2020. (Click the icon to view the data.) For many years, Medhelp has used gross margin percentage to evaluate the relative profitability of its market segments. But Flair recently attended a seminar on activity-based costing and is considering using it at Medhelp to analyze and allocate "other operating costs." (Click the icon to view the activities and relevant information.) The level of each activity in the three market segments and the total cost incurred for each activity in 2020 is as follows: (Click the icon to view the activity level anc cost information.) \begin{tabular}{|c|c|c|c|c|c|} \hline Medhelp 2020 & & \begin{tabular}{l} neral \\ rmarket \\ lains \end{tabular} & \begin{tabular}{c} Drugstore \\ Chains \end{tabular} & \begin{tabular}{c} Mom-and-Pop \\ Single Stores \end{tabular} & Medhelp \\ \hline Revenues & $ & 3,718,000$ & 3,165,000 & 1,980,000$ & 8,863,000 \\ \hline Cost of goods sold & & 3,606,000 & 2,985,000 & 1,800,000 & 8,391,000 \\ \hline Gross margin & $ & 112,000$ & 180,000 & 180,000 & 472,000 \\ \hline Other operating costs & & & & & 307,295 \\ \hline Operating income & & & & $ & 164,705 \\ \hline \end{tabular} He meets with all the key managers and several of his operations and sales staff, and they agree that there are five key activities that drive other operating costs at Medhelp: Each customer order consists of one or more line items. A line item represents a single product (such as Extra-Strength Tylenol Tablets). Each product line item is delivered in one or more separate cartons. Each store delivery entails the delivery of one or more cartons of products to a customer. Medhelp's staff stacks cartons directly onto display shelves in customers' stores. Currently, there is no additional charge to the customer for shelf-stocking and not all customers use Medhelp for this activity. Requirements 1. Compute the 2020 gross-margin percentage for each of Medhelp's three market segments. 2. Compute the cost driver rates for each of the five activity areas. 3. Use the activity-based costing information to allocate the $307,295 of "other operating costs" to each of the market segments. Compute the operating income for each market segment. 4. Comment on the results. What new insights are available with the activity-based costing information? Requirement 1. Compute the 2020 gross-margin percentage for each of Medhelp's three market segments. (Enter the percent to two decimal places.) Requirement 2. Compute the cost driver rates for each of the five activity areas. (Round activity rates to three decimal places, X.XXX.) Begin by selecting the formula you will use. Then calculate the rate for each activity area and determine the allocation base. Requirement 3. Use the activity-based costing information to allocate the $307,295 of "other operating costs" to each of the market segments. Compute the operating income (loss) for each market segment. Compute the operating income for each market segment. (Use parentheses or a minus sign when entering operating losses.) Requirement 4. Comment on the results. What new insights are available with the activity-based costing information? Before commenting on the results, calculate the operating income (loss) percentage for each marketing segment. First select the formula labels and then calculate the percentage. (Enter the percent to two decimal places. Use parentheses or a minus sign when entering operating losses.)
