2 EconomicsQUESTION 4A company produces goods at three factories. The goods are then distributed to fourlocations where they are sold to the public.Monthly production capacitiesFactory 1Factory 2Factory 3Total supplyMonthly demand at each retail outletRetail outlet ARetail outlet BRetail outlet CRetail outlet DTotal demandRetail OutletABCD2118272219182420Factory 3 24 25 28 25Solve the above transportation problem.Units506050160Cost of ShippingThe cost of shipping one unit from factories to retail outlets varies as follows (all costs inKina):Factory 1Factory 2Units50703010160Use 'Transportation Problem' to solve the aboveproblems using MS Excel Solver.

The transportation model is used to calculate the minimum cost of the route by selecting different…

Answered: Use 'Transportation Problem' to solve…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Ch. 19 Q9
Given the following history, use a three-quarter moving average to forecast the demand for the third quarter of this year. Note that the 1st quarter is January, February, and March; 2nd quarter April, May, June; 3rd quarter July, August, September; and 4th quarter October, November, December. Note: Round final answer to a whole number. Last year This year JANUARY 110 135 Forecast for the third quarter FEBRUARY 130 145 MARCH 140 190 APRIL 180 205 MAY 190 235 JUNE 210 270 JULY 155 AUGUST 145 SEPTEMBER 135
Subject: Engineering Management, Ch. 3 - Planning Technical Activities Please explain each of the content of Human Resources Plan The human resources plan must contain the following: •Personnel requirements of the company •Plans for recruitment and selection •Training plan •Retirement plan
Q-1)A glass melting furnaces feed auto plumping machines for producing the electric lamp casing (balloon),there are two main kinds can be produced, the original and the big one, they must produce at least 25 million of the original but not accede over 35 million ,and they must produce 3 million of the big one, however the ratio of the original must be at least 5 times to the big one which make a profit double the original, producing million of the big one utilize 5% Of the available materials but the original utilize 2.5% of the available materials ,For this problem ,the objective function is: Max Z =0.5X1+2X2 O MIN Z =2X1+X2 O Max Z =2X1+2X2 O Max Z =2X1+X2
Q.14. What do you mean by organising function? Explain the common type of organisational structures adopted by the companies these days? (10)
Q.No.2: Determine the type of scale (Nominal, Ordinal, Interval or Ratio) for the following examples. Age: _______________ Qualification: Intermediate Bachelor Master Phil. & Above Total work Experience in years: 1-5 6-10 11-15 16 & above Type of Organization ORIC R&D Firm Think tank Salary More than 15000 More than 25000 More than 45000 More than 95000 I love gardening. 1)Strongly Agree 2) Neutral 3)Disagree
5) Sometimes it is appropriate to take a job instead of a career. Explain at least two situations where this would be true.
A.3 Yellowburn University, a not-for-profit higher education organization, has the following mission statement: ‘We aim to deliver excellent tuition in state-of-the-art facilities to help develop socially responsible students and to contribute to global academic research.’ Which TWO of the following would be appropriate objectives to fit in with this mission? To deliver the best possible lessons. Each member of staff is to write two research papers for publication over the next two years. To increase car parking space at the university by 10% in the next 12 months to improve access. To get 15% of all students to receive first class honors degrees each year. To ensure 100% attendance from all students for every lecture.
Q1
10
Candidates B C 1st place votes 10 20 40 2nd place votes 20 40 10 3rd place votes 40 10 20 What is the score of the winning candidate by Borda Count Method? a. 164 b. 170 c. 160 d. 150 A a
Subject: acounting

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS

Use 'Transportation Problem' to solve the above problems using MS Excel Solver.