Question: PLEASE ANSWER FAST MANAGEMENT SCIENCE QUESTION SHOULD BE DONE IN EXCEL AND INCLUDE ALL FORMULAS 1. Newton Gourmet Chocolates operates two plants that produce candy.

PLEASE ANSWER FAST

MANAGEMENT SCIENCE QUESTION

SHOULD BE DONE IN EXCEL AND INCLUDE ALL FORMULAS

1. Newton Gourmet Chocolates operates two plants that produce candy. The Jefferson CIty plant which can produce up to 50 tons per month and the Omaha plant which can produce up to 40 tons per month. NGC sells its candy to three different distributors, Des Moines (demand = 25 tons per month), Kansas City (demand = 15 tons per month), and St. Louis (demand = 10 tons per month). The costs of shipping between the respective plants is shown in the table to the left:

What is the optimal shipping plan to minimize NGCs shipping costs? (Use solver and include a screeshot of the solver window)

Suppose that the Jefferson City

plant was required to run at capacity. How would you accommodate this change in Solver?(Again, include a screenshot of your solver window.)

What would the optimal shipping plan be in this case?


	Des Moines	Kansas City	St. Louis
Jefferson City	14	16	7
Omaha	8	10	5

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!

PLEASE ANSWER FAST MANAGEMENT SCIENCE QUESTION SHOULD BE DONE IN EXCEL AND INCLUDE ALL FORMULAS 1. Newton Gourmet Chocolates operates two plants that produce candy. The Jefferson CIty plant which can...

Please answer it using Excel Please answer it using Excel Newton Gourmet Chocolates operates two plants that produce candy. The Jefferson Clty plant which can produce up to 50 tons per month and the...

Newton Gourmet Chocolates operates two plants that produce candy. The Jefferson CIty plant which can produce up to 5 0 tons per month and the Omaha plant which can produce up to 4 0 tons per month....

Please answer this question: Are plant-based meat substitute products just a fad? Also, how likely is it that a large percentage of the worlds population will switch from eating animal meats to...

please complete the answer sheet using 2016 annual report Financial Statement Analysis Project ANSWER SHEET Name(s): No. Question 1. Who is responsible for the financial statements and maintaining...

Label Each Question and Section: Read the Point/Counterpoint on page 534 of the text: Organizations Should Strive to Create Positive Organizational Culture Should organizations do everything they can...

Hi, I need help solving this question about the case study below. Can anyone help me out? Question: What would you assess as the fundamental strength of the competitive forces that Beyond Meat faces?...

Can someone help me answer what the critical factors for Beyond Meat and the other makers of plant-based meat substitutes are? oing into 2020, Beyond Meat, a producer March 31, 2020, the company's...

Tamara deposits $400 in an account paying an effective semi-annual interest rate 4.83750%. Sebhat deposits $800 in an account paying an effective interest rate j2. After 13 years they have the same...

Assume you have been asked to develop a proposal for Memorial University to enhance the quality of undergraduate student ratings of teacher performance. Along these lines, the university has decided...

Fill in the blank question. A company borrows $50,000 by signing a $50,000, 8% note that requires six equal payments of (round to the nearest dollar) at the end of each year. (The present value of an...

Pricing an option is easy because every input to the pricing model is perfectly observable, especially the volatility parameter. True False