i need the answer to be by excel solver

Problem for Group N (formulate the problem and find optimal solution) 51 Silicon Valley Corporation (Silvco) manufactures transistors. An important aspect of the manufacture of transistors is the melting of the element germanium (a major component of a transistor) in a furnace. Unfortunately, the melting process yields germanium of highly variable quality. Two methods can be used to melt germanium; method 1 costs $50 per transistor, and method 2 costs $70 per transistor. The qualities of germanium obtained by methods 1 and 2 are shown in Table 80. Silvco can refire melted germanium in an attempt to improve its quality. It costs $25 to refire the melted germanium for one transistor. The results of the refiring process are shown in Table 81. Silvco has sufficient furnace capacity to melt or refire germanium for at most 20,000 transistors per month. Silvco's monthly demands are for 1,000 grade 4 transistors, 2,000 grade 3 transistors, 3,000 grade 2 transistors, and 3,000 grade 1 transistors. Use linear programming to minimize the cost of producing the needed transistors. TABLE 80 TABLE 81