please provide it from excel...

Consider a store that solis a perishable product, such as a case of Chobani 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 . Week 1 Interrupts Slepe . S 400 400 400 4 1. 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 fourweek period. Conduct your analysis in the sheet "Part A of the MS Excel file "in-class Exercise #5.xlsx" Part B (55 points). Suppose the store will also determine the initial procurement quantity of the product. Accordingly, given the unit procurement cost of the product is $100, determine how many units of the product the store should order at the beginning of the horizon, together with the pricing scheme that the firm will pursue over the four weeks to maximize the total profit. Conduct your analysis in the sheet 'Part B of the MS Excel file "in-class Exercise #5.xlsx Part C (20 points). The store would charge relatively higher prices for the product in each period if the store had a higher initial inventory level, ce, greater than 400 units to be cleared over the four weeks is this claim correct? Justify your answer in the sheet Part C of the MS Excel fie "In-class Exercise #5.xlsx" Consider a store that solis a perishable product, such as a case of Chobani 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 . Week 1 Interrupts Slepe . S 400 400 400 4 1. 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 fourweek period. Conduct your analysis in the sheet "Part A of the MS Excel file "in-class Exercise #5.xlsx" Part B (55 points). Suppose the store will also determine the initial procurement quantity of the product. Accordingly, given the unit procurement cost of the product is $100, determine how many units of the product the store should order at the beginning of the horizon, together with the pricing scheme that the firm will pursue over the four weeks to maximize the total profit. Conduct your analysis in the sheet 'Part B of the MS Excel file "in-class Exercise #5.xlsx Part C (20 points). The store would charge relatively higher prices for the product in each period if the store had a higher initial inventory level, ce, greater than 400 units to be cleared over the four weeks is this claim correct? Justify your answer in the sheet Part C of the MS Excel fie "In-class Exercise #5.xlsx