please provide as excel solution.

Consider a store that sells a perishable product, such as a case of Chobant low-fat passion fruit yogurt. The product has an initial inventory of 400 units that need to be sold during a four week horizon and there are no replenishment opportunities for the product. The past data suggest the product has the following linear demand structure for the four weeks Chobani yogurt T " Week Intersept 00 " S 400 400 400 Slope 41 -1.B L.M - Part A (25 points). Determine a pricing strategy for the product that enables the store to liquidate all units of the product available at the beginning of Week 1 by maximizing the total revenue over the four week penod. Conduct your analysis in the sheet "Part A" of the MS Excel file "in-class Exercise #5.xlsx" teost of the product is $100, determine how many units Consider a store that sells a perishable product, such as a case of Chobant low-fat passion fruit yogurt. The product has an initial inventory of 400 units that need to be sold during a four week horizon and there are no replenishment opportunities for the product. The past data suggest the product has the following linear demand structure for the four weeks Chobani yogurt T " Week Intersept 00 " S 400 400 400 Slope 41 -1.B L.M - Part A (25 points). Determine a pricing strategy for the product that enables the store to liquidate all units of the product available at the beginning of Week 1 by maximizing the total revenue over the four week penod. Conduct your analysis in the sheet "Part A" of the MS Excel file "in-class Exercise #5.xlsx" teost of the product is $100, determine how many units