Please solve this optimization question using excel solver and show all work withing the clees. You have a small shop that manufactures bicycles. Based on the data you have collected across the years, you have precise data for your demand for every month of the coming year. You must meet this demand every month, but you are allowed to overproduce and store bicycles from month$-$to$-$month. Your forecasted demand is as follows: Jan$-10,$ Feb$-10,$ Mar$-15,$ Apr$-25,$ May$-50,$ Jun$-75,$ Aug$-50,$ sept$-25,$ oct$-15,$ nov$-10,$ Dec$-10.$ The variable costs of running this business are storage and churn. You can store inventory from one month to the next at a cost of $$5/$bike You can add production from month$-$to$-$month at a cost of $$25/$bike and you can decrease production from month$-$to$-$month at a cost of $$15/$bike

Your production in the December prior to this year was $10$ bicycles, and you sold all your inventory by the end of that month.

You must finish the calendar year with zero inventory $($for tax purposes$).$

What monthly production schedule will allow you to meet all of your demand, but will minimize the cost of doing business $($churn and storage$)?$ What is that$$total$$cost$?$