Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please help filling this spreadsheet by using Solver in excel. especially dinding total recieved and minimize total cost, thank you! Cost to ship to Rick's
please help filling this spreadsheet by using Solver in excel. especially dinding total recieved and minimize total cost, thank you!
Cost to ship to Rick's interdimensional Transport Terminals Rick Intermdimensional Transports (RIT) provides all of the transportation for Morty's Citadel. Morty's Citadel produces a robotic assistant called Mr. Meeseeks in Oklahoma City, Atlanta, and Phoenix Areas. The components produced in either Oklahoma City. Atlanta, or Phoenix will be picked up by RIT and brought to their regional terminals/warehouses in Denver. Memphis, or Charlotte. RIT will then deliver the components to Morty's Citadel's Showrooms in Detroit, Miami, Dallas, New Orleans, and Boston. RIT has provided a truckload costs for Morty's Citadel. The tables are below. Cost to ship to Rick's interdimensional Transport Terminals The Oklahoma City facility at maximum can ship out 60 Truckloads, the Atlanta Facility has a maximum capacity of 60 truckloads, and the Phoenix facility can ship a maximum of 65 Truckloads: The RIT Terminals should not keep any freight on hand. Everything recelved should be shipped out. They do not have a maximum capacity. Mortys: Citadel showrooms demand the following amount of truckload deliveries: Detroit requires 47 truckloads, Miami requires 32 truckloads, Dallas requires 37 truckloads. New Orleans requires 37 truckloads, and Boston requires 32 truckloads. Morty's Citadel wants to minimize transportation costs. Cost to ship to Rick's interdimensional Transport Terminals Rick Intermdimensional Transports (RIT) provides all of the transportation for Morty's Citadel. Morty's Citadel produces a robotic assistant called Mr. Meeseeks in Oklahoma City, Atlanta, and Phoenix Areas. The components produced in either Oklahoma City. Atlanta, or Phoenix will be picked up by RIT and brought to their regional terminals/warehouses in Denver. Memphis, or Charlotte. RIT will then deliver the components to Morty's Citadel's Showrooms in Detroit, Miami, Dallas, New Orleans, and Boston. RIT has provided a truckload costs for Morty's Citadel. The tables are below. Cost to ship to Rick's interdimensional Transport Terminals The Oklahoma City facility at maximum can ship out 60 Truckloads, the Atlanta Facility has a maximum capacity of 60 truckloads, and the Phoenix facility can ship a maximum of 65 Truckloads: The RIT Terminals should not keep any freight on hand. Everything recelved should be shipped out. They do not have a maximum capacity. Mortys: Citadel showrooms demand the following amount of truckload deliveries: Detroit requires 47 truckloads, Miami requires 32 truckloads, Dallas requires 37 truckloads. New Orleans requires 37 truckloads, and Boston requires 32 truckloads. Morty's Citadel wants to minimize transportation costs Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started