Question: PLEASE solve this problem using excel and insert screenshots step by step for solver part. 5. HiDec produces two models of electronic gadgets that use

PLEASE solve this problem using excel and insertPLEASE solve this problem using excel and insertPLEASE solve this problem using excel and insert screenshots step by step for solver part.

5. HiDec produces two models of electronic gadgets that use resistors, capacitors, and chips. The following table summarizes the data of the situation: Unit resource requirements Model 1 ( units) Model 2 ( units) Resource 3 2 2 Resistor Capacitor Chips Unit profit ($) Maximum availability ( units) 1200 1000 800 0 4 3 4 Let xi and x2 be the amounts produced of Models 1 and 2, respectively. Following are the LP model. Maximize z= 3x1 + 4x2 Subject to 2x + 3x2 0 a) Solve the problem using Excel. Use these Excel reports to answer the rest of the questions in this problem. b) What is the impact of adding one resistor to the optimal profit? Repeat for one capacitor and one chip. c) What is the range of applicability of the dual prices of the resistor, capacitor and chip? d) If the available number of chips is reduced to 350 units, can you find the new optimum profit using the information given by Excel. Explain. e) A new contractor is offering to sell HiDeC additional resistors at 40 cents each but only if HiDec would purchase at least 500 units. Should HiDec accept the offer? f) Suppose that the per-unit profit of Model 1 is increased to $3.05. Compute the new optimal solution and the new optimal profit

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!