Question: Transportation Model (Solve using Excel Solver) BOM Manufacturing has four plants P1, P2, P2, and P4 located throughout a state with production capacities of 1100,

Transportation Model (Solve using Excel Solver)

Transportation Model (Solve using Excel Solver) BOM Manufacturing has four plants P1, P2, P2, and P4 located throughout a state with production capacities of 1100, 950, 850, and 980 units, respectively. Lately, because of the higher demand, the company needs to supply its four retail shops B1, B2, B3, and B4 with 1200,950, 1050, and 1750 units, respectively. The current transportation costs per unit are illustrated below. B1 B2 B3 B4 Capacity P1 3 5 7 6 1100 P2 5 8 3 950 P3 4 6 10 4 850 P4 6 7 4 5 980 1200 950 1050 1750 Between the three identified possible locations, L1, L2, and L3, given the estimated transportation costs per unit as shown below, which location will you choose to build the new plant and why? B2 B3 L1 L 2 L3 B1 4 7 3 B4 5 5 6 8 4 5 10

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!

The Bolded words are the questions asked!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! Question 1) The Sea Wharf Restaurant would like to determine the best way to allocate a monthly...

uantitative Analysis BA 452 Homework 3 Questions Homework 3 covers the theory and applications in Lessons I-6 and I-7. This document has four parts: Objectives of doing your homework. Assignment of...

Is there a way you can do the work on solver and then send it as an attachment? Or Excel? Thank you! Update: Ok that's fine. Could you possibly do the work that requires solver and then send those as...

Assumptions: 1. Each manufacturing unit operates continuously, 24 hours a day, up to 7 days a week. 2. At least one setup per week is necessary to run a unit. 3. The company intends to full all...

you will be given a Organization Profile in which you will then answer your questions according to the information in the Organization Profile. The questions should be formatted such that when I send...

1. Compute the year-to-year percentage change in "diluted-income from continuing operations" for each of the five years. 1a. Do the earnings appear volatile? 2. Compute the ratio of long term debt to...

download the...

Bromine is one of the few elements that is liquid in its standard state. Though quite polarizable, its boiling point (59C) is well below that of water, hence it has a high vapor pressure at room...

Simple Value Limited (SVL) was incorporated on January 1, 2011 when the sole shareholder invested $1,000,000. This is the only financing the firm needed. SVL has a single project that it developed...

The rate lock is: Applied on the firstyear credited interest rate and not on the guaranteed income payment. II . A timetrame whereby Northwestern Mulual locks - in the first - year credited interest...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...