Freddy Electronics must develop a plan to allocate capacity to fulfilling forecasted demand of $400$ units in

March, $500$ units in April, and $700$ units in May. Freddy's have $75$ units of inventory currently on hand.

For each month, they can produce units as follows:

Assume the following costs:

Develop an Excel model that allocates production capacity to satisfy demand at a minimum cost. Do it using Excel Solver only. It is mandatory for this question and also explain which formulas have been used in the solver for further clarity. ie$.,$ a Formula page and then a final output page with the solver solution $.$ I need this ASAP