Question: Analytics Assignment help!! You work for a major supplier of paper products (paper towels, tissues, TP, etc.). You deliver your production of a mix of

Analytics Assignment help!!

You work for a major supplier of paper products (paper towels, tissues, TP, etc.). You deliver your production of a mix of paper products in pallets from each of three production facilities to meet the needs at four distribution centers. There is a currently a critical need for pallets of your paper products at the distribution centers. In a normal market you have been supplying the distribution center needs based on a minimum cost model. However, now you want to minimize the total time for your deliveries so you need to determine the best solution to do so. You developed the table below with delivery times (in hours) for shipping a pallet of paper products from each production facility to each distribution center:

Analytics Assignment help!! You work for a major USE EXCEL TO SOLVE THE MODEL

Analytics Assignment help!! You work for a major

Production Facility Charleston Savannah Wilmington Demand Atlanta 8 14 10 700 Retail Distribution Center St. Louis Dallas New York 52 80 50 70 95 66 62 86 58 500 1500 2000 Supply 2000 1000 1000 + Ship_? units From To Hours Total : O

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!

I NEED THE COMPLETED TABLE ABOVE You work for a major supplier of paper products (paper towels, tissues, TP, etc.). You deliver your production of a mix of paper products in pallets from each of...

Excel (Create Q4 Model) 4. (15 points) You work for a major supplier of paper products (paper towels, tissues. TP, etc.). You deliver your production of a mix of paper products in pallets from each...

You work for a major supplier of paper products (paper towels, tissues, TP, etc.). You deliver your production of a mix of paper products in pallets from each of four production facilities to meet...

Key issue/problem statement - what is the key problem/s or issue/s addressed in the case? What is the main decision that manager/s need to make? Maximum = 2 issues. Options with pros and cons...

I am dyslexic so it takes much longer for me to do any reading, so any and all help is greatly appreciated. I will be sure to thumbs up! Please I need help... Report Layout Structure Table of...

"I don't play to lose." --Murry Pitts, Carded Graphics owner and president Murry Pitts was passionate about his business. He firmly believed that to survive and thrive in the folding carton industry,...

Which of the following processes has a AS 0 A) 2H, () O, () 2H,0 (g) B) 2NO2 g) Ba (aq) 2F (aq) 2HgO (s) OB

1. Which of the following is NOT a risk that may be presented by adoption of cloud computing? Select all that apply. A. If cloud solutions are not configured properly for security controls, they may...

QUESTION 3 What makes a warm / cool season grass? Mencion three points. Clue - Think about their growing conditions and their physiology For the toolbar, prest ALT Ft 0 ( PG ) or ALT FN F 1 0 ( Mac )...

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...