Question 1the concrete pipe factories of the DSI(State Hydraulic Works)in Eskişehir, Bursa and Konya and the 2019 needs for thesepipes are given below.The annual production capacities ofAnnual Production (Pieces)Requirement (Pieces)Factory CapacityEskişehir 8000Bursa7000Konya 9000City Demandİstanbul7500Ankara6000Trabzon 5000Gaziantep 5500Estimated intercity transportation prices :Transportation Prices (Pipe / TL)İstanbul Ankara Trabzon Gaziantep||Eskişehir 44404650Bursa30403060Konya45304245Create a mathematical model that will provide the mosteconomical transportation of pipes produced in differentfactories to the points of need.

Answered: Image /qna-images/answer/f6f47865-434e-45a6-8f48-8f9b43fb661c.jpg

Answered: Question 1 the concrete pipe factories…

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

Problem 3-14 (Algo) Demand for stereo headphones and music players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for this year was as follows: MONTH DEMAND (UNITS) 4,150 4,25e 3,950 4, 350 4,95e 4,650 5,25e 4,850 5,35e 5,65e 6,25e 5,95e January February March Аpril Мay June July August September October November December a. Using linear regression analysis, what would you estimate demand to be for each month next year? Using a spreadsheet, follow the general format in Exhibit 3.8. (Do not round Intermedlate calculatlons. Round your answers to 2 decimal places.) Month Forecast January February March April May June July August September October November December b. To be reasonably confident of meeting demand, Nina decides to use 3 standard errors…
Q4 Lab2 Subject: Production And operation Mnagement please answer ASAP
Question 2 - Rohe (Hong Kong) Ltd is a pharmaceutical company which manufactures and supplies various drugs for drug stores in Asia. Currently, Rohe (Hong Kong) Ltd has four factories A, B, C and D. Management has decided to build a new factory at a location central to these factories. Information regarding the yearly demands and the map coordinates for the four factories are shown in below table. Factories e Demand e x-coord- 9,000- y-coorde A- 20e 130e Be 3,000 60- 404 Ce 5,000- 70- 100- De 16,000- 90 30 (a) Determine the map coordinates of the new factory. (b) Suggest and elaborate TWO other factors that need to consider in the selection of location. e
Demand for stereo headphones and MP3 players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for last year was as follows: MONTH DEMAND (UNITS) January 4,220 February 4,320 March 4,020 April 4,420 May 5,020 June 4,720 July 5,320 August 4,920 September 5,420 October 5,720 November 6,320 December 6,020 Using linear regression analysis, what would you estimate demand to be for each month next year? (Round two decimal places) To be reasonably confident of meeting demand, Nina decides to use 3 standard errors of estimate for safety. How many additional units…
Question 2 Rohe (Hong Kong) Ltd is a pharmaceutical company which manufactures and supplies various drugs for drug stores in Asia. Currently, Rohe (Hong Kong) Ltd has four factories A, B, C and D. Management has decided to build a new factory at a location central to these factories. Information regarding the yearly demands and the map coordinates for the four factories are shown in below table. Factories Demand - x-coord 9,000- 3,000- 5,000 y-coord 130 40 A Be 20 60 Ce 70 100 De 16,000- 90 30 (a) Determine the map coordinates of the new factory. (b) Suggest and elaborate TWO other factors that need to consider in the selection of location. «
Demand for stereo headphones and MP3 players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for last year was as follows: MONTH DEMAND (UNITS) January 4,240 February 4,340 March 4,040 April 4,440 May 5,040 June 4,740 July 5,340 August 4,940 September 5,440 October 5,740 November 6,335 December 6,030 a. Using linear regression analysis, what would you estimate demand to be for each month next year? (Do not round intermediate calculations. Round your answers to 2 decimal places.) b. To be reasonably confident of meeting demand, Nina decides to use 4 standard errors of estimate for safety. How many additional units should be held to meet this level of confidence? (Do not round intermediate calculations. Round…
Q16 please help me!
Problem 16-11 (Algo) One of your Taiwanese suppliers has bid on a new line of molded plastic parts that is currently being assembled at your plant. The supplier has bid $0.10 per part, given a forecast you provided of 100,000 parts in year 1; 300,000 in year 2; and 500,000 in year 3. Shipping and handling of parts from the supplier's factory is estimated at $0.01 per unit. Additional inventory handling charges should amount to $0.003 per unit. Finally, administrative costs are estimated at $30 per month. Although your plant is able to continue producing the part, the plant would need to invest in another molding machine, which would cost $20,000. Direct materials can be purchased for $0.05 per unit. Direct labor is estimated at $0.04 per unit for wages plus a 50 percent surcharge for benefits and, indirect labor is estimated at $0.011 per unit plus 50 percent benefits. Up-front engineering and design costs will amount to $50,000. Finally, management has insisted that overhead be…
May 77.000 Problem 4 (Regression Analysis, Service Company) Bobby Gonzales owns a catering company that prepares banquets and parties for both individual and business functions throughout the year. Gonzales business is seasonal, with a heavy schedule during the summer months and the year-end holidays and a light schedule at other times. During peak periods there are extra costs. One of the major events Gonzales' customers request is a cocktail party. He offers a standard cocktail party and has developed the following cost structure on a per person basis. Food and bevernges Labor (0.5 hour x PIO per hour) Overhead (0.5 hour x P14 per hour) Total costs per person PI5.00 5.00 7.00 P27.00 Gonzales is quite certain about his estimates of the food, beverages, and labor costs but is not as comfortable with the overhead estimate. This estimate was based on the actual data for the past 12 months presented below. These data indicate that overhead costs vary with the direct labor- hours used. The…
Q3 needed to be solved correctly By hand solution needed
answer question 1 and 2 on problem 1
Question 5: A Mechanical Design Company produces an innovative design of Batttery used for electric cars. The standard design of producing one(1) unit of Battery is provided in the bill of materials BOM which requires material mix shown in Table Q5a. The current monthly production of Battery is 2000 units per month with the actual material consumption shown in Table Q5b. Determine the following and justify why it is favorable or adverse. (i) Material usage variance; (ii) Material price variance; (ii) Total material cost variance; Table Q5a Usage (units) 5 Materials Total cost (OMR) V 17 W 3 38 X 8 50 Y 38 Table Q5b Usage (units) 12,047 6,902 17,556 4,122 Total cost (OMR) 50,526 94,083 103,953 76,408 Materials V W Y

SEE MORE QUESTIONS

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