Could you create a spreadsheet model for the following information? this is to determine the optimal shipment routes by
Posted: Thu Jul 14, 2022 2:06 pm
Could you create a spreadsheet model for the followinginformation? this is to determine the optimal shipment routes byminimizing total cost.
You have finally been promoted to Senior Manager for thenuts and bolts category at Locky Locke Inc., a manufacturer with alarge demand for bolts at its three (3) factories. You havesurveyed the market and found four (4) suppliers for a certainsteady selling SKU, ZA27R46. Your factories' weekly demandfor bolts are:
Each of the four suppliers can provide the ZA27R46, but theydiffer in unit price, weekly capacity, and distance to Locky LockeInc. three factories. The unit prices and the weekly capacityfor each of the four suppliers are shown below:
Transport Distance (miles)
Factory 1
Factory 2
Factory 3
U.S. Ainbolt
120
380
806
Der Bolt, Thun
465
717
853
Li Tningbolt
553
572
830
M. Bolton
915
406
564
You have finally been promoted to Senior Manager for thenuts and bolts category at Locky Locke Inc., a manufacturer with alarge demand for bolts at its three (3) factories. You havesurveyed the market and found four (4) suppliers for a certainsteady selling SKU, ZA27R46. Your factories' weekly demandfor bolts are:
Each of the four suppliers can provide the ZA27R46, but theydiffer in unit price, weekly capacity, and distance to Locky LockeInc. three factories. The unit prices and the weekly capacityfor each of the four suppliers are shown below:
Transport Distance (miles)
Factory 1
Factory 2
Factory 3
U.S. Ainbolt
120
380
806
Der Bolt, Thun
465
717
853
Li Tningbolt
553
572
830
M. Bolton
915
406
564