Question

Make sure you Maximize profit for this problem.
I do not see a Total Out column or a Total In Column in your spreadsheet. You should be using the solution method for an Unbalanced Transportation Problem. Use Excel 2016. Also, include a dummy destination

Fill in the rest of the questions, other ones that are filled in are correct

Bindley Corporation has a Minneapolis. Plans call for the r contract to y motors for all washing machines produced by Rinso Ltd. Rinso manufactures the washers at four locations around the country: New York, Fort Worth, San Diego, and g numbers of washing machines to be produced at each location New York Fort Worth San Diego Minneapolis 75,000 59,000 77,000 60,000 Bindley has three plants that can produce the motors. The plants and production capacities are 51,000 160,000 70,000 Due to estimates of the dollar profit per unit. (Shipment will be made in lots of 1,000.) production and transportation costs, the profit Bindley earns on each 1,000 units depends on where they were produced and where they were shipped. The following table gives the accounting department PRODUCED AT NEW YORK FORT WORTH SAN DIEGO MINNEAPOLIS 14 28 10 20 25 14 13 30 18 20 Given profit maximization as a criterion, Bindley would like to determine how many motors should be produced at each plant and how many motors should be shipped from each plant to each destination a. Develop a transportation grid for this problem From/To San Diego 18 New York Fort Worth 14 28 10 59000 20 14 13 30 51000 160000 70000 Macon 25 20 75000 77000 60000 Given profit maximization as a criterion, Bindley would like to determine how many motors should be produced at each plant and how many motors should be shipped from each plant to each destination. a. Develop a transportation grid for this problem 20 14 28 10 59000 18 14 13 30 60000 51000 160000 70000 25 20 Requirements 75000 b. Find the optimal solution using Microsoft Excel. (Leave no cells blank - be certain to enter "O" wherever required.) Candidate Solution Total Shipped Macon 50,000 60000 70000 Total supplied 5900077000 60000 40000 Macon Total pront

Answer 1

M16 From/To Boulder Macon Gary Requirements New York Fort worth San Diego Minneapolis Supply 20 18 14 13 30 51000 160000 25 28 10 59000 20 75000 Decision Variables From/To Boulder Macon Gary New York Fort worth San Diego Minneapolis 10 Objective function Maximize the total profit 12 13 From/To Boulder Macon Gary Total profit New York Fort worth San Diego Minneapolis -B8 B2 -89"ВЗ -B10 B4 -SUM(B14 E16) Constraints -C8 C2 -C9 C3 -C10 C4 -D8 D2 15 16 17 18 19 SUM(B8:E8) 20 SUM(B9:E9) 21 SUM(B10:E10) 22 SUM(B8:B10) 23 SUM(C8:C10) 24 SUM(D8:D10) 25 SUM(E8 E10) 26 |-С9 -D10 D4 -E10 E4 하2 -F4 -B5 50000

1 From/ToNew York Fort worth San Diego Minneapolis Supply 51000 160000 Boulder Macon Gary 18 25 13 10 30 5 Requirements 75000 59000 Decision Variables 7 From/ToNew York Fort worth San Diego Minneapolis Boulder Macon 10 Gary Objective function Maximize the total profit 12 13 From/To New York Fort worth San Diego Minneapolis Boulder Macon Gary 15 16 17 Total profit 18 19 Constraints 51000 160000 59000 25 26

Solver Parameters SBS17 Set Objective To: O Max OMin alue Of By Changing aiable Cells: SBS& SES10 Subject to the Constraints: SAS19:SAS21 SCS19:SCS21 SAS22:SAS26 = SCS22:SCS26 SBS&SE$10 >= 0 Add Change Delete Reset All Load/Save Make Unconstrained Variables Non-Negative Select a Solng GRGNonlinear Method: Options Solving Method Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Simplex engine for linear Solver Problems, and select the Evolutionary engine for Solver problems that are non-smooth. Help Solve Close

Decision Variables From/To New York Fort worth San Diego Minneapolis Boulder Macon 9000 32000 35000 10000 0 0 10 Ga 0 Objective function 12 Maximize the total profit From/To New York Fort worth San Diego Minneapolis Boulder Macon 0 126000 576000 0 1875000 1400000 0 16 I 17 Total profit 6747000 Ga 0