Concept explainers
a)
To identify: If there are any binding constraints.
Introduction:
Linear programming:
Linear programming is a mathematical modeling method where a linear function is maximized or minimized taking into consideration the various constraints present in the problem. It is useful in making quantitative decisions in business planning.
b)
To determine: The value of decision variables when the profit on product 3 is changed.
c)
To determine: The value of decision variables when the profit on product 1 is changed.
d)
To determine: The value of decision variables when labor hours are 10 hours less.
e)
To determine: The additional profit if the manager decides that 20 units of product 2 could be produced.
f)
To determine: If the profit per each product increased by 1 will change the decision variables.
Want to see the full answer?
Check out a sample textbook solutionChapter 19 Solutions
Operations Management
- Valencia products makes automobile radar detectors and assembles two models. Laser stop and Speedbuster both models use the same electronic components after reviewing the components required and the profit for each model, the firm found the following linear optimization model for profit, where L is the number of LaserStop models produced and S is the number of Speedbuster models produced. Implement the linear optimization model on a spreadsheet and use. Solver to find an optimal solution. Interpret the optimal solution, identify the binding constraints and verify the values of the slack variables . Maximize profit = 123 L + 139 S 19 L + 11 S < 4,000 (availability of component A) 6 L + 9 S < 35000 (availability of component B) L > 0 and S > 0 The optimal solution is to produce how many Laser stop models ? And how many Speedbuster models ? The maximum possible profit is ? Component A is or is not a binding…arrow_forwardA manufacturing firm has four plants and wants to find the most efficient means of meeting the requirements of its four customers. The relevant information for the plants and customers, along with shipping costs in dollars per unit, are shown in the table below: Customer (requirement) Factory (capacity) Customer 1 (125) Customer 2 (150) Customer 3 (175) Customer 4 (75) A (100) $ 15 $ 10 $ 20 $ 17 B (75) $ 20 $ 12 $ 19 $ 20 C (100) $ 22 $ 20 $ 25 $ 14 D (250) $ 21 $ 15 $ 28 $ 12 How many supply nodes are present in this problem? Multiple Choice: 4 3 1 8 16arrow_forwardallons of deionized water from each wholesaler to each distribution center is shown in the following table: Question Viewer a. Which of the following statements regarding setting up the tableau for the optimal solution for this problem is true? B. The sum of supply capacities is greater than the sum of demands, so a dummy distribution center is needed. C. The sum of supply capacities is less than the sum of demands, so a dummy wholesaler is needed. b. What is the total cost of the solution? The optimal cost is $ ((Enter your response rounded to the nearest dollar.)arrow_forward
- Valencia Products makes automobile radar detectors and assembles two models: LaserStop and SpeedBuster. Both models use the same electronic components. After reviewing the components required and the profit for each model, the firm found the following linear optimization model for profit, where L is the number of LaserStop models produced and S is the number of SpeedBuster models produced. Implement the linear optimization model on a spreadsheet and use Solver to find an optimal solution. Interpret the optimal solution, identify the binding constraints, and verify the values of the slack variables. Maximize Profit = 123L+139S 17 L+11 S≤5000 (Availability of component A) 5L+9S≤4500 (Availability of component B) L≥0 and S≥0 Implement the linear optimization model and find an optimal solution. Interpret the optimal solution. The optimal solution is to produce _ LaserStop models and _ SpeedBuster models. This…arrow_forwardCompute the objective function value for the following problem: Min 30X + 150Y subject to : 2X>=0 ;2X + 10Y = 20; X+Y>=0 a. 0 b. 54 c. infeasible d. 300 e. unboundedarrow_forwardInstructions: Solve using Excel Solver. Create the linear programming model and get the optimal solution to the problem. (Follow the steps and format in the photo below) 1. A company manufactures two products X1 and X2 on three machines A, B, and C. X1 requires 1 hour on machine A and 1hour on machine B and yields a revenue of Php 30. Product X2 requires 2 hours on machine A and 1 hour on machine B and 1 hour on machine C and yields revenue of PhP 50. In the coming planning period the available time of three machines A, B, and C are 2000 hours, 1500 hours and 600 hours respectively. Find the optimal product mix.arrow_forward
- Bao wants to consolidate the sales data in the S., Canada, and U.K. worksheets on the All Locations worksheet. Ungroup the worksheets, go to the All Locations worksheet, and then consolidate the data as follows: In cell B6, enter a formula using the SUM function and a 3D reference to total the revenue from Action movies in Quarter 1 (cell B6) in the U.S., Canada, and U.K. Copy the formula in cell B6 to calculate the revenue from the other types of movies for all four quarters (range B7:B11 and C6:E11), pasting the formula only.arrow_forwardPlease do not give solution in image formate thanku. Warrenia has two regions. In Oliviland, the marginal benefit associated with pollution cleanup is MB = 300 – 10Q, while in Linneland, the marginal benefit associated with pollution cleanup is MB = 200 – 4Q. Suppose that the marginal cost of cleanup is $12 per unit. What is the optimal level of pollution clean in each of the two regions?arrow_forwardVogel's Approximation Method The three blood banks in Franklin County are coordinated through a central office that facilitates blood delivery to four hospitals in the region. The cost to ship a standard container of blood from each bank to each hospital is shown in the table below. Also given are the biweekly number of containers available at each bank and the biweekly number of containers of blood needed at each hospital. Find an initial solution to the table below using the Vogel’s Approximation Method. How many shipment should be made from Bank 2 to Hospital 2? O 70 O 60 O 50 O 40 How many shipment should be made from Bank 3 to Hospital 3? O 40 O 30 O 20 O 10arrow_forward
- Vogel's Approximation Method The three blood banks in Franklin County are coordinated through a central office that facilitates blood delivery to four hospitals in the region. The cost to ship a standard container of blood from each bank to each hospital is shown in the table below. Also given are the biweekly number of containers available at each bank and the biweekly number of containers of blood needed at each hospital. Find an initial solution to the table below using the Vogel’s Approximation Method. How many shipment should be made from Bank 3 to Hospital 1? * a. 90 b. 30 c. 50 d. 40 How many shipment should be made from Bank 2 to Hospital 3? * a. 10 b. 20 c. 40 d. 30arrow_forwardDennison Manufacturing makes large helical springs used in aircraft landing gear. The company has narrowed its potential choices for its new manufacturing facility to four cities. The following information is known about the manufacturing and shipping costs of locating in each of these four cities: Fixed Costsper Year Variable ManufacturingCosts per Unit Variable ShippingCosts per Unit Phoenix Buffalo Seattle Atlanta $300,000 $600,000 $1,500,000 $1,750,000 $70.00 $56.00 $36.00 $42.00 $5.00 $4.00 $2.00 $5.00 a. Use break-even point analysis to determine where Dennison should locate.b. Based solely on break-even quantity, if Dennison’s manufacturing forecast for the foreseeable future is 40,000 units annually, where should he locate?arrow_forwardFor the linear program Max 2A + 3Bs.t. 1A + 2B <= 6 5A +3B <= 15 A, B >= 0 find the optimal solution using excel. What is the value of theobjective function at the optimal solution?arrow_forward
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,