Question: Can someone please help show how to do this problem step by step in excel. I am having a hard time. Neki Sports Company manufacturers

Can someone please help show how to do this problem step by step in excel. I am having a hard time.

Can someone please help show how to do this

Neki Sports Company manufacturers treadmills in factories located in Pittsburgh and Kansas City. These are shipped to regional distribution centers in Chicago, Phoenix, and Philadelphia. Ultimately, they are delivered to supply houses in New York and Los Angeles. The available supplies at the factories, demands at the final destinations, and shipping costs are illustrated in the table below. To From Los Chicago Phoenix Philadelphia New York Angeles Supply Pittsburgh $4 $8 $2 1,500 Kansas City $3 $6 $5 - 1,000 Chicago $5 $7 $ Phoenix $3 - $8 2 Philadelphia $2 $9 Demand 1,200 800 Formulate this as a linear programming problem. Using Excel, determine how many units should be shipped for all possible origin and destination points (final or intermediate) in the distribution network in order to minimize shipping costs

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 show all work with final answer. Neki Sports Company manufacturers treadmills in factories located in Pittsburgh and Kansas City. These are shipped to regional distribution centers in Chicago,...

3. (7 pts) Neki Sports Company manufacturers treadmills in factories located in Pittsburgh and Kansas City. These are shipped to regional distribution centers in Chicago, Phoenix, and Philadelphia....

can someone please help me!!! i keep getting stuck at step 5 Exp19_Excel_Ch12_Cap_Bulldog_Collectibles Project Description: You are the operations manager for Bulldog collectables, a small start-up...

Below is the Case Reading: TRANSPARENCY AND ETHICS AT EVERLANE Everlane was a clothing retailer of modern, everyday basics, such as white t-shirts, jeans, and backpacks. To set themselves apart from...

I am struggling to do the proper computations for some simple accounting. After i get this down, i will produce a paper on the importance of each number i solved for. Can someone please help me...

HELP!! I don't think the tutor answered did this assignment properly and I am way behind on my other assignments. Can someone please help me? Writea 1,050- to 1,750-word paper in which you address...

I need help completing the general journal I am completely confused someone please help Building Blocks of Accounting .. A Financial Perspective A SOLE PROPRIETORSHIP DeAnna, when you are ready to...

I'm in serious need of help in my accounting class (acc205) . I'm falling behind and I need help with this weeks assignment. for week three for the may-june month . can someone please help me ....

In a paragraph of approximately 150-200 words, analyze a film or TV/Streaming Show poster of your choosing by focusing on the ways in which representations in the poster are gendered. Include an...

Provide a method for separating the mixtures of two or three compounds, dissolved in a solvent diethyl ether. (Pavia) Pavia, Donald L. A Microscale Approach to Organic Laboratory Techniques, 6th...

Which of the following items belongs to pre - opening expenses and working capital category? Question 4 8 options: Parking garage Land closing cost Survey Training

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...