Compute the problem using transportation modeling

Assignment Help Operation Research

Reference no: EM13711387

Compute the following problem using Transportation Modeling using Excel Solver

Problem 1- A toy manufacturer ships toys from three plants to three regional distribution centers. The shipping costs per carload, plant capacities (in carloads) and demands (in carloads) are given below. Solve the problem and report your transportation assignments, including the total transportation cost.

Center 1 2 3

Plant

A 4 10 6

B 8 16 6

C 14 18 10

Plant Capacities Center Demands

A 100 1 200

B 300 2 300

C 300 3 200

Problem 2- A company produces concrete blocks at three plants. It ships these blocks to each of four construction sites for use in building shopping malls. Given below are the shipping costs (in dollars per truckload from Plant X to Site Y), the capacities for each plant (in truckloads) and the demand of each site (in truckloads). Solve the problem and report your transportation assignments, including the total transportation cost.

Site--> 1 2 3 4

Plant

A 5 12 7 0

B 4 6 7 6

C 2 8 5 3

Plant Capacities Site Demands

A 50 1 40

B 50 2 20

C 60 3 30

4 70

I need help to explain how to set-up and solve the linear programming problems. Also describe transportation modeling using excel solver.

Reference no: EM13711387

Questions Cloud

Display the global growth of smart phones : A national Digital service provider would like you to prepare a Windows application that will display the global growth of smart phones.

Describe globex investment capital corporation : Globex Investment Capital Corporation owns six companies that have the following estimated returns (in millions of dollars) if sold in 1 of the next 3 years.

Explain waikiki enterprise corporation lp : What are the decision variables. What is the objective function. What are the constraints. What are the non-negativity assumptions.

Explain the content and user access methods : Find an example of an actual data warehouse. For this example, explain the content, user access methods, purpose, and sources of data (what on-line transaction processing [OLTP] databases feed data into the data warehouse) -

Compute the problem using transportation modeling : Compute the following problem using Transportation Modeling using Excel Solver. A toy manufacturer ships toys from three plants to three regional distribution centers.

Explain what is research design : What is Research Design. Can you give an overview of the different methods. describe this solutions compares a selection of research design methodologies.

Explore marketing research-a six step process : Briefly discusses the marketing research process. How can a firm leverage its marketing information system (MIS) to yield the greatest value for its research efforts.

Describe health care operations managers : Define operations management and briefly describe the roles and goals of health care operations managers. Which role is most important and why.

Explain the significance of the marketing research report : Explain the significance of the Marketing Research Report. Discuss the relative importance of the marketing research report to other stages in the marketing research process.

User Account

All Pages