Guide me on how to solve this using both excel and python The extra credit questions are optional. If you choose to complete them and answer them correctly, you will earn the points indicated below. These points will be added on top of the maximum score for this problem and provide an opportunity to boost your overall score before the final exam.

E$1.$ Write the algebraic formulation for Q$1$ and Q$2$ above. $(0\mathrm{.}2$ points$)$

E$2.$ Nancy Grant is the owner of Coal Bank Hollow Recycling, a company that specializes in collecting and recycling paper products. Nancy's company uses two different recycling processes to convert newspaper, mixed paper, white office paper, and cardboard into paper pulp. The amount of paper pulp extracted from the recyclable materials and the cost of extracting the pulp differs depending on which recycling process is used. For instance, every ton of newspaper subjected to recycling process $1$ costs $\backslash (\backslash$$ $12\backslash )$ and yields $0\mathrm{.}9$ tons of paper pulp. The paper pulp produced by the two different recycling processes goes through other operations to be transformed into pulp for newsprint, packaging paper, or print stock quality paper. The yields associated with transforming the paper

products into pulp and the recycled pulp into the final products are summarized in the following table along with the availability of inputs, the demand for the outputs, and the ton cost associated with each operation:

What is the minimum cost way of satisfying customer demand?

a$.$ Solve using Excel Solver $(0\mathrm{.}2$ points$)$

b$.$ Solve using Python $(0\mathrm{.}5$ pts $)$