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

Find cause the cost of capital to decrease, Due to changes in regulatory re...

Due to changes in regulatory requirements, the transactions costs associated with selling corporate securities increased by $1 per share. This change will Answer a. cause the co

Explain kinds of skills needed by service workers, How does the degree of c...

How does the degree of customer contact relate to the kinds of skills needed by service workers and the degree of training they require?

Describe the impact of social networking, Discuss the impact of social netw...

Discuss the impact of social networking in computing today, and in the future five years

Considering strategic choice - operation strategy, Considering Strategic Ch...

Considering Strategic Choice - Operation Strategy (Strategic analysis will be covered in Strategy - Analysis and Evaluation).  The following points are an extract from Port

Describe approaches to communication as related to managers, Clampitt prese...

Clampitt presented a communication model for his first 2 approaches to communication as related to managers; Arrow & Circuit. What communication model best describes his Dance Appr

Explain how do these policies and practices align, Analyze Apple, Inc.'s le...

Analyze Apple, Inc.'s legal and compliance policies and practices. How do these policies and practices align with Apple, Inc.'s legal compliance standards? If alignment is n

Explain what are the separate problems, One day a teller of a bank was robb...

One day a teller of a bank was robbed. When the robber ran the teller ran after him. Well over taking the robber, the teller was shot in the leg. The teller was given an award for

Explain sustainable competitive business advantage, What might be the most ...

What might be the most effective way to secure cooperation from one's Union in tailoring Total Compensation to help the company achieve a sustainable competitive business advantage

Explain the first step in the process is idle, A bottleneck is an operation...

A bottleneck is an operation that has the lowest effective capacity of any operation in the process. TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement i

Explain is the value of the educational programming, Is the value of the ed...

Is the value of the educational programming provided to hospitals and schools worth the price of the commercial messages that accompany it?

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