Problem 4: (Difficulty level: 1) Short-Run Manufacturing Problems at DEC In the fourth quarter of 1988, the corporate demand/supply group of Digital Equipment Corporation (DEC) was under pressure to come up with a manufacturing plan for dealing with a series of major supply shortfalls that were impacting on the production, revenue, and customer satisfaction of one of DEC's new family of general purpose computer systems and workstations. The critical components for this family of systems that were going to be in short supply in the first quarter of 1989 were CPU chip sets, 1-meg memory boards, 256K memory boards, and disk drives. Pertinent data for these components and their usage in the family of systems is given below: System List price Chip sets 1 Meg memory 256K memory Disk drive avg GP-1 $60,000 2 0.3 GP-2 $40,000 2 1.7 GP-3 $30,000 WS-1 $30,000 1 1.4 WS-2 $15,000 1 1989 First Quarter Availability: 7,000 4,000 15,000 8,000 Brian Shannahan of corporate supply/demand was asked on short notice to formulate a manufacturing strategy given these shortfalls. Brian wanted to take into account both the importance of revenue for DEC as well as the maintenance of DEC's reputation for customer satisfaction and service. Brian took a quick stab at the market sales situation and then developed the following target data for the first quarter of 1989: Minimum Maxinrun Acceptable Customer Supply Demand CP-1 1,800 GP-2 500 CIP-3 300 WS-1 500 WS-Z 400 GP FAMILY 3.800 WS FAMILY 3.200 Brian Shannahan then proceeded to analyze DEC's problem and to formulate a manufacturing strategy. What is the strategy? Use both MATLAB Optimisation Toolbox and Excel Solver to solve the problem and perform sensitivity analysis. Then describe and formulate another two similar Linear Programming problems (with at least 5 design variables and the parameters should come from modern computers) and solve them using both MATLAB Optimisation Toolbox and Excel Solver