Solve this problem utilizing Excel solver and provide the management the appropriate recommendations and expected cost

The following table summarizes the parallels between the elements of the production-inventory problem and the transportation model: Solve the following production-inventory problem modeling it as a transportation problem. Soala Co. produces solar powered air conditioning systems for use in households. The periods with major demand are during Spring and Summer (i.e., through March until August). The demand starts slow, peaks in the middle of the season, and tapers off toward the end. The following table provides the production capacities and demands (in hundreds) for the six montr under consideration for the Santa Clara county: The unit production costs during March and April is $600, for months May and June is a little bit more expensive at $900, and it goes down to $700 during July and August. The holding cost per unit per month is $50, during any month