use excel

1. The Energetic company needs to make plans for the energy systems for a new building. The energy needs in the building fall into three categories: (1) electricity, (2) heating water, and (3) heating space in the building. The daily requirements for these three categories (all measured in the same units) are 20 electricity units, 10 heating water units, and 30 space heating units. The three possible sources of energy to meet these needs are electricity, natural gas, and a solar heating unit that can be installed on the roof. The size of the roof limits the largest possible solar heater to 30 units, but there is no limit to the electricity and natural gas available. Electricity needs can be met only by purchasing electricity (at a cost of 50KWD per unit). Both other energy needs can be met by any source or combination of sources. The unit costs are given in the following table. The objective is to minimize the total cost of meeting the energy needs. a. Define the decision variables. (3 points) b. Formulate and solve a linear|program to minimize the energy costs of meeting the energy needs. (12 points)) c. Which heating requirement (water or space) would you consider reducing to lower cost? Explain. (5 points)