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

Describe mpc can run independent of the operation plan, Which of the follow...

Which of the following is true? MPC can run independent of the operation plan. Business failure can result from poor MPC performance. In PAC, order release directly affect

Explain benefits and variable pay, Benefits and Variable Pay Please respond...

Benefits and Variable Pay Please respond to the following- • Analyze the types of benefits usually available in the health care industry and determine which benefits are most im

Explain what contract type puts more risk on the buyer, What are the differ...

What are the different types of contracts and how do they impact risk? What contract type puts more risk on the buyer? What contract type puts more risk on the seller?

Traditional accounting based measurements, Traditional Accounting Based Mea...

Traditional Accounting Based Measurements and Their Limitations  Neely (1999) suggests that traditional financial measures of performance are criticised because they:

Explain all the principles of organization, Explain all the principles of o...

Explain all the principles of organization. Principles of Organization: Organization is a structure or mechanism which enables living things to work efficiently together.

Cell or group layout - process design, Cell or Group Layout - Process Desig...

Cell or Group Layout - Process Design In the years following World War II a novel form of layout was developed in Eastern Europe, suitable for many small to medium-batch opera

Explain technologies to keep the organization competitive, Select an organi...

Select an organization. Who are the stakeholders of your selected organization? How would the stakeholders be affected by the failure of the organization to keep up with new techno

How minimize the work-in-process inventory, The production manager must det...

The production manager must determine the processing sequence for 7 jobs through the grinding and debarring departments. The same sequence will be followed in both departments. The

I need to describe forecasting, I need to explain forecasting, also how it ...

I need to explain forecasting, also how it is performed at St. Arnold's Brewery (Houston, TX) also what forecasting error is and if there has been any in the past.

Make an aggregate plan, Prepare an aggregate plan for the coming year assum...

Prepare an aggregate plan for the coming year assuming that the sales forecast is perfect Use a spreadsheet Bradford Manufacturing in the spreadsheet an area has been designated fo

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