As the head buyer for a major supermarket chain, you are constantly being asked by manufacturers and distributors to stock their new products. Over 50 new items are introduced each week. Many times,...

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