All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.

Information Report

Category:
## Reviews

Published:

Views: 39 | Pages: 18

Extension: PDF | Download: 3

Share

Related documents

Description

Page 1 of 18 [Page 95] Problems 1. Given the following QM for Windows computer solution of a linear programming model, graph the problem and identify the solution point, including variable values and slack,

Transcript

Page 1 of 18 [Page 95] Problems 1. Given the following QM for Windows computer solution of a linear programming model, graph the problem and identify the solution point, including variable values and slack, from the computer output: [View full size image] 2. Explain the primary differences between a software package such as QM for Windows and Excel spreadsheets for solving linear programming problems. 3. Given the following Excel spreadsheet for a linear programming model and Solver window, indicate the formula for cell B13 and fill in the Solver window with the appropriate information to solve the problem: [View full size image] Page 2 of 18 [Page 96] 4. Given the following graph of a linear programming model with a single constraint and the objective function maximize Z = 30x x 2, determine the optimal solution point: Page 3 of 18 Determine the values by which c 1 and c 2 must decrease or increase in order to change the current solution point to the other extreme point. 5. Southern Sporting Goods Company makes basketballs and footballs. Each product is produced from two resourcesrubber and leather. The resource requirements for each product and the total resources available are as follows: Resource Requirements per Unit Product Rubber (lb.) Leather (ft. 2 ) Basketball 3 4 Football 2 5 Total resources available 500 lb. 800 ft. 2 [Page 97] Each basketball produced results in a profit of $12, and each football earns $16 in profit. a. Formulate a linear programming model to determine the number of basketballs and footballs to produce in order to maximize profit. b. Transform this model into standard form. 6. Solve the model formulated in Problem 5 for Southern Sporting Goods Company graphically. Page 4 of 18 a. Identify the amount of unused resources (i.e., slack) at each of the graphical extreme points. b. What would be the effect on the optimal solution if the profit for a basketball changed from $12 to $13? What would be the effect if the profit for a football changed from $16 to $15? c. What would be the effect on the optimal solution if 500 additional pounds of rubber could be obtained? What would be the effect if 500 additional square feet of leather could be obtained? 7. For the linear programming model for Southern Sporting Goods Company, formulated in Problem 5 and solved graphically in Problem 6: a. Determine the sensitivity ranges for the objective function coefficients and constraint quantity values, using graphical analysis. b. Verify the sensitivity ranges determined in (a) by using the computer. c. Using the computer, determine the shadow prices for the resources and explain their meaning. 8. A company produces two products, A and B, which have profits of $9 and $7, respectively. Each unit of product must be processed on two assembly lines, where the required production times are as follows. Hours/Unit Product Line 1 Line 2 A 12 4 B 4 8 Total hours a. Formulate a linear programming model to determine the optimal product mix that will maximize profit. b. Transform this model into standard form. 9. Solve Problem 8 graphically. a. Identify the amount of unused resources (i.e., slack) at each of the graphical extreme points. b. What would be the effect on the optimal solution if the production time on line 1 were reduced to 40 hours? c. What would be the effect on the optimal solution if the profit for product B Page 5 of 18 were increased from $7 to $15? to $20? 10. For the linear programming model formulated in Problem 8 and solved graphically in Problem 9: 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. [Page 98] 11. Irwin Textile Mills produces two types of cotton clothdenim and corduroy. Corduroy is a heavier grade of cotton cloth and, as such, requires 7.5 pounds of raw cotton per yard, whereas denim requires 5 pounds of raw cotton per yard. A yard of corduroy requires 3.2 hours of processing time; a yard of denim requires 3.0 hours. Although the demand for denim is practically unlimited, the maximum demand for corduroy is 510 yards per month. The manufacturer has 6,500 pounds of cotton and 3,000 hours of processing time available each month. The manufacturer makes a profit of $2.25 per yard of denim and $3.10 per yard of corduroy. The manufacturer wants to know how many yards of each type of cloth to produce to maximize profit. a. b. Transform this model into standard form. 12. Solve the model formulated in Problem 11 for Irwin Textile Mills graphically. a. How much extra cotton and processing time are left over at the optimal solution? Is the demand for corduroy met? b. What is the effect on the optimal solution if the profit per yard of denim is increased from $2.25 to $3.00? What is the effect if the profit per yard of corduroy is increased from $3.10 to $4.00? c. What would be the effect on the optimal solution if Irwin Mills could obtain only 6,000 pounds of cotton per month? 13. Solve the linear programming model formulated in Problem 11 for Irwin Mills by using the computer. a. If Irwin Mills can obtain additional cotton or processing time, but not both, which should it select? How much? Explain your answer. b. Identify the sensitivity ranges for the objective function coefficients and for the constraint quantity values. Then explain the sensitivity range for the demand for corduroy. Page 6 of United Aluminum Company of Cincinnati produces three grades (high, medium, and low) of aluminum at two mills. Each mill has a different production capacity (in tons per day) for each grade, as follows: Mill Aluminum Grade 1 2 High 6 2 Medium 2 2 Low 4 10 The company has contracted with a manufacturing firm to supply at least 12 tons of high-grade aluminum, 8 tons of medium-grade aluminum, and 5 tons of low-grade aluminum. It costs United $6,000 per day to operate mill 1 and $7,000 per day to operate mill 2. The company wants to know the number of days to operate each mill in order to meet the contract at the minimum cost. 15. Solve the linear programming model formulated in Problem 14 for United Aluminum Company graphically. a. How much extra (i.e., surplus) high-, medium-, and low-grade aluminum does the company produce at the optimal solution? b. What would be the effect on the optimal solution if the cost of operating mill 1 increased from $6,000 to $7,500 per day? [Page 99] c. What would be the effect on the optimal solution if the company could supply only 10 tons of high-grade aluminum? 16. Solve the linear programming model formulated in Problem 14 for United Aluminum Company by using the computer. a. Identify and explain the shadow prices for each of the aluminum grade contract requirements. b. Identify the sensitivity ranges for the objective function coefficients and the constraint quantity values. c. Would the solution values change if the contract requirements for high-grade aluminum were increased from 12 tons to 20 tons? If yes, what would the new solution values be? 17. The Bradley family owns 410 acres of farmland in North Carolina on which they grow corn and tobacco. Each acre of corn costs $105 to plant, cultivate, and harvest; each acre of tobacco costs $210. The Bradleys have a budget of $52,500 for next year. Page 7 of 18 The government limits the number of acres of tobacco that can be planted to 100. The profit from each acre of corn is $300; the profit from each acre of tobacco is $520. The Bradleys want to know how many acres of each crop to plant in order to maximize their profit. 18. Solve the linear programming model formulated in Problem 17 for the Bradley family farm graphically. a. How many acres of farmland will not be cultivated at the optimal solution? Do the Bradleys use the entire 100-acre tobacco allotment? b. What would the profit for corn have to be for the Bradleys to plant only corn? c. If the Bradleys can obtain an additional 100 acres of land, will the number of acres of corn and tobacco they plan to grow change? d. If the Bradleys decide not to cultivate a 50-acre section as part of a crop recovery program, how will it affect their crop plans? 19. Solve the linear programming model formulated in Problem 17 for the Bradley farm by using the computer. a. The Bradleys have an opportunity to lease some extra land from a neighbor. The neighbor is offering the land to them for $110 per acre. Should the Bradleys lease the land at that price? What is the maximum price the Bradleys should pay their neighbor for the land, and how much land should they lease at that price? b. The Bradleys are considering taking out a loan to increase their budget. For each dollar they borrow, how much additional profit would they make? If they borrowed an additional $1,000, would the number of acres of corn and tobacco they plant change? 20. The manager of a Burger Doodle franchise wants to determine how many sausage biscuits and ham biscuits to prepare each morning for breakfast customers. The two types of biscuits require the following resources: Biscuit Labor (hr.) Sausage (lb.) Ham (lb.) Flour (lb.) Sausage Ham The franchise has 6 hours of labor available each morning. The manager has a contract with a local grocer for 30 pounds of sausage and 30 pounds of ham each morning. The manager also purchases 16 pounds of flour. The profit for a sausage biscuit is $0.60; the profit for a ham biscuit is $0.50. The manager wants to know the number of each type of biscuit to prepare each morning in order to maximize Page 8 of 18 profit. [Page 100] 21. Solve the linear programming model formulated in Problem 20 for the Burger Doodle restaurant graphically. a. How much extra sausage and ham is left over at the optimal solution point? Is there any idle labor time? b. What would the solution be if the profit for a ham biscuit were increased from $0.50 to $0.60? c. What would be the effect on the optimal solution if the manager could obtain 2 more pounds of flour? 22. Solve the linear programming model developed in Problem 20 for the Burger Doodle restaurant by using the computer. a. Identify and explain the shadow prices for each of the resource constraints. b. Which of the resources constraints profit the most? c. Identify the sensitivity ranges for the profit of a sausage biscuit and the amount of sausage available. Explain these sensitivity ranges. 23. Rucklehouse Public Relations has been contracted to do a survey following an election primary in New Hampshire. The firm must assign interviewers to conduct the survey by telephone or in person. One person can conduct 80 telephone interviews or 40 personal interviews in a single day. The following criteria have been established by the firm to ensure a representative survey: At least 3,000 interviews must be conducted. At least 1,000 interviews must be by telephone. At least 800 interviews must be personal. An interviewer conducts only one type of interview each day. The cost is $50 per day for a telephone interviewer and $70 per day for a personal interviewer. The firm wants to know the minimum number of interviewers to hire in order to minimize the total cost of the survey. 24. Solve the linear programming model formulated in Problem 23 for Rucklehouse Public Relations graphically. a. Determine the sensitivity ranges for the daily cost of a telephone interviewer Page 9 of 18 and the number of personal interviews required. b. Does the firm conduct any more telephone and personal interviews than are required, and if so, how many more? c. What would be the effect on the optimal solution if the firm were required by the client to increase the number of personal interviews conducted from 800 to a total of 1,200? 25. Solve the linear programming model formulated in Problem 23 for Rucklehouse Public Relations by using the computer. a. If the firm could reduce the minimum interview requirement for either telephone or personal interviews, which should the firm select? How much would a reduction of one interview in the requirement you selected reduce total cost? Solve the model again, using the computer, with the reduction of this one interview in the constraint requirement to verify your answer. b. Identify the sensitivity ranges for the cost of a personal interview and the number of total interviews required. 26. 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 gallons per week, regardless of the blend. The production manager wants to complete the order in 1 week. The blend is sold for $5 per gallon. [Page 101] The distillery company's cost per gallon is $2 for rye and $1 for bourbon. The company wants to determine the blend mix that will meet customer requirements and maximize profits. 27. Solve the linear programming model formulated in Problem 26 for the Bluegrass Distillery graphically. a. Indicate the slack and surplus available at the optimal solution point and explain their meanings. b. What increase in the objective function coefficients in this model would change the optimal solution point? Explain your answer. 28. Solve the linear programming model formulated in Problem 26 for the Bluegrass Distillery by using the computer. a. Identify the sensitivity ranges for the objective function coefficients and explain what the upper and lower limits are. Page 10 of 18 b. How much would it be worth to the distillery to obtain additional production capacity? c. If the customer decided to change the blend requirement for its custom-made whiskey to a mix of three parts rye to one part bourbon, how would this change the optimal solution? 29. Alexis Harrington received an inheritance of $95,000, and she is considering two speculative investmentsthe purchase of land and the purchase of cattle. Each investment would be for 1 year. Under the present (normal) economic conditions, each dollar invested in land will return the principal plus 20% of the principal; each dollar invested in cattle will return the principal plus 30%. However, both investments are relatively risky. If economic conditions were to deteriorate, there is an 18% chance she would lose everything she invested in land and a 30% chance she would lose everything she invested in cattle. Alexis does not want to lose more than $20,000 (on average). She wants to know how much to invest in each alternative to maximize the cash value of the investments at the end of 1 year. 30. Solve the linear programming model formulated in Problem 29 for Alexis Harrington graphically. a. How much would the return for cattle have to increase in order for Alexis to invest only in cattle? b. Should all of Alexis's inheritance be invested according to the optimal solution? c. How much profit would the optimal solution earn Alexis over and above her investment? 31. Solve the linear programming model formulated in Problem 29 for Alexis Harrington by using the computer. a. If Alexis decided to invest some of her own savings along with the money from her inheritance, what return would she realize for each dollar of her own money that she invested? How much of her own savings could she invest before this return would change? b. If the risk of losing the investment in land increased to 30%, how would this change the optimal investment mix? [Page 102] 32. Transform the following linear programming model into standard form and solve by using the computer: Page 11 of Chemco Corporation produces a chemical mixture for a specific customer in 1,000- pound batches. The mixture contains three ingredientszinc, mercury, and potassium. The mixture must conform to formula specifications that are supplied by the customer. The company wants to know the amount of each ingredient it needs to put in the mixture that will meet all the requirements of the mix and minimize total cost. The customer has supplied the following formula specifications for each batch of mixture: The mixture must contain at least 200 pounds of mercury. The mixture must contain at least 300 pounds of zinc. The mixture must contain at least 100 pounds of potassium. The ratio of potassium to the other two ingredients cannot exceed 1 to 4. The cost per pound of mercury is $400; the cost per pound of zinc, $180; and the cost per pound of potassium, $90. a. b. Solve the model formulated in (a) by using the computer. 34. The following linear programming model formulation is used for the production of four different products, with two different manufacturing processes and two different material requirements: Page 12 of 18 a. Solve this problem by using the computer. b. Identify the sensitivity ranges for the objective function coefficients and the constraint quantity values. c. Which is the most valuable resource to the firm? d. One of the four products is not produced in the optimal solution. How much would the profit for this product have to be for it to be produced? 35. Island Publishing Company publishes two types of magazines on a monthly basis: a restaurant and entertainment guide and a real estate guide. The company distributes the magazines free to businesses, hotels, and stores on Hilton Head Island in South Carolina. The company's profits come exclusively from the paid advertising in the magazines. Each of the restaurant and entertainment guides distributed generates $0.50 per magazine in advertising revenue, whereas the real estate guide generates $0.75 per magazine. The real estate magazine is a more sophisticated publication that includes color photos, and accordingly it costs $0.25 per magazine to print, compared with only $0.17 for the restaurant and entertainment guide. The publishing company has a printing budget of $4,000 per month. There is enough rack space to distribute at most 18,000 magazines each month. In order to entice businesses to place advertisements, Island Publishing promises to distribute at least 8,000 copies of each magazine. The company wants to determine the number of copies of each magazine it should print each month in order to maximize advertising revenue. [Page 103] 36. Solve the linear programming model formulation in Problem 35 for Island Publishing Company graphically. a. Determine the sensitivity range for the advertising revenue generated by the real estate guide. b. Does the company spend all of its printing budget? If not, how much slack is left over? Page 13 of 18 c. What would be the effect on the optimal solution if the local real estate agents insisted that 12,000 copies of the real estate guide be distributed instead of the current 8,000 copies, or they would withdraw their advertising? 37. Solve the linear programming model formulated in Problem 35 for Island Publishing Company by using the computer. a. How much would it be worth to Island Publishing Company to obtain enough additional rack space to distribute 18,500 copies instead of the current 18,000 copies? 20,000 copies? b. How much would it be worth to Island Publishing to reduce the requirement to distribute the entertainment guide from 8,000 to 7,000 copies? 38. Mega-Mart, a discount store chain, is to build a new store in Rock Springs. The parcel of land the company has purchased is large enough to accommodate a store with 140,000 square feet of floor space. Based on marketing and demographic surveys of the area and historical data from its other stores, Mega-Mart estimates its annual profit per square foot for each of the store's departments to be as shown

Recommended

Related Search

We Need Your Support

Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

Thanks to everyone for your continued support.

No, Thanks