Family 99 Supermarkets has decided to increase the size of its store. It wants information about the profitability of individual product lines: soft drinks, fresh produce, and packaged food. FS99 provides the following data for 2020for each product line: Soft Drinks Fresh Products Packaged Food Revenues (RM) 300,000 850,000 480,000 Cost of goods sold (RM) 240,000 600,000 360,000 Cost of bottles returned (RM) 6,000 3,000 3,000 Number of purchase orders placed 140 330 140 Number of deliveries received 120 850 250 Hours of shelf-stocking time 200 2,500 1,300 Items sold 50,000 450,000 150,000 Activity Description of Activity Total Support Costs RM12,000 Bottle returns Returning of empty bottles to store Cost-Allocation Base Charge straight to product 610 purchase orders 1,220 deliveries Ordering Placing of orders for purchases RM 61,000 RM122,00 RM 70,000 Delivery Physical delivery and receipt of merchandise Shelf-stocking Stocking of merchandise on store shelves and ongoing restocking Customer Assistance provided to customers, support including checkout and bagging Total 4,000 hours of shelf stocking 650,000 items sold RM125,000 390,000 Family 99 Supermarkets currently allocates store support costs (all costs other than cost of goods sold) to product lines on the basis of cost of goods sold of each product line. Calculate the operating income and operating income as a percentage of revenues for each product line. Soft Drinks Fresh Products Packaged Foods Revenues Cost of goods sold Store support cost (equal to each) Total costs Operating income Operating income +Revenues If Family 99 Supermarkets allocates store support costs (all costs other than cost of goods sold) to product lines using an ABC system, calculate the operating income and operating income as a percentage of revenues for each product line. You need to calculate the Overhead Calculation Base Activity Cost-Allocation Base Overhead Allocation Rate (RM) Bottle returns Ordering Delivery Shelf-stocking Total Support Costs RM4,800 RM 61,000 RM122,00 RM 70,000 Charge straight to product 610 purchase orders 1,220 deliveries 4,000 hours of shelf stocking 650,000 items sold RM125,000 Customer support Total 382,800 Soft Drinks Fresh Products Packaged Foods Revenues Cost of goods sold Bottle-return costs Ordering costs Delivery costs Shelf-stocking costs Customer support costs Total costs Operating income Operating income - Revenues Analyse the situation using the two costing system. Suggest some recommendations to 99 Supermarket management