|×23X22X13X21 +X11X12 +Mins.t.X12X13X22X23+X11X21X21X22X11X23X12X13X11 X12' X13 X21• X22' X23 2 0(b) Solve the linear program to determine the optimal solution.CostAmountJefferson City-Des MoinesJefferson City-Kansas CityJefferson City-St. LouisOmaha-Des MoinesOmaha-Kansas CityOmaha-St. LouisTotalVIVII|||++ Consider the following network representation of a transportation problem.25Des Moines14Jefferson40City8Kansas15City81125Omaha2425St. LouisSuppliesDemandsThe supplies, demands, and transportation costs per unit are shown on the network.(a) Develop a linear programming model for this problem; be sure to define the variables in your model.

Suppose the no. of products transported from Jefferson City to Des Moines be x11 and so on. We take…

Answered: Consider the following network…

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

Cutey Barber Salon Cutey Barber Salon is a trendy barber salon that is located in a densely populated city called Maple. Demand for the services offered by the salon is fairly high. It offers services such as haircuts, hair styling, scalp massaging and conditioning treatment, straight razor and wet shave, beard sculpting, facials and hair colouring. In addition to these services provided, the salon sells premium hair products to customers. The salon has the ability to produce a maximum of 20,000 haircuts and hairstyling per year. Demand for haircuts and hairstyling over the last five years can be seen in the following table:- Year Demand for haircuts and hairstyling 2017 11,500 2018 12,200 2019 13,400 2020 14,000 2021 14,500 Although the business does not have a written vision and mission statement, it is clear in the minds of management what they want to achieve and what they would like to be in the future. Currently, customers can walk in at…
Georgia Cabinets manufactures kitchen cabinets that are sold to local dealers throughout the Southeast. Because of a large backlog of orders for oak and cherry cabinets, the company decided to contract with three smaller cabinetmakers to do the final finishing operation. For the three cabinetmakers, the number of hours required to complete all the oak cabinets, the number of hours required to complete all the cherry cabinets, the number of hours available for the final finishing operation, and the cost per hour to perform the work are shown here: Cabinetmaker 1 Cabinetmaker 2 Cabinetmaker 3 Hours required to complete all the oak cabinets 47 40 27 Hours required to complete all the cherry cabinets 64 51 36 Hours available 40 30 35 Cost per hour $34 $41 $52 For example, Cabinetmaker 1 estimates it will take 47 hours to complete all the oak cabinets and 64 hours to complete all the cherry cabinets. However, Cabinetmaker 1 only has 40 hours available for the final…
Suppliers A, B, and C supply components to three plants -- F, G, and H via two transshipment facilities -- T1 and T2. It costs $4 to ship from T1 regardless of final destination and $3 to ship to T2 regardless of supplier. Shipping to T1 from A, B, and C costs $3, $4, and $5, respectively, and shipping from T2 to F, G, and H costs $10, $9, and $8, respectively. Suppliers A, B, and C can provide 200, 300 and 500 units respectively and plants F, G, and H need 350, 450, and 200 units respectively. The Logistics Manager has come to you for help. Answer the following question: Which of these is not an element of the objective function? Group of answer choices 4D-T1 600T1 9T2-G 3C-T2 Plz do fast asap
The Gulf Coast Foundry is developing a long-range strategic plan for buying scrap metal for its foundry operations. The foundry can buy scrap metal in unlimited quantities from two sources, Atlanta (A) and Birmingham (B), and it receives the scrap daily in railroad cars. The scrap is melted down, and lead and copper are extracted for use in the foundry processes. Each railroad car of scrap from source A yields 1 ton of copper and 1 ton of lead and costs $10,000. Each railroad car of scrap from source B yields 1 ton of copper and 2 tons of lead and costs $15,000. If the foundry needs at least 21/2 tons of copper and at least 4 tons of lead per day for the foreseeable future, how many railroad cars of scrap should be purchased per day from Source A and Source B to minimize the long-range scrap metal cost?
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 to Capacity constraints X11 + X12 + x13 + x14 =11 Requirement constraints X11 +x21 + X31 = 6 X21 +x22 +x23 +x24 = 13 X12 +x22 +x32 = 10 X31 + X32 + X33 +X34 = 19 X13 + x23 +X33 = 12 X14 +x24 +x34 = 15 and *i 2 0, for all i = 1,2,3,4 ;j=1,2,3
The following network describes a transportation scenario in which there are four sources A, B, C, and D, and three destinations P, Q, and R. (The numbers next to each arrow represent the cost of transporting one unit from that particular source to the destination located at the other end of that arrow). Write the mathematical formulation of the problem. Use the Excel Solver to solve the problem. Generate the answer and sensitivity reports in Excel, and submit your Excel workbook as a separate attachment. Provide the solution obtained in the space provided. What is the optimal cost of transportation?
Solve the following problem: The Krampf Lines railway company specializes in coal handling. On Saturday, Krampf had empty cars at the following towns in the quantities indicated: Town Supply of cars Morgantown 35 Youngstown 60 Pitsburg 25 By Monday, the following towns will need cars as follows: Town Demand for cars Coal Valley 30 Coal town 45 Coal junction 25 Coalsburg 20 The result is shown in the table below. To From Coal Valley Coal town Coal junction Coalsburg Morgantown 50 30 60 70 Youngstown 20 80 10 90 Pitsburg 100 40 80 30 Required: Minimize total miles over which cars are moved to new locations regarding the following: Formulate as a linear programming. Use North-West corner method to obtain the total shipment cost of coal cars.
Cutey Barber SalonCutey Barber Salon is a trendy barber salon that is located in a densely populated city called Maple. Demand for the services offered by the salon is fairly high. It offers services such as haircuts, hair styling, scalp massaging and conditioning treatment, straight razor and wet shave, beard sculpting, facials and hair colouring. In addition to these services provided, the salon sells premium hair products to customers. The salon has the ability to produce a maximum of 20,000 haircuts and hairstyling per year. Demand for haircuts and hairstyling over the last five years can be seen in the following table:-Year Demand for haircuts and hairstyling2017 11,5002018 12,2002019 13,4002020 14,0002021 14,500Although the business does not have a written vision and mission statement, it is clear in the minds of management what they want to achieve and what they would like to be in the future.Currently, customers can walk in at anytime to be served. At times, customers have to…
eBook Problem 8-21 (Algorithmic) Round Tree Manor is a hotel that provides two types of rooms with three rental classes: Super Saver, Deluxe, and Business. The profit per night for each type of room and rental class is as follows: Room Type 1 Type II Rental Class Super Saver $37 $18 Explain. Deluxe $40 $33 Variable SuperSaver rentals allocated to room type I SuperSaver rentals allocated to room type II Deluxe rentals allocated to room type I Deluxe rentals allocated to room type II Business rentals allocated to room type II Is the demand by any rental class not satisfied? Business Type 1 rooms do not have wireless Internet access and are not available for the Business rental class. Round Tree's management makes a forecast of the demand by rental class for each night in the future. A linear programming model developed to maximize profit is used to determine how many reservations to accept for each rental class. The demand forecast for a particular night is 125 rentals in the Super Saver…

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