Purchase Solution

Transportation Modeling using Excel Solver

Not what you're looking for?

Ask Custom Question

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
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

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
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

Purchase this Solution

Solution Summary

This solution shows how to set-up and solve the linear programming problems in an attached Excel file.

Purchase this Solution

Free BrainMass Quizzes
Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

Learning Lean

This quiz will help you understand the basic concepts of Lean.

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.