Answered step by step
Verified Expert Solution
Link Copied!

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!
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of Auditing And Other Assurance Services

Authors: Ray Whittington, Kurt Pany

22nd Edition

126059808X, 978-1260598087

More Books

Students also viewed these Accounting questions

Question

9. Prove Theorem 11.2.2.

Answered: 1 week ago