Maurice Tutor

(5)

$15/per page/Negotiable

About Maurice Tutor

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Algebra,Applied Sciences See all
Algebra,Applied Sciences,Biology,Calculus,Chemistry,Economics,English,Essay writing,Geography,Geology,Health & Medical,Physics,Science Hide all
Teaching Since: May 2017
Last Sign in: 409 Weeks Ago
Questions Answered: 66690
Tutorials Posted: 66688

Education

  • MCS,PHD
    Argosy University/ Phoniex University/
    Nov-2005 - Oct-2011

Experience

  • Professor
    Phoniex University
    Oct-2001 - Nov-2016

Category > Management Posted 05 Jan 2018 My Price 9.00

contemplating construction

A large company which has 3 manufacturing locations is contemplating construction of a new facility which will supply 3 warehouses. The two leading locations are Toledo and Cincinnati. The new factory would have a supply capacity of 160 units per week. Transportation costs for Toledo to warehouses A, B, and C are $18, $8, and $13 per unit, respectively. Transportation costs for Cincinnati to warehouses A, B, and C are $7, $17, and $13 per unit, respectively. Transportation costs for the existing system are shown in the following table:

________________Warehouse A________Warehouse B_______Warehouse C________Capacity

Mfg 1____________10_________________14_______________10_________________210

Mfg 2____________12_________________17_______________20_________________140

Mfg 3____________11_________________11_______________12__________________150

Demand_________220________________220______________220

 

Please answer the following questions USING EXCEL SOLVER AND SHOW ALL WORK!

 

a) Complete an optimal transportation plan for location Toledo.

b) Complete an optimal transportation plan for location Cincinnati.

c) What location should the manufacturer select for the new transportation system?

 

Answers

Maurice Tutor
(5)
Status NEW Posted 05 Jan 2018 01:01 PM My Price 9.00

Hel-----------lo -----------Sir-----------/Ma-----------dam-----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------acq-----------uis-----------iti-----------on -----------of -----------my -----------pos-----------ted----------- so-----------lut-----------ion-----------.Pl-----------eas-----------e p-----------ing----------- me----------- on-----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be-----------

Not Rated(0)