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 electronic information exchanges throughout firms, Of focus in any ...

Of focus in any HMIS is data compatibility, which includes the use of common codes and data definitions, specifically used for electronic information exchanges throughout the organ

What are the advantages of using single sourcing strategies, What are the a...

What are the advantages of using single sourcing strategies? Advantages of using Single sourcing: a. Simple to keep relations along with only one supplier b. Simple to

Problem on abc analysis of inventory, Problem on ABC Analysis of Inventory:...

Problem on ABC Analysis of Inventory: The ABC Analysis of Inventory divides inventory into three classes: Class A - high annual dollar volume Class B - medium annual doll

Explain what are the causes of the quality problems, 1. What are the causes...

1. What are the causes of the quality problems on the Greasex line? Display your answer on a fishbone diagram. 2. What general steps should Hank follow in setting up a continuou

Service blueprinting - process design, Service Blueprinting - Process Desig...

Service Blueprinting - Process Design Most of the recording techniques described so far had their origins in the heyday of scientific management. Service blueprinting is much

Process design, Process Design New product is not realities unit they...

Process Design New product is not realities unit they are manufactured. Process design is necessary to manufacture new products. Process design is concerned with the overall

Explain dispute arises the hotel management, A famous New York City hotel, ...

A famous New York City hotel, Hotel Lux, is noted for its food as well as its luxury accommodations. Hotel Lux contracts with a famous chef, Chef Perlee, to become its head chef at

Simulation problem, neater eater hamburger joints frequency distribution op...

neater eater hamburger joints frequency distribution operation research problem

Multifactor productivity, A company that makes shopping carts for supermark...

A company that makes shopping carts for supermarkets and other stores recently purchased some new equipment that reduces the labor content of the jobs needed to produce the shoppin

How to determine the capacity requirements, Electronics assembly operates t...

Electronics assembly operates two 8 hours shifts for 275 days per year. Use this information in the table to determine the capacity requirements. Cell Phone Demand forecast (phones

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