- +44 141 628 6080
- [email protected]

Explaintransportation modeling using excel solver

Transportation Modeling using Excel Solver

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

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

Expected delivery within 24 Hours

1926754

Questions

Asked

3,689

Active Tutors

1439270

Questions

Answered

**
Start Excelling in your courses, Ask a tutor for help and get answers for your problems !! **

Â©TutorsGlobe All rights reserved 2022-2023.

## Q : Calculate the change in share price

Consider a firm with 80 shareholders, including yourself, who each owns 1 share worth $10. In addition, I own 20 shares and I am trying to fire the management.