please help me solve in excel

The J. Mehta Company's production manager is planning a series of one-month production periods for stainless steel sinks. The forecasted demand for the next four months is as follows: The Mehte firm can normally produce 100 stainless steel sinks in a month This is done during regular production hours at a cost of $95 per sink. If demand in any one month cannot be satisfied by rogutar production, the production manager has three other choices: (1) he can produce up to 35 more sinks per month in evertime but at a cost of $125 per sink: (2) he can purchase a limited number of sinks from o friendly competitor for resalo (the maximum number of outside purchases over the fout-month period is 450 sinks, at a cost of $150 each) (3) Ot, he can fill the demand from his on hand inventory (ie beoinning inventory) The inventory carrying cost is 510 per sink per month ( 10 o the cost of holding a sink in inventory at the end of the month is 510 per sink) There are 10 Sinks in Inventory at the beginning of Menth 1 Sotup the Production Smoothing problem with the goal of minimizing cest The J. Mehta Company's production manager is planning a series of one-month production periods for stainless steel sinks. The forecasted demand for the next four months is as follows: The Mehte firm can normally produce 100 stainless steel sinks in a month This is done during regular production hours at a cost of $95 per sink. If demand in any one month cannot be satisfied by rogutar production, the production manager has three other choices: (1) he can produce up to 35 more sinks per month in evertime but at a cost of $125 per sink: (2) he can purchase a limited number of sinks from o friendly competitor for resalo (the maximum number of outside purchases over the fout-month period is 450 sinks, at a cost of $150 each) (3) Ot, he can fill the demand from his on hand inventory (ie beoinning inventory) The inventory carrying cost is 510 per sink per month ( 10 o the cost of holding a sink in inventory at the end of the month is 510 per sink) There are 10 Sinks in Inventory at the beginning of Menth 1 Sotup the Production Smoothing problem with the goal of minimizing cest