part B must be solved by either Excel or lingo or a similar software

A drug company estimates demand (in millions of doses) for one of its vaccines as follows: October, 7.1; November, 13.2; December, 12.8; January, 7.7; and February, 2.1. There is relatively little demand for the vaccine during the other months, and company policy for supply these demands is to have a million doses in inventory at the end of February. The vaccine takes four weeks to produce, so no doses are available for shipping during the month they are produced. Once the vaccine is ready, however, it can either be shipped immediately to customers or carried forward as inventory at a cost 10 cents per dose per month. Traditionally, the company produces the vaccine only between August and December inclusively. Any vaccine remaining in inventory from the previous year is destroyed on September 1. The company's production capacities (in millions of doses) and the anticipated production costs (in cents per dose) for each month of the upcoming production cycle are as follows: (a) Think this production planning problem as a transportation problem, and fill the following transportation tableau: (b) Determine a production plan that meets all demands at minimum total cost