1107 Words5 Pages

The homework problems for Module 4 are: 2-24, 34, 36, 38 (you only have to do part A for these problems. You do not have to do the part B graphical solutions) and 3-10, 12 (parts B and C for Problem 12), 28, 30. Please use Excel solver function.

I posted an annotated solution to Problem 2-5. This problem is an examplar for both the chapter 2 and 3 problems. In this example I show how I typically set up a problem. First I set up the linear programming model and then develop a parallel set-up to use as input to the Solver add-in. I use this strategy because I first like to set up the problem solution before I worry about setting up the parameters for using Solver.

24. Universal Claims Processors processes insurance claims for large*…show more content…*

-------------------------------------------------

Hours/ Unit

-------------------------------------------------

Product Line 1 Line 2

-------------------------------------------------

A 12 4

-------------------------------------------------

B 4 8

-------------------------------------------------

Total hours 60 40 a. Formulate a linear programming model to determine the optimal product mix that will maximize profit.

12. For the linear programming model formulated in Problem 10 and solved graphically in Problem 11: a. Determine the sensitivity ranges for the objective function coefficients, using graphical analysis.

b. Verify the sensitivity ranges determined in ( a) by using the computer. c. Using the computer, determine the shadow prices for additional hours of production time on line 1 and line 2 and indicate whether the company would prefer additional line 1 or line 2 hours.

28. The Bluegrass Distillery produces custom- blended whiskey. A particular blend consists of rye and bourbon whiskey. The company has received an order for a minimum of 400 gallons of the custom blend. The customer specified that the order must contain at least 40% rye and not more than 250 gallons of bourbon. The customer also specified that the blend should be mixed in the ratio of two parts rye to one part bourbon. The distillery can produce 500

I posted an annotated solution to Problem 2-5. This problem is an examplar for both the chapter 2 and 3 problems. In this example I show how I typically set up a problem. First I set up the linear programming model and then develop a parallel set-up to use as input to the Solver add-in. I use this strategy because I first like to set up the problem solution before I worry about setting up the parameters for using Solver.

24. Universal Claims Processors processes insurance claims for large

-------------------------------------------------

Hours/ Unit

-------------------------------------------------

Product Line 1 Line 2

-------------------------------------------------

A 12 4

-------------------------------------------------

B 4 8

-------------------------------------------------

Total hours 60 40 a. Formulate a linear programming model to determine the optimal product mix that will maximize profit.

12. For the linear programming model formulated in Problem 10 and solved graphically in Problem 11: a. Determine the sensitivity ranges for the objective function coefficients, using graphical analysis.

b. Verify the sensitivity ranges determined in ( a) by using the computer. c. Using the computer, determine the shadow prices for additional hours of production time on line 1 and line 2 and indicate whether the company would prefer additional line 1 or line 2 hours.

28. The Bluegrass Distillery produces custom- blended whiskey. A particular blend consists of rye and bourbon whiskey. The company has received an order for a minimum of 400 gallons of the custom blend. The customer specified that the order must contain at least 40% rye and not more than 250 gallons of bourbon. The customer also specified that the blend should be mixed in the ratio of two parts rye to one part bourbon. The distillery can produce 500

Related

## Advantages Of Linear Programming

885 Words | 4 Pagesas linear equalities and inequalities in terms of decision variables. An LP solution may be accepted provided these constraints are satisfied by it. Along with resource constraints, one more assumption that act as a constraint is known as “non- negativity” constraint or restriction. As per this constraint, the decision variables can take either zero or positive values. 2.1.2 Advantages of Linear Programming Below mentioned are few advantages of linear programming method • Linear programming method

## Question Paper of Mba

1832 Words | 8 Pages5. What is an assignment problem? It is true to say that it is a special case of the transportation problem? Explain. How can you formulate an assignment problem as a standard linear programming problem? Illustrate. What do you understand by an assignment problem? Give a brief outline for solving it. 6. What are different types of inventories? Explain. What functions does inventory

## Analysis

1340 Words | 6 PagesAssignment Week 1 Answer the following questions: 1. Describe the rationale for utilizing probability concepts. For practical reasons, variables are observed to collect data. The sampled data is then analyzed to elicit information for decision making in business and indeed in all human endeavors. However, sampled information is incomplete and not free from sampling error. Its use in decision-making processes introduces an element of chance. Therefore, it is important for a decision-maker

