### Find the optimal mix and optimal value

Assignment Help Operation Management
##### Reference no: EM13106136

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?

#### Describe training method

Suppose you are the manager of an accounts receivable unit in a large company. You are switching to a new system of billing and record-keeping and need to train your three sup

#### Create decision tree and calculate expected monetary value

Superior Products Inc. is considering two potential equipment alternatives for production of their best selling product line. Option 1 involves proven equipment: Fixed cost in

#### Determine the minimum width of the displayed letter strokes

Assume you are going to give a presentation to about 30 people in a medium sized room. In order to maximize the contrast, you used black letters on white background in your sl

#### Calculating the mad, mse, and mape

The Cardinal Electronics Company must project the sales of cellular phones for the next year (called year 2). The number of cell phones sold by Cardinal Electronics in each of

#### Determine the expected value of perfect information

Mary Decker is thinking of suing the manufacturer of her car because of a defect that she believes caused her to have an accident, and kept her out of work for a year.

#### Explanation for negotiating pay and benefits

Use the internet to research how an interviewee or a current employee might negotiate better pay and/or benefits. Consider using a search term like "negotiating pay and benefi

Discuss the advantages and disadvantages of end-user computing and determine if this is an application that should be progressively pursued. Explain your rationale.

#### Simple minimizing process velocity

Recently some Operations Management experts have begun insisting that simple minimizing process velocity, which actually means minimizing the time that it takes to process som