b. What is the net present value of the optimal solution? (Round your answer to the nearest whole number.)Net present valuec. How much of the available capital will be spent (Hint: Constraint 1 enforces the available capital limit)? (Round your answer to thenearest whole number.)Available capital A firm has prepared the following binary integer program to evaluate a number of potential locations for new warehouses. The firm'sgoal is to maximize the net present value of their decision while not spending more than their currently available capital.Max 35x1 + 25x2 + 15x3+ 15x4s.t. 4x1 + 12x2 + 6x3 + 7x4 < 16 (Constraint 1}x3 + x4 Z 2 {Constraint 2}x1+x2x1+ x2 < 1 {Constraint 3}x1+ x3 2 1{Constraint 4}x2 = X4 (Constraint 5}1, if location jis selected0, otherwiseSolve this problem to optimality and answer the following questions:a. Which of the warehouse locations will/will not be selected?Location 1 willLocation 2 willLocation 3 willLocation 4 will

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

Answered: A firm has prepared the following…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

The MidLands Trucking Company based in Louisvillehas eight trucks located throughout the Mideast that havedelivered their loads and are available for shipments. Through their Internet logistics site MidLands has re-ceived shipping requests from 12 customers. The follow-ing table shows the mileage for a truck to travel to a customer location, pick up the load, and deliver it. Determine the optimal assignment of trucks to customersthat will minimize the total mileage. Customers Truck A B C D E F G H I J K L1 500 730 620 410 550 600 390 480 670 710 440 5902 900 570 820 770 910 660 650 780 840 950 590 6703 630 660 750 540 680 750 810 560 710 1200 490 6504 870 1200 810 670 710 820 1200 630 700 900 540 6205 950 910 740 810 630 590 930 650 840 930 460 5606 1100 860 800 590 570 550 780 610 1300 840 550 7907 610 710 910 550 810 730 910 720 850 760 580 6308 560 690 660 640 720 670 830 690 880 1000 710 680
J 2 An electronics store wants to identify a location for a warehouse that will ship to five retail stores. The coordinates and annual number of truckloads are given in the accompanying table. Develop a model to find the best location, assuming that straight-line distances can be used between the locations. Experiment with the model by testing each of the possible best solutions, included, to find the best location. Click here to view the data for the store locations and annual numbers of truckloads. Click here to view some possible best solutions. The best location is at____. (Type an ordered pair. Round each coordinate to the nearest integer as needed.)
9-7 The management of the Executive Furniture Corporation decided to expand the production capacity at its Des Moines factory and to cut back the production capacities at its other two factories. It also recognizes a shifting market for its desks and revises the requirements at its three warehouses. The table on this page provides the requirement at each of the warehouses, the capacity at each of the factories, and the shipping cost per unit to ship from each factory to each warehouse. Find the least-cost way to meet the requirements given the capacity at each factory.
Oscar’s Bowling, Inc., wants to break into the Phoenix metropolitan market with one of its super-sized 200 lane, 24-hour bowling alleys. It, however, only has enough capital to build one facility. Oscar wants it to be centered by population, as determined by the center of gravity method. The following information is given: City Population x coordinate y coordinate Tempe Scottsdale Chandler Mesa Glendale 250,000 400,000 300,000 700,000 350,000 5 5 5 10 1 5 10 0 1 10 a. Where should Oscar build? b. If Oscar wanted to relocate to the closest city near his new facility, where would he live?
Problem 4-17 Hemmingway, Inc., is considering a $5 million research and development (R&D) project. Profit projections appear promising, but Hemmingway's president is concerned because the probability that the R&D project will be successful is only 0.50. Furthermore, the president knows that even if the project is successful, it will require that the company build a new production facility at a cost of $20 million in order to manufacture the product. If the facility is built, uncertainty remains about the demand and thus uncertainty about the profit that will be realized. Another option is that if the R&D project is successful, the company could sell the rights to the product for an estimated $25 million. Under this option, the company would not build the $20 million production facility. FIGURE 4.16 DECISION TREE FOR HEMMINGWAY, INC. Start R&D Project ($5 million) Do Not Start the R&D Project Successful 0.5 Not Successful 0.5 3 Building Facility ($20 million) Sell Rights Profit ($…
Ohio Swiss Milk Products manufactures and distributes ice cream in Ohio, Kentucky, and West Virginia. The company wants to expand operations by locating another plant in northern Ohio. The size of the new plant will be a function of the expected demand for ice cream within the area served by the plant. A market survey is currently under way to determine that demand. Ohio Swiss wants to estimate the relationship between the manufacturing cost per gallon and the number of gallons sold in a year to determine the demand for ice cream and, thus, the size of the new plant. The following data have been collected: ITT Plant 1 Cost per Thousand Gallons (Y) $1,024 Thousands of Gallons Sold (X) 434.7 2 962 466.4 3 1,065 1,006 1,045 1,068 251.3 372.1 5 245.0 258.6 614.9 7 988 8. 997 414.0 267.5 380.4 3,704.9 9 1,063 1,000 $10,218 10 Total a. Develop a regression equation to forecast the cost per thousand gallons as a function of the number of thousands of gallons produced. The forecasting model is…
An operations manager wants to use gravity location approximation to decide the location of a warehouse. The x and y coordinates of three customer locations, demand (D) at those locations, and transportation costs per unit per mile (F) are presented in the table below. Help the operations manager by finding the approximate location of the warehouse. Customers y F 1 10 20 1 10 2 20 1 20 3 10 10 2 10 x=20, y=10 x=14, y=10 x=10, y=14 x=13.3, y=11.7 O x=10, y=15

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS