Family Supermarkets (FS) has decided to increase the size of its Memphis store. It wants information about the profitability of individual product lines: soft drinks, fresh produce, and packaged food. FS provides the following data for 2020 for each product line:

FS also provides the following information for 2020:

Required

1. Family 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.
2. If Family 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.
3. Comment on your answers in requirements 1 and 2.

Transcribed Image Text:

Revenues Cost of goods sold Cost of bottles returned Number of purchase orders placed Number of deliveries received Hours of shelf-stocking time Items sold Soft Drinks $317,400 $240,000 $ 4,800 144 120 216 50,400 Fresh Produce $840,240 $600,000 $ 0 336 876 2,160 441,600 Packaged Food $483,960 $360,000 $ 0 144 264 1,080 122,400