e. Use VAM to obtain the initial solution for the transportation model below:Minimize Z = (21x11 +16x12 + 25.x13 +13x14)+ (17x21 +18x22 +14x23 + 23x24)+ (32x31 + 27x32 +18x33 +41x34)Subject toCapacity constraintsX11 + X12 + x13 + x14 =11Requirement constraintsX11 +x21 + X31 = 6X21 +x22 +x23 +x24 = 13X12 +x22 +x32 = 10X31 + X32 + X33 +X34 = 19X13 + x23 +X33 = 12X14 +x24 +x34 = 15and *i 2 0, for all i = 1,2,3,4 ;j=1,2,3

From the given problem, the transportation problem can be tabulated as follows. A B C D…

Answered: e. Use VAM to obtain the initial…

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

Western Chassis produces high-quality polished steel and aluminum sheeting and two lines ofindustrial chassis for the rack mounting of Internet routers, modems, and other telecommunicationsequipment. The contribution margin (contribution toward profit) for steel sheeting is $0.40 per poundand for aluminum sheeting is $0.60 per pound. Western earns $12 contribution on the sale of aStandard chassis rack and $15 contribution on a Deluxe chassis rack. During the next productioncycle, Western can buy and use up to 25,800 pounds of raw unfinished steel either in sheeting or inchassis. Similarly, 20,400 pounds of aluminum are available. One standard chassis rack requires 16pounds of steel and 8 pounds of aluminum. A Deluxe chassis rack requires 12 pounds of each metal.The output of metal sheeting is restricted only by the capacity of the polisher. For the next productioncycle, the polisher can handle any mix of the two metals up to 4,000 pounds of metal sheeting. Chassismanufacture can be…
A company manufactures a product at its plants in A, B, and C, then ships the product to six customers in G, H, J, K, and L. The monthly capacity of plants A, B, and Care 7300, 7400, and 7500 units, respectively. The monthly demand from customers G, H, J, K, and Lare. 1200, 8900, 7600, 2600, and 1500 units, respectively. Use Excel Solver to find the optimal distribution plant that will give the lowest total monthly shipping cost if the shipping cost per unit (in dollars per unit) are as follows: from A to G, H, J, K, and L are 4, 9, 20, 6, and 13 dollars per unit, respectively; from B to G, H, J, K, and Lare 7, 6, 12, 2, and 9 dollars per unit, respectively; from C to G, H, J, K, and Lare 12, 7, 3, 17, and 6 dollars per unit, respectively. The optimal total shipping costs is dollars per month
Smith Inc. is a retail mail order firm that currently uses a centralized collection system that requires all checks to be sent to its flotation headquarters. An average of 6 days is required for mailed checks to be received, 3 days for Smith Inc. to process them, and 2 days for the checks to clear through its bank. A proposed lockbox system would decrease the mailing and processing time to 2 days and the check clearing time for 1 day. Smith Inc. has an average daily collection of P250,000. If Smith Inc. adopts this proposed lockbox system, its average cash balance will increase by. A. 1.2M B. 450k C. 750k D. 2M
Use the following information for the next 3 questions: A product is to take 30 hours to be delivered to a customer and shipping costs are $2700. If the product is 8 hours or more late, the penalty is $500. Shipping costs decline at a rate of $50 for each additional hour of transit time allowed. 1. What is the optimal delivery time (y) that will minimize costs? - 33.2 hours - 31.2 hours - 32.2 hours - 30.2 hours - 34.2 hours - 35.2 hours 2. If the product is delivered in 34 hours, what is the Taguchi Loss Cost (L)? - $250 - $300 - $80 - $500 - $0 - $125 - $375 3. If the product is delivered in 36 hours, what is the Total Cost (Taguchi Loss Cost plus Process Cost)? - $2,700 - $2,681.25 - $2,400 - $2,396.75 - $2,250.30 - $2,543.50
Formulate but do not solve the problem.The management of Hartman Rent-A-Car has allocated $2.25 million to buy a fleet of new automobiles consisting of compact, intermediate-size, and full-size cars. Compacts cost $18,000 each, intermediate-size cars cost $27,000 each, and full-size cars cost $36,000 each. If Hartman purchases twice as many compacts as intermediate-size cars and the total number of cars to be purchased is 100, determine how many cars of each type will be purchased. (Assume that the entire budget will be used. Let x, y, and z denote the number of compact, intermediate-sized, and full-size cars purchased, respectively.) = 2,250,000 = x = 100
How the Use of HLOOKUP function to determine sales for a particular day, be useful and applicable in business and other transactions?
ABC pharmaceutical Company has four factories that ship supplies to four warehouses. The company’s management hires you as a consultant to determine a minimum-cost shipping plan for its monthly output to the warehouses. Factory capacities, warehouse demands, and shipping cost per box are shown below. Factory Supply or capacity (boxes) Warehouse Demand (boxes) Richmond 60 Chicago 100 Santa Fe 80 Jacksonville 90 Austin 120 Huntville 50 Vacaville 90 Fresno 70 Shipping Costs per box (In Dollars) From To Chicago To Jacksonville To Huntsville To Fresno Richmond 35 35 46 60 Santa Fe 65 40 35 25 Austin 50 50 80 90 Vacaville 40 40 66 75 Draw a diagram by showing factories, warehouses, and connecting arcs. Define variables, write the objective function and constraints.
Please see the screenshot for this optimization problem. Thanks.
Davis Inc. produces three product lines in its manufacturing facility in St. John's, NL: Product Line (1), Product Line (2), Product Line (3). Davis is considering dropping Product Line (2) because it has been unprofitable for the past two years. Which of the following items is (are) irrelevant to Davis' decision to drop/keep Product Line (2)? O a) Total cost of rent on the manufacturing facility. O b) Customer demand for Product Line (2). Oc) Savings in direct materials cost associated with Product Line (2). O d) All of the above items are considered relevant in the decision.
Degenerate Transportation Problem: What is the cost and the cell evaluation?
The north–south highway system passing through Albany, New York, can accommodate the capacities (in thousands) shown. Formulate this problem as an LP to determine the maximum number of vehicles that can be accommodated in this north-south highway system. How many vehicles per hour must travel over each road (arc) to obtain this maximal flow? Can the highway system accommodate a north–south flow of 10,000 vehicles per hour?
Solve 9 a and b

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