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 30x1 + 35x2 + 15x3+ 20x4s.t. 12x1 + 8x2 + 5x3 + 11x4 s 20 (Constraint 1)2 2 (Constraint 2}+X1x2X3X4s1 {Constraint 3}+X1 + x2X1 + x3 2 1 (Constraint 4}x2 = x4 (Constraint 5)S 1, if location j is selected0, otherwiseXjSolve 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

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

A Manager has the problem of assigning four new machines to three production facilities. The respective profits derived are as shown. If only one machine is assigned to a production facility, detemine the optimal assignment. Profits (K'000) production facility Machine B C A 10 10 14 10 11 13 C 12 10 10 13 12 11 B.
a-) find the initial solution using the Vogel's Approximation Method (VAM). and Find the optimal solution.
2
Gerald Glynn manages the Michaels Distribution Center. After careful examination of his database information, he has determined the daily requirements for part-time loading dock personnel. The distribution center operates 7 days a week, and the daily part-time staffing requirements are Day M T W Th F S Su Requirements 7 3 5 5 6 2 2 Find the minimum number of workers Glynn must hire. Prepare a workforce schedule for these individuals so that each will have 2 consecutive days off per week and all staffing requirements will be satisfied. Give preference to the S-Su pair in case of a tie. (Note: If there is a tie that cannot be broken by following the preference to the S-Su pair, choose the pair closest to the beginning of the considered week.) Part 2 The minimum number of workers is _________workers. (Enter your response as a…
1. Ethan Steel, Inc. has two factories that manufacture steel components for two different rail projects located at two different sites. They would like to determine the number of steel components they need to transport from each factory to each project site. The demand for the steel components for the two projects, Project A, and Project B are 3000, and 4000, respectively. The production and shipping details are as below:Production details:Factory 12Maximum capacity 20005000Shipping details (with per-unit shipping cost in dollars):Project Factory A B 178265Develop a linear programming optimization model to determine the distribution plan (from factories to projects) that minimizes the total transportation cost. (Do NOT solve the model.)
A renowned chocolatier, Francesco Schroeder, makes three kinds of chocolate confectionery: artisanal truffles, handcrafted chocolate nuggets, and premium gourmet chocolate bars. He uses the highest quality of cacao butter, dairy cream, and honey as the main Ingredients. Francesco makes his chocolates each morning, and they are usually sold out by the early afternoon. For a pound of artisanal truffles, Francesco uses 1 cup of cacao butter, 1 cup of honey, and 1/2 cup of cream. The handcrafted nuggets are milk chocolate and take 1/2 cup of cacao, 2/3 cup of honey, and 2/3 cup of cream for each pound. Each pound of the chocolate bars uses 1 cup of cacao butter, 1/2 cup of honey, and 1/2 cup of cream. One pound of truffles, nuggets, and chocolate bars can be purchased for $35, $25, and $20, respectively. A local store places a daily order of 10 pounds of chocolate nuggets, which means that Francesco needs to make at least 10 pounds of the chocolate nuggets each day. Before sunrise each…
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
The Acme Company operates four factories that ship products to five warehouses. The shipping costs, requirements capacities, and optimal allocations are shown in Figure. What is the total cost of the optimal solution?
ld by the m to spoilage Ho manufacre d 3-27 Farm Grown Umation. 2:3-24 Today's Electronics specializes in manufacturing modern electronic components. It also builds the equipment that produces the components. Phyl- lis Weinberger, who is responsible for advising the president of Today's Electronics on electronic manu- facturing equipment, has developed the following table concerning a proposed facility: products. Each etables and and sells for the end of cessing daily demand ity that daily the probability is 0.3. Farm Gro PROFIT ($) POOR customer demand Tos than the demand, I STRONG FAIR MARKET MARKET MARKET from a competiton is $16 per case. 550,000 110,000 -310,000 Large facility (a) Draw a decision table (b) What do you recomnen 300,000 129,000 -100,000 Medium-sized facility :3-28 In Problem 3-27m believe the probs Small facility 200,000 100,000 -32,000 to changing conons. ignored, what deon wa No facility (a) Develop an opportunity loss table. (b) What is the minimax regret…
Boysen produces enamel and acrylic paint from two particular raw materials M1 and M2. The following data provides the data regarding the production restrictions.
Diana are currently employed as full-time supervisor at a wealth management company in Kuala Lumpur, and she want to negotiate with the head manager, Mrs. Janice to work flexible hours from home on long term bases due to her condition which have previously miscarriage for two times. She is worried about her current pregnancy which just entered the second month. She and her husband has been waiting to conceive for more than 4 years. However, Diana want to implement this flexible hour (work remotely) to everyone in the company. Diana want to work remotely because she is now having to take care of herself as according to the doctor, she is so fragile at the early of her pregnancy. She must reduce her steps to make sure no bleeding could happen. Since she was on work from home mode for the last month as she is given bed rest by the doctor, she seems to prefer working in such condition. Diana found that working remotely gave her the flexibility and was able to concentrate a lot more…
A manufacturing company has 4 factories and 3 warehouses. The costs for transporting its products from factories to ware houses, the supply capacity of factories and demands in warehouses are given respectively by 6 4 81 70 170 4 3 2 C = 130 S = D= 200 2 4 7 100 130 1 5 8 200 a. Use minimum cost method to find an initial feasible solution. b. Determine the amount of products to be transported from factories to warehouses to minimize the cost.

SEE MORE QUESTIONS

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