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?

Reference no: EM13106136

Questions Cloud

What is the ratio of the current in bulb a : Two lightbulbs operate on the same potential difference. Bulb A has four times the power output of bulb B. What is the ratio of the current in bulb A to the current in bulb B?
Calculating productivity : Lori produces "Final Exam Care Packages" for resale by her sorority. She is currently working a total of 5 hours per day to produce 100 care packages.
What is the work done by friction : A skier of mass 68.4 kg glides down a hill of slope 26.5 degree at constant speed. If she travels a distance 35.0m down the hill, what is (a) the work done by friction and (b) the coefficient of friction between her skis and the slope?
Find the work done by the force on the particle : A force F= (6x - 2y)N acts on a particle that undergoes a displacement delta r= (3x + y)m. Find (a) the work done by the force on the particle and (b) the angle between F and r.
Find the optimal mix and optimal value : 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.
Determine the speed of the object : A 0.48-kg object connected to a light spring with a force constant of 23.6 N/m oscillates on a frictionless horizontal surface. The spring is compressed 4.0 cm and released from rest.
Essay on how objects either do or don-t help form modify : Write down 2-3 page essay in which you consider how objects either do or don't help form, modify, or enforce the image which individuals project to people around them.
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 supervisors and twenty-eight employees in the new procedures.
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 investment of $800,000 Variable cost of $45/unit.

Reviews

Write a Review

Operation Management Questions & Answers

  Book review - the goal

Operations Management is about a book review. Title of the book is "Goal". This book has been written by Dr. Eliyahu Goldartt. The book has been appreciated by many as one of those books which offers an insight into the operations and strategic capac..

  Operational plan in hospitality enterprise

Operational plan pertaining to a hospitality enterprise is given in detail in the solution. The operational plan is an important plan or preparation which gives guidelines regarding the role and responsibilities of each and every operation at all lev..

  Managing operations and information

Recognise the importance of a strategic approach to the development and deployment of organisational information systems. Demonstrate an understanding of the importance of databases and their integration to the organisation's overall information mana..

  A make-or-buy analysis

An analysis of the holding costs, including the appropriate annual holding cost rate.

  Evolution and contributor of operations management

Briefly explain Evolution and contributor of Operations management.

  Functions and responsibilities of an operations manager

A number of drivers of change have transformed the roles, functions and responsibilities of an operations manager over recent years. These drivers have not only been based on technological innovations but also on the need for organisations to develop..

  Compute the optimal order quantity

Compute the Optimal Order quantity of DVD players. Determine the appropriate reorder point.

  Relationship to operations practice in the organisation

Evaluate problems in operations and identify approaches to overcoming them. Critically evaluate operating plans and identify areas for improvement. Justify, implement and evaluate changes to operations in line with modern approaches.

  A make or buy analysis

Develop a report for Figi Fabricating that will address the question of whether the company should continue to purchase the part from the supplier or begin to produce the part itself.

  Prepare a staffing plan

Prepare a staffing plan showing the change of your unit from medical/surgical staffing to oncology staffing.

  Leadership styles in different organizations

Ccompare the effectiveness of different leadership styles in different organizations

  Risk management tools and models

Be able to understand the concept of risk, roles and responsibilities for risk management and risk management tools and models.

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