Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 5, Problem 67P
a)
Summary Introduction
To determine: The way to minimize the sum of penalty and shipping cost.
Introduction: In linear programming, the unbounded solution would occur when the objective function is infinite. If no solution satisfied the constraints, then it is said to be unfeasible solution.
b)
Summary Introduction
To determine: The way the change in penalty cost affects the optimal cost.
Introduction: In linear programming, the unbounded solution would occur when the objective function is infinite. If no solution satisfied the constraints then it is said to be unfeasible solution.
c)
Summary Introduction
To determine: The way the change in warehouse capacity affects the optimal cost.
Introduction: In linear programming, the unbounded solution would occur when the objective function is infinite. If no solution satisfied the constraints, then it is said to be unfeasible solution.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Create spreadsheets and use Solver to determine the correct volumes to be produced to minimize cost for the following problem. Your company has two trucks that it wishes to use on a specific contract. One is a new truck the company is making payments on, and one is an old truck that is fully paid for. The new truck’s costs per mile are as follows: 54₵ (fuel/additives), 24₵ (truck payments), 36₵ (driver), 12₵ (repairs), and 1₵ (misc.). The old truck’s costs are 60₵ (fuel/additives), 0₵ (truck payments), 32₵ (rookie driver), 24₵ (repairs), and 1₵ (misc.). The company knows that truck breakdowns lose customers, so it has capped estimated repair costs at $14,000. The total distance involved is 90,000 miles (to be divided between the two trucks).
Using the same file but with a different worksheet, solve the following problem.
Rename the worksheet as Problem 2.
Submit the same file that shows the solution (tables with optimal answers).
Dr. S, the Dean of RVR COB, has decided to apply a new method in assigning professors to
courses next trimester. As a criterion for judging who should teach each course, Dean S
reviews the past two years' teaching evaluations. Since each of the four professors taught
each of the four courses at one time or another during the two-year period, Dr. S can record
a course rating for each instructor. Find the best assignment for professors.
PROFESSOR STATISTICS ACCOUNTING FINANCE ECONOMICS
Andy
Benny
Charles
Dennis
90
70
85
55
Course
Upload Choose a File
65
60
40
80
95
80
80
65
40
75
60
55
Which professor should be assigned to teach each of those courses?
The following data structure and constraints exist for a magazine publishing company:a. The company publishes one regional magazine in each of four states: Florida (FL), South Carolina (SC), Georgia (GA), and Tennessee (TN).b. The company has 300,000 customers (subscribers) distributed throughout the four states listed in Problem 2a.c. On the first day of each month, an annual subscription INVOICE is printed and sent to each customer whose subscription is due for renewal. The INVOICE entity contains a REGION attribute to indicate the customer's state of residence (FL, SC, GA, TN):The company is aware of the problems associated with centralized management and has decided to decentralize management of the subscriptions into the company's four regional subsidiaries. Each subscription site will handle its own customer and invoice data. The management at company headquarters, however, will have access to customer and invoice data to generate annual reports and to issue ad hoc queries such…
Chapter 5 Solutions
Practical Management Science
Ch. 5.2 - Prob. 1PCh. 5.2 - Prob. 2PCh. 5.2 - Prob. 3PCh. 5.2 - Prob. 4PCh. 5.2 - Prob. 5PCh. 5.2 - Prob. 6PCh. 5.2 - Prob. 7PCh. 5.2 - Prob. 8PCh. 5.2 - Prob. 9PCh. 5.3 - Prob. 10P
Ch. 5.3 - Prob. 11PCh. 5.3 - Prob. 12PCh. 5.3 - Prob. 13PCh. 5.3 - Prob. 14PCh. 5.3 - Prob. 15PCh. 5.3 - Prob. 16PCh. 5.3 - Prob. 17PCh. 5.3 - Prob. 18PCh. 5.4 - Prob. 19PCh. 5.4 - Prob. 20PCh. 5.4 - Prob. 21PCh. 5.4 - Prob. 22PCh. 5.4 - Prob. 23PCh. 5.4 - Prob. 24PCh. 5.4 - Prob. 25PCh. 5.4 - Prob. 26PCh. 5.4 - Prob. 27PCh. 5.4 - Prob. 28PCh. 5.4 - Prob. 29PCh. 5.5 - Prob. 30PCh. 5.5 - Prob. 31PCh. 5.5 - Prob. 32PCh. 5.5 - Prob. 33PCh. 5.5 - Prob. 34PCh. 5.5 - Prob. 35PCh. 5.5 - Prob. 36PCh. 5.5 - Prob. 37PCh. 5.5 - Prob. 38PCh. 5 - Prob. 42PCh. 5 - Prob. 43PCh. 5 - Prob. 44PCh. 5 - Prob. 45PCh. 5 - Prob. 46PCh. 5 - Prob. 47PCh. 5 - Prob. 48PCh. 5 - Prob. 49PCh. 5 - Prob. 50PCh. 5 - Prob. 51PCh. 5 - Prob. 52PCh. 5 - Prob. 53PCh. 5 - Prob. 54PCh. 5 - Prob. 55PCh. 5 - Prob. 56PCh. 5 - Prob. 57PCh. 5 - Prob. 58PCh. 5 - Prob. 59PCh. 5 - Prob. 60PCh. 5 - Prob. 61PCh. 5 - Prob. 62PCh. 5 - Prob. 63PCh. 5 - Prob. 64PCh. 5 - Prob. 65PCh. 5 - Prob. 66PCh. 5 - Prob. 67PCh. 5 - Prob. 68PCh. 5 - Prob. 69PCh. 5 - Prob. 70PCh. 5 - Prob. 71PCh. 5 - Prob. 72PCh. 5 - Prob. 73PCh. 5 - Prob. 74PCh. 5 - Prob. 75PCh. 5 - Prob. 76PCh. 5 - Prob. 77PCh. 5 - Prob. 80PCh. 5 - Prob. 81PCh. 5 - Prob. 82PCh. 5 - Prob. 83PCh. 5 - Prob. 85PCh. 5 - Prob. 86PCh. 5 - Prob. 87PCh. 5 - Prob. 1C
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.Similar questions
- Seas Beginning sells clothing by mail order. An important question is when to strike a customer from the companys mailing list. At present, the company strikes a customer from its mailing list if a customer fails to order from six consecutive catalogs. The company wants to know whether striking a customer from its list after a customer fails to order from four consecutive catalogs results in a higher profit per customer. The following data are available: If a customer placed an order the last time she received a catalog, then there is a 20% chance she will order from the next catalog. If a customer last placed an order one catalog ago, there is a 16% chance she will order from the next catalog she receives. If a customer last placed an order two catalogs ago, there is a 12% chance she will order from the next catalog she receives. If a customer last placed an order three catalogs ago, there is an 8% chance she will order from the next catalog she receives. If a customer last placed an order four catalogs ago, there is a 4% chance she will order from the next catalog she receives. If a customer last placed an order five catalogs ago, there is a 2% chance she will order from the next catalog she receives. It costs 2 to send a catalog, and the average profit per order is 30. Assume a customer has just placed an order. To maximize expected profit per customer, would Seas Beginning make more money canceling such a customer after six nonorders or four nonorders?arrow_forwardIf a monopolist produces q units, she can charge 400 4q dollars per unit. The variable cost is 60 per unit. a. How can the monopolist maximize her profit? b. If the monopolist must pay a sales tax of 5% of the selling price per unit, will she increase or decrease production (relative to the situation with no sales tax)? c. Continuing part b, use SolverTable to see how a change in the sales tax affects the optimal solution. Let the sales tax vary from 0% to 8% in increments of 0.5%.arrow_forwardAn analyst has started preparing a spreadsheet as shown below. Column A contains the headings for various parameters and Column B contains the analyst's range names to be used in Excel. A B 1 Price per Unit 2 Cost per Unit 3 Profit per Unit PricePerUnit Cost_Per_Unit Profit per Unit 4 5 Fixed Costs Fixed_Costs 6 Variable Costs Variable Costs Label each of the following range names as "Correct" if is a valid range name in Excel or "Incorrect" if the range name is not valid for use in Excel. Proposed Range Name PricePerUnit Cost Per_Unit Profit per Unit Fixed_Costs Variable Costsarrow_forward
- Company aims to determine the optimal number of products to be produced in order to maximize the total profit. a) Formulate the problem using algebraic method. b) Solve the model using the graphical method (indicate optimal solution and profit). C) again). Use graphical method to determine the shadow price for each of these resources (based on the definition of shadow price and by increasing each resource by one unit and solving the problem d) Use the Excel solver to do parts b and c. e) follow: Using Solver Table generate the optimal solution and the total profit for each resource as e1: Consider unit profit for product 1 (use range from 0 to 4 and increment of 1) e2: Consider unit profit for product 2 (use range from 0 to 4 and increment of 1) е3: Consider simultaneous changes for both unit profits in part e1 and e2 using given ranges. e4: Consider available resource of Raw material 1 (use range from 2 to 14 and increment of 1) e5: Consider available resource of Raw material 2 (use…arrow_forwardHi... I'm having trouble with the following: Min Jee wants to combine the sales data from each of the art fairs. Switch to the Combined Sales worksheet, and then update the worksheet as follows: In cell A5, enter a formula without using a function that references cell A5 in the Madison Copy the formula from cell A5 to the range A6:A8 without copying the formatting. In cell B5, enter a formula using the SUM function, 3-D references, and grouped worksheets that totals the values from cell B5 in the Chicago:Madison Copy the formula from cell B5 to the range B6:B8 without copying the formatting. Copy the formulas and the formatting from the range B5:B8 to the range C5:E8. (Hint: You can ignore the error about empty cells because Min Jee will enter the Madison sales data later.)arrow_forwardA linear programming computer package is needed. Hilltop Coffee manufactures a coffee product by blending three types of coffee beans. The cost per pound and the available pounds of each bean are as follows. Bean Cost per Pound Available Pounds 1 2 3 1 $0.50 2 $0.70 3 $0.45 Consumer tests with coffee products were used to provide ratings on a scale of 0-100, with higher ratings indicating higher quality. Product quality standards for the blended coffee require a consumer rating for aroma to be at least 75 and a consumer rating for taste to be at least 80. The individual ratings of the aroma and taste for coffee made from 100% of each bean are as follows: Bean Aroma Rating Taste Rating 75 85 60 85 lb lb lb 450 87 650 74 450 Assume that the aroma and taste attributes of the coffee blend will be a weighted average of the attributes of the beans used in the blend. (a) What is the minimum-cost blend (in pounds) that will meet the quality standards and provide 1,000 pounds of the blended…arrow_forward
- Please solve using Excel @Risk add-in the question is Textbook Problem from Practical Management Science 6th Edition Chapter 11.4 Problem 30P. In the solution please provided step-by-step excel formulas used. The full Question is attached in the image. Seas Beginning sells clothing by mail order. An important question is when to strike a customer from the company’s mailing list. At present, the company strikes a customer from its mailing list if a customer fails to order from six consecutive catalogs. The company wants to know whether striking a customer from its list after a customer fails to order from four consecutive catalogs results in a higher profit per customer. Thefollowing data are available:-> If a customer placed an order the last time she received a catalog, then there is a 20% chance she will order from the next catalog.-> If a customer last placed an order one catalog ago, there is a 16% chance she will order from the next catalog she receives.-> If a customer…arrow_forwardPlease answer it immediately sir Linear Programming The Booboo sawmill in Batangas produces pine and oak boards for manufacturing firms. Each month the sawmill must deliver atleast 5 tons of wood to the manufacturer . It takes the sawmill 3 days to produce a ton of pine and a 2 days to produce a ton of oak and the sawmill can allocate 18 days out of a month for this contract. The sawmill can get enough pine to make atleast 4 tons of wood and enough oak to make atmost 7 tons of wood. Determine the number of tons of pine and oak in order to minimize cost, given that pine has a cost of $3 and oak $6 to producearrow_forwardHudson Corporation is considering three options for managing its data warehouse: continuing with its own staff, hiring an outside vendor to do the managing (referred to as outsourcing), or using a combination of its own staff and an outside vendor. The cost of the operation depends on future demand. The annual cost of each option (in thousands of dollars) depends on demand as follows: DemandStaffing Options High Medium LowOwn staff 650 650 600Outside vendor 900 600 300Combination 800 650 500(a) If the demand probabilities are 0.2, 0.5, and 0.3, which decision alternative will minimize the expected cost of the data warehouse? Outside vendorWhat is the expected annual cost associated with that recommendation? Enter your answer in thousands dollars. For example, an answer of $200 thousands should be entered as 200,000. Expected annual cost = $570000(b) Construct a risk profile for the optimal decision in part (a). The input in the box below will…arrow_forward
- A linear programming computer package is needed. Hilltop Coffee manufactures a coffee product by blending three types of coffee beans. The cost per pound and the available pounds of each bean are as follows. Bean Cost per Pound Available Pounds 1 2 3 1 $0.50 $0.70 2 $0.45 3 Consumer tests with coffee products were used to provide ratings on a scale of 0-100, with higher ratings Indicating higher quality. Product quality standards for the blended coffee require a consumer rating for aroma to be at least 75 and a consumer rating for taste to be at least 80. The Individual ratings of the aroma and taste for coffee made from 100% of each bean are as follows: Bean Aroma Rating Taste Rating 75 85 60 85 450 87 550 74 350 Assume that the aroma and taste attributes of the coffee blend will be a weighted average of the attributes of the beans used in the blend. (a) What is the minimum-cost blend (In pounds) that will meet the quality standards and provide 1,000 pounds of the blended coffee…arrow_forwardfertilizer manufacturer has to fulfill supply contracts to its two main customers (650 tons to Customer A and 800 tons to Customer B). It can meet this demand by shipping existing inventory from any of its three warehouses. Warehouse 1 (W1) has 400 tons of inventory onhand, Warehouse 2 (W2) has 500 tons, and Warehouse 3 (W3) has 600 tons. The company would like to arrange the shipping for the lowest cost possible, where the per-ton transit costs are as follows: W 1 W 2 W 3 Customer A $7.50 $6.25 $6.50 Customer B $6.75 $7.00 $8.00 Write the objective function and the constraint in equations. Let Vij= tons shipped to customer i from warehouse j, and so on. For example, VA1=tons shipped to customer A from warehouse W1. This exercise contains only parts b, c, d, e, and f. Part 2 b) The objective function for the LP model =arrow_forward1. Construct a 2-by2 contingency table to determine the total number of people who fail the screening test and will be referred for diagnostic testing in the hearing centers. 2. Construct a 2-by-2 contingency table to determine the total number of people who fail the diagnostic test, which represents the target market for hearing aid sales.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,