A firm has prepared the followingbinary integer program to evaluate anumber of potential locations for newwarehouses. The firm's goal is tomaximize the net present value of theirdecision while not spending more thantheir currently available capital.Max 15x1 + 25x2 + 15x3+ 35x4s.t. 8x1 + 11x2 +6x3 + 6x4 s 17{Constraint 1}X1 + x2 +X1 + x2 < 1 {Constraint 3}X1 + x3 2 1 {Constraint 4}X2 = X4 {Constraint 5}X4 2 2 {Constraint 2}X3+S 1, if location jis selected(0, otherwiseSolve this problem to optimality andanswer the following questions:Xja. Which of the warehouse locationswill/will not be selected?Location 1 willLocation 2 willLocation 3 willLocation 4 willbe selectednot be selected b. What is the net present value of theoptimal solution? (Round youranswer to the nearest wholenumber.)Net present valuec. How much of the available capitalwill be spent (Hint: Constraint 1enforces the available capital limit)?(Round your answer to the nearestwhole number.)Available capital

Answered: Image /qna-images/answer/42791205-538e-4fea-8543-56f749e78384.jpg

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

Cutlery Corner sells specialty knives to knife enthusiasts. They have a generous advertising budget to spread among four media channels: their recurring TV show, newspaper ads, radio spots, and social media. Tom, the owner and star of the TV show is adamant that the show air at least twice a day, seven days a week but decides you can allocate the rest of the budget as you see fit. The TV shows draws 20,000 interested viewers per airing and costs $2,000 per episode. Daily newspaper ads cost $1500 and can be run up to seven days a week. Given the level of readership for newspapers, you settle on a figure of 10,000 people reached per ad. Radio spots come in 15 second and 30 second durations – 15 second spots in drive time cost $500 per airing and 30 second spots any other time of the day are a relative bargain at $250. Drive time spots are available twice a day (morning and evening commute) five days a week and reach 12,000, and the "any other time" spots could air up to six times a day…
Hudson Corporation is considering three options for managing its data processing operation: 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: Demand Staffing Options High Medium Low Own staff 600 550 350 Outside vendor 900 650 450 Combination 700 600 400 a. If the demand probabilities are 0.4, 0.25, and 0.35, which decision alternative will minimize the expected cost of the data processing operation? Own Staff What is the expected annual cost associated with that recommendation? If required, round your answer to the nearest thousand of dollars. Expected annual cost = $ ___________
A fruit juice manufacturer has recently begun negotiations with brokers in the areas where it intends to distribute its products. Before finalizing the agreements, however, the manager wants to determine shipping routes and costs. The firm has three plants with the capacities as shown below: Estimate demands in each of the warehouse localities are: PLANT CAPACITY (PIECES PER WEEK) WAREHOUSE 1 2 3 400 800 600 A B C D DEMAND (PIECES PER WEEK) 900 200 400 300 The estimated ship cost per box for the various routes are: ΤΟ FROM A B C D 1 5 7 9 12 2 10 7 2 3 3 8 9 6 4 Row/Column Opportunity Cost Demand Row/Column Cell Total Cost Opportunity Cost Cost of the above Test of unallocated Cells allocation Supply Amount char
How did you find the solutions in the table for the range of optimality for the profit coefficient?
A 36,000 square foot office building in Emeryville, California that was 88% leased had a 2023 annual net operating income estimated to be $1,880,000 with gross leases for all its tenants and a three level subterranean parking garage with 180 parking spaces. The 2024 NOI could be increased by all the following, EXCEPT: Increasing the operating expenses by adding additional maintenance staff Increasing the parking income by charging tenants for their employee parking Increasing the occupancy rate of the building by signing leases with new tenants Increasing the rental rates in new leases that are signed for the building
like this fill the boxes

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

A firm has prepared the following binary integer program to evaluate a number of potential locations for new warehouses. The firm's goal is to maximize the net present value of their decision while not spending more than their currently available capital.