Question: PLEASE READ QUESTION , a and b are slightly differeent from other questions posted here. Please show me for part a the formula with and

PLEASE READ QUESTION , a and b are slightly differeent from other questions posted here. Please show me for part a the formula with and without the numbers inputed. Please show me a step by step how to do in excel for part b. Thanks

Hansen Controls has been awarded a contract for a large number of control panels. To meet This Demand it will use its excisting plants in Sandiego and Houston, and consider new plants in Tulsa, St. Louis and Portland. Finished Crontrol panels are to be shipped to seattle, senver and Kansas City. Pertinent infromation is given in the table.

Shipping cost to destination:

Sources	Construction Cost	Seattle	Denver	Kansas City	Capacity
San Diego	----	5	7	8	2500
Houston	----	10	8	6	2500
Tulsa	350000	9	4	3	10000
St. Louis	200000	12	6	2	10000
Portland	480000	4	10	11	10000
	Demand	3000	8000	9000

a) Develop an optimization model (i.e., show the formulated mathematical model) whose solution would reveal which plants to build and the optimal shipping schedule.

b) Solve the model using Microsoft Excel Solver Add-in and provide your recommendation.

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!

Assignment please Read Article New Coke - Write a response to the following questions: What assumptions did Coca Cola Company make? What biases can you identify? What did competitors do before and...

Please read the question carefully, it is different from previously posted. It may be similar but part b and c are totally different Please check my answer, I have posted many times but most of the...

I need answers for question 3 for early activities, 4 for late activities and 5 for ploting the total costs for 3 and 4 on the same graph and comment on it please. And i recommend looking at the...

Part A When the new president at Mid-West U took over, it was only a short time before the incumbent vice president announced his resignation. Unfortunately, there was no one waiting in the wings,...

(PLEASE DO NOT COPY YOUR ANSWER FROM A DIFFERENT QUESTION AND POST IT HERE. PLEASE READ THE QUESTION CAREFULLY. THIS QUESTION IS DIFFERENT FROM OTHER QUESTIONS ON CHEGG. IF THE SAME ANSWER AS OTHER...

Welcome! Please read this page (in particular) very carefully. Instructions You need to understand how to send your assignments (deliverables) Instructor: to your instructor. The tabs (bottom of each...

I'm an undergrad accounting student in an introduction to forensic accounting course.I need help getting started on a final project for this class over a fictitious company called the Grand Teton...

Need answers to all the blanks. Background Assume it is currently 1 June 2023. You are working for the temporary accounting employment agency known as Accomp. Today you have been asked to work at...

pls i need help with the samsung wiley Annual Report Project only the other 4 Attachment is a guideline telling you what need to be done.pls see the attached Apple company wiley Annual Report ANNUAL...

2.42 The cantilever beam shown has a rectangular cross section b 2c. (a) Using the equation , = -My/1,, prove that a, = wxy/(611). (b) Determine (x, y) and or,(x, y) using Eqs. (2.4-2). (c) Show...

A radar pulse returns to the receiver after a total travel time of 3.00 X 10 -4 s. How far away is the object that reflected the wave?

Projects A and B both last for 4 years and have ic However, the NPV profiles of the two projects cr decreases at a faster rate as cost of capital increas CORRECT? a . More of Project A ' s cash flows...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...