Solve the model with excel solver

Assignment Help Engineering Mathematics
Reference no: EM13961927

URE Industries gets a productivity of f(x, y) = 2*x^2*y + 3*x*y^2 + 2*y^3

from x units of labor and y units of capital. If labor costs $50 per unit and capital costs $100 per unit, how many units of labor and capital should URE use, given that its budget is 150,000$?

a) Assume that x and y can be positive or negative (URE can either consume or supply labor and capital), formulate the model and solve it with Excel Solver. Try different starting points (initial values in the changing cells).

b) Assume that x and y are nonnegative, solve the model with Excel Solver.

Reference no: EM13961927

Questions Cloud

Type of grass seed to purchase to minimize cost : The company believes it needs to have at least 1,200 pounds of Home 1 mix, 900 pounds of Home 2 mix, and 2,400 pounds of Commerical 3 seed mix on hand. A pound of tall fescue costs the company $1,70, a pound of mustang fescue costs $2.80, and a po..
Calculate vertical distance from the surface of the liquid : An object with height h, mass M, and a uniform cross-sectional area A floats upright in a liquid with density p. Calculate the vertical distance from the surface of the liquid to the bottom of the floating object at equilibrium.
A charge q is placed between two grounded infinite parallel : A charge q is placed between two grounded infinite parallel conducting planes which are a distance "d" apart (see figure attached). Let ε_r = 1.
How much force necessary to maintain uniform motion upward : A weight of 30lb rests on an inclined plane 3 ft high and 5 ft long. a force F making an angle of 30° with the plane pulls the body upward. If the coefficient of friction is 0.20, how much force is necessary to maintain uniform motion upward?
Solve the model with excel solver : Assume that x and y can be positive or negative (URE can either consume or supply labor and capital), formulate the model and solve it with Excel Solver. Try different starting points (initial values in the changing cells).
Solve the linear programming model : For the following problem, solve the linear programming model by using the computer. You must use QM for Windows to solve this problem. Please include the original problem plus results screen in the Word document you create. Follow the format of t..
What the probability that bob will arrive earlier than john : Bob and John are traveling from city A to city D. Bob decides to take the upper route (through B) whereas John takes the lower route, What is the probability that John will not arrive in city D within ten hours? What is the probability that Bob will..
Determining the work-force planning : Work-force planning All-Basa, Inc., produces two models of bookcases, for which relevant data are summarized as follows:
What is the net force applying to the box : Imagine a book on the horizontal surface. without motion (at rest). Gravity force pushing the book down with force 10 N, but the book is remaining on the surface without motion (at rest). What is the Net Force applying to the box?

Reviews

Write a Review

Engineering Mathematics Questions & Answers

  Optimal number of reservations amtrak

Calculate what the optimal number of reservations Amtrak should accept should be. If the optimal number of reservations listed in part 1 is implemented, calculate what the expected value of "loss sales" per trip would be

  What is the test value

A researcher hypothesizes that the variation in the amount of money spent on business dinners is greater than the variation of the amount of money spent on lunches. The variance of nine business dinners was $6.12 and the variance of 12 business lu..

  Describe r by listing the ordered pairs in r

Describe R by listing the ordered pairs in R and draw the digraph of this relation. Is this relation a partial order? Explain.  If this relation is a partial order, draw its Hasse diagram.

  Calculate the average sublimation flux

Air at 1 atm flows at a Reynolds number of 50,000 normal to a long, circular, 1-in.-diameter cylinder made of naphthalene. Using the physical properties of Example 3.14 for a temperature of 100oC, calculate the average sublimation flux in kmol/s-m..

  Determining the parallel-pipe system

For the parallel-pipe system of Fig, each pipe is cast iron, and the pressure drop p1 - p2 = 3 lbf/in2. Compute the total flow rate between 1 and 2 if the fluid is SAE 10 oil at 20°C.

  Member of the family research council

Assume you are a member of the Family Research Council and have become increasingly concerned about the drug use by professional sports players.

  Find the angle resultant force makes with positive

Find the angle the resultant force makes with the positive x-axis. (Let a=24lb and b=18lb. Round your answers to one decimal place.)

  Data with the least squares regression line issues

Show the scatterplot for this data with the least squares regression line. Find R^2. How much of the variation is explained by the regression line?

  Question regarding the apportionment problem

You are a census officer in a newly democratic nation and you have been charged with using the census data from the table below to determine how 100 congressional seats should be divided among the 10 states of the union.

  What is the force exerted by charges a and b on c

Two electrons repel each other with a force of 10-8N. How far apart are they?

  Fifo and lifo costs under perpetual inventory system

Calculate the cost of each individual sale separately using LIFO procedures. The firm uses the perpetual inventory system, and there are 52 units of the item on hand at the end of the year. What is the total cost of the ending inventory according ..

  Analysis of the regressions

Analysis of the Regressions - Make very specific comments and give reasons regarding any similarities or differences in the output results and which regression produces the strongest correlation coefficient result?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd