Question
Solve the following problem. Full solution needed including complete formulation (constraints, decision variables, object function). Additional need the solution using excel solver. Zevon Enterprises provides
Solve the following problem. Full solution needed including complete formulation (constraints, decision variables, object function). Additional need the solution using excel solver.
Zevon Enterprises provides services for clients worldwide and to protect all parties to this course as well as Zevon, we shall refer to those services as X1, X2, and X3. Each of these services has its own special mix of needs for the resources the company has at its disposal. The X1 product requires three lawyers, seven guns, and $6,000; the X2 product requires two lawyers, five guns, and $4,000; and the X3 product requires four lawyers, six guns, and $7,000. Zevon has access to 5,000 lawyers, 10,000 guns, and $15,000,000. For ease of conversation, Zevon employees usually speak about dollars as "per thousand" so one of them asking for $7 means that they really need $7,000.
Zevon's demand is variable depending on what they charge for it. For example, the X1 product's demand is 200 - 2.25p1. The demand for X2 is 300 - 3p2, and the demand for X3 is 400 - 3.5p3. The per unit profit for X1 through X3 can be calculated by subtracting the per unit cost from the sales price, so for X1, the profit is p1 - 2.25, for X2 the profit is p2 - 3, and for X3 the profit is p3 - 3.5.
Formulate the problem and solve it using excel.
Zevon Enterprises provides services for clients worldwide and to protect all parties to this course as well as Zevon, we shall refer to those services as X1,X2, and X3. Each of these services has its own special mix of needs for the resources the company has at its disposal. The X1 product requires three lawyers, seven guns, and $6,000; the X2 product requires two lawyers, five guns, and $4,000; and the X3 product requires four lawyers, six guns, and $7,000. Zevon has access to 5,000 lawyers, 10,000 guns, and $15,000,000. For ease of conversation, Zevon employees usually speak about dollars as "per thousand" so one of them asking for $7 means that they really need $7,000. Zevon's demand is variable depending on what they charge for it. For example, the X1 product's demand is 2002.25p1. The demand for X2 is 3003p2, and the demand for X3 is 400 - 3.5p3. The per unit profit for X1 through X3 can be calculated by subtracting the per unit cost from the sales price, so for X1, the profit is p1 - 2.25 , for X2 the profit is p2 - 3 , and for X3 the profit is p3 -3.5 . Formulate the problem and solve it using excel. Submit your solution on paper and upload excelStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started