Based on the information provided, develop a linear programming model for Zeta's production planning. Solve the problem using the Linear Programming module within Excel Solver, and develop a production plan for Zeta for the next six months.
Zeta is a producer of a variety of microprocessors and memory chips that are used in products such as automobiles, computers, digital cameras, and so on. Although the microprocessors for each application are unique, they can be broadly placed into three classes: low grade (LG), medium grade (MG), and high grade (HG). Because of long supplier lead times, Zeta plans its production based on a six-month rolling horizon. Table 9.15 shows the expected demand for each of the three types of microprocessors for the next six months.
In table 9.15

Month LG MG 50,000 25,000 15,000 45,000 20,000 18,000 35,000 30,000 28,000 32,000 HG 35,000 40,000 46,000 60,000 20,000 22,000 21,000 20,000