## Brs Mdm3 Tif Ch05 Essay

1883 Words | 8 PagesTransportation, Assignment, and Network Models 5.1 Chapter Questions 1) Which of the following is NOT a network flow model? A) Transportation model B) Assignment model C) Product mix model D) Shortest-path model E) Minimal-spanning tree model Answer: C Page Ref: 162 Topic: Introduction Difficulty: Easy 2) Which of the following models determines the path through the network that connects all the points? A) Transportation model B) Assignment model C) Product mix model D) Shortest-path model E) Minimal-spanning

## 12

2155 Words | 9 PagesASSIGNMENT BRIEF Qualification Unit number, Code and Title Pearson BTEC Level 5 HND Diploma Business Unit 34, R/505/8181, Operations Management in Business Module Leader: Lecturers: Abimbola Taiwo Ousman Kolley, Abimbola Taiwo Distribution date Submission deadline W/C – 22/09/14 7th December 2014 Assignment title Operations Management in Business Learning Outcome Learning outcome Assessment Criteria In this assessment you will have the opportunity to present evidence that shows you are able

## Management Science

1375 Words | 6 Pagesnot feel that this is a significant enough increase in Profit Margin to take on the additional risk of maintenance and possible additional costs associated with taking on an additional loom. Let alone the additional cost of purchasing the loom. Question 4: A discussion of the objective coefficients ranges: A shorter range indicates a more sensitive variable (concerning the objective function coefficients). The shortest ranges we found was that of the Qty of Fabric 1 manufactured on dobbie and

## Essay on The Art and Science of Java

3918 Words | 16 PagesAnswers to Review Questions Chapter 1. Introduction 1. Babbage’s Analytical Engine introduced the concept of programming to computing. 2. Augusta Ada Byron is generally recognized as the first programmer. The U.S. Department of Defense named the Ada programming language in her honor. 3. The heart of von Neumann architecture is the stored-programming concept, in which both data and programming instructions are stored in the same memory system. 4. Hardware is tangible and comprises the physical parts

## Rt3Apjfpajpofjpoajfasda

2811 Words | 12 PagesChapter 13 Aggregate Planning True / False Questions 1. Aggregate planning is intermediate-range capacity planning that typically covers a time horizon of one to three months. FALSE Difficulty: Medium TLO: 1 Taxonomy: Knowledge 2. The goal of aggregate planning is to achieve a production plan that attempts to balance the organization's resources and meet expected demand. TRUE Difficulty: Easy TLO: 1 Taxonomy: Knowledge 3. Aggregate planners are concerned

## Assignment of S/W Eng..

1401 Words | 6 PagesU9 Assignment of Software Engineering Homework-1 Submitted by: Submitted To: Name: Abhishek Mr. Amandeep sir Section: E - 3004 Roll_No: RE3004B58 Group : 2 Part – A Q1: Take a suitable example to develop a software and implement the waterfall Model technique in it to develop the software ? Ans: The waterfall

## Using Stepping Stone and Modi Methods to Solve Transportation Problems

9897 Words | 40 Pagespervading competition while others simply mismanaged their successes. One thing stands out though, and that is the deficiency of these transporters in the management of peak periods. Thus the need to use mathematical models and scientific algorithms in the scheduling and assignment of organizational resources for the purpose of optimizing the use of organizational resources is necessary in order to bring about maximum utilization of resources to yield productive improvements more especially in the

### Advantages Of Linear Programming

885 Words | 4 Pages### Question Paper of Mba

1832 Words | 8 Pages### Analysis

1340 Words | 6 Pages### Brs Mdm3 Tif Ch05 Essay

1883 Words | 8 Pages### 12

2155 Words | 9 Pages### Management Science

1375 Words | 6 Pages### Essay on The Art and Science of Java

3918 Words | 16 Pages### Rt3Apjfpajpofjpoajfasda

2811 Words | 12 Pages### Assignment of S/W Eng..

1401 Words | 6 Pages### Using Stepping Stone and Modi Methods to Solve Transportation Problems

9897 Words | 40 Pages