Reference no: EM13962886
Problem:
A company makes products C and D from 2 resources, labor and material. The company wants to determine the selling price which will maximize profits. One unit of C costs $30 to make and demand is estimated to be 50 - .09 * Price of C. One unit of D costs $20 to make and demand is estimated to be 30 - .14 * Price of D. The utilization of labor and materials and the available quantity of resources is shown in the table. A reasonable price for the products is between 90 and 140.
Product C D Available resources
Labor (hr/unit) 2 4 150
Material (ounces/unit) 2 8 220
Manufacturing cost($/unit) 30 20
Demand (units) 50 - 0.09*P1 30 - 0.14*P2
(Part a) Let X1 = demand for C's and X2 =demand for D's. Let P1 = price for C's and P2 = price for D's. Provide an algebraic formulation for the NLP.
(Part b) Implement and solve the problem in Excel. Describe the optimal solution.
(Part c) Comment on the values of the Lagrange multipliers for the Labor and Material availability constraints. What is worth noting?
The following problem requires the use to the Solver add-in within Excel. No other software application(s) will suffice for the purposes of this learning exercise. Please show all work and label the answers, so the student can benefit from context. Note: The problem is also posted in the attached MS Word document, so that it is sure to be legible in transmission. The formatting is disrupted in this text field, but the MS Word document clearly conveys the columns, etc.
|
What does solomon ash''s conformity study
: What does Solomon Ash's conformity study suggest about the impact of groups on us? Why do people choose to change their opinions in groups? Give at least two reasons and explain them.
|
|
Per-case transportation costs
: A logistics specialist for Wiethoft Inc. must distribute cases of parts from 3 factories to 3 assembly plants. The monthly supplies and demands, along with the per-case transportation costs are:
|
|
Find the magnetic field at the disk center
: A small/thin circular conducting disk that can carry total current, as represented by 'I'. The current path is circular at every distance from the center of the disk, and the each circle center is the disk center.
|
|
Optimal solution to a linear programming problem
: Explain the following statement with an example: the optimal solution to a linear programming problem can be found at an extreme point of the feasible region for the problem.
|
|
Reasonable price for the products
: One unit of D costs $20 to make and demand is estimated to be 30 - .14 * Price of D. The utilization of labor and materials and the available quantity of resources is shown in the table. A reasonable price for the products is between 90 and 140.
|
|
Determine the number of knee replacements
: Determine the number of knee replacements (in units) that particular wing must perform each month to break even. (Break-Even Point or BEP). In other words how many knee replacements must the surgeon perform each month to break-even
|
|
What is primary characteristic of decentralized organization
: What is the primary characteristic of a decentralized organization? Why is investing in foreign companies an effective way to diversity an individual's investment portfolio?
|
|
Calculate the expected mass of this hypothetical meson
: Considering Yukawa's hypothesis that the nuclear force should be due to the exchange of massive particles (that he called mesons), calculate the expected mass of this hypothetical meson.
|
|
The lorentz force and behavior of current carrying conductor
: You will run a simulation of Lorentz force exerted on a current carrying conductor located in the magnetic field of a horseshoe magnet. The experiment is set up so that you can change the direction of polarity of the magnet and the direction of th..
|