Problem: [Total marks 451 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 4 3 2 3 3 4500 5 N Non-electronic Components 1 3 N 2 2500 10 Assembly time 1 (hours) Selling Price (per 70 unit) 80 150 110 Part 11 Q2. Solve the spreadsheet model using Excel Solver to generate Answer and Sensitivity reports and answer the following questions. By Looking at the Excel Solver reports above answer the following questions with brief explanations. [Note: Answers without brief explanations would not qualify for full marks] [2] i. What is the impact on profit of a change in the supply of nonelectronic components? [2] ii. What is the impact on profit if we could increase the supply of electronic components by 400 units (to a total of 5,100)? iii. In the previous question what would happen, if we could increase the supply of electronic components by 4,000 units (to a total of 8,700 units)? [2] iv. Refer to the question about getting an additional 400 units of electronic components. What would happen if the supplier of these 400 units wanted 8 per unit rather than the current cost of 7 per unit? [2] V. [3] Assume that we have the opportunity to get 250 additional hours of assembly time. However, this extra time will cost us 15 per hour rather than the current cost of 10 per hour. Should we take it? vi. If we force the production of VCRs, what would be the impact on total profit? [2] vii. How profitable must VCRs become before Anderson would consider producing them? [2] viii. Assume that there is some uncertainty in the price for DVD players. For what range of price will the current production remain optimal? If DVD players sold for 106, what would be Anderson's new total profit? [3]