Question: Part 1 0.0/0.5 points (graded) CMS Inc. is a large manufacturer of industrial parts and components based in Chicago, IL. The company distributes their products

Part 1 0.0/0.5 points (graded) CMS Inc. is aPart 1 0.0/0.5 points (graded) CMS Inc. is aPart 1 0.0/0.5 points (graded) CMS Inc. is aPart 1 0.0/0.5 points (graded) CMS Inc. is aPart 1 0.0/0.5 points (graded) CMS Inc. is aPart 1 0.0/0.5 points (graded) CMS Inc. is a
Part 1 0.0/0.5 points (graded) CMS Inc. is a large manufacturer of industrial parts and components based in Chicago, IL. The company distributes their products through a network of three warehouses located in Atlanta, GA; Charlotte, NC; and Jacksonville, FL. The company's customer base includes original equipment manufacturers across Southeastern U.S. The monthly demand aggregated by state is shown in the table below: State Demand (cases) AL 490 FL 1880 GA 1060 KY 467 NC 1049 SC 615 TN 685 VA 854 Each warehouse can handle a limited number of cases per month. The warehouse capacities are listed below: . Atlanta, GA: 3500 cases . Charlotte, NC: 3500 cases . Jacksonville, FL: 3500 cases It costs 2.5 $/mile to ship one case from the manufacturing plant to the warehouses. The distances (in miles) from the plant in Chicago, IL to the three warehouses are displayed in the following table: Atlanta, Charlotte, Jacksonville, FL GA NC Chicago, IL 717 756 1100Similarly, the company spends 6.4 $/mile to move one case of products from the warehouses to the different customers' states. The distances (in miles) between the warehouses and states are shown in the table below: AL FL GA KY NC SC TN VA Atlanta, GA 189 509 5 490 304 351 280 581 Charlotte, 458 524 276 440 5 217 481 310 NC Jacksonville, 372 141 368 746 420 238 617 656 FL According to a distribution network optimization conducted 5 years ago, all the demand from AL, GA, KY, SC, and TN is shipped from the warehouse located in Atlanta, GA. The warehouse in Charlotte, NC currently serves NC and VA. Finally, the warehouse in Jacksonville, FL only serves FL. Based on the current customer allocation, what is the actual transportation cost (inbound + outbound costs)? Round your answer to the nearest integer.Part 2 0.0/1.0 point (graded) The company decides to update the customers allocation running a new network optimization model to minimize transportation cost. What is the optimal transportation cost (inbound + outbound costs)? Round your answer to nearest integer.Part 3 0.0/1.0 point (graded) CMS also wants to revisit the number of warehouses open. For this purpose, the company includes a fixed cost associated with running each warehouse on a monthly basis in the mathematical model. The monthly fixed costs are listed below: 0 Atlanta, GA: $2000000 - Charlotte, NC: $2000000 0 Jacksonville, FL: $2000000 What is the optimal total cost (fixed + transportation costs)? Round your answer to the nearest integer. Part 4 0.0/0.5 points (graded) Based on the optimized model you created for Part 3, how many warehouses does the company need to remain open? Part 5 0.0}1.0 point (graded) From your answer in part 3, what percentage of demand is fulfilled within 350 miles (distance from warehouses to states) in order to satisfy the customer demand? Input your answer as a percentage with one decimal place (e.g., if your answer is 89.483%, type 89.5)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!