Question: PLEASE PROVIDE ME WITH AN EXCEL SOLUTION NN has been given a new contract for a large number of electric panels. To meet this demand,

PLEASE PROVIDE ME WITH AN EXCEL SOLUTION

PLEASE PROVIDE ME WITH AN EXCEL SOLUTION NN has

NN has been given a new contract for a large number of electric panels. To meet this demand, it will use its existing plants in Chicago and Houston, and consider new plants in Tuscaloosa, St. Louis, and Portland. Finished control panels are to be shipped to Seattle, Denver, and Kansas City. All related information is given in the table below: Shipping Cost to Destination Sources Construction Cost Seattle Denver Kansas City Capacity Chicago 5 7 8 2,500 Houston 10 8 6 2,500 Tuscaloosa 350,000 9 4 3 10,000 St. Louis 200,000 12 6 2 10,000 Portland 480,000 4 10 11 10,000 Demand 3,000 8,000 9,000 Develop a model whose solution would reveal which plants to build and the optimal shipping schedule. (Hints: all demand must be met, we have two cost components, shipping cost and the fixed construction costs if a new plant is chosen) Then answer these questions: a. What is your total cost? b. Which plants will be chosen? What is the excess capacity in each operating plant? d. If the capacity of the proposed 3 plants in Tuscaloosa, St.Louis and Portland) is to be reduced to 7000, how your answer will change? c

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!

ITM 309: Business Information Technology and Systems Spring 2016 Watson and the new era of cognitive systems Jerry Haan IBM Cloud Ecosystem Development January 27, 2016 2013 International Business...

GE . has been given a new contract for a large number of electric panels. To meet this demand, it will use its existing plants in Chicago and Houston, and consider new plants in Tuscaloosa, St....

BLC Inc. is a medium-sized manufacturing company based in the UK. The company operates mainly in the London area and is based in Peterborough. At a recent board meeting, the company decided to expand...

KIKX Inc. has been given a new contract for a large number of electric panels. To meet this demand, it will use its existing plants in Chicago and Houston, and consider new plants in Tuscaloosa, St....

\f 134 THE BIG SQUEEZE munications Workers of America that has sought to unionize high"tech workers. "They hire whomever Microsoft tells them to put on their payroll. Then they p~ocess their...

The Power of Partnerships Instructions to the students: Student must read the case study carefully which is based upon risk management approaches adopted by Rolls Royce company. Answer the questions...

Please provide the calculations on excel or word file along with the solution Research paper on Apple INC. The paper should be approximately 7 - 10 pages (12 - font, double-spaced) in length. Proper...

has been given a new contract for a large number of electric panels. To meet this demand, it will use its existing plants in Chicago and Houston, and consider new plants in Tuscaloosa, St . Louis,...

please provide answers from 5 to 18 The Rise, Fall, and Resurrection of Iridium: A Project Management Perspective The Iridium Project was designed to create a worldwide wireless handheld mobile phone...

An 90-m curve, g1 = 1.50%, g2 = +0.75%, VPI station = 6 + 280, VPI elevation = 550.600 m, stakeout at 10-m increments. Compute and tabulate full-station elevations for an unequal-tangent vertical...

Vista Corp. owes $600,000 to First National. The debt is a 10-year, 10% note due December 31, 2014. Because Vista Corp. is in financial trouble, First National agrees to extend the maturity date to...

Which approach to forecasting involves using causal variables? A ) Qualitative B ) Intuitive C ) Quantitative D ) Judgmental E ) Predictive

What is an example of constructive feedback? provide reference