Question: Consider the screenshot below (if it doesn't display properly, you can download the source spreadsheet from this link) which shows a potential solution for a

Consider the screenshot below (if it doesn't display properly, you can download the source spreadsheet from this link) which shows a potential solution for a standard Transportation Planning problem. When it comes time to set up Solver, which should your decision variables be?

Consider the screenshot below (if it doesn't

B4:D13
	B15:D15
	F4:F13
	B19:D28
	F19:F28
	H19:H28
	B30:D30
	B32:D32

B D F I Distribution Costs Los Angeles Tulsa S 356.25 $ 593.75 $ $ 356.25 $ 593.75 $ S 178.13 S 475.00 $ S 356.25 $ 475.00 $ S 178.13 S 475.00 $ S 356.25 S 296.88 $ Seattle 59.38 178.13 296.88 296.88 593.75 593.75 Demand 950 831.25 2375 593.75 1187.5 1543.75 3000 3000 3000 1 Aggie Power 2 3 4 Seattle 5 Portland 6 San Francisco 7 Boise 12 Flagstaff 13 Durango 14 15 Supply Available 16 17 18 19 Seattle 20 Portland 21 San Francisco 22 Boise 27 Flagstaff 28 Durango 29 30 Total 31 Relation 32 Supply Available 33 34 Total Cost Distribution Plan Los Angeles Tulsa 950.00 0.00 831.25 0.00 1218.75 1156.25 0.00 593.75 0.00 1187.50 0.00 62.50 Seattle 0.00 0.00 0.00 0.00 0.00 1481.25 Total 950.00 831.25 2375.00 593.75 1187.50 1543.75 Relation Demand 950 831.25 2375 593.75 1187.5 1543.75 3000.00 3000.00 1481.25 3000 3000 3000 $3,145,019.53

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Consider the screenshot below (if it doesn't display properly, you can download the source spreadsheet from this link) which shows a potential solution for an Employee Scheduling problem (a problem...

Question 9 (2 points) Consider the screenshot below (if it doesn't display properly, you can download the source spreadsheet from this link) which shows a potential solution for a Capital Budgeting...

Question 1 (2 points) Consider the screenshot below (if it doesn't display properly or if you want to mess around in the file, you can download the source spreadsheet from this link); assume that the...

Question 2 (2 points) Suppose that a firm called Applecore is determining how best to spend its advertising budget; among other selections, Applecore has decided to advertise on a series of websites,...

Question 1 (2 points) Suppose that a firm called Applecore is determining how best to spend its advertising budget; among other selections, Applecore has decided to advertise on a series of websites,...

7. Construct the Wheatstone bridge in Figure 2.4. Use a 9 V source and R,-50 k-ohm, R-40k-ohm, a resistance box and a third resistor for Rx. Measure the value of Rx using the ohmmeter. 8. Connect a...

(Ratio analysis over time) The following information comes from the accounting records of Hercep Ltd. for the first three years of its existence: 2018 2019 2020 Statement of Financial Position Assets...

Which types of dependencies are most common in project schedules? Select an answer: finich - 4 o - finick stan - to - start start - to - fonikt frish - 0 - fireh finiah - 6 0 - aturt frish - 6 0 -...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...