What formula is used to create the graph? That is where I am stuck. For the Vale

Question

What formula is used to create the graph? That is where I am stuck.

For the Valencia Products model in Problem 1, graph the constraints and identifythe feasible region. Then identify each of the corner points and show how increasing the objective function value identifies the optimal solution. Valencia Products makes automobile radar detectors and assembles two models: LaserStop and SpeedBuster. The firm can sell a it produces. Both models use the same electronic components. Two of these can be obtained only from a single supplier. For the next month, the supply of these is limited to 4,000 of component A and 3,500 of component B. The number of each component required for each product and the profit per unit are given in the table. 1. Components Required/Unit B 6 10 Profit/unit $24 $40 LaserStop SpeedBuster 18 12 a. Identify the decision variables, objective function, and constraints in simple verbal statements b. Mathematically formulate a linear optimization model.

Explanation / Answer

since you are asking formula i am assuming you are using excel...

There is no such formula in excel for graph - GO to insert> chart > Select X,Y scatter chart> Select data> Series 1 edit and then put values(minimum 2 cordinates in order to form a line). And put minimum 2 values of each equation.

Example : Constraint A(Component) = 18X + 12Y <= 3500

Assuming this equation to be linear -

PUt x = 0, Y =3500/12 =291.67

Put Y = 0, X = 3500/18 =194.44

Therefore put (0,291.67) (194.44, 0)

Similarly add other series(i.e. equations) in chart

Feel free to ask any doubt in comments..

Please provide feedback.. Thanks in advance..:-)

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.