WK Qu. 7-11 A firm has prepared the following binary...A firm has prepared the following binary integer program to evaluate a number of potential locations for newwarehouses. The firm's goal is to maximize the net present value of their decision while not spending more than theircurrently available capital.Max 35x1 + 25x2 +15x3+ 30x4s.t. 7x1 + 8x2 +7x3 + 13x4 ≤ 18 [Constraint 1}+ x4 ≥ 2 [Constraint 2}X1 + x2 + x3X1 + X2 ≤ 1 [Constraint 3}X1 + X3 ≥ 1 [Constraint 4)X2=X4 [Constraint 5)1, if location j is selectedxj =0, otherwiseSolve this problem to optimality and answer the following questions:a. Which of the warehouse locations will/will not be selected?Location 1willLocation 2willLocation 3willLocation 4willbe selectednot be selectedNet presentvaluebe selectednot be selectedb. What is the net present value of the optimal solution? (Round your answer to the nearest whole number.)50c. How much of the available capital will be spent (Hint: Constraint 1 enforces the available capital limit)? (Round youranswer to the nearest whole number.)Available capital

Objective Functions and Constraints: Based on the given details, the objective…

Answered: a. Which of the warehouse locations…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter7: Nonlinear Optimization Models

Section: Chapter Questions

Problem 56P

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.
The Tinkan Company produces one-pound cans for the Canadian salmon industry. Each year the salmon spawn during a 24-hour period and must be canned immediately. Tinkan has the following agreement with the salmon industry. The company can deliver as many cans as it chooses. Then the salmon are caught. For each can by which Tinkan falls short of the salmon industrys needs, the company pays the industry a 2 penalty. Cans cost Tinkan 1 to produce and are sold by Tinkan for 2 per can. If any cans are left over, they are returned to Tinkan and the company reimburses the industry 2 for each extra can. These extra cans are put in storage for next year. Each year a can is held in storage, a carrying cost equal to 20% of the cans production cost is incurred. It is well known that the number of salmon harvested during a year is strongly related to the number of salmon harvested the previous year. In fact, using past data, Tinkan estimates that the harvest size in year t, Ht (measured in the number of cans required), is related to the harvest size in the previous year, Ht1, by the equation Ht = Ht1et where et is normally distributed with mean 1.02 and standard deviation 0.10. Tinkan plans to use the following production strategy. For some value of x, it produces enough cans at the beginning of year t to bring its inventory up to x+Ht, where Ht is the predicted harvest size in year t. Then it delivers these cans to the salmon industry. For example, if it uses x = 100,000, the predicted harvest size is 500,000 cans, and 80,000 cans are already in inventory, then Tinkan produces and delivers 520,000 cans. Given that the harvest size for the previous year was 550,000 cans, use simulation to help Tinkan develop a production strategy that maximizes its expected profit over the next 20 years. Assume that the company begins year 1 with an initial inventory of 300,000 cans.
In Example 11.1, the possible profits vary from negative to positive for each of the 10 possible bids examined. a. For each of these, use @RISKs RISKTARGET function to find the probability that Millers profit is positive. Do you believe these results should have any bearing on Millers choice of bid? b. Use @RISKs RISKPERCENTILE function to find the 10th percentile for each of these bids. Can you explain why the percentiles have the values you obtain?
Pricing Decisions at Madison The Madison Company manufactures and retails a certain product. The company wants to determine the price that maximizes its profit from this product. The unit cost of producing and marketing the product is 50. Madison will certainly charge at least 50 for the product to ensure that it makes some profit. However, there is a very competitive market for this product, so that Madisons demand falls sharply when it increases its price. How should the company proceed?2 In the pricing model in Example 7.1 with the constant elasticity demand function, the assumption is that all units demanded are sold. Suppose the company has the capacity to produce only 200 units. If demand is less than capacity, all of demand is sold. If demand is greater than or equal to capacity, only 200 units are sold. Use Solver to find the optimal price and the corresponding profit. Then use SolverTable to see how sensitive these answers are to the production capacity, letting it vary from 170 to 230 in increments of 10. Discuss your findings relative to the original solution in Example 7.1. In other words, what is the effect of capacity on the optimal price and profit?
W. L. Brown, a direct marketer of womens clothing, must determine how many telephone operators to schedule during each part of the day. W. L. Brown estimates that the number of phone calls received each hour of a typical eight-hour shift can be described by the probability distribution in the file P10_33.xlsx. Each operator can handle 15 calls per hour and costs the company 20 per hour. Each phone call that is not handled is assumed to cost the company 6 in lost profit. Considering the options of employing 6, 8, 10, 12, 14, or 16 operators, use simulation to determine the number of operators that minimizes the expected hourly cost (labor costs plus lost profits).

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