This Excel assignment will demonstrate the transportation problem, which is concerned with finding the minimum cost of transporting a single commodity from a given number of sources (i.e., factories) to a given number of destinations (i.e., warehouses). Note that in this problem, the demand equals the supply. There are more advanced transportation problems that deal with the situation for when the demand does not equal the supply, which is called an unbalanced problem. In an unbalanced problem, you would have had to add a dummy source if demand is greater than supply OR add a dummy destination if supply is greater than demand.
For this assignment, complete the following:
Download and review Transportation Problem-fill in_1.pdf for step-by-step instructions. The pdf file below will walk you through each step in the assignment.
Watch the video: Solving Transportation Problems in Excel_1_.mp4 (5:42). The video below helps to visually see the steps. I did not create this video and the sound is not good. It is a reference to help you visually follow the steps in the tutorial document (pdf file) that accompanies this assignment.
Open a blank Microsoft Excel spreadsheet. You will need to input the data from the instructions document into your blank Excel file. You will need to use a Windows based computer (Mac computers will not be supported by the University).
Save and Submit your Excel spreadsheet
Note that in this problem, the Demand equals Supply. There are more advanced transportation problems that deal with the situation for when demand does not equal supply (called an ‘unbalanced’ problem). In an unbalanced problem, you would have had to add a dummy source if demand > supply OR add a dummy destination if supply > demand.
https://learn-us-east-1-prod-fleet02-xythos.content.blackboardcdn.com/609adae01c5c3/548006?X-Blackboard-Expiration=1665360000000&X-Blackboard-Signature=VwgrH%2FKnG%2FZEe67%2F3iVzvkd%2BbbELd35lIFX5Pn5M0X8%3D&X-Blackboard-Client-Id=300545&response-cache-control=private%2C%20max-age%3D21600&response-content-disposition=inline%3B%20filename%2A%3DUTF-8%27%27Solving%2520Transportation%2520Problems%2520in%2520Excel%25281%2529.mp4&response-content-type=video%2Fmp4&X-Amz-Security-Token=IQoJb3JpZ2luX2VjEIP%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCXVzLWVhc3QtMSJHMEUCIQDAF8OKbotn1utNGcDBSjc0JzaAE%2F1ZRPGGoQ5RXjCkMgIgRpJAvNjq4ypswaJ50yw2%2Fco8WvUqPNtkX8JPfYs4pzgqzQQITBACGgw2MzU1Njc5MjQxODMiDKX6yiHtBFeQbVKMwyqqBMRR%2F3ydV8MmQ%2BmGny1b%2FW0nMNtWGchMvc%2FoaWhGw6iTgyrSnr2qJJXO8Z2wxnB%2BlQtUmUMUHk1QWPhS9XAGWSLUhbTKIk7OlLzkYbIdgtDr%2Bsba%2BOVhsZqYrH1BLW%2FuFQjkR3VOvoZ4NkC%2BugqqjgFRTzH54LgL6Nt1pIMhU6jqyoYwUCBCSYNF59mzJvFM3VsTyF8yE53XAV%2B1r9cp6jFHhQwfK%2BFtvxKP459IH5GM1emtKTlh%2FjaWxPvNOO7sXnFV7qriLdIQo8FyMj%2BvJg5vAR5oalAhgIkj8N36D17A59AxrvVhtnSkQWdlxAdsozKH96YUUr%2FtZo%2B1WpUyDLFNqeJp%2FJPS%2BKLa5wsTDlHMrNMpm3wjACcd6I%2BJWdc9jCx0L8Ddp%2BDZ2EZBCwSb33eqYWhznWivfALoy7CW8YciOZVEoYYMEhinrQWCmH5tt87CuHNwQpr96hgEI9J%2BmQmbPIbihNg4An9yLpNXMoNfI1UIPi79TE0vNIS6iCtDUhqXU4wVRWB9Qat2xxCTi%2FhBsLzvMS5cPBNxcCQdHwK9KIBNk4pd%2BozdQp%2BMX9cbrx1MrDl4tji0DrPqCRI6tCAwvG966yues47mDufsbTXtzcPiA8TtYsVd4ve0up8a5JYO8eCUaqhu79krS9PjoZHU89OkmIHy8hNxLVqO85OMK2knO4NMCBkm4mfdppQadXPAzAsHndmWuG%2FLRvBUePt2N3jUoRRrJeuyMKuljJoGOqkBjZajZg9gLDGtvUKhCcmjMMaqlS2tdYnvY8JbSe40LIyV%2B2UfuI%2B0FqKoWmMKr828YUBNltgDaHkB5raezgj0UfrEEou2LUkpSxQ439A%2BRCm%2F1rdd6VU1QkoejNZGraB5Gpeee4nRDRTZnGv6ClJioYm1XNgdFFQxhqt%2Fkh7KNBjIHzCu3twnRL5becmcWDchekYIRekGl%2BXb1hbbj0BFj0qW9qyVl2upYw%3D%3D&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Date=20221009T180000Z&X-Amz-SignedHeaders=host&X-Amz-Expires=21600&X-Amz-Credential=ASIAZH6WM4PLR37E3TXD%2F20221009%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Signature=60d1eb999c2e704727967abc9c27dafd5d2331acffce99a64c9b2bc0209e22fc