Find optimal solution affected, Operation Management

Assignment Help:

1. Sydneyville manufactures household and commercial furnishings. The office division produces two desks, rolltop and regular. Sydneyville constructs the desks in its plant outside Medford, Oregon, from a selection of woods. The woods are cut to a uniform thickness of 1 inch. For this reason, one measures the wood in units of square feet. One rolltop desk requires 10 square feet of pine, 4 square feet of cedar, and 15 square feet of maple. One regular desk requires 20 square feet of pine, 16 square feet of cedar, and 10 square feet of maple. The desks yield respectively $115 and $90 profit per sale. At the current time the firm has available 200 square feet of pine, 128 square feet of cedar, and 220 square feet of maple. They have backlogged orders for both desks and would like to produce the number of rolltop and regular desks that would maximize profit. a. Identify the decision variable. b. Write down the objective function. c. Write down the constraints. d. Solve the problem graphically. e. Solve the problem using EXCEL SOLVER. f. Find the optimal mix and optimal value. 2. Continuing with Q1 above, use Sensitivity (post optimality) analysis to answer following questions: a. Sydneyville's sales manager has renegotiated the contract for regular desks and now expects to make a profit of $125 on each. He excitedly conveys this information to the firm's production manager, expecting that the optimal mix of rolltop and regular desks will change as a result. Does it? b. Suppose that the new contract also has higher profit for the rolltop desks. If the new profit for the rolltop desks is $140, how will this change the optimal solution? c. A logging company has offered to sell Sydneyville an additional 50 square feet of maple for $5.00 per square foot. Based on the original objective function, would you recommend that they accept the offer? d. Assuming that Sydneyville purchases the 50 square feet of maple, how is the optimal solution affected?


Related Discussions:- Find optimal solution affected

Explain causes of labour turnover, Explain  causes of labour turnover. ...

Explain  causes of labour turnover. Causes of Labour Turnove: (a) Voluntary withdrawals (through the worker) because of: - Not like for the present job; - Best job

Explain the different stages of group development, Question 1: There is...

Question 1: There is no use in considering non-financial issues when motivating people as many consider that money is the prime and only motivating factor. Discuss this st

Explain first step in your data analytical project, Your final project enta...

Your final project entails systematic extraction of decision-aiding insights out of a dataset provided to you in the Doc Sharing area. This project will provide you with hands-on e

Explain functional structure with simple structure, Explain how the followi...

Explain how the following somewhat match each other: • functional structure with simple structure • divisional structure with departmentalization by product • machine bureaucracy w

What are some new products organizational markets, What are some new produc...

What are some new products I could use that serve two business (organizational) markets?

Compute xpected top-down estimated cost for project, You have been asked to...

You have been asked to estimate the costs for a project to build an industrial power plant. Based on historical data, the steam turbine accounts for 30 percent of the total costs f

I want examples of some of these that are associated stories, I need exampl...

I need examples of some of these that are associated with the university. Liberty University. I know what they are i just need help with stories or exaples of these things that are

Decribe an examination-taking work plan, 1 Page maximum for the whole quest...

1 Page maximum for the whole question] : College students are "invincible". They study on the floor, spread their materials on the floor and lean over to access them, slouch in a c

Explain the drug research and distribution industry, If Merck can donate $5...

If Merck can donate $50 million in free doses of ivermectin, what does that say about the amount of revenue the company generates in the drug research and distribution industry?

Write Your Message!

Captcha
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