Implement the linear optimization model that you developed for Valencia Products in Problem 1in Excel and use Solver to find an optimal solution. Interpret the Solver Answer report and identifythe binding constraints and verify the values ofthe slack variables by substituting the optimalsolution into the model constraints.1. Valencia Products makes automobile radar detectors and assembles two models:LaserStop and SpeedBuster. The firm can sell all it produces. Both models usethe same electronic components. Two of these can be obtained only from a singlesupplier. For the next month, the supply of these is limited to 4,000 of componentA and 3,500 of component B. The number of each component required for eachproduct and the profit per unit are given in the table.LaserStopSpeedBusterComponentsRequired/UnitABProfit/unit186$241210$40a. Identify the decision variables, objective function, and constraints in simpleverbal statements.b. Mathematically formulate a linear optimization model.

Linear Programming is a technique used to find the optimal values of decision variables that…

Answered: the same electronic components. Two of…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter5: Network Models

Section: Chapter Questions

Problem 67P

See similar textbooks

Similar questions

Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can produce x units of Wozac per year, it will cost 16x. Each unit of Wozac is sold for 3. Each unit of Wozac produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. Determine how large a Wozac plant the company should build to maximize its expected profit over the next 10 years.
Lemingtons is trying to determine how many Jean Hudson dresses to order for the spring season. Demand for the dresses is assumed to follow a normal distribution with mean 400 and standard deviation 100. The contract between Jean Hudson and Lemingtons works as follows. At the beginning of the season, Lemingtons reserves x units of capacity. Lemingtons must take delivery for at least 0.8x dresses and can, if desired, take delivery on up to x dresses. Each dress sells for 160 and Hudson charges 50 per dress. If Lemingtons does not take delivery on all x dresses, it owes Hudson a 5 penalty for each unit of reserved capacity that is unused. For example, if Lemingtons orders 450 dresses and demand is for 400 dresses, Lemingtons will receive 400 dresses and owe Jean 400(50) + 50(5). How many units of capacity should Lemingtons reserve to maximize its expected profit?
Formulate and then solve a linear programming model of this problem, to determine how manycontainers of each product to produce tomorrow to maximize profits. The company makes fourjuice products using orange, grapefruit, and pineapple juice.Product Retail Price per QuartOrange juice $1.00Grapefruit juice .90Pineapple juice .80All-in-One 1.10The All-in-One juice has equal parts of orange, grapefruit, and pineapple juice. Each product isproduced in a one-quart size (there are four quarts in a gallon). On hand are 400 gallons of orangejuice, 300 gallons of grapefruit juice, and 200 gallons of pineapple juice. The cost per gallon is$2.00 for orange juice, $1.60 for grapefruit juice, and $1.40 for pineapple juice.In addition, the manager wants grapefruit juice to be used for no more than 30 percent of thenumber of containers produced. She wants the ratio of the number of containers of orange juice tothe number of containers of pineapple juice to be at least 7 to 5.
1. If constraint has a shadow price of $6, Right-Hand-Side (RHS) is 12, allowable increase is 2, allowable decrease is 4. How would objective function change if the RHS of this constrains changes from 12 to 9? Answer___________
1. Write a linear program for the problem. 2. What is the optimal production mix among different coffee varieties and the profit associated with it? 3. What should be the per bag profit of Tarrazu which will make it beneficial to produce this variety? 4. One Cup is considering increasing the weekly bags to 150. If it costs One Cup $3.00 per bag to procure beans of any variety. Conduct sensitivity analysis and determine if One Cup should consider increasing the per week production. 5. Identify the range over which per bag profit of Sumatra and Kona may vary and still retain the current production plan as optimal for One Cup. 6. Once roasted the coffee beans must be preserved properly. To ensure that, One Cup Coffee is considering investing in a vacuum packaging machine for 24 hours/ week. It takes 10, 15 and 10 minutes to pack a bag of Sumatra, Kona and Tarazzu respectively. Identify if the current production plan will suit the installation of the new packaging scheme.
Innis Investments manages funds for a number of companies and wealthy clients. The investment strategy is tailored to each client's needs. For a new client, Innis has been authorized to invest up to $1.2 million in two investment funds: a stock fund and a money market fund. Each unit of the stock fund costs $50 and provides an annual rate of return of 10%; each unit of the money market fund costs $100 and provides an annual rate of return of 4%. The client wants to minimize risk subject to the requirement that the annual income from the investment be at least $60,000. According to Innis' risk measurement system, each unit invested in the stock fund has a risk index of 8, and each unit invested in the money market fund has a risk index of 3. The higher risk index associated with the stock fund simply indicates that it is the riskier investment. Innis's client also specified that at least $300,000 be invested in the money market fund. Refer to the computer solution shown below. Optimal…
I’ve been able to find the optimal solution and resulting profit with excel solver. But can’t figure out how to set up the problem with POM QM
Please 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 produce
A company manufactures two products. If it chargesprice pi for product i, it can sell qi units of product i,where q1 = 60 - 3p1 + p2 and q2 = 80 - 2p2 + p1. Itcosts $5 to produce a unit of product 1 and $12 to produce a unit of product 2. How many units of eachproduct should the company produce, and what pricesshould it charge, to maximize its profit? Use spreadsheet modelling in Excel
A cement mix company is renowned for providing high strength concrete additives - at high unit cost. It delivers two types of cement additives - Tuf and Rok. In making these additives the company adds two special products, Qikcem and Plascem. These additives contain two (2) basic ingredients: Lime and Flyash, in different proportions, as shown in the table below. Flyash [%] Lime Cost Special Products Qikcem (1) Plascem (2) Availability [kg/hr] 2600 3600 [%] [S/kg] 10 15 45 55 35 65 The cement additive, Tuf should not contain more than 70% of Lime and the cement additive, Rok must contain at least 45% of Flyash. The company can sell at most 800oerkg of its additive products (Tuf and Rok) per hour. There are other limitations and local requirements, as stated beklew: a) Due to the plant installed capacity and personnel requirements, no more than 6000 kg/hour of Tuf can be produced b) The plant has contracted to deliver at least 3500 kg/hour of Tuf c) The company is restricted, by local…
“Good Intentions” (GI) company produces two products, which it sells on both a cash and credit basis. Revenues from credit sales will not have been received but are included in determining profit earned during the current six-month period. Sales during the next six months can be made either from units produced during the next six months or from the beginning inventory. Relevant information about products one and two is as follows. During the next six months, at most 150 units of product type 1 can be sold on a cash basis, and at most 100 units of product 1 can be sold on a credit basis. It costs £35 to produce each unit of product type 1, and each sells for £40. A credit sale of a unit of product 1 yields £0.50 less profit than a cash sale (because of delays in receiving payment). Two hours of production time are needed to produce each unit of product 1. At the beginning of the six-month period, 60 units of product 1 are in the inventory. During the next six months, at most 175 units…
3. A company that produces a single product wants to determine its production, inventory holding and purchasing policies for the months of January, February and March. The firm has to meet the determined amount of demand every month. In order to meet this demand, it can produce itself or purchase that amount from another company. However, if production is to be made, either at least 100 units will be produced or not at all. In addition, due to technical capacities, maximum amounts that can be produced in a month is 400 units. In addition, the company has to pay 750$ of tax in the months it produces. The company can transfer the excess demand to the next month by bearing the inventory cost, but the company cannot stock more than 75 products due to the physical conditions in the warehouse. If the company wants to keep more units on inventory, they can rent a warehouse with a capacity of 125 products for 150$ per month. However, during this period, the company can rent this warehouse for…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS