Question Details

[answered] A soft drink manufacturing company has 3 factories set up o



  1. A soft drink manufacturing company has 3 factories set up one in each of the three cities ? Orland, Tampa, and Port St. Lucie and it supplies the produced soft drink bottles to 3 warehouses located in the city of Miami. The associated per-unit transportation cost table is provided below:
???????????????????????????????????????????Transportation?Costs ? ($)
Factories/Warehouse ? (W) W1 W2 W3
Orlando 4 3 7
Tampa 7 6 4
Port St. Lucie 3 6 6

The factory at Orlando has a capacity of 15,000 units.

The factory at Tampa has a capacity of 18,000 units.

The factory at Port St. Lucie has a capacity of 8,000 units.

The requirements of the warehouses are:

Warehouse Requirement (Bottles)
W1 18,000
W2 12,000
W3 5,000

How many decision variables do you have in this problem?

6 points ??

  1. A soft drink manufacturing company has 3 factories set up one in each of the three cities ? Orland, Tampa, and Port St. Lucie and it supplies the produced soft drink bottles to 3 warehouses located in the city of Miami. Using the information from question?6 answer the following:

How many constraints do you have in this problem? (ignore the sign constraints)

  1. Based on the problem of the soft drink manufacturing company:

What is the optimal minimum cost for this problem? Use Excel Solver to find your solution.

  1. Based on the problem of the soft drink manufacturing company:

What is the optimal value for the route Orlando ? W1, that is how many units?should be sent?from Orlando to location W1 in order to minimize the total transportation cost?

  1. Based on the problem of the soft drink manufacturing company:

What is the optimal value for the route?Orlando ? W2, that is how many units?should be sent?from Orlando to location W2 in order to minimize the total transportation cost?

  1. Based on the problem of the soft drink manufacturing company:

What is the optimal value for the route?Tampa ? W1, that is how many units?should be sent?from?Tampa to location W1 in order to minimize the total transportation cost?

  1. Based on the problem of the soft drink manufacturing company:

What is the optimal value for the route?Tampa ? W2, that is how many units?should be sent?from?Tampa to location W2 in order to minimize the total transportation cost?

  1. Based on the problem of the soft drink manufacturing company:

SOFT DRINK MANUFACTURING NETWORK MODEL Orlando

 

Tampa

 

Port St. Lucie Orlando

 

Tampa

 

Port St. Lucie Demand Transportation costs, $/unit

 

W1

 

W2

 

W3

 

4

 

3

 

7

 

6

 

3

 

6 7

 

4

 

6 Allocations on Routes

 

W1

 

W2

 

W3

 

3000...

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Sep 18, 2020

PRICE: $15

Solution~0001003643.zip (25.37 KB)

Buy this answer for only: $15

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy from our tutoring website www.aceyourhomework.com (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 18, 2020

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN YOUR SET DEADLINE.

Order Now