Question: i need this question solved on EXCEL + i need explaination on how we got the answers on EXCEL Q4 Question 4 10 Points Slick

i need this question solved on EXCEL + i need explaination on how we got the answers on EXCEL

Q4 Question 4 10 Points Slick Oil Company has three warehouses from which it can ship products to any of three retail outlets. The demand in cans for the product Gunkout is 320 at retail outlet 1; 350 at outlet 2; and 255 at outlet 3. The inventory (capacity) of Gunkout at warehouse A is 270; at warehouse B is 375; and at warehouse C is 390. The cost of transporting one unit of Gunkout from each warehouse to each retail outlet is as follows: WAREHOUSE A B 1 14 8 5 RETAILER 2 13 6 6 3 11 9 8 Formulate an LP to determine how many units should be shipped from each warehouse to each retailer so the demand at each retailer is met at minimum cost. Solve this problem on a computer. (Note: feel free to use the 3 x 3 Transportation Model Template used during class.)

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!

i need excel steps and solution i need this question solved on EXCEL + i need explaination on how we got the answers on EXCEL Q4 Question 4 10 Points Slick Oil Company has three warehouses from which...

i need each step exlaination + answer for this queston on EXCEL i need this question solved on EXCEL + i need explaination on how we got the answers on EXCEL Q4 Question 4 10 Points Slick Oil Company...

Case Studies: For each, you will submit your electronic document (.doc, .docx, or PDF) via Blackboard before class begins on the assigned date. Your case study will be not less than six pages in...

Using the link attach create a master budget. This assignment is to be submitted using an Excel XLS or XLSX workbook. Each budget schedule is to be contained on a separate spreadsheet tab. You are to...

Read the case: The dream's door: a case of a MNC in Poland Introduction It was a nice sunny morning in Zurich. DAK Europe's chairman gathered all of his board members around a large table and went...

A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 B C D E F G Estimate Estimation Error Square of Error Template for Linear Regression Time...

3 COLLEGE ALGEBRA - TRIGONOMETRY Business and Finance (MAT115) This course will start with a review of basic algebra (factoring, solving linear equations, and equalities, etc.) and proceed to a study...

13. PLEASE HELP!!! Assignment Submission For this assignment, you submit answers by question parts. The number of submissions remaining for each question part only changes if you submit or change the...

Kindly solve the following Economics 333 HR #3 Use the following information on the supply and demand for oil in the hypothetical country Economica to answer the questions below. Assume that the...

I split up my screen shots. please help me. I keep getting my answers incorrect with my formulas within cells ezto.mheducation.com Question 6 - 5.7 Excel Spreadsheet Assignment #2 - C....

If you hold the loop in a vertical plane, the colors should settle into a pattern of horizontal bands. Sketch the bands that you see indicating both their color and width.

What is the purpose of a protocol analyzer? How can this be a useful tool for Network Administrators? Discuss how this tool allowed you to have a greater comprehension of the structure of network...

Some of the steps included in the fulfillment process are: Order processing, productions, storage Send purchase orders, process orders, receive and payment Sales order processing, shipping, billing...

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...