b Determine the optimum location for the new plant such that the distance move is minimum (use SimpleMedian Model). Show your complete solution.Existing PlantLocation (x,y) of existing plantLoads to be shifted from new plant toexisting plantsF1(20,30)F2(10,40)F3(30,50)F4(40,60)755900450500

Answered: Image /qna-images/answer/9122292c-e076-493e-ae56-840a8aada50c.jpg

Answered: Determine the optimum location for the…

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

N2. Account
Operations Management CH 3 Question 14 Harlen Industries has a simple forecasting model: Take the actual demand for the same month last year and divide that by the number of fractional weeks in that month. This gives the average weekly demand for that month. This weekly average is used as the weekly forecast for the same month this year. This technique was used to forecast eight weeks for this year, which are shown in the following tables along with the actual demand that occurred. The following eight weeks show the forecast (based on last year) and the demand that actually occurred:
11
470 q 16 a speculative stock possessees a _________ probability of _________ return and is currently _______- a. high, negative, underpriced b. high, negative, overpriced c. high, positive, overpriced d. low, negative, overpriced e. low, positive, underpriced
Q1. Hotel manager Mr. Smith and his resourceful assistant, John, run a 26-room hotel in a little town. A combination of Mr. Smith's friendly attitude and the absence of a respectable hotel in the nearby vicinity imply that Mr. Smith enjoys sufficient demand at his low fare of $159 per night. John notes that some customers will walk into the hotel requesting a room for that evening and they are willing to pay a high fare of $325 per night. John knows this demand is variable. (In reality, this demand is U(4,9)) He suggests some rooms should be kept unsold to the low-fare customers so that they can serve the high-fare customers. a) To maximize profits with John's plan, what is the booking limit that should be set for low fare customers? b) Mr Smith does not like the idea of John and says “we will sell to everyone who reserves in advance and ignore the walk-in demand." If Mr Smith has his way, what will be the hotel's expected revenue? C) John replies, "If you are going to forgo the…
PS.53 Brother I.D. Ricks is a faculty member at BYU-Idaho whose grandchildren live in Oklahoma and California. He and his wife would like to visit their grandchildren at least once a year in these states. They currently have one vehicle with well over 100,000 miles on it, so they want to buy a newer vehicle with fewer miles and that gets better gas mileage. They are considering two options: (1) a new subcompact car that would cost $24,000 to purchase or (2) a used sedan that would cost $18,000. They anticipate that the new subcompact would get 38 miles per gallon (combined highway and around town driving) while the sedan would get 25 miles per gallon. Based on their road tripping history they expect to drive 11,000 miles per year. For the purposes of their analysis they are assuming that gas will cost $3.44 per gallon. Question: How many miles would the Ricks need to drive before the cost of these two options would be the same? (Display your answer to the nearest whole number.) (Hint:…
Need from d to g
QUESTION 4 Suppose the following are the seasonal indices for the first three quarters of the year for a quarterly series: Quarter Seasonal Index Q1 72.4 Q2 85.3 Q3 109.6 Remember that the seasonal indices should average 100 so you should be able to infer the seasonal index for Q4. Furthermore, suppose that the estimated coeffcients from a regression of the deseasonalized series on Time are given below: Coefficients Intercept 2,506 Time 71.3 If the original value of the series in a Q1 was 2,040, then what is the seasonally adjusted value? (please round your answer to 1 decimal place)
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.
Problem 7-09 (Algorithmic) Hawkins Manufacturing Company produces connecting rods for 4- and 6-cylinder automobile engines using the same production line. The cost required to set up the production line to produce the 4-cylinder connecting rods is $1,400, and the cost required to set up the production line for the 6-cylinder connecting rods is $3,100. Manufacturing costs are $15 for each 4-cylinder connecting rod and $18 for each 6-cylinder connecting rod. Hawkins makes a decision at the end of each week as to which product will be manufactured the following week. If a production changeover is necessary from one week to the next, the weekend is used to reconfigure the production line. Once the line has been set up, the weekly production capacities are 6,500 6-cylinder connecting rods and 8,200 4-cylinder connecting rods. Let X4 = the number of 4-cylinder connecting rods produced next week X6 = the number of 6-cylinder connecting rods produced next week S4= 1 if the production line is…
QUESTION ONE (b) The forecast of a product for the first week of January was 200 units, whereas the actual demand turned out to be 220 units. i. Find the forecast for the week of January assuming the smoothing constant 0.2 α = ii. Find the forecast for the third week of third week of January if the actual demand of the second week is 210 units
Q1. General Appliance Corp. produces refrigerators at three plants: Marietta, Minneapolis and Phoenix. They ship them to major retail outlets in Chicago, Los Angeles and New York City. The accounting, production and marketing departments have provided the following information in the given tables; Plant capacities over the next planning period, retail outlet demand and unit cost of shipping between any plant and retail outlet. The company would like to minimize the cost of their transportation network by identifying how many units to ship between each plant and retail outlet. 1. Formulate this linear optimization problem by clearly listing the decision variables, objective function and constraints. 2. Create a spreadsheet model for this problem and solve it using Solver. What is the minimum cost? Plant Supply Marietta 1200 Minneapolis 800 Phoenix 1600 Retail Outlet Demand Chicago 650 Los Angeles 1450 New York City 1500…

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