Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed

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 excel

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Manufacturing Planning And Control For Supply Chain Management

Authors: F. Robert Jacobs, William Berry, David Clay Whybark, Thomas Vollmann

6th Edition

0073377821, 9780073377827

More Books

Students also viewed these General Management questions