Question: I need to know how to do this on excel please. Q2. (20 points) XYZ has four factories with weekly production capacity of 60, 40,

I need to know how to do this on excel please.

Q2. (20 points) XYZ has four factories with weekly production capacity of 60, 40, 60 and 50 widgets. These widgets must be shipped to three warehouses with a demand of 50, 30 and 35 units. The cost to ship to each location is known and shown in the table below. Which factory should ship how many widgets to which warehouse to minimize cost? Set up the problem as a LP problem and solve it using Solver. The solver dialog box should be populated when I open your submission. The Answer Report must be downloaded. Data Warehouse Factory A B D 3 $350.00 $300,00 $400,00 $350.00 $250.00 $100,00 $300.00 S200.00 $250.00 $350.00 $400.00 $300.00 40 60 35 Production Capacity $375.00 50 $300.00 60 $275.00 50 $500.00 50 55 Demand

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!

By MARK@ (Ruska, Markevichus, Naniev, Grachev) Emerging russian ice-cream market is good area for different producers as it has great potential 1. Currently Russian ice-cream market is the 4th...

SKT 11:18 Material Cost $ Estimated Process Time at Selling Product Weekly Work-Station (Mins/Unit) Price $ Demand X Y Alpha 25 55 40 30 10 20 10 Beta 25 60 45 50 60 20 20 Gamma 10 70 60 40 40 50 60...

Midterm Examination Questions - Spring 2016 1. The final examination grades of random samples of students from three different classes are shown below. Class A Class B Class C 92 91 85 85 85 93 96 90...

A company that manufactures paving material for driveways and parking lots expects the following demand for its product for the next four weeks: 40 80 60 70 Week number Material (tons) The company's...

1. ABT & Co. needs your advice on the production schedule for its product line. Analyze the information for the four-station four-product line, given below. Estimated Selling Material Process Time at...

1. ABT & Co. needs your advice on the production schedule for its product line. Analyze the information for the four-station four-product line, given below. Product Estimated Weekly Demand Selling...

Find attached Ingredients: Water, MCC, Salt, Nicotine, pH regulator, sweeteners and flavours I am wondering why the decision to go with LYFT. I understand migrating to LYFT would be easier from sells...

FILE TOOLS VIEW 6401819_1_writing-case--4 - Word (Product Activation Failed) Financing Early Operations Musk's first entrepreneurial venture was to join up with his brother, Kimbal, and establish...

PLEASE COMPLETE NO LATER THAN 10/07 @8:00AM Each question(1,2,& 3) must be a minimum of 200 words. Please make answers detailed and knowledgeable based off the attached reading. ARE YOU ABLE TO...

Please see attachment. All three question need to be answered in narrative format. If you have questions, just let me know. Normal requirement for references are 2 outside our course text....

Consider M(x, y) + N(x,y)=0. (a) Suppose we can find a function F = F(x,y) so that F, = M and F, N. Give an example of such an equation and solve it. (b) Suppose we can find functions and so that...

ces Tarnish Industries produces miniature models of farm equipment. These collectibles are in great demand. It takes two operations, molding and finishing. to complete the miniatures. Next year's...

6 2 . Which is true of real estate investments? They have a high equity risk They have a high liquidity risk They have a high currency risk They have a high inflation risk Skipped 6 3 . A company...

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...