PLEASE SOLVING MATHEMATICAL MODELS AND LP EXCELL SOLVER PLEASE. I NEED IT QUICKLY. THANK YOU.

4. The demand for an item over the next four quarters is 300, 400, 450 and 250 units, respectively. The price per unit starts at $ 20 in the first quarter and increases by $ 2 each quarter thereafter. The supplier can provide no more than 400 units in any one quarter. Although we can take advantage of lower prices in early quarters, a storage cost of $ 3.5 is incurred per unit per quarter. In addition, the maximum number of units that can be held over from one quarter to the next cannot exceed 100. Develop the model to find the optimum schedule for purchasing the item to meet the demand