Still Thinking Of Assignment Help & Grades ? Book Your Assignment At The Lowest Price Now & Secure Higher Grades!
*
*

Programming

The Childfaiar Company produces child pushchairs that have been providing by three plants
which are shipped to four different distribution centres. The plant number 1, 2, and 3 produce 12,
17 and 11 shipments every month respectively. The entire distribution centre needs ten purchases
every month. The distance to the respective distribution centres from each plant is shown below:
The cost of cargo is $85 plus 55 cents mile for each shipment. How much should be shipped to
each distribution centre from all the plants to minimize the total cost of shipping?
The above condition can be described as a transportation problem. We can determine the
optimum amount of shipments from each plant to each distribution centre using the Solver tool
in Microsoft Excel.
Actually, this is the linear exercise in programming. Three components were involved in the
whole direct programming exercise:
In the form that is provided in Sheet 1 of the attached excel file, the data is tabulated. The
selected variables are the ideal combination of shipments to each distribution centre from the
factory. The cost of each plant to the different distribution centres is given as per shipping.

Grab Assignment Offers

First Order Offer

30%
off
Book Your First Assignment And get 30% off on your order.
* Conditions and restrictions apply.

Similar order offer

100%
off
Book 4 Similar Assignments within 3 days get 1 more copy 100% FREE
* Conditions and restrictions apply.

Special Offer

Buy 3
1 Free
Book 3 Assignment And get 1 Assignment Free.
* Conditions and restrictions apply.

Upto

10%
off
Book 2 Assignment within 48 hours, get 10% OFF on second assignment
* Conditions and restrictions apply.

TabPanel

Need Assignment Help

online assignment assistance
grab your copy now...
*
*
*Email and Country fields are Mandatory

Need Assignment Help

online assignment assistance
grab your copy now...
*
*

*Email and Country fields are Mandatory

Get a Quote

- +