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

Calculate the economic order quantity, A local nursery greens uses 1560 bag...

A local nursery greens uses 1560 bags of plant food annually. Green works 52 weeks per year. It costs $10 to place an order for plant food. The annual holding cost rate is $5 per b

Explain what changes in culture are needed at the plaza inn, 1. How could t...

1. How could the Plaza Inn develop a collaborative strategy? Develop a specific plan. 2. How could technology help solve the problems at the front desk? Explain what you propose

Explain the fixed cost and the variable cost of production, The fixed cost ...

The fixed cost and the variable cost of production of product are 200000USD and demand is 500units to break even unit price of first 300 item will be?

Explain college management and faculty, Pretend you are attending a college...

Pretend you are attending a college if you are not and answer the following questions. Putting together college classes for a given term is no mean problem in production scheduling

Explain the three steps in completing a job analysis, As an entrepreneur, h...

As an entrepreneur, how would you go about doing a job analysis for the first employee you are going to hire in your new business? What are the three steps in completing a job anal

Explain the four-step framework, Describe the four-step framework for one-t...

Describe the four-step framework for one-to-one marketing that can be adapted to CRM marketing?

Explain what is the maximum time in hours the machine, 2-10 minute breaks, ...

2-10 minute breaks, 1-20minute lunch, 1-10 minute clean up, restroom. What is the maximum time in hours the machine is available to run in a single shift?

Explain units of output per dollar of input, A hamburger factory produces 4...

A hamburger factory produces 40,000 hamburgers each week. The equipment used costs $5,000 and will remain productive for 4 years. The labor cost per year is $9,500. a. What is the

Explain the business-level strategy, Research the corporate-level of strate...

Research the corporate-level of strategies and evaluate the business-level strategy do you believe is appropriate to offset forces in the industry for Victory Motorcycles. Can you

Describe analyze the elements of a typical scope statement, Analyze the ele...

Analyze the elements of a typical scope statement and the significance of each element. As a project leader, determine how you would communicate the scope of a project to the proje

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