Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PLEASE SOLVE (in excel preferably) I have a distance matrix between factories and warehouses. The factories supply to the warehouse. What is the transportation cost

PLEASE SOLVE (in excel preferably)

I have a distance matrix between factories and warehouses. The factories supply to the warehouse. What is the transportation cost formula I can use (it can be an expression of variables)? If I take the fuel cost as R25 per liter. I don't have other cost values (that I think might be necessary).

Factories are letters (A - L)

Warehouses are the numbers (1 - 9)

I know Transportation cost can be distance divided by fuel price. But I want the transport cost per unit transported.

Distance matrix:

1 2 3 4 5 6 7 8 9
A - - - - 0,59 7,84 - - -
B 1,16 1,16 0,43 - - - - - 4,35
C - - - - - - - 1 -
D - - - - - - 35,33 - -
E 2,09 2,09 3,37 - - - - - 1,25
F - - - 67,2 8,78 3,13 - - -
G 2,38 2,38 3,49 - - - - - 1,11
H 19,06 19,06 18,42 - - - 36,36 - 22,22
I - - - 0,33 - - - 15,2 -
J - - - - - - 0,76 - -
K - - - - - - 38,39 - -
L 3,56 3,56 4,85 181,47 - - - - 0,36

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Calculus Early Transcendentals

Authors: James Stewart

8th edition

1285741552, 9781305482463 , 978-1285741550

More Books

Students also viewed these Economics questions

Question

In Problems 1130, solve each equation by factoring. x 2 + 4x = 0

Answered: 1 week ago

Question

If u is a unit vector, find u v and u w. u V

Answered: 1 week ago