Question

As the head buyer for a major supermarket chain, you are constantly being asked by manufacturers and distributors to stock their new products. More than 50 new items are introduced each week. Many times, these products are launched with national advertising campaigns and special promotional allowance to retailers. To add new products, the amount of shelf space allocated to existing products must be reduced or items must be eliminated together. Develop a MIS report that you can use to estimate the change in profits from adding or deleting items from an inventory. Your analysis should include input such as estimated weekly sales in units, shelf space allocated to stock items, total cost per unit, and sales per unit. Your analysis should calculate total annual profit by items and then sort the rows in descending order based on total annual profit.

Answer 1

I a. A girl need besties