URGENTTTTTT

I need step by step solution on excel file also. Its Urgent The J$.$ Mehta Company$$s production manager isplanning for a series of $1-$month production periodsfor stainless steel sinks$.$ The demand for the next$4$ months is as follows:MONTHDEMAND FORSTAINLESS STEEL SINKS$1120216032404100$Pl

$\backslash$table$[[$MONTH$,\backslash$table$[[$DEMAND FOR$],[$STAINLESS STEEL SINKS$]]],[1,120],[2,160],[3,240],[4,100]]$The Mehta firm can normally produce $100$ stainlesssteel sinks in a month. This is done during regular pro$-$duction hours at a cost of $$100$ per sink. If demand inany $1$ month cannot be satisfied by regular production,the production manager has three other choices: $(1)$ hecan produce up to $50$ more sinks per month in overtime but at a cost of $$130$ per sink; $(2)$ he can purchase alimited number of sinks from a friendly competitorfor resale $($the maximum number of outside purchasesover the $4-$month period is $450$ sinks$,$ at a cost of $$150$each$)$; or $(3)$ he can fill the demand from his on$-$handinventory. The inventory carrying cost is $$10$ per sinkper month. Back orders are not permitted. Inventory onhand at the beginning of month $1$ is $40$ sinks$.$ Set upthis $$production smoothing$$ problem as a transporta$-$tion problem to minimize cost.