Problem: Total marks 45) Anderson Electronics is considering the production of four potential products: VCRs, stereos, TVs, and DVD players. The input for all products can be viewed in terms of just three main resources: electronic components, nonelectronic components, and assembly time. The composition of the four products in terms of these three inputs is shown in the table below, along with the unit selling prices of the products. Electronic components can be obtained at 7 per unit; nonelectronic components can be obtained at 5 per unit; assembly time costs 10 per hour. Each resource is available in limited quantity as shown in the table. VCR Stereo TV DVD Supply Cost Player (per unit) Electronic 3 3 4700 7 Components Non-electronic 2 3 4500 5 Components 3 2 N N 4 1 3 2 2500 10 Assembly time 1 (hours) Selling Price (per 70 unit) 80 150 110 Part IV Prepare a short technical report on the above problem. The report should not exceed 2 pages of A4 (12 point font, single spacing) including any output tables from the Excel Solver solution. [7]