partial credit, E5-27 (similar to) Question Help Maclin Maclin Supermarkets ( Upper M MS) operates at capacity and decides to apply ABC analysis to three product lines: baked goods, milk and fruit juice, and frozen foods. It identifies four activities and their activity cost rates as follows: LOADING... (Click the icon to view the activity cost rates.) The revenues, cost of goods sold, store support costs, activities that account for the store support costs, and activity-area usage of the three product lines are as follows: LOADING... (Click the icon to view the information for the three product lines.) Requirements 1. Use the simple costing system to prepare a product-line profitability report for Upper M MS. 2. Use the ABC system to prepare a product-line profitability report for Upper M MS. 3. What new insights does the ABC system in requirement 2 provide to Upper M MS managers? Requirement 1. Use the simple costing system to prepare a product-line profitability report for Upper M MS. (Round the percentages to the nearest hundredth percent, X.XX%.) Milk and Frozen Baked Goods Fruit Juice Products Total Revenues Costs Cost of goods sold Store support Total costs Operating income Operating income/Revenues % % % % Enter any number in the edit fields and then click Check Answer. 2 parts remaining Clear All Check Answer Data Table Milk and Frozen Baked Goods Fruit Juice Products Financial data Revenues $ 61,000 $ 63,500 $ 51,000 Cost of goods sold $ 38,000 $ 47,000 $ 35,000 Store support $ 11,400 $ 14,100 $ 10,500 Activity-area usage (cost-allocation base) Ordering (purchase orders) 30 25 13 Delivery (deliveries) 98 36 28 Shelf-stocking (hours) 183 166 24 Customer support (items sold) 15,500 20,500 7,900 Under its simple costing system, Upper M MS allocated support costs to products at the rate of 30% of cost of goods sold